Abstract | ||
---|---|---|
Data warehouse (DW) design is based on a set of requirements expressed as service level agreements (SLAs) and business level objects (BLOs). Populating a DW system from a set of information sources is realized with extract-transform-load (ETL) processes based on SLAs and BLOs. The entire task is complex, time consuming, and hard to be performed manually. This paper presents our approach to the requirement-driven creation of ETL designs. Each requirement is considered separately and a respective ETL design is produced. We propose an incremental method for consolidating these individual designs and creating an ETL design that satisfies all given requirements. Finally, the design produced is sent to an ETL engine for execution. We illustrate our approach through an example based on TPC-H and report on our experimental findings that show the effectiveness and quality of our approach. |
Year | DOI | Venue |
---|---|---|
2012 | 10.1007/978-3-642-32584-7_6 | DaWaK |
Keywords | Field | DocType |
etl design,data warehouse,respective etl design,integrating etl,etl engine,dw system,information requirement,experimental finding,service level agreement,business level object,entire task,individual design | Data warehouse,Data mining,Service level,Computer science,Service-level agreement,Partial match,Database | Conference |
Citations | PageRank | References |
10 | 0.57 | 15 |
Authors | ||
4 |
Name | Order | Citations | PageRank |
---|---|---|---|
Petar Jovanovic | 1 | 62 | 7.78 |
Oscar Romero | 2 | 467 | 35.46 |
Alkis Simitsis | 3 | 1665 | 94.62 |
Alberto Abelló | 4 | 848 | 61.88 |