Coalescing Data Marts

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.

Authors:

• N. Parimala
• P. Pahwa

Keywords:

• Data warehouse
• Dimension
• OLAP
• Star Schema.

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.