Abstract
Database systems offering a multidimensional schema on a logical level (e.g. OLAP systems) are often used in data warehouse environments. The user requirements in these dynamic application areas are subject to frequent changes. This implies frequent structural changes of the database schema. In this paper, we present a formal framework to describe evolutions of multidimensional schemas and their effects on the schema and on the instances. The framework is based on a formal conceptual description of a multidimensional schema and a corresponding schema evolution algebra. Thus, the approach is independent of the actual implementation (e.g. MOLAP or ROLAP). We also describe how the algebra enables a tool supported environment for schema evolution.
An extended version of this paper can be downloaded at http://www.forwiss.tu-muenchen.de/∼system42/publications/
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
J. Banerjee, W. Kim, H.-J. Kim, H.F. Korth: Semantics and Implementation of Schema Evolution in Object-Oriented Databases, Proc. SIGMOD Conference, 1987.
M. Blaschka: FIESTA: A Framework for Schema Evolution in Multidimensional Information Systems, Proc. of 6th CAiSE Doctoral Consortium, 1999, Heidelberg, Germany
E. Baralis, S. Paraboschi, E. Teniente: Materialized view selection in a multidimensional database, Proceedings Conference on Very Large Databases, Athens, Greece, 1997.
L. Cabibbo, R. Torlone: A Logical Approach to Multidimensional Databases. Proc. EDBT 1998.
A. Datta, H. Thomas: A Conceptual Model and an algebra for On-Line Analytical Processing in Data Warehouses, Proc. WITS 1997
A. Gupta, I. S. Mumick: Maintenance of Materialized Views: Problems, Techniques, and Applications, Data Engineering Bulletin, June 1995.
M. Golfarelli, D. Maio, S. Rizzi, Conceptual design of data warehouses from E/R schemes, Proc. 31st Hawaii Intl. Conf. on System Sciences, 1998.
M. Golfarelli, S. Rizzi, A Methodological Framework for Data Warehouse Design, ACM DOLAP Workshop, Washington 1998
C.A. Hurtado, A.O. Mendelzon, A.A. Vaisman: Maintaining Data Cubes under Dimension Updates, Proceedings of the ICDE’ 99, Sydney Australia
G. Höfling, Schema Evolution in Object-oriented Databases,. PhD Thesis, Technische Universität München, 1996 (In German)
R. Kimball: Slowly Changing Dimensions, Data Warehouse Architect, DBMS Magazine, April 1996, URL: http://www.dbmsmag.com
W. Lehner, Multidimensional Normal Forms, Proceedings of SSDBM’98, Capri, Italy
W. Lehner: Modeling Large Scale OLAP Scenarios. Proc. of the EDBT 98, Valencia Spain http://www6.informatik.uni-erlangen.de/dept/staff/lehner-publications.html
M. Mohania: Avoiding Re-computation: View Adaptation in Data Warehouses. Proc. 8th International Database Workshop, Hong-Kong, Springer LNCS, 1997
C. Quix: Repository Support for Data Warehouse Evolution. Proc. CAiSE99 Workshop on Design and Management of Data Warehouses (DMDW99), 1999.
E.A. Rundensteiner, A.J. Lee, A. Nica: On Preserving Views in Evolving Environments. Proc. of the 4th KRDB Workshop, Athens, Greece, August 1997
C. Sapia: On Modelling and Predicting Query Behavior in OLAP Systems. Proc. CAiSE99 Workshop on Design and Management of Data Warehouses (DMDW99), 1999.
C. Sapia, M. Blaschka, G. Höfling, B. Dinter, Extending the E/R Model for the Multidimensional Paradigm, Proc. DWDM Workshop (ER98 Conference), Singapore.
C. Sapia, M. Blaschka, G. Höfling, An Overview of Multidimensional Data Models, FORWISS Technical Report FR-1999-001
M. Tresch, Evolution in Object Databases, Teubner, Stuttgart, 1995 (In German)
Panos Vassiliadis: Modeling Multidimensional Databases, Cubes and Cube Operations. Conference on Statistical and Scientific Databases (SSDBM) 1998
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Blaschka, M., Sapia, C., Höfling, G. (1999). On Schema Evolution in Multidimensional Databases. In: Mohania, M., Tjoa, A.M. (eds) DataWarehousing and Knowledge Discovery. DaWaK 1999. Lecture Notes in Computer Science, vol 1676. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48298-9_17
Download citation
DOI: https://doi.org/10.1007/3-540-48298-9_17
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66458-1
Online ISBN: 978-3-540-48298-7
eBook Packages: Springer Book Archive