Representation of conceptual ETL designs in natural language using Semantic Web technology

Simitsis, A; Skoutas, D; Castellanos, M

dc.contributor.author	Simitsis, A	en
dc.contributor.author	Skoutas, D	en
dc.contributor.author	Castellanos, M	en
dc.date.accessioned	2014-03-01T01:34:27Z
dc.date.available	2014-03-01T01:34:27Z
dc.date.issued	2010	en
dc.identifier.issn	0169-023X	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/20736
dc.subject	Conceptual model	en
dc.subject	Data warehouses	en
dc.subject	ETL	en
dc.subject	Metadata	en
dc.subject	Natural language	en
dc.subject	Ontologies	en
dc.subject	Semantic Web	en
dc.subject.classification	Computer Science, Artificial Intelligence	en
dc.subject.classification	Computer Science, Information Systems	en
dc.subject.other	Conceptual model	en
dc.subject.other	Conceptual modeling	en
dc.subject.other	Customizable	en
dc.subject.other	Data store	en
dc.subject.other	Data warehouse architecture	en
dc.subject.other	Design steps	en
dc.subject.other	Domain ontologies	en
dc.subject.other	Error prones	en
dc.subject.other	ETL process	en
dc.subject.other	Extract transform loads	en
dc.subject.other	Linguistic techniques	en
dc.subject.other	Natural languages	en
dc.subject.other	Ontologies semantic web	en
dc.subject.other	Reasoner	en
dc.subject.other	Research approach	en
dc.subject.other	Semantic Web technology	en
dc.subject.other	Technical skills	en
dc.subject.other	Template-based	en
dc.subject.other	Conceptual design	en
dc.subject.other	Data warehouses	en
dc.subject.other	Linguistics	en
dc.subject.other	Machine design	en
dc.subject.other	Metadata	en
dc.subject.other	Multi agent systems	en
dc.subject.other	Ontology	en
dc.subject.other	Semantics	en
dc.subject.other	Semantic Web	en
dc.title	Representation of conceptual ETL designs in natural language using Semantic Web technology	en
heal.type	journalArticle	en
heal.identifier.primary	10.1016/j.datak.2009.08.009	en
heal.identifier.secondary	http://dx.doi.org/10.1016/j.datak.2009.08.009	en
heal.language	English	en
heal.publicationDate	2010	en
heal.abstract	Extract-Transform-Load (ETL) processes constitute the back stage of Data Warehouse architectures. Several studies characterize the ETL design as a time-consuming and error-prone procedure. A critical phase in the ETL lifecycle involves the early communications and design steps that aim at producing a conceptual ETL design. Various research approaches have dealt with the conceptual modeling of ETL processes, but all share two inconveniences: they require intensive human effort from the designers to create them, as well as technical knowledge from the business people to understand them. In this paper, we focus on the second aspect and provide a method for the representation of a conceptual ETL design as a narrative, which is the most natural means of communication and does not require particular technical skills or familiarity with any specific model. Specifically, this work builds upon previously proposed techniques that automate the conceptual design by leveraging Semantic Web technology. The key idea is to map the involved data stores, either source or target, to a domain ontology and then, to use a reasoner for producing the ETL design. We discuss how linguistic techniques can be used for the establishment of a common application vocabulary. We present a flexible and customizable template-based mechanism for the representation of the ETL design as a narrative. Finally, we discuss issues related to the production of meaningful reports and we provide implementation details. (C) 2009 Elsevier B.V. All rights reserved.	en
heal.publisher	ELSEVIER SCIENCE BV	en
heal.journalName	Data and Knowledge Engineering	en
dc.identifier.doi	10.1016/j.datak.2009.08.009	en
dc.identifier.isi	ISI:000273112900006	en
dc.identifier.volume	69	en
dc.identifier.issue	1	en
dc.identifier.spage	96	en
dc.identifier.epage	115	en