Advertisement

The COMET Metamodel for Temporal Data Warehouses

  • Johann Eder
  • Christian Koncilia
  • Tadeusz Morzy
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2348)

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.

Keywords

Dimension Data Transformation Function Integrity Constraint Structure Version Hierarchical Relation 
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

  1. [AV98]
    C. Adamson and M. Venerable. Data Warehousing Design Solutions. Wiley, New York, 1 edition, 1998.Google Scholar
  2. [BSH99]
    M. Blaschka, C. Sapia, and G. Höfling. On Schema Evolution in Multidimensional Databases. In Proc. of the DaWak’99 Conference, 1999.Google Scholar
  3. [CCS93]
    E. Codd, S. Codd, and C. Smalley. Providing OLAP to User-Analysts: An IT Mandate. Hyperion Solutions Corporation, California, 1993.Google Scholar
  4. [CS99]
    P. Chamoni and S. Stock. Temporal Structures in Data Warehousing. In Data Warehousing and Knowledge Discovery (DaWaK) 1999, pages 353–358, Italy, 1999.Google Scholar
  5. [EJS98]
    O. Etzion, S. Jajodia, and S. Sripada, editors. Temporal Databases: Research and Practise. Number LNCS 1399. Springer-Verlag, 1998.Google Scholar
  6. [EK01]
    J. Eder and C. Koncilia. Changes of Dimension Data in Temporal Data Warehouses. In Proc. of the DaWak 2001 Conference, 2001.Google Scholar
  7. [EKM01]
    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.Google Scholar
  8. [FGM00]
    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.Google Scholar
  9. [HLV00]
    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.Google Scholar
  10. [JD98]
    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].Google Scholar
  11. [Kur99]
    A. Kurz. Data Warehousing-Enabling Technology. MITP-Verlag, 1999.Google Scholar
  12. [Vai01]
    A. Vaisman. Updates, View Maintenance and Time Management in Multidimensional Databases. Universidad de Buenos Aires, 2001. Ph.D. Thesis.Google Scholar
  13. [Yan01]
    J. Yang. Temporal Data Warehousing. Stanford University, 2001. Ph.D. Thesis.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2002

Authors and Affiliations

  • Johann Eder
    • 1
  • Christian Koncilia
    • 1
  • Tadeusz Morzy
    • 2
  1. 1.Dep. of Informatics-SystemsUniversity of KlagenfurtAustria
  2. 2.Institute of Computing SciencePoznan University of TechnologyPoland

Personalised recommendations