Abstract
“The Times They Are A-Changing” (B. Dylan), and with them the structures, schemas, master data, etc. of data warehouses. For the correct treatment of such changes in OLAP queries the orthogonality assumption of star schemas has to be abandoned. We propose the COMET model which allows to represent not only changes of transaction data, as usual in data warehouses, but also of schema, and structure data. The COMET model can then be used as basis of OLAP tools which are aware of structural changes and permit correct query results spanning multiple periods and thus different versions of dimension data. In this paper we present the COMET metamodel in detail with all necessary integrity constraints and show how the intervals of structural stabilities can be computed for all components of a data warehouse.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
C. Adamson and M. Venerable. Data Warehousing Design Solutions. Wiley, New York, 1 edition, 1998.
M. Blaschka, C. Sapia, and G. Höfling. On Schema Evolution in Multidimensional Databases. In Proc. of the DaWak’99 Conference, 1999.
E. Codd, S. Codd, and C. Smalley. Providing OLAP to User-Analysts: An IT Mandate. Hyperion Solutions Corporation, California, 1993.
P. Chamoni and S. Stock. Temporal Structures in Data Warehousing. In Data Warehousing and Knowledge Discovery (DaWaK) 1999, pages 353–358, Italy, 1999.
O. Etzion, S. Jajodia, and S. Sripada, editors. Temporal Databases: Research and Practise. Number LNCS 1399. Springer-Verlag, 1998.
J. Eder and C. Koncilia. Changes of Dimension Data in Temporal Data Warehouses. In Proc. of the DaWak 2001 Conference, 2001.
J. Eder, C. Koncilia, and T. Morzy. A Model for a Temporal Data Warehouse. In Proc. of the Int. OESSEO 2001 Conference, Rome, Italy, 2001.
E. Franconi, F. Grandi, and F. Mandreoli. Schema Evolution and Versioning: a Logical and Computational Characterisation. In Workshop on Foundations of Models and Languages for Data and Objects, 2000.
B. Hüsemann, J. Lechtenbörger, and G. Vossen. Conceptual Data Warehouse Design. In Proc. of the International Workshop on Design and Management of Data Warehouses (DMDW 2000), Stockholm, 2000.
C. S. Jensen and C. E. Dyreson, editors. A consensus Glossary of Temporal Database Concepts-Feb. 1998 Version, pages 367–405. Springer-Verlag, 1998. in [EJS98].
A. Kurz. Data Warehousing-Enabling Technology. MITP-Verlag, 1999.
A. Vaisman. Updates, View Maintenance and Time Management in Multidimensional Databases. Universidad de Buenos Aires, 2001. Ph.D. Thesis.
J. Yang. Temporal Data Warehousing. Stanford University, 2001. Ph.D. Thesis.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Eder, J., Koncilia, C., Morzy, T. (2002). The COMET Metamodel for Temporal Data Warehouses. In: Pidduck, A.B., Ozsu, M.T., Mylopoulos, J., Woo, C.C. (eds) Advanced Information Systems Engineering. CAiSE 2002. Lecture Notes in Computer Science, vol 2348. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-47961-9_9
Download citation
DOI: https://doi.org/10.1007/3-540-47961-9_9
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-43738-3
Online ISBN: 978-3-540-47961-1
eBook Packages: Springer Book Archive