loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

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)

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.227.239.9

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Oliveira Santos, I.; Góis Costa, J.; Colaço Júnior, M. and R. P. Nascimento, A. (2017). Experimental Evaluation of Automatic Tests Cases in Data Analytics Applications Loading Procedures. In Proceedings of the 19th International Conference on Enterprise Information Systems - Volume 1: ICEIS; ISBN 978-989-758-247-9; ISSN 2184-4992, SciTePress, pages 304-311. DOI: 10.5220/0006337503040311

@conference{iceis17,
author={Igor Peterson {Oliveira Santos}. and Juli Kelle {Góis Costa}. and Methanias {Cola\c{C}o Júnior}. and André Vinícius {R. P. Nascimento}.},
title={Experimental Evaluation of Automatic Tests Cases in Data Analytics Applications Loading Procedures},
booktitle={Proceedings of the 19th International Conference on Enterprise Information Systems - Volume 1: ICEIS},
year={2017},
pages={304-311},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006337503040311},
isbn={978-989-758-247-9},
issn={2184-4992},
}

TY - CONF

JO - Proceedings of the 19th International Conference on Enterprise Information Systems - Volume 1: ICEIS
TI - Experimental Evaluation of Automatic Tests Cases in Data Analytics Applications Loading Procedures
SN - 978-989-758-247-9
IS - 2184-4992
AU - Oliveira Santos, I.
AU - Góis Costa, J.
AU - Colaço Júnior, M.
AU - R. P. Nascimento, A.
PY - 2017
SP - 304
EP - 311
DO - 10.5220/0006337503040311
PB - SciTePress