Modeling techniques for extraction transformation and load processes: a critical review

The use of Business Intelligence systems has been increased over the last fifteen years. Small and medium enterprises have seen the importance of this type of systems in supporting decision-making process. However, there is no consensus about standards that supports activities associated to the deve...

Full description

Saved in:
Bibliographic Details
Main Authors: Martínez, Alexander Bustamante, Galvis-Lista, Ernesto Amaru, Florez, Luis Carlos Gómez
Format: Conference Proceeding
Language:English
Subjects:
Bismuth
Business
Business Intelligence
Computational modeling
ETL Process Design
Information systems > Information systems applications
Load modeling
Principal component analysis
Software
Software Engineering
Unified modeling language
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The use of Business Intelligence systems has been increased over the last fifteen years. Small and medium enterprises have seen the importance of this type of systems in supporting decision-making process. However, there is no consensus about standards that supports activities associated to the development process of this type of systems, namely, ETL design, Datawarehouse design, OLAP cubes design, and others. Hence, this paper focuses on presenting a literature review about the proposed techniques for modeling the ETL process, in order to identify trends, to provide to the practitioners an overview of the field enabling them to make decisions to choose an alternative, and finally, to show to the researchers in the field of business intelligence in particular, and software engineering researchers in general, the need to work on the construction of standards to help reduce the blur found in the design activities.
DOI:10.1145/2261605.2261611