Skip to main content
SpringerLink
Log in

Changes of Dimension Data in Temporal Data Warehouses

  • Conference paper
  • First Online:
Data Warehousing and Knowledge Discovery (DaWaK 2001)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2114))

Included in the following conference series:

Abstract

Time is one of the dimensions we frequently find in data warehouses allowing comparisons of data in different periods. In current multi-dimensional data warehouse technology changes of dimension data cannot be represented adequately since all dimensions are (implicitly) considered as orthogonal. We propose an extension of the multi-dimensional data model employed in data warehouses allowing to cope correctly with changes in dimension data: a temporal multi-dimensional data model allows the registration of temporal versions of dimension data. Mappings are provided to transfer data between different temporal versions of the instances of dimensions and enable the system to correctly answer queries spanning multiple periods and thus different versions of dimension data.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. M. Blaschka. FIESTA: A Framework for Schema Evolution in Multidimensional Information Systems. In Proc. of 6th Doctoral Consortium, Germany, 1999.

    Google Scholar 

  2. M. Blaschka, C. Sapia, and G. Höfling. On Schema Evolution in Multidimensional Databases. In Proc. of the DaWak99 Conference, Florence, Italy, 1999.

    Google Scholar 

  3. M. Böhlen. Temporal Database System Implementations. SIGMOD, 24(4), 1995.

    Google Scholar 

  4. P. Chamoni and S. Stock. Temporal Structures in Data Warehousing. In Data Warehousing and Knowledge Discovery (DaWaK) 1999, p. 353–358, Italy, 1999.

    Google Scholar 

  5. S.M. Clamen. Schema Evolution and Integration. In Distributed and Parallel Databases: An International Journal, p. 2(1):101–126.

    Google Scholar 

  6. O. Etzion, S. Jajodia, and S. Sripada, editors. Temporal Databases: Research and Practise. LNCS 1399. Springer-Verlag, 1998.

    Google Scholar 

  7. Goralwalla, Tansel, and Zsu. Experimenting with Temporal Relational Databases. ACM, CIKM95, 1995.

    Google Scholar 

  8. Gregersen and Jensen. Temporal Entity-Relationship Models-a Survey. Time-Center, 1997.

    Google Scholar 

  9. C.S. Jensen and C.E. Dyreson, editors. A consensus Glossary of Temporal Database Concepts-Feb. 1998 Version. Springer-Verlag, 1998. In [6].

    Google Scholar 

  10. C. Li and X. Wang. A Data Model for Supporting On-Line Analytical Processing. ACM, CIKM 96, 1996.

    Google Scholar 

  11. C. Liu, S. Chang, and P. Chrysanthis. Database Schema Evolution using EVER Diagrams. In Proc. of the Workshop on Advanced Visual Interfaces, 1994.

    Google Scholar 

  12. A. Mendelzon and A. Vaisman. Temporal Queries in OLAP. In Proc. of the 26th VLDB Conference, Egypt, 2000.

    Google Scholar 

  13. SAP America, Inc. and SAPAG. Data Modelling with BW-ASAP for BW Accelerator. 1998. White Paper: URL: http://www.sap.com.

  14. P. Vassiliadis and T. Sellis. A Survey of Logical Models for OLAP Databases. In SIGMOD Record 28, 1999.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dep. of Informatics-Systems, University of Klagenfurt, Klagenfurt

    Johann Eder & Christian Koncilia

Authors
  1. Johann Eder
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Christian Koncilia
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Kyoto University, Kyoto, 606-8501, Japan

    Yahiko Kambayashi

  2. EC3, Siebensterngasse 21/3, 1070, Wien

    Werner Winiwarter

  3. Center for Spatial Information Science (CSIS), University of Tokyo, 4-6-1, Komaba Meguro-ku, Tokyo, 153-8904, Japan

    Masatoshi Arikawa

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Eder, J., Koncilia, C. (2001). Changes of Dimension Data in Temporal Data Warehouses. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2001. Lecture Notes in Computer Science, vol 2114. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44801-2_28

Download citation

  • DOI: https://doi.org/10.1007/3-540-44801-2_28

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42553-3

  • Online ISBN: 978-3-540-44801-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation