Abstract
This paper demonstrates ETLMR, a novel dimensional Extract–Transform–Load (ETL) programming framework that uses MapReduce to achieve scalability. ETLMR has builtin 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 MapReducebased 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 employment. In addition, we also present the scalability on large data sets.
Originalsprog | Engelsk |
---|---|
Tidsskrift | Proceedings of the VLDB Endowment |
Vol/bind | 5 |
Udgave nummer | 12 |
Sider (fra-til) | 1882-1885 |
Antal sider | 4 |
ISSN | 2150-8097 |
Status | Udgivet - aug. 2012 |
Begivenhed | International Conference on Very Large Data Bases - Istanbul, Tyrkiet Varighed: 27 aug. 2012 → 31 aug. 2012 Konferencens nummer: 38 |
Konference
Konference | International Conference on Very Large Data Bases |
---|---|
Nummer | 38 |
Land/Område | Tyrkiet |
By | Istanbul |
Periode | 27/08/2012 → 31/08/2012 |