In this paper we propose a system supporting the semi-automatic definition of inter-attribute mappings and transformation functions used as 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 in a common representation data coming from multiple sources. Our proposal couples and extends the functionalities of two previously developed systems: the MOMIS integration system and the RELEVANT data analysis system.
An ETL tool based on semantic analysis of schemata and instances / Sonia Bergamaschi; Francesco Guerra; Mirko Orsini; Claudio Sartori; Maurizio Vincini. - STAMPA. - LNCS 5712:(2009), pp. 58-65. (Intervento presentato al convegno 13th International Conference on Knowledge-Based and Intelligent Information & Engineering Systems tenutosi a Santiago, Chile nel September 28-30, 2009).
An ETL tool based on semantic analysis of schemata and instances
SARTORI, CLAUDIO;
2009
Abstract
In this paper we propose a system supporting the semi-automatic definition of inter-attribute mappings and transformation functions used as 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 in a common representation data coming from multiple sources. Our proposal couples and extends the functionalities of two previously developed systems: the MOMIS integration system and the RELEVANT data analysis system.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.