A framework for the design of ETL scenarios

Vassiliadis, P; Simitsis, A; Georgantas, P; Terrovitis, M

dc.contributor.author	Vassiliadis, P	en
dc.contributor.author	Simitsis, A	en
dc.contributor.author	Georgantas, P	en
dc.contributor.author	Terrovitis, M	en
dc.date.accessioned	2014-03-01T01:18:31Z
dc.date.available	2014-03-01T01:18:31Z
dc.date.issued	2003	en
dc.identifier.issn	0302-9743	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/15061
dc.subject	Data Warehouse	en
dc.subject	Logic Design	en
dc.subject	Extract Transform Load	en
dc.subject.classification	Computer Science, Theory & Methods	en
dc.title	A framework for the design of ETL scenarios	en
heal.type	journalArticle	en
heal.identifier.primary	10.1007/3-540-45017-3_35	en
heal.identifier.secondary	http://dx.doi.org/10.1007/3-540-45017-3_35	en
heal.language	English	en
heal.publicationDate	2003	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. 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. © Springer-Verlag Berlin Heidelberg 2003.	en
heal.publisher	SPRINGER-VERLAG BERLIN	en
heal.journalName	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)	en
heal.bookName	LECTURE NOTES IN COMPUTER SCIENCE	en
dc.identifier.doi	10.1007/3-540-45017-3_35	en
dc.identifier.isi	ISI:000185035400033	en
dc.identifier.volume	2681	en
dc.identifier.spage	520	en
dc.identifier.epage	535	en