Coalescing Data Marts

Authors: N. Parimala, P. Pahwa

Abstract:

OLAP uses multidimensional structures, to provide access to data for analysis. Traditionally, OLAP operations are more focused on retrieving data from a single data mart. An exception is the drill across operator. This, however, is restricted to retrieving facts on common dimensions of the multiple data marts. Our concern is to define further operations while retrieving data from multiple data marts. Towards this, we have defined six operations which coalesce data marts. While doing so we consider the common as well as the non-common dimensions of the data marts.

Keywords: Data warehouse, Dimension, OLAP, Star Schema.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1085269

References:

[1] W. H. Inmon: Building the Data Warehouse. John Wiley and Sons, Second Edition 1996.
[2] R. Kimball.: The Data Warehouse Toolkit, John Wiley and Sons 1996.
[3] A. Abello, J. Samos, F. Saltor: "Implementing Operations To Navigate Semantic Star Schemata" in 6th International Workshop on Data Warehousing and OLAP (DOLAP 2003).New Orleans(USA),November 2003.Pages 56-62.ACM Press 2003 ISBN 1-58113-727-3.
[4] S. Chaudhari, U. Dayal: "An Overview of Data Warehousing and OLAP Technology" SIGMOD Record,26(1):65-74 1997.
[5] M. Golfarelli, D. Maio, S. Rizzi: "The Dimensional Fact Model: A Conceptual model for Data Warehouses" Int.Tour of Cooperative Inf. Systems 7, 2&3 1998.
[6] P. Pahwa and Parimala N.: "Conceptual Design of Data Warehouses From XML Schemata using CCM" 2nd Int. Conference on Intellectual Capital, Knowledge Management and Organizational Learning, Dubai 2005.
[7] C. Li and X.S. Wang: "A data model for supporting on-line analytical processing" in proceedings of the 5th International Conference on Information and Knowledge Management (CIKM-96), pages 81-88 1996.
[8] L. Cabibbo, R. Torlone: "On the Integration of Autonomous Data Marts" in 16th Int. Conference on Scientific and Statistical Database 2004.
[9] A. Abello, J. Samos, F. Saltor: "On Relationships Offering New Drill Across Possibilities" in Int. Workshop on Data Warehousing and OLAP (DOLAP2002).ACM 2002.
[10] L. Cabibbo, R. Torlone"Dimension Compatibility for Data Mart Integration"Proc. 12th Italian Symposium on Advanced Databases systems, Caglian Italy,2004,PP 6-17.
[11] W. Giovinazzo. O-O Data Warehouse Design. Prentice Hall, 2000.
[12] R. Agarwal, A. Gupta, S. Sarawagi: "Modelling Multidimensional Databases" in proceedings of 13th International Conference on Data Engineering (ICDE-97), Pages 232-243. IEEE Computer Society, 1997.