Optimizing ETL processes in data warehouses

Simitsis, A; Vassiliadis, P; Sellis, T

dc.contributor.author	Simitsis, A	en
dc.contributor.author	Vassiliadis, P	en
dc.contributor.author	Sellis, T	en
dc.date.accessioned	2014-03-01T02:43:27Z
dc.date.available	2014-03-01T02:43:27Z
dc.date.issued	2005	en
dc.identifier.issn	10844627	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/31422
dc.subject	Data Warehouse	en
dc.subject	Process Model	en
dc.subject	State Space	en
dc.subject	State Transition	en
dc.subject	Time Window	en
dc.subject	Extract Transform Load	en
dc.subject.other	Data warehouse	en
dc.subject.other	Extraction-Transformation-Loading (ETL)	en
dc.subject.other	Algorithms	en
dc.subject.other	Mathematical transformations	en
dc.subject.other	Optimization	en
dc.subject.other	Data warehouses	en
dc.title	Optimizing ETL processes in data warehouses	en
heal.type	conferenceItem	en
heal.identifier.primary	10.1109/ICDE.2005.103	en
heal.identifier.secondary	http://dx.doi.org/10.1109/ICDE.2005.103	en
heal.publicationDate	2005	en
heal.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. 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. © 2005 IEEE.	en
heal.journalName	Proceedings - International Conference on Data Engineering	en
dc.identifier.doi	10.1109/ICDE.2005.103	en
dc.identifier.spage	564	en
dc.identifier.epage	575	en