loading...
Optimizing ETL Processes in Data Warehouses
Tokyo, Japan April 05-April 08
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2005.10321st International Conference on Data ...
 This Article 
 
Buy PURCHASE ARTICLE: $19
PDF
HTML
Buy IEEE Xplore Subscribers
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
ASCII Text
x 
 
Alkis Simitsis, Panos Vassiliadis, Timos Sellis, "Optimizing ETL Processes in Data Warehouses," Data Engineering, International Conference on, pp. 564-575, 21st International Conference on Data Engineering (ICDE'05), 2005.
 
 
BibTex
x
 
@article{ 10.1109/ICDE.2005.103,
author = {Alkis Simitsis and Panos Vassiliadis and Timos Sellis},
title = {Optimizing ETL Processes in Data Warehouses},
journal ={Data Engineering, International Conference on},
volume = {0},
year = {2005},
issn = {1084-4627},
pages = {564-575},
doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2005.103},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - CONF
JO - Data Engineering, International Conference on
TI - Optimizing ETL Processes in Data Warehouses
SN - 1084-4627
SP564
EP575
A1 - Alkis Simitsis,
A1 - Panos Vassiliadis,
A1 - Timos Sellis,
PY - 2005
KW - null
VL - 0
JA - Data Engineering, International Conference on
ER -
 
Alkis Simitsis, National Technical University of Athens
Panos Vassiliadis, University of Ioannina
Timos Sellis, National Technical University of Athens
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. Usually, these processes must be completed in a certain time window; thus, it is necessary to optimize their execution time. In this paper, we delve into the logical optimization of ETL processes, modeling it as a state-space search problem. We consider each ETL workflow as a state and fabricate the state space through a set of correct state transitions. Moreover, we provide algorithms towards the minimization of the execution cost of an ETL workflow.
Citation:
Alkis Simitsis, Panos Vassiliadis, Timos Sellis, "Optimizing ETL Processes in Data Warehouses," icde, pp.564-575, 21st International Conference on Data Engineering (ICDE'05), 2005
Usage of this product signifies your acceptance of the Terms of Use.