A framework for the design of ETL scenarios

Authors:
Panos Vassiliadis;Alkis Simitsis;Panos Georgantas;Manolis Terrovitis
Affiliations:
University of Ioannina, Dept. of Computer Science, Ioannina, Greece;National Technical University of Athens, Dept. of Electrical and Computer Eng., Athens, Greece;National Technical University of Athens, Dept. of Electrical and Computer Eng., Athens, Greece;National Technical University of Athens, Dept. of Electrical and Computer Eng., Athens, Greece
Venue:
CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering
Year:
2003

Citing 6
Cited 16

A logical language for data and knowledge bases

A logical language for data and knowledge bases
AJAX: an extensible data cleaning tool

SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom

The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Conceptual modeling for ETL processes

Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Potter's Wheel: An Interactive Data Cleaning System

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

Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)

Optimizing ETL Processes in Data Warehouses

ICDE '05 Proceedings of the 21st International Conference on Data Engineering
State-Space Optimization of ETL Workflows

IEEE Transactions on Knowledge and Data Engineering
A generic and customizable framework for the design of ETL scenarios

Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Data management research at the Knowledge and Database Systems Lab: (NTU Athens)

ACM SIGMOD Record
Data quality awareness: a case study for cost optimal association rule mining

Knowledge and Information Systems - Special Issue on Mining Low-Quality Data
A method for the mapping of conceptual designs to logical blueprints for ETL processes

Decision Support Systems
ETL Workflow Analysis and Verification Using Backwards Constraint Propagation

CAiSE '09 Proceedings of the 21st International Conference on Advanced Information Systems Engineering
A taxonomy of ETL activities

Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
A generic and customizable framework for the design of ETL scenarios

Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Resumption of data extraction process in parallel data warehouses

PPAM'05 Proceedings of the 6th international conference on Parallel Processing and Applied Mathematics
Improving the web usage analysis process: a UML model of the ETL process

WebKDD'04 Proceedings of the 6th international conference on Knowledge Discovery on the Web: advances in Web Mining and Web Usage Analysis
Graph-based modeling of ETL activities with multi-level transformations and updates

DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
Blueprints and measures for ETL workflows

ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Influence of balancing used in a distributed data warehouse on the extraction process

TEAA'05 Proceedings of the 31st VLDB conference on Trends in Enterprise Application Architecture
EMD: entity mapping diagram for automated extraction, transformation, and loading processes in data warehousing

International Journal of Intelligent Information and Database Systems
Using REO on ETL conceptual modelling: a first approach

Proceedings of the sixteenth international workshop on Data warehousing and OLAP

Quantified Score

Hi-index	0.00

Visualization

Abstract

Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, we delve into the logical design of ETL scenarios. We describe a framework for the declarative specification of ETL scenarios with two main characteristics: genericity and customization. Moreover, we present a palette of several templates, representing frequently used ETL activities along with their semantics and their interconnection. Finally, we discuss implementation issues and we present a graphical tool, ARKTOS II that facilitates the design of ETL scenarios, based on our model.