Designing ETL processes using semantic web technologies

Skoutas, D; Simitsis, A

dc.contributor.author	Skoutas, D	en
dc.contributor.author	Simitsis, A	en
dc.date.accessioned	2014-03-01T02:44:00Z
dc.date.available	2014-03-01T02:44:00Z
dc.date.issued	2006	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/31607
dc.subject	Conceptual modeling	en
dc.subject	Data warehousing	en
dc.subject	ETL	en
dc.subject	Ontologies	en
dc.subject	Reasoning	en
dc.subject	Semantic web technology	en
dc.subject	Transformations	en
dc.subject.other	Conceptual design	en
dc.subject.other	Data structures	en
dc.subject.other	Data warehouses	en
dc.subject.other	Mathematical transformations	en
dc.subject.other	Ontology	en
dc.subject.other	Conceptual modeling	en
dc.subject.other	Data sources	en
dc.subject.other	Semantic web technology	en
dc.subject.other	Semantic Web	en
dc.title	Designing ETL processes using semantic web technologies	en
heal.type	conferenceItem	en
heal.identifier.primary	10.1145/1183512.1183526	en
heal.identifier.secondary	http://dx.doi.org/10.1145/1183512.1183526	en
heal.publicationDate	2006	en
heal.abstract	One of the most important tasks performed in the early stages of a data warehouse project is the analysis of the structure and content of the existing data sources and their intentional mapping to a common data model. Establishing the appropriate mappings between the attributes of the data sources and the attributes of the data warehouse tables is critical in specifying the required transformations in an ETL workflow. The selected data model should besuitable for facilitating the redefinition and revision efforts, typically occurring during the early phases of a data warehouse project, and serve as the means of communication between the involved parties. In this paper, we argue that ontologies constitute a very suitable model for this purpose and show how the usage of ontologies can enable a high degree of automation regarding the construction of an ETL design. Copyright 2006 ACM.	en
heal.journalName	DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP	en
dc.identifier.doi	10.1145/1183512.1183526	en
dc.identifier.spage	67	en
dc.identifier.epage	74	en