Measures for ETL processes models in data warehouses

Authors:
Lilia Muñoz;Jose-Norberto Mazón;Juan Trujillo
Affiliations:
Technological University of Panama, Panama, Panama;University of Alicante, Alicante, Spain;University of Alicante, Alicante, Spain
Venue:
Proceedings of the first international workshop on Model driven service engineering and data quality and security
Year:
2009

Citing 12
Cited 2

Investigating quality factors in object-oriented designs: an industrial case study

Proceedings of the 21st international conference on Software engineering
Arktos: towards the modeling, design, control and execution of ETL processes

Information Systems - Data extraction, cleaning and reconciliation
Building the Data Warehouse,3rd Edition

Building the Data Warehouse,3rd Edition
Conceptual modeling for ETL processes

Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
State-Space Optimization of ETL Workflows

IEEE Transactions on Knowledge and Data Engineering
FMESP: framework for the modeling and evaluation of software processes

Journal of Systems Architecture: the EUROMICRO Journal - Special issue: AGILE methodologies for software production
Integrated decision support systems: A data warehousing perspective

Decision Support Systems
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms

Data & Knowledge Engineering
Using Shannon Entropy in ETL Processes

SYNASC '07 Proceedings of the Ninth International Symposium on Symbolic and Numeric Algorithms for Scientific Computing
An MDA approach for the development of data warehouses

Decision Support Systems
Modelling ETL Processes of Data Warehouses with UML Activity Diagrams

OTM '08 Proceedings of the OTM Confederated International Workshops and Posters on On the Move to Meaningful Internet Systems: 2008 Workshops: ADI, AWeSoMe, COMBEK, EI2N, IWSSA, MONET, OnToContent + QSI, ORM, PerSys, RDDS, SEMELS, and SWWS
Blueprints and measures for ETL workflows

ER'05 Proceedings of the 24th international conference on Conceptual Modeling

EMD: entity mapping diagram for automated extraction, transformation, and loading processes in data warehousing

International Journal of Intelligent Information and Database Systems
Effective data warehouse for information delivery: a literature survey and classification

International Journal of Networking and Virtual Organisations

Quantified Score

Hi-index	0.00

Visualization

Abstract

In data warehousing, ETL (Extract, Transform, and Load) processes take charge of extracting the data from data sources that would be contained in the data warehouse. Due to their relevance, the quality of these processes should be formally assessed since the early stages of development, in order to avoid making bad decisions as a result of incorrect data. In this paper, a set of measures to evaluate the structural complexity of ETL process models at conceptual level is presented. Moreover, this study is accompanied by four experiments whose aim is the empirical validation of the proposed measures. The main advantage of this approach is the early evaluation of ETL process models. This early evaluation support designers in their maintenance tasks. This proposal is based on UML (Unifield Modeling Language) activity diagrams for modeling ETL processes and the adoption of the FMESP (Framework for the Modeling and Evaluation of Software Processes) framework.