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.

An ETL tool based on semantic analysis of schemata and instances / Bergamaschi, Sonia; Guerra, Francesco; Orsini, Mirko; C., Sartori; Vincini, Maurizio. - STAMPA. - 5712:2(2009), pp. 58-65. ((Intervento presentato al convegno 13th International Conference on Knowledge-Based and Intelligent Information and Engineering Systems, KES 2009 tenutosi a Santiago, Chile nel September 28-30, 2009 [10.1007/978-3-642-04592-9_8].

An ETL tool based on semantic analysis of schemata and instances

BERGAMASCHI, Sonia;GUERRA, Francesco;ORSINI, Mirko;VINCINI, Maurizio
2009

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.
13th International Conference on Knowledge-Based and Intelligent Information and Engineering Systems, KES 2009
Santiago, Chile
September 28-30, 2009
5712
58
65
Bergamaschi, Sonia; Guerra, Francesco; Orsini, Mirko; C., Sartori; Vincini, Maurizio
An ETL tool based on semantic analysis of schemata and instances / Bergamaschi, Sonia; Guerra, Francesco; Orsini, Mirko; C., Sartori; Vincini, Maurizio. - STAMPA. - 5712:2(2009), pp. 58-65. ((Intervento presentato al convegno 13th International Conference on Knowledge-Based and Intelligent Information and Engineering Systems, KES 2009 tenutosi a Santiago, Chile nel September 28-30, 2009 [10.1007/978-3-642-04592-9_8].
File in questo prodotto:
File Dimensione Formato  
kes-finale.pdf

non disponibili

Tipologia: Pre-print dell'autore (bozza pre referaggio)
Dimensione 126.59 kB
Formato Adobe PDF
126.59 kB Adobe PDF   Visualizza/Apri   Richiedi una copia
Pubblicazioni consigliate

Caricamento pubblicazioni consigliate

Licenza Creative Commons
I metadati presenti in IRIS UNIMORE sono rilasciati con licenza Creative Commons CC0 1.0 Universal, mentre i file delle pubblicazioni sono rilasciati con licenza Attribuzione 4.0 Internazionale (CC BY 4.0), salvo diversa indicazione.
In caso di violazione di copyright, contattare Supporto Iris

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/11380/615698
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 1
  • ???jsp.display-item.citation.isi??? 0
social impact