{"id":"https://openalex.org/W1982583191","doi":"https://doi.org/10.14778/2367502.2367528","title":"MapReduce-based dimensional ETL made easy","display_name":"MapReduce-based dimensional ETL made easy","publication_year":2012,"publication_date":"2012-08-01","ids":{"openalex":"https://openalex.org/W1982583191","doi":"https://doi.org/10.14778/2367502.2367528","mag":"1982583191"},"language":"en","primary_location":{"id":"doi:10.14778/2367502.2367528","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2367502.2367528","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://vldb.org/pvldb/vol5/p1882_xiufengliu_vldb2012.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100735899","display_name":"Xiufeng Liu","orcid":"https://orcid.org/0000-0001-5133-6688"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Xiufeng Liu","raw_affiliation_strings":["Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010748912","display_name":"Christian Thomsen","orcid":"https://orcid.org/0000-0002-0862-0509"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Christian Thomsen","raw_affiliation_strings":["Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061064237","display_name":"Torben Bach Pedersen","orcid":"https://orcid.org/0000-0002-1615-777X"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Torben Bach Pedersen","raw_affiliation_strings":["Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I891191580"],"apc_list":null,"apc_paid":null,"fwci":5.8371,"has_fulltext":true,"cited_by_count":29,"citation_normalized_percentile":{"value":0.95743514,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"5","issue":"12","first_page":"1882","last_page":"1885"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9861000180244446,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9861000180244446,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9682000279426575,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9646000266075134,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6500636339187622},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3999713957309723},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.34122931957244873}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6500636339187622},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3999713957309723},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.34122931957244873}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/2367502.2367528","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2367502.2367528","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:pure.atira.dk:publications/ac24fc9f-e061-417b-9adc-382b56de56e1","is_oa":true,"landing_page_url":"https://vbn.aau.dk/da/publications/ac24fc9f-e061-417b-9adc-382b56de56e1","pdf_url":"http://vldb.org/pvldb/vol5/p1882_xiufengliu_vldb2012.pdf","source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Xiufeng, L, Thomsen, C & Pedersen, T B 2012, 'MapReduce-based Dimensional ETL Made Easy', Proceedings of the VLDB Endowment, vol. 5, no. 12, pp. 1882-1885. < http://vldb.org/pvldb/vol5/p1882_xiufengliu_vldb2012.pdf >","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.294.842","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.294.842","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://vldb.org/pvldb/vol5/p1882_xiufengliu_vldb2012.pdf","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:pure.atira.dk:publications/ac24fc9f-e061-417b-9adc-382b56de56e1","is_oa":true,"landing_page_url":"https://vbn.aau.dk/da/publications/ac24fc9f-e061-417b-9adc-382b56de56e1","pdf_url":"http://vldb.org/pvldb/vol5/p1882_xiufengliu_vldb2012.pdf","source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Xiufeng, L, Thomsen, C & Pedersen, T B 2012, 'MapReduce-based Dimensional ETL Made Easy', Proceedings of the VLDB Endowment, vol. 5, no. 12, pp. 1882-1885. < http://vldb.org/pvldb/vol5/p1882_xiufengliu_vldb2012.pdf >","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.4399999976158142,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1982583191.pdf","grobid_xml":"https://content.openalex.org/works/W1982583191.grobid-xml"},"referenced_works_count":5,"referenced_works":["https://openalex.org/W2044490410","https://openalex.org/W2122465391","https://openalex.org/W2152236140","https://openalex.org/W2170634549","https://openalex.org/W7033391756"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"This":[0,40,82],"paper":[1],"demonstrates":[2],"ETLMR":[3,18,72],",":[4],"a":[5,77],"novel":[6],"dimensional":[7,47],"Extract--Transform--Load":[8],"(ETL)":[9],"programming":[10],"framework":[11],"that":[12],"uses":[13],"Map-Reduce":[14],"to":[15,44,73],"achieve":[16],"scalability.":[17],"has":[19],"built-in":[20],"native":[21],"support":[22],"of":[23,62,85],"data":[24,75,86,106],"warehouse":[25],"(DW)":[26],"specific":[27],"constructs":[28],"such":[29],"as":[30],"star":[31],"schemas,":[32,34],"snowflake":[33],"and":[35,88,95],"slowly":[36],"changing":[37],"dimensions":[38],"(SCDs).":[39],"makes":[41],"it":[42],"possible":[43],"build":[45],"MapReduce-based":[46],"ETL":[48,53],"flows":[49],"very":[50],"easily.":[51],"The":[52],"process":[54],"can":[55],"be":[56],"configured":[57],"with":[58],"only":[59],"few":[60],"lines":[61],"code.":[63],"We":[64],"will":[65],"demonstrate":[66],"the":[67,102],"concrete":[68],"steps":[69],"in":[70],"using":[71],"load":[74],"into":[76],"(partly":[78],"snowflaked)":[79],"DW":[80],"schema.":[81],"includes":[83],"configuration":[84],"sources":[87],"targets,":[89],"dimension":[90],"processing":[91],"schemes,":[92],"fact":[93],"processing,":[94],"deployment.":[96],"In":[97],"addition,":[98],"we":[99],"also":[100],"present":[101],"scalability":[103],"on":[104],"large":[105],"sets.":[107]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":8},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":3}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}