Authors:
Igor Peterson Oliveira Santos
;
Juli Kelle Góis Costa
;
Methanias Colaço Júnior
and
André Vinícius R. P. Nascimento
Affiliation:
Federal University of Sergipe - UFS, Brazil
Keyword(s):
Business Intelligence, Data Warehouse, Software Testing, Data Quality, Experimental Software Engineering, DbUnit.
Related
Ontology
Subjects/Areas/Topics:
Artificial Intelligence and Decision Support Systems
;
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Information Systems Analysis and Specification
;
Software Engineering
;
Strategic Decision Support Systems
;
Tools, Techniques and Methodologies for System Development
Abstract:
Business Intelligence (BI) relies on Data Warehouse (DW), a historical data repository designed to support the decision making process. Despite the potential benefits of a DW, data quality issues prevent users from realizing the benefits of a BI environment and Data Analytics. Problems related to data quality can arise in any stage of the ETL (Extract, Transform and Load) process, especially in the loading phase. This Paper presents an approach to automate the selection and execution of previously identified test cases for loading procedures in BI environments based on DW. To verify and validate the approach, a unit tests framework was developed. The overall goal is achieve efficiency improvement. The specific aim is reduce test effort and, consequently, promote test activities in data warehousing process. A controlled experiment evaluation in the industry carried out to investigate the adequacy of the proposed method against a generic framework for DW procedures development. Constru
cted specifically for database application tests, DbUnit was the generic framework chosen for the experiment by convenience of the programmers. The experiment's results show that our approach clearly reduces test effort when compared with execution of test cases using a generic framework.
(More)