ARKTOS: Towards the modeling, design, control and execution of ETL processes

Vassiliadis, P; Vagena, Z; Skiadopoulos, S; Karayannidis, N; Sellis, T

dc.contributor.author	Vassiliadis, P	en
dc.contributor.author	Vagena, Z	en
dc.contributor.author	Skiadopoulos, S	en
dc.contributor.author	Karayannidis, N	en
dc.contributor.author	Sellis, T	en
dc.date.accessioned	2014-03-01T01:16:10Z
dc.date.available	2014-03-01T01:16:10Z
dc.date.issued	2001	en
dc.identifier.issn	0306-4379	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/13960
dc.subject	Data quality	en
dc.subject	Data warehousing	en
dc.subject	Extraction-transformation-loading tools	en
dc.subject.classification	Computer Science, Information Systems	en
dc.subject.other	Computational complexity	en
dc.subject.other	Computer aided analysis	en
dc.subject.other	Data mining	en
dc.subject.other	Data structures	en
dc.subject.other	Data warehouses	en
dc.subject.other	Management information systems	en
dc.subject.other	Software prototyping	en
dc.subject.other	Data quality	en
dc.subject.other	Extraction-transformation-loading tools	en
dc.subject.other	Quality management	en
dc.subject.other	Software Package Arktos	en
dc.subject.other	Information analysis	en
dc.title	ARKTOS: Towards the modeling, design, control and execution of ETL processes	en
heal.type	journalArticle	en
heal.identifier.primary	10.1016/S0306-4379(01)00039-4	en
heal.identifier.secondary	http://dx.doi.org/10.1016/S0306-4379(01)00039-4	en
heal.language	English	en
heal.publicationDate	2001	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. Literature and personal experience have guided us to conclude that the problems concerning the ETL tools are primarily problems of complexity, usability and price. To deal with these problems we provide a uniform metamodel for ETL processes, covering the aspects of data warehouse architecture, activity modeling, contingency treatment and quality management. The ETL tool we have developed, namely ARKTOS, is capable of modeling and executing practical ETL scenarios by providing explicit primitives for the capturing of common tasks. ARKTOS provides three ways to describe an ETL scenario: a graphical point-and-click front end and two declarative languages: XADL (an XML variant), which is more verbose and easy to read and SADL (an SQL-like language) which has a quite compact syntax and is, thus, easier for authoring. (C) 2001 Elsevier Science Ltd. All rights reserved.	en
heal.publisher	PERGAMON-ELSEVIER SCIENCE LTD	en
heal.journalName	Information Systems	en
dc.identifier.doi	10.1016/S0306-4379(01)00039-4	en
dc.identifier.isi	ISI:000172158400002	en
dc.identifier.volume	26	en
dc.identifier.issue	8	en
dc.identifier.spage	537	en
dc.identifier.epage	561	en