In this paper we propose a system supporting the semi-automatic definition of inter-attribute semantic mappings and transformation functions used as an ETL tool in a data warehouse architecture. The tool supports schema level analysis, for the mapping definitions amongst the data sources and the data warehouse, and instance level operations, 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.
A semantic approach to ETL technologies / Sonia Bergamaschi; Francesco Guerra; Mirko Orsini; Claudio Sartori; Maurizio Vincini. - In: DATA & KNOWLEDGE ENGINEERING. - ISSN 0169-023X. - STAMPA. - 70:8(2011), pp. 717-731. [10.1016/j.datak.2011.03.003]
A semantic approach to ETL technologies
SARTORI, CLAUDIO;
2011
Abstract
In this paper we propose a system supporting the semi-automatic definition of inter-attribute semantic mappings and transformation functions used as an ETL tool in a data warehouse architecture. The tool supports schema level analysis, for the mapping definitions amongst the data sources and the data warehouse, and instance level operations, 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.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
