Automatic generation of ETL processes from conceptual models

International Conference on Information and Knowledge Management, Proceedings

Volumn , Issue , 2009, Pages 33-40

  Mũoz, Lilia ^a   Mazón, Jose Norberto ^b   Trujillo, Juan ^a  

^a UNIVERSIDAD TECNOLÓGICA DE PANAMÁ   (Panama)

^b UNIVERSITY OF ALICANTE   (Spain)

Author keywords

Data warehouses; ETL processes; MDA; QVT

Indexed keywords

AUTOMATIC CODE GENERATIONS; AUTOMATIC GENERATION; CONCEPTUAL MODEL; CONCEPTUAL MODELING; DATA SOURCE; DECISION MAKERS; DEVELOPMENT TIME; ETL PROCESS; ETL PROCESSES; MDA(MODEL DRIVEN ARCHITECTURE); MULTI-DIMENSIONAL VIEW; OPERATIONAL DATA;

AUTOMATIC PROGRAMMING; DIELECTRIC WAVEGUIDES; KNOWLEDGE MANAGEMENT; MULTI AGENT SYSTEMS; NETWORK COMPONENTS; SOFTWARE ARCHITECTURE;

DATA WAREHOUSES;

EID: 74549184081     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1651291.1651298     Document Type: Conference Paper

References (20)

1. W. Eckerson and C. White. Evaluating ETL and data integration platforms. www.dw-institute.com/etlreport/, 2003.
2. IBM. IBM. WebSphere DataStage. http://www-01.ibm.com/software/websphere/, Visited May 2009.
3. W. Inmon. Building the Data Warehouse (3rd Edition). Wiley & Sons, New York, 2002.
4. Z. Li, J. Sun, H. Yu, and J. Zhang. Commoncube-based conceptual modeling of ETL processes. In International Conference on Control and Automation (ICCA2005), pages 131-136, 2005.
5. S. Luján-Mora, P. Vassiliadis, and J. Trujillo. Data mapping diagrams for data warehouse design with uml. In P. Atzeni, W. W. Chu, H. Lu, S. Zhou, and T. W. Ling, editors, ER, volume 3288 of Lecture Notes in Computer Science, pages 191-204. Springer, 2004.
6. S. March and A. Hevner. Integrated decision support systems: A data warehousing perspective. Decision Support Systems, 43(3):1031-1043, 2007.
7. Microsoft. Microsoft. SQL Server 2008 Integration Services (SSIS). http://msdn.microsoft.com/eses/sqlserver/cc511477.aspx, Visited May 2009.
8. J. Miller and J. Mukerji. Mda guide version 1.0.1. Technical report, Object Management Group (OMG), 2003.
9. L. Mu∼noz, J.-N. Mazón, J. Pardillo, and J. Trujillo. Modelling ETL processes of data warehouses with uml activity diagrams. In R. Meersman, Z. Tari, and P. Herrero, editors, OTM Workshops, volume 5333 of Lecture Notes in Computer Science, pages 44-53. Springer, 2008.
10. Object Management Group. Model Driven Architecture (MDA), version 1.0.1. http://www.omg.org/mda/specs.htm, Visited May 2009.
11. Object Management Group. MOF 2.0 Query/Views/Transformations. http://www.omg.org/cgi-bin/doc?ptc/2005-11-01, Visited May 2009.
12. Object Management Group. Unified Modeling Language (UML), version 2.2. http://www.omg.org/ technology/documents/formal/uml.htm, Visited May 2009.
13. Oracle. Oracle Warehouse Builder 11g. http://www.oracle.com/technology/ products/warehouse/, Visited May 2009.
14. A. Simitsis and P. Vassiliadis. A methodology for the conceptual modeling of ETL processes. In J. Eder, R. Mittermeir, and B. Pernici, editors, CAiSE Workshops, volume 75 of CEUR Workshop Proceedings. CEUR-WS.org, 2003.
15. A. Simitsis. and P. Vassiliadis A method for the mapping of conceptual designs to logical blueprints for ETL processes. Decis. Support Syst., 45(1):22-40, 2008
16. D. Skoutas and A. Simitsis. Designing ETL processes using semantic web technologies. In I.-Y. Song and P. Vassiliadis, editors, DOLAP, pages 67-74. ACM, 2006.
17. M. Solomon. Ensuring a successful data warehouse initiative. IS Management, 22(1):26-36, 2005.
18. J. Trujillo and S. Luján-Mora. A UML Based Approach for Modeling ETL Processes in Data Warehouses. In I.-Y. Song, S. W. Liddle, T. W. Ling, and P. Scheuermann, editors, ER, volume 2813 of Lecture Notes in Computer Science, pages 307-320. Springer, 2003.
19. P. Vassiliadis, A. Simitsis, P. Georgantas, M. Terrovitis, and S. Skiadopoulos. A generic and customizable framework for the design of ETL scenarios. Inf. Syst., 30(7):492-525, 2005.
20. P. Vassiliadis, A. Simitsis, and S. Skiadopoulos. Conceptual modeling for ETL processes. In D. Theodoratos, editor, DOLAP, pages 14-21. ACM, 2002.