Systematic review and comparison of modeling ETL processes in data warehouse

Abstract: In a Data Warehouse (DW), ETL processes (Extraction, Transformation, Load) are responsible for extracting, transforming and loading data from the data sources into the DW. A good design of these processes in the early stages of a DW project is essential to avoid making bad decisions as a r...

Descripción completa

Autores Principales: Muñoz, Lilia, Mazón, Jose Norberto, Trujillo, Juan
Formato: Artículo
Idioma: Inglés
Publicado: 2018
Materias:
Acceso en línea: https://ieeexplore.ieee.org/abstract/document/5556705/
http://ridda2.utp.ac.pa/handle/123456789/4920
http://ridda2.utp.ac.pa/handle/123456789/4920
Sumario: Abstract: In a Data Warehouse (DW), ETL processes (Extraction, Transformation, Load) are responsible for extracting, transforming and loading data from the data sources into the DW. A good design of these processes in the early stages of a DW project is essential to avoid making bad decisions as a result of incorrect data. In this paper, we apply the method of systematic review to identify, extract and analyze the main proposals on modeling conceptual ETL processes for DWs. The main proposals are identified and compared based on the features, activities and notation of ETL processes. Finally we conclude the study by reflecting on the approaches being studied and providing an updated framework for future research.