Experimentation at Industrial Setting to Improve the Effectiveness of the ETL Procedures Implementation in a Business Intelligence Environment

Authors

Juli Kelle Góis Costa, UFS – Federal University of SergipeFollow
Igor Peterson Oliveira Santos, UFS – Federal University of SergipeFollow
André Vinicius Rodrigues P Nascimento, UFS – Federal University of SergipeFollow
Methanias Colaço Júnior, UFS – Federal University of SergipeFollow

Document Type

Article

Publication Date

5-2015

Keywords

Experimental Software Engineering, RAD, Data Warehouse, ETL, BI

Abstract

Business Intelligence (BI) relies on Data Warehouse (DW), a historical data repository designed to support the decision making process. Without an effective Data Warehouse, organizations cannot extract the data required for information analysis in time to enable more effective strategic, tactical, and operational insights. This paper presents an approach and a Rapid Application Development (RAD) tool to increase efficiency and effectiveness of ETL (Extract, Transform and Load) programs development. An experimental evaluation of the approach is carried out in a controlled experiment that carefully evaluated the efficiency and effectiveness of the tool in an industrial setting. The results indicate that our approach can indeed be used as method aimed at improving ETL process development.

Comments

This paper is in Portuguese (Experimentação na Indústria para Aumento da Efetividade da Construção de Procedimentos ETL em um Ambiente de Business Intelligence)

Recommended Citation

Costa, Juli Kelle Góis; Santos, Igor Peterson Oliveira; Nascimento, André Vinicius Rodrigues P; and Colaço, Methanias Júnior, "Experimentation at Industrial Setting to Improve the Effectiveness of the ETL Procedures Implementation in a Business Intelligence Environment" (2015). Proceedings of the XI Brazilian Symposium on Information Systems (SBSI 2015). 40.
https://aisel.aisnet.org/sbis2015/40