Modelling ETL Processes of Data Warehouses with UML Activity Diagrams

Authors:
Lilia Muñoz;Jose-Norberto Mazón;Jesús Pardillo;Juan Trujillo
Affiliations:
Lucentia Research Group. Dep. of Information Systems, Control, Evaluation and Computing Resources, University Technological of Panama, Panama;Lucentia Research Group, Dep. of Software and Computing Systems, University of Alicante, Spain;Lucentia Research Group, Dep. of Software and Computing Systems, University of Alicante, Spain;Lucentia Research Group, Dep. of Software and Computing Systems, University of Alicante, Spain
Venue:
OTM '08 Proceedings of the OTM Confederated International Workshops and Posters on On the Move to Meaningful Internet Systems: 2008 Workshops: ADI, AWeSoMe, COMBEK, EI2N, IWSSA, MONET, OnToContent + QSI, ORM, PerSys, RDDS, SEMELS, and SWWS
Year:
2008

Citing 0
Cited 6

Automatic generation of ETL processes from conceptual models

Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Measures for ETL processes models in data warehouses

Proceedings of the first international workshop on Model driven service engineering and data quality and security
A family of experiments to validate measures for UML activity diagrams of ETL processes in data warehouses

Information and Software Technology
Improving the maintainability of data warehouse designs: modeling relationships between sources and user concepts

Proceedings of the fifteenth international workshop on Data warehousing and OLAP
BPMN-based conceptual modeling of ETL processes

DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
BPMN patterns for ETL conceptual modelling and validation

ISMIS'12 Proceedings of the 20th international conference on Foundations of Intelligent Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

Extraction-transformation-loading (ETL) processes play an important role in a data warehouse (DW) architecture because they are responsible of integrating data from heterogeneous data sources into the DW repository. Importantly, most of the budget of a DW project is spent on designing these processes since they are not taken into account in the early phases of the project but once the repository is deployed. In order to overcome this situation, we propose using the unified modelling language (UML) to conceptually model the sequence of activities involved in ETL processes from the beginning of the project by using activity diagrams (ADs). Our approach provides designers with easy-to-use modelling elements to capture the dynamic aspects of ETL processes.