A Framework for User-Centered Declarative ETL

作者: Vasileios Theodorou , Alberto Abelló , Maik Thiele , Wolfgang Lehner

DOI: 10.1145/2666158.2666178

关键词:

摘要: As business requirements evolve with increasing information density and velocity, there is a growing need for efficiency automation of Extract-Transform-Load (ETL) processes. Current approaches the modeling optimization ETL processes provide platform-independent solutions (semi-)automated transition among different abstraction levels, focusing on cost performance. However, suggested representations are not abstract enough to communicate role process quality in user-centered perspective has yet been adequately examined. In this paper, we introduce novel methodology end-to-end design that takes under consideration both functional non-functional requirements. Based existing work, raise level conceptual representation operations show how characteristics can generate specific patterns design.

参考文章(17)
Ladjel Bellatreche, Selma Khouri, Nabila Berkani, Semantic Data Warehouse Design: From ETL to Deployment à la Carte database systems for advanced applications. pp. 64- 83 ,(2013) , 10.1007/978-3-642-37450-0_5
Matteo Golfarelli, Stefano Rizzi, Elisa Turricchia, Sprint planning optimization in agile data warehouse design data warehousing and knowledge discovery. pp. 30- 41 ,(2012) , 10.1007/978-3-642-32584-7_3
Vasileios Theodorou, Alberto Abelló, Wolfgang Lehner, Quality Measures for ETL Processes data warehousing and knowledge discovery. pp. 9- 22 ,(2014) , 10.1007/978-3-319-10160-6_2
Petar Jovanovic, Oscar Romero, Alkis Simitsis, Alberto Abelló, Integrating ETL processes from information requirements data warehousing and knowledge discovery. pp. 65- 80 ,(2012) , 10.1007/978-3-642-32584-7_6
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
Emona Nakucçi, Vasileios Theodorou, Petar Jovanovic, Alberto Abelló, Bijoux: Data Generator for Evaluating ETL Process Quality data warehousing and olap. pp. 23- 32 ,(2014) , 10.1145/2666158.2666183
Panos Vassiliadis, Alkis Simitsis, Eftychia Baikousi, A taxonomy of ETL activities Proceeding of the ACM twelfth international workshop on Data warehousing and OLAP - DOLAP '09. pp. 25- 32 ,(2009) , 10.1145/1651291.1651297
Matthias Boehm, Uwe Wloka, Dirk Habich, Wolfgang Lehner, GCIP Proceedings of the 12th International Conference on Extending Database Technology Advances in Database Technology - EDBT '09. pp. 1128- 1131 ,(2009) , 10.1145/1516360.1516494
Lilia Muñoz, Jose-Norberto Mazón, Juan Trujillo, Automatic generation of ETL processes from conceptual models Proceeding of the ACM twelfth international workshop on Data warehousing and OLAP - DOLAP '09. pp. 33- 40 ,(2009) , 10.1145/1651291.1651298