loading
Documents

Research.Publish.Connect.

Paper

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

ISBN: 978-989-758-247-9

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. Construc ted 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)

PDF ImageFull Text

Download
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 35.175.120.59

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, . 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, 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},
}

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
AU - Oliveira Santos, I.
AU - Góis Costa, J.
AU - Colaço Júnior, .
AU - R. P. Nascimento, A.
PY - 2017
SP - 304
EP - 311
DO - 10.5220/0006337503040311

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.