Analyzing Mappings and Properties in Data Warehouse Integration

Authors

  • Maurizio Vincini University of Modena and Reggio Emilia

Keywords:

data warehouse, information sharing and integration, dimension mappings

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.

Downloads

Additional Files

Published

2017-09-19

How to Cite

[1]
M. Vincini, “Analyzing Mappings and Properties in Data Warehouse Integration”, Int. j. eng. technol. innov., vol. 7, no. 4, pp. 229–242, Sep. 2017.

Issue

Vol. 7 No. 4 (2017)

Section

Articles

License

Copyright (c) 2017 International Journal of Engineering and Technology Innovation

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Copyright Notice

 

Submission of a manuscript implies: that the work described has not been published before that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication. Authors can retain copyright in their articles with no restrictions. Also, author can post the final, peer-reviewed manuscript version (postprint) to any repository or website.

 

 

Since Jan. 01, 2019, IJETI will publish new articles with Creative Commons Attribution Non-Commercial License, under Creative Commons Attribution Non-Commercial 4.0 International (CC BY-NC 4.0) License.

The Creative Commons Attribution Non-Commercial (CC-BY-NC) License permits use, distribution and reproduction in any medium, provided the original work is properly cited and is not used for commercial purposes.