Ontology-driven conceptual design of ETL processes using graph transformations

Skoutas, D; Simitsis, A; Sellis, T

dc.contributor.author	Skoutas, D	en
dc.contributor.author	Simitsis, A	en
dc.contributor.author	Sellis, T	en
dc.date.accessioned	2014-03-01T02:46:17Z
dc.date.available	2014-03-01T02:46:17Z
dc.date.issued	2009	en
dc.identifier.issn	03029743	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/32636
dc.subject	Conceptual Design	en
dc.subject	Conceptual Model	en
dc.subject	Data Warehouse	en
dc.subject	Domain Ontology	en
dc.subject	Graph Transformation	en
dc.subject	Schema Mapping	en
dc.subject	Extract Transform Load	en
dc.subject.other	Conceptual model	en
dc.subject.other	Customizable	en
dc.subject.other	Data store	en
dc.subject.other	Domain ontologies	en
dc.subject.other	ETL process	en
dc.subject.other	Extract transform loads	en
dc.subject.other	Graph Transformation	en
dc.subject.other	Graph transformation rules	en
dc.subject.other	Graph-based representations	en
dc.subject.other	Main tasks	en
dc.subject.other	Schema mappings	en
dc.subject.other	Conceptual design	en
dc.subject.other	Data warehouses	en
dc.subject.other	Ontology	en
dc.subject.other	Semantics	en
dc.subject.other	Population statistics	en
dc.title	Ontology-driven conceptual design of ETL processes using graph transformations	en
heal.type	conferenceItem	en
heal.identifier.primary	10.1007/978-3-642-03098-7_5	en
heal.identifier.secondary	http://dx.doi.org/10.1007/978-3-642-03098-7_5	en
heal.publicationDate	2009	en
heal.abstract	One of the main tasks during the early steps of a data warehouse project is the identification of the appropriate transformations and the specification of inter-schema mappings from the source to the target data stores. This is a challenging task, requiring firstly the semantic and secondly the structural reconciliation of the information provided by the available sources. This task is a part of the Extract-Transform-Load (ETL) process, which is responsible for the population of the data warehouse. In this paper, we propose a customizable and extensible ontology-driven approach for the conceptual design of ETL processes. A graph-based representation is used as a conceptual model for the source and target data stores. We then present a method for devising flows of ETL operations by means of graph transformations. In particular, the operations comprising the ETL process are derived through graph transformation rules, the choice and applicability of which are determined by the semantics of the data with respect to an attached domain ontology. Finally, we present our experimental findings that demonstrate the applicability of our approach. © 2009 Springer-Verlag.	en
heal.journalName	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)	en
dc.identifier.doi	10.1007/978-3-642-03098-7_5	en
dc.identifier.volume	5530 LNCS	en
dc.identifier.spage	120	en
dc.identifier.epage	146	en