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. Research has only recently dealt with the above problem and provided few models, tools and techniques to address the issues around the ETL environment [1,2,3,5]. In this paper, we present a logical model for ETL processes. The proposed model is characterized by several templates, representing frequently used ETL activities along with their semantics and their interconnection. In the full version of the paper [4] we present more details on the aforementioned issues and complement them with results on the characterization of the content of the involved data stores after the execution of an ETL scenario and impact-analysis results in the presence of changes.
[1]
Joseph M. Hellerstein,et al.
An Interactive Framework for Data Cleaning
,
2000
.
[2]
Dennis Shasha,et al.
AJAX: an extensible data cleaning tool
,
2000,
SIGMOD '00.
[3]
Timos K. Sellis,et al.
ARKTOS: towards the modeling, design, control and execution of ETL processes
,
2001,
Inf. Syst..
[4]
Joseph M. Hellerstein,et al.
An Interactive Framework for Data Cleaning and Transformation
,
1999
.