{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,6,1]],"date-time":"2024-06-01T17:11:23Z","timestamp":1717261883425},"reference-count":4,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,8]]},"abstract":"<jats:p>\n            This paper demonstrates\n            <jats:italic>ETLMR<\/jats:italic>\n            , a novel dimensional Extract--Transform--Load (ETL) programming framework that uses Map-Reduce to achieve scalability. ETLMR has built-in native support of data warehouse (DW) specific constructs such as star schemas, snowflake schemas, and slowly changing dimensions (SCDs). This makes it possible to build MapReduce-based dimensional ETL flows very easily. The ETL process can be configured with only few lines of code. We will demonstrate the concrete steps in using ETLMR to load data into a (partly snowflaked) DW schema. This includes configuration of data sources and targets, dimension processing schemes, fact processing, and deployment. In addition, we also present the scalability on large data sets.\n          <\/jats:p>","DOI":"10.14778\/2367502.2367528","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1882-1885","source":"Crossref","is-referenced-by-count":13,"title":["MapReduce-based dimensional ETL made easy"],"prefix":"10.14778","volume":"5","author":[{"given":"Xiufeng","family":"Liu","sequence":"first","affiliation":[{"name":"Aalborg University, Denmark"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Christian","family":"Thomsen","sequence":"additional","affiliation":[{"name":"Aalborg University, Denmark"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Torben Bach","family":"Pedersen","sequence":"additional","affiliation":[{"name":"Aalborg University, Denmark"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2012,8]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"137","volume-title":"Proc. of OSDI","author":"Dean J.","year":"2004","unstructured":"J. Dean and S. Ghemawat , \" MapReduce: Simplified Data Processing on Large Clusters \". In Proc. of OSDI , pp. 137 -- 150 , 2004 . J. Dean and S. Ghemawat, \"MapReduce: Simplified Data Processing on Large Clusters\". In Proc. of OSDI, pp. 137--150, 2004."},{"key":"e_1_2_1_2_1","first-page":"96","volume-title":"Proc. of DaWaK","author":"Liu X.","year":"2011","unstructured":"X. Liu , C. Thomsen and T. B. Pedersen , \" ETLMR: A Highly Scalable ETL Framework Based on MapReduce \". In Proc. of DaWaK , pp. 96 -- 111 , 2011 . X. Liu, C. Thomsen and T. B. Pedersen, \"ETLMR: A Highly Scalable ETL Framework Based on MapReduce\". In Proc. of DaWaK, pp. 96--111, 2011."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1629175.1629197"},{"key":"e_1_2_1_4_1","first-page":"49","volume-title":"Proc. of DOLAP","author":"Thomsen C.","year":"2009","unstructured":"C. Thomsen and T. B. Pedersen , \" pygrametl: A Powerful Programming Framework for Extract-Transform-Load Programmers \". In Proc. of DOLAP , pp. 49 -- 56 , 2009 . 10.1145\/1651291.1651301 C. Thomsen and T. B. Pedersen, \"pygrametl: A Powerful Programming Framework for Extract-Transform-Load Programmers\". In Proc. of DOLAP, pp. 49--56, 2009. 10.1145\/1651291.1651301"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2367502.2367528","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:55:44Z","timestamp":1672224944000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2367502.2367528"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,8]]},"references-count":4,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2012,8]]}},"alternative-id":["10.14778\/2367502.2367528"],"URL":"https:\/\/doi.org\/10.14778\/2367502.2367528","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,8]]}}}