Modelling ETL processes of data warehouses with UML activity diagrams

 

Authors
Muñoz, Lilia; Mazón, Jose Norberto; Pardillo, Jesús; Trujillo, Juan
Format
Article
Status
publishedVersion
Description

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.
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.

Publication Year
2018
Language
eng
Topic
ETL
UML
activity diagrams
modelling processes
ETL
UML
activity diagrams
modelling processes
Repository
RI de Documento Digitales de Acceso Abierto de la UTP
Get full text
http://ridda2.utp.ac.pa/handle/123456789/4916
Rights
openAccess
License
https://creativecommons.org/licenses/by-nc-sa/4.0/