Integrating ETL processes from information requirements

作者: Petar Jovanovic , Oscar Romero , Alkis Simitsis , Alberto Abelló

DOI: 10.1007/978-3-642-32584-7_6

关键词:

摘要: Data warehouse (DW) design is based on a set of requirements expressed as service level agreements (SLAs) and business objects (BLOs). Populating DW system from information sources realized with extract-transform-load (ETL) processes SLAs BLOs. The entire task complex, time consuming, hard to be performed manually. This paper presents our approach the requirement-driven creation ETL designs. Each requirement considered separately respective produced. We propose an incremental method for consolidating these individual designs creating that satisfies all given requirements. Finally, produced sent engine execution. illustrate through example TPC-H report experimental findings show effectiveness quality approach.

参考文章(23)
Conceptual Modeling: Foundations and Applications Lecture Notes in Computer Science. ,vol. 5600, ,(2009) , 10.1007/978-3-642-02463-4
Conceptual Modeling - ER 2010 Lecture Notes in Computer Science. ,vol. 6412, ,(2010) , 10.1007/978-3-642-16373-9
Sara Cohen, Werner Nutt, Yehoshua Sagiv, Containment of Aggregate Queries international conference on database theory. pp. 111- 125 ,(2003) , 10.1007/3-540-36285-1_8
Alkis Simitsis, Umeshwar Dayal, Malu Castellanos, Kevin Wilkinson, Leveraging business process models for ETL design international conference on conceptual modeling. pp. 15- 30 ,(2010) , 10.5555/1929757.1929760
Panos Vassiliadis, Alkis Simitsis, Spiros Skiadopoulos, Conceptual modeling for ETL processes data warehousing and olap. pp. 14- 21 ,(2002) , 10.1145/583890.583893
Maurizio Lenzerini, Data integration: a theoretical perspective symposium on principles of database systems. pp. 233- 246 ,(2002) , 10.1145/543613.543644
Panos Kalnis, Dimitris Papadias, Multi-query optimization for on-line analytical processing Information Systems. ,vol. 28, pp. 457- 473 ,(2003) , 10.1016/S0306-4379(02)00026-1
Jose-Norberto Mazón, Juan Trujillo, An MDA approach for the development of data warehouses decision support systems. ,vol. 45, pp. 41- 58 ,(2008) , 10.1016/J.DSS.2006.12.003
Zineb El Akkaoui, Esteban Zimanyi, Defining ETL worfklows using BPMN and BPEL Proceeding of the ACM twelfth international workshop on Data warehousing and OLAP - DOLAP '09. pp. 41- 48 ,(2009) , 10.1145/1651291.1651299
Ronald Fagin, Phokion G. Kolaitis, Renée J. Miller, Lucian Popa, Data exchange: semantics and query answering Theoretical Computer Science. ,vol. 336, pp. 89- 124 ,(2005) , 10.1016/J.TCS.2004.10.033