Ontology-based conceptual design of ETL processes for both structured and semi-structured data

Skoutas, D; Simitsis, A

dc.contributor.author	Skoutas, D	en
dc.contributor.author	Simitsis, A	en
dc.date.accessioned	2014-03-01T01:26:48Z
dc.date.available	2014-03-01T01:26:48Z
dc.date.issued	2007	en
dc.identifier.issn	1552-6283	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/18233
dc.relation.uri	http://www.scopus.com/inward/record.url?eid=2-s2.0-70249144124&partnerID=40&md5=2b8a9567c81c1297003fae10866c3a9a	en
dc.relation.uri	http://www.igi-pub.com/articles/details.asp?ID=7574	en
dc.relation.uri	http://www.informatik.uni-trier.de/~ley/db/journals/ijswis/ijswis3.html#SkoutasS07	en
dc.relation.uri	http://www.dblab.ntua.gr/pubs/uploads/TR-2007-20.pdf	en
dc.subject	Conceptual design	en
dc.subject	Data semantics	en
dc.subject	Data warehousing	en
dc.subject	ETL	en
dc.subject	Ontology	en
dc.subject	Semantic matching	en
dc.subject	Workflow diagram	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	Data source	en
dc.subject.other	Data warehousing	en
dc.subject.other	ETL process	en
dc.subject.other	Graph-based representations	en
dc.subject.other	Main tasks	en
dc.subject.other	Ontology semantics	en
dc.subject.other	Ontology-based	en
dc.subject.other	Reasoner	en
dc.subject.other	Schema mappings	en
dc.subject.other	Semantic correspondence	en
dc.subject.other	Semantic Web technology	en
dc.subject.other	Semi structured data	en
dc.subject.other	Workflow diagrams	en
dc.subject.other	Conceptual design	en
dc.subject.other	Management	en
dc.subject.other	Multi agent systems	en
dc.subject.other	Ontology	en
dc.subject.other	Semantic Web	en
dc.subject.other	Semantics	en
dc.subject.other	Data warehouses	en
dc.title	Ontology-based conceptual design of ETL processes for both structured and semi-structured data	en
heal.type	journalArticle	en
heal.language	English	en
heal.publicationDate	2007	en
heal.abstract	One of the main tasks in the early stages of a data warehouse project is the identification of the appropriate transformations and the specification of inter-schema mappings from the data sources to the data warehouse. In this article, we propose an ontology-based approach to facilitate the conceptual design of the back stage of a data warehouse. A graph-based representation is used as a conceptual model for the datastores, so that both structured and semi-structured data are supported and handled in a uniform way. The proposed approach is based on the use of Semantic Web technologies to semantically annotate the data sources and the data warehouse, so that mappings between them can be inferred, thereby resolving the issue of heterogeneity. Specifically, a suitable application ontology is created and used to annotate the datastores. The language used for describing the ontology is OWL-DL. Based on the provided annotations, a DL reasoner is employed to infer semantic correspondences and conflicts among the datastores, and to propose a set of conceptual operations for transforming data from the source datastores to the data warehouse. Copyright © 2007, IGI Global.	en
heal.publisher	IGI PUBLISHING	en
heal.journalName	International Journal on Semantic Web and Information Systems	en
dc.identifier.isi	ISI:000250766300001	en
dc.identifier.volume	3	en
dc.identifier.issue	4	en
dc.identifier.spage	1	en
dc.identifier.epage	24	en