The information inside the Data Warehouse (DW) is used to take strategic decisions inside the organization that is why data quality plays a crucial role in guaranteeing the correctness of the decisions. Data quality also becomes a major issue when integrating information from two or more heterogeneous DWs. In the present paper, we perform extensive analysis of a mapping-based DW integration methodology and of its properties. In particular, we will prove that the proposed methodology guarantees coherency, meanwhile in certain cases it is able to maintain soundness and consistency. Moreover, intra-schema homogeneity is discussed and analysed as a necessary condition for summarizability and for optimization by materializing views of dependent queries.

Analyzing mappings and properties in Data Warehouse integration / Beneventano, Domenico; Olaru, MARIUS OCTAVIAN; Vincini, Maurizio. - In: INTERNATIONAL JOURNAL OF ENGINEERING AND TECHNOLOGY INNOVATION. - ISSN 2223-5329. - 7:4(2017), pp. 229-242.

Analyzing mappings and properties in Data Warehouse integration

Domenico Beneventano
;
Marius Olaru;Maurizio Vincini
2017-01-01

Abstract

The information inside the Data Warehouse (DW) is used to take strategic decisions inside the organization that is why data quality plays a crucial role in guaranteeing the correctness of the decisions. Data quality also becomes a major issue when integrating information from two or more heterogeneous DWs. In the present paper, we perform extensive analysis of a mapping-based DW integration methodology and of its properties. In particular, we will prove that the proposed methodology guarantees coherency, meanwhile in certain cases it is able to maintain soundness and consistency. Moreover, intra-schema homogeneity is discussed and analysed as a necessary condition for summarizability and for optimization by materializing views of dependent queries.
7
4
229
242
Analyzing mappings and properties in Data Warehouse integration / Beneventano, Domenico; Olaru, MARIUS OCTAVIAN; Vincini, Maurizio. - In: INTERNATIONAL JOURNAL OF ENGINEERING AND TECHNOLOGY INNOVATION. - ISSN 2223-5329. - 7:4(2017), pp. 229-242.
Beneventano, Domenico; Olaru, MARIUS OCTAVIAN; Vincini, Maurizio
File in questo prodotto:
File Dimensione Formato  
beneventano2013.pdf

Open access

Tipologia: Versione pubblicata dall'editore
Dimensione 189.59 kB
Formato Adobe PDF
189.59 kB Adobe PDF Visualizza/Apri
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: https://hdl.handle.net/11380/1153068
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 1
  • ???jsp.display-item.citation.isi??? 0
social impact