An ETL Tool Based on Semantic Analysis of Schemata and Instances

Authors:
Sonia Bergamaschi;Francesco Guerra;Mirko Orsini;Claudio Sartori;Maurizio Vincini
Affiliations:
DII, Università di Modena e Reggio Emilia, Italy;DEA, Università di Modena e Reggio Emilia, Italy;DII, Università di Modena e Reggio Emilia, Italy;DEIS, Università di Bologna, Italy;DII, Università di Modena e Reggio Emilia, Italy
Venue:
KES '09 Proceedings of the 13th International Conference on Knowledge-Based and Intelligent Information and Engineering Systems: Part II
Year:
2009

Citing 4
Cited 0

Synthesizing an Integrated Ontology

IEEE Internet Computing
Extracting Relevant Attribute Values for Improved Search

IEEE Internet Computing
A generic and customizable framework for the design of ETL scenarios

Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Automatic annotation in data integration systems

OTM'07 Proceedings of the 2007 OTM confederated international conference on On the move to meaningful internet systems - Volume Part I

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this paper we propose a system supporting the semi-automatic definition of inter-attribute mappings and transformation functions used as an ETL tool in a data warehouse project. The tool supports both schema level analysis, exploited for the mapping definitions amongst the data sources and the data warehouse, and instance level operations, exploited for defining transformation functions that integrate data coming from multiple sources in a common representation. Our proposal couples and extends the functionalities of two previously developed systems: the MOMIS integration system and the RELEVANT data analysis system.