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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Golfarelli, M., Mandreoli, F., Penzo, W., Rizzi, S., Turricchia, E.: OLAP query reformulation in peer-to-peer data warehousing. Information Systems 37(5), 393–411 (2012)
Berger, S., Schrefl, M.: From Federated Databases to a Federated Data Warehouse System. In: Proceedings of the 41st Hawaii International International Conference on Systems Science, HICS 2008, p. 394 (2008)
Özsu, M.T., Liu, L.: Encyclopedia of Database Systems. Springer US (2009)
Banek, M., Vrdoljak, B., Tjoa, A.M., Skocir, Z.: Automated Integration of Heterogeneous Data Warehouse Schemas. IJDWM 4(4), 1–21 (2008)
Bergamaschi, S., Castano, S., Vincini, M.: Semantic Integration of Semistructured and Structured Data Sources. SIGMOD Record 28(1), 54–59 (1999)
Madhavan, J., Bernstein, P.A., Rahm, E.: Generic Schema Matching with Cupid. In: Apers, P.M.G., Atzeni, P., Ceri, S., Paraboschi, S., Ramamohanarao, K., Snodgrass, R.T. (eds.) VLDB, pp. 49–58. Morgan Kaufmann (2001)
Melnik, S., Garcia-Molina, H., Rahm, E.: Similarity Flooding: A Versatile Graph Matching Algorithm and Its Application to Schema Matching. In: ICDE, pp. 117–128 (2002)
Bergamaschi, S., Olaru, M.O., Sorrentino, S., Vincini, M.: Dimension matching in Peer-to-Peer Data Warehousing. In: 16th IFIP WG8.3 International Conference on Decision Support Systems, DSS 2012, Anávissos, Greece (2012)
Sorrentino, S., Bergamaschi, S., Gawinecki, M.: NORMS: An automatic tool to perform schema label normalization. In: ICDE, pp. 1344–1347 (2011)
Sorrentino, S., Bergamaschi, S., Gawinecki, M., Po, L.: Schema label normalization for improving schema matching. Data & Knowledge Engineering 69(12), 1254–1273 (2010)
Beneventano, D., Bergamaschi, S., Guerra, F., Vincini, M.: The MOMIS Approach to Information Integration. ICEIS (1), 194–198 (2001)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, vol. 32. John Wiley & Sons, Inc., New York (2002)
Torlone, R.: Two approaches to the integration of heterogeneous data warehouses. Distributed and Parallel Databases 23(1), 69–97 (2008)
Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley (1995)
Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Int. J. Cooperative Inf. Syst. 7(2-3), 215–247 (1998)
Golfarelli, M., Mandreoli, F., Penzo, W., Rizzi, S., Turricchia, E.: Towards OLAP query reformulation in Peer-to-Peer Data Warehousing. In: Song, I.Y., Ordonez, C. (eds.) DOLAP, pp. 37–44. ACM (2010)
Sato, H.: Handling summary information in a database. In: Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data, SIGMOD 1981, p. 98. ACM Press, New York (1981)
Malvestuto, F.M., Zuffada, C.: Statistical and Scientific Database Management. LNCS, vol. 339. Springer, Heidelberg (1989)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Olaru, MO. (2012). Partial Multi-dimensional Schema Merging in Heterogeneous Data Warehouses. In: Atzeni, P., Cheung, D., Ram, S. (eds) Conceptual Modeling. ER 2012. Lecture Notes in Computer Science, vol 7532. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-34002-4_46
Download citation
DOI: https://doi.org/10.1007/978-3-642-34002-4_46
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-34001-7
Online ISBN: 978-3-642-34002-4
eBook Packages: Computer ScienceComputer Science (R0)