Supporting Data Changes in Multidimensional Data Warehouses


(*) Corresponding author


Authors' affiliations


DOI's assignment:
the author of the article can submit here a request for assignment of a DOI number to this resource!
Cost of the service: euros 10,00 (for a DOI)

Abstract


This paper is in the field of data warehouses based on “On-Line Analytical Processing” (OLAP) technology. We detail the integration of changes in a multidimensional schema. First, the conceptual model we provide integrates the changes of facts (subject of analysis) and dimensions (axes of analysis). These changes are modeled through fact and dimension versions. Second, the logical model we provide is based on Relational-OLAP concepts. The conceptual versions are translated into data version tables and structure tables.
Copyright © 2017 Praise Worthy Prize - All rights reserved.

Keywords


Multidimensional Model; Data Versions; R-OLAP

Full Text:

PDF


References


E.F. Codd, Providing OLAP (on-line analytical processing) to user-analysts: an IT mandate, Technical Report, E.F. Codd and Associates, 1993.

M. Raffanelli, Multidimensional Databases: Problems and Solutions (Idea Group, 2003).

R. Kimball, The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses (John Wiley & Sons, Inc, 1996).

A.A Vaisman, A.O Mendelzon, A temporal query language for OLAP: Implementation and a case study. Proceedings of 8th Biennial Workshop on Data Bases and Programming Languages - DBPL 2001, Rome, Italy, LNCS 2397, September 2001, pp. 78-96.

M. Body, M. Miquel, Y. Bédard, A. Tchounikine, A multidimensional and multiversion structure for OLAP Applications. Proceedings of 5th International Workshop on Data Warehousing and OLAP - DOLAP'02, USA, Nov. 2002, pp. 1-6.

S. Rizzi, M. Golfarelli, What Time Is It in the Data Warehouse?, Proceedings of 8th International Conference Data Warehousing and Knowledge Discovery, Dawak 2006, LNCS 4081, 2006, pp. 134-144.

M. Golfarelli, J. Lechtenbörger, S. Rizzi, G. Vossen. Schema Versioning in Data Warehouses: Enabling Cross-Version Querying via Schema Augmentation. Data and Knowledge Engineering, vol. 59, n. 2, pp. 435-459, 2006.

R. Wrembel, T. Morzy, Multiversion Data Warehouses: Challenges and Solutions. Proceedings of IEEE 3rd International Conference on Computational Cybernetics - ICCC'05, Mauritius, 2005, pp. 139-144.

M. Blaschka, C. Sapia, G. Höfling, On schema evolution in multidimensional databases. Proceedings of 1st International Conference on Data Warehousing and Knowledge Discovery - DaWaK'99, Florence (Italy), August 30–Sept. 1, LNCS 1676, 1999, pp 153-164.

C.A. Hurtado, A.O. Mendelzon, A.A. Vaisman, Maintaining Data cubes under dimension updates, Proceedings of 15th International Conference on Data Engineering - ICDE'99, Sydney (Australia), March 23-26, 1999, pp 346-355.

A.A. Vaisman, A.O. Mendelzon, W. Ruaro, S.G. Cymerman, Supporting dimension updates in an OLAP Server. Proceedings of 14th International Conference on Advanced Information Systems Engineering CAISE'02, Canada, 2002, pp. 67-82.

C. Hurtado, A.O. Mendelzon, A. A. Vaisman, Updating OLAP dimensions, Proceedings of the Second International Workshop on Data Warehousing and OLAP, ACM DOLAP’99, 1999, p. 60-66.

A.O. Mendelzon, A. A. Vaisman, Temporal queries in OLAP, Proceedings of 26th International Conference on Very Large Data Bases, September 10-14, 2000, VLDB 2000, Cairo (Egypt), 2000, pp 242-253.

J. Eder, C. Koncilia, Changes of Dimension Data in Temporal Data Warehouses. Proceedings of the 3rd Int. Conf. on Data Warehousing and Knowledge Discovery – DAWAK’01,LNCS 2114, Munich (Germany), 2001, pp. 284-293.

J. Eder, C. Koncilia, T. Morzy, The COMET metamodel for temporal data warehouses. Proceedings of the 14th International Conference on Advanced Information Systems Engineering CAISE'02, Canada, 2002, pp. 83–99.

B. Bebel, J. Eder, C. Koncilia T. Morzy, R. Wrembel, Creation and Management of Versions in Multiversion Data Warehouse. Proceedings of the ACM Symposium on Applied Computing, Nicosia (Cyprus), March 14-17, 200, pp. 717-72.

T. Morzy, R. Wrembel, On Querying Versions of Multiversion Data Warehouse, Proceedings of 7th International Workshop on Data Warehousing and OLAP - DOLAP’04, pp.92-101, Washington DC (USA), Nov. 12-13 2004.

E. Bertino, E. Ferrari, G. Guerrini, A formal temporal object-oriented data model. Proceedings of 5th International Conference on Extending Database Technology - EDBT’96, pp342-356, Avignon (France), March 25-29, 1996.

F. Ravat, O. Teste, G. Zurfluh, A Multiversion-based multidimensional Model, Proceedings of 8th International Conference Data Warehousing and Knowledge Discovery, DAWAK 2006, LNCS 4081, 2006, pp. 65-74.

M. Golfarelli, D. Maio, S. Rizzi, Conceptual design of data warehouses from E/R schemes, Proceedings of 31st Hawaii International Conference on System Sciences, Vol. 7, 1998, pp. 334-343.

F. Ravat, O. Teste, G. Zurfluh, Constraint-Based Multi-Dimensional Databases, In Zongmin Ma (Ed.), Database Modeling for Industrial Data Management, XI (IDEA Group, 2006, pp. 323-368).


Refbacks

  • There are currently no refbacks.


Please send any question about this web site to info@praiseworthyprize.com
Copyright © 2005-2024 Praise Worthy Prize