During the last decades, the Data Warehouse has been one of the main components of a Decision Support System (DSS) inside a company. Given the great diffusion of Data Warehouses nowadays, managers have realized that there is a great potential in combining information coming from multiple information sources, like heterogeneous Data Warehouses from companies operating in the same sector. Existing solutions rely mostly on the Extract-Transform-Load (ETL) approach, a costly and complex process. The process of Data Warehous integration can be greatly simplified by developing a method that is able to semi-automatically discover semantic relationships among attributes of two or more different, heterogeneous Data Warehouse schemas. In this paper, we propose a method for the semi-automatic discovery of mappings between dimension hierarchies of heterogeneous Data Warehouses. Our approach exploits techniques from the Data Integration research area by combining topological properties of dimensions and semantic techniques.

Dimension matching in Peer-to-Peer Data Warehousing / Bergamaschi, Sonia; Marius Octavian, Olaru; Sorrentino, Serena; Vincini, Maurizio. - STAMPA. - 238:(2012), pp. 149-160. ((Intervento presentato al convegno Fusing Decision Support Systems into the Fabric of the Context tenutosi a Anávissos, Greece nel 28-30 june, 2012 [10.3233/978-1-61499-073-4-149].

Dimension matching in Peer-to-Peer Data Warehousing

BERGAMASCHI, Sonia;SORRENTINO, Serena;VINCINI, Maurizio
2012-01-01

Abstract

During the last decades, the Data Warehouse has been one of the main components of a Decision Support System (DSS) inside a company. Given the great diffusion of Data Warehouses nowadays, managers have realized that there is a great potential in combining information coming from multiple information sources, like heterogeneous Data Warehouses from companies operating in the same sector. Existing solutions rely mostly on the Extract-Transform-Load (ETL) approach, a costly and complex process. The process of Data Warehous integration can be greatly simplified by developing a method that is able to semi-automatically discover semantic relationships among attributes of two or more different, heterogeneous Data Warehouse schemas. In this paper, we propose a method for the semi-automatic discovery of mappings between dimension hierarchies of heterogeneous Data Warehouses. Our approach exploits techniques from the Data Integration research area by combining topological properties of dimensions and semantic techniques.
Fusing Decision Support Systems into the Fabric of the Context
Anávissos, Greece
28-30 june, 2012
238
149
160
Bergamaschi, Sonia; Marius Octavian, Olaru; Sorrentino, Serena; Vincini, Maurizio
Dimension matching in Peer-to-Peer Data Warehousing / Bergamaschi, Sonia; Marius Octavian, Olaru; Sorrentino, Serena; Vincini, Maurizio. - STAMPA. - 238:(2012), pp. 149-160. ((Intervento presentato al convegno Fusing Decision Support Systems into the Fabric of the Context tenutosi a Anávissos, Greece nel 28-30 june, 2012 [10.3233/978-1-61499-073-4-149].
File in questo prodotto:
Non ci sono file associati a questo prodotto.
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: https://hdl.handle.net/11380/778889
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 4
  • ???jsp.display-item.citation.isi??? 1
social impact