Blueprints and measures for ETL workflows

Authors:
Panos Vassiliadis;Alkis Simitsis;Manolis Terrovitis;Spiros Skiadopoulos
Affiliations:
Dept. of Computer Science, University of Ioannina, Ioannina, Hellas;Dept. of Electrical and Computer Eng., National Technical University of Athens, Athens, Hellas;Dept. of Electrical and Computer Eng., National Technical University of Athens, Athens, Hellas;Dept. of Electrical and Computer Eng., National Technical University of Athens, Athens, Hellas
Venue:
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Year:
2005

Citing 9
Cited 7

Logic programming and databases

Logic programming and databases
Property-Based Software Engineering Measurement

IEEE Transactions on Software Engineering
The Unified Modeling Language user guide

The Unified Modeling Language user guide
AJAX: an extensible data cleaning tool

SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Software metrics: roadmap

Proceedings of the Conference on The Future of Software Engineering
Conceptual modeling for ETL processes

Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Software Measurement: A Necessary Scientific Basis

IEEE Transactions on Software Engineering
Potter's Wheel: An Interactive Data Cleaning System

Proceedings of the 27th International Conference on Very Large Data Bases
A framework for the design of ETL scenarios

CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering

Data management research at the Knowledge and Database Systems Lab: (NTU Athens)

ACM SIGMOD Record
Data integration flows for business intelligence

Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
QoX-driven ETL design: reducing the cost of ETL consulting engagements

Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Measures for ETL processes models in data warehouses

Proceedings of the first international workshop on Model driven service engineering and data quality and security
ETL workflows: from formal specification to optimization

ADBIS'07 Proceedings of the 11th East European conference on Advances in databases and information systems
A family of experiments to validate measures for UML activity diagrams of ETL processes in data warehouses

Information and Software Technology
Hybrid Analytic Flows-the Case for Optimization

Fundamenta Informaticae - Scalable Workflow Enactment Engines and Technology

Quantified Score

Hi-index	0.00

Visualization

Abstract

Extract-Transform-Load (ETL) workflows are data centric workflows responsible for transferring, cleaning, and loading data from their respective sources to the warehouse. Previous research has identified graph-based techniques that construct the blueprints for the structure of such workflows. In this paper, we extend existing results by explicitly incorporating the internal semantics of each activity in the workflow graph. Apart from the value that blueprints have per se, we exploit our modeling to introduce rigorous techniques for the measurement of ETL workflows. To this end, we build upon an existing formal framework for software quality metrics and formally prove how our quality measures fit within this framework.