loading
Documents

Research.Publish.Connect.

Paper

Authors: Zineb El Akkaoui 1 ; Alejandro Vaisman 2 and Esteban Zimányi 2

Affiliations: 1 SEEDS Team, INPT Lab, Rabat and Morocco ; 2 CoDE Lab, Université Libre de Bruxelles, Brussels and Belgium

ISBN: 978-989-758-372-8

Keyword(s): ETL processes, Data Integration Performance, Design Quality, Theoretical Validation, Empirical Validation.

Abstract: The Extraction, Transformation and Loading (ETL) process is a crucial component of a data warehousing architecture. ETL processes are usually complex and time-consuming. Particularly important (although overlooked) in ETL development is the design phase, since it impacts on the subsequent ones, i.e., implementation and execution. Addressing ETL quality at the design phase allows taking actions that can have a positive and low-cost impact on process efficiency. Using the well-known Briand et al. framework (a theoretical validation framework for system artifacts), we formally specify a set of internal metrics that we conjecture to be correlated with process efficiency. We also provide empirical validation of this correlation, as well as an analysis of the metrics that have stronger impact on efficiency. Although there exist proposals in the literature addressing design quality in ETL, as far as we are aware of, this is the first proposal aimed at using metrics over ETL models to predict the performance associated to these models. (More)

PDF ImageFull Text

Download
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.153.135.60

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:
El Akkaoui, Z.; Vaisman, A. and Zimányi, E. (2019). A Quality-based ETL Design Evaluation Framework.In Proceedings of the 21st International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-372-8, pages 249-257. DOI: 10.5220/0007786502490257

@conference{iceis19,
author={Zineb El Akkaoui. and Alejandro Vaisman. and Esteban Zimányi.},
title={A Quality-based ETL Design Evaluation Framework},
booktitle={Proceedings of the 21st International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2019},
pages={249-257},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0007786502490257},
isbn={978-989-758-372-8},
}

TY - CONF

JO - Proceedings of the 21st International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A Quality-based ETL Design Evaluation Framework
SN - 978-989-758-372-8
AU - El Akkaoui, Z.
AU - Vaisman, A.
AU - Zimányi, E.
PY - 2019
SP - 249
EP - 257
DO - 10.5220/0007786502490257

Login or register to post comments.

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