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

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.
Sonia Bergamaschi; Francesco Guerra; Mirko Orsini; Claudio Sartori; Maurizio Vincini
File in questo prodotto:
Eventuali allegati, non sono esposti

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/11585/107254
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 38
  • ???jsp.display-item.citation.isi??? 27
social impact