Partial multi-dimensional schema merging in heterogeneous data warehouses

  • Authors:
  • Marius-Octavian Olaru

  • Affiliations:
  • Department of Information Engineering (DII), University of Modena and Reggio Emilia, Modena, Italy

  • Venue:
  • ER'12 Proceedings of the 31st international conference on Conceptual Modeling
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

In recent years, novel approaches and architectures to support Data Warehouse integration (like the P2P Data Warehouse [1], also called Business Intelligence Network, or BIN) have been proposed. Although the concept has been defined from a theoretical point of view, until now no automatic or semi-automatic method that allows the integration of multidimensional information coming from heterogeneous Data Warehouses has been proposed. This paper proposes a method capable of exploiting dimension mappings between two or more multidimensional schemas in order to import and integrate heterogeneous DW instances subsets. The proposed method is based on a semi-automatic mapping generation technique previously developed, and on the dimension-chase algorithm defined in literature for integration purposes.