Skip to main content
SpringerLink
Log in

Schema Versioning in Data Warehouses

  • Conference paper
Conceptual Modeling for Advanced Application Domains (ER 2004)

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

Included in the following conference series:

Abstract

As several mature implementations of data warehousing systems are fully operational, a crucial role in preserving their up-to-dateness is played by the ability to manage the changes that the data warehouse (DW) schema undergoes over time in response to evolving business requirements. In this paper we propose an approach to schema versioning in DWs, where the designer may decide to undertake some actions on old data aimed at increasing the flexibility in formulating cross-version queries, i.e., queries spanning multiple schema versions. After introducing an algebra of DW schema operations, we define a history of versions for data warehouse schemata and discuss the relationship between the temporal horizon spanned by a query and the schema on which it can consistently be formulated.

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 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.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. Eder, J., Koncilia, C.: Changes of dimension data in temporal data warehouses. In: Proc. DaWaK, pp. 284–293 (2001)

    Google Scholar 

  2. Yang, J.: Temporal data warehousing. PhD thesis, Stanford University (2001)

    Google Scholar 

  3. Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. IJCIS 7, 215–247 (1998)

    Google Scholar 

  4. Maier, D.: The theory of relational databases. Computer Science Press, Rockville (1983)

    MATH  Google Scholar 

  5. Lechtenbörger, J.: Computing Unique Canonical Covers for Simple FDs via Transitive Reduction. Technical report, Angewandte Mathematik und Informatik, University of Muenster, Germany. To appear on Information Processing Letters (2004)

    Google Scholar 

  6. Aho, A.V., Garey, M.R., Ullman, J.D.: The transitive reduction of a directed graph. SIAM Journal on Computing 1, 131–137 (1972)

    Article  MATH  MathSciNet  Google Scholar 

  7. Lechtenbörger, J., Vossen, G.: Multidimensional normal forms for data warehouse design. Information Systems 28, 415–434 (2003)

    Article  MATH  Google Scholar 

  8. Pourabbas, E., Shoshani, A.: Answering Joint Queries from Multiple Aggregate OLAP Databases. In: Proc. 5th DaWaK, Prague (2003)

    Google Scholar 

  9. McKenzie, E., Snodgrass, R.: Schema evolution and the relational algebra. Information Systems 15, 207–232 (1990)

    Article  Google Scholar 

  10. Roddick, J., Snodgrass, R.: Schema versioning. In: The TSQL2 Temporal Query Language, pp. 425–446. Kluwer Academic Publishers, Dordrecht (1995)

    Google Scholar 

  11. Jensen, C.S., Clifford, J., Elmasri, R., Gadia, S.K., Hayes, P.J., Jajodia, S.: A consensus glossary of temporal database concepts. ACM SIGMOD Record 23, 52–64 (1994)

    Article  Google Scholar 

  12. Roddick, J.: A survey of schema versioning issues for database systems. Information and Software Technology 37, 383–393 (1995)

    Article  Google Scholar 

  13. Quix, C.: Repository Support for Data Warehouse Evolution. In: Proc. DMDW (1999)

    Google Scholar 

  14. Vaisman, A., Mendelzon, A., Ruaro, W., Cymerman, S.: Supporting dimension updates in an OLAP server. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 67–82. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  15. Blaschka, M.: FIESTA - A framework for schema evolution in multidimensional databases. PhD thesis, Technische Universitat Munchen, Germany (2000)

    Google Scholar 

  16. Eder, J., Koncilia, C., Morzy, T.: The COMET Metamodel for temporal data warehouses. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 83–99. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  17. Oracle: Oracle change management pack. Oracle Technical White Paper (2000)

    Google Scholar 

  18. Kalido: Kalido dynamic information warehouse - a technical overview. KALIDO White Paper (2004)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. DEIS, University of Bologna, Italy

    Matteo Golfarelli & Stefano Rizzi

  2. Dept. of Information Systems, University of Muenster, Germany

    Jens Lechtenbörger & Gottfried Vossen

Authors
  1. Matteo Golfarelli
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jens Lechtenbörger
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Stefano Rizzi
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Gottfried Vossen
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Key Laboratory of Data Engineering and Knowledge Engineering, (Renmin University of China), MOE, 100872, Beijing, P.R. China

    Shan Wang

  2. University of Kyoto, Japan

    Katsumi Tanaka

  3. Department of Computer Science and Engineering, Fudan University, 200433, China

    Shuigeng Zhou

  4. School of Computing, National University of Singapore,  

    Tok-Wang Ling

  5. Department of Computer Science and Technology, Tongji University, 201804, China

    Jihong Guan

  6. Key Laboratory of High Confidence Software Technologies (Peking University), Ministry of Education, China, School of Electronics Engineering and Computer Science, Peking University, China

    Dong-qing Yang

  7. Dipartimento di Elettronica, Informatica e Sistemistica, Alma Mater Studiorum – Università di Bologna, Italy

    Fabio Grandi

  8. School of Computer Science & Informatics, University College Dublinq, Belfield, Dublin 4, Ireland

    Eleni E. Mangina

  9. College of Information Science and Technology, Drexel University, USA

    Il-Yeol Song

  10. Institute for Applied Informatics, Alpen-Adria-Universität Klagenfurt, Austria

    Heinrich C. Mayr

Rights and permissions

Reprints and permissions

Copyright information

© 2004 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Golfarelli, M., Lechtenbörger, J., Rizzi, S., Vossen, G. (2004). Schema Versioning in Data Warehouses. In: Wang, S., et al. Conceptual Modeling for Advanced Application Domains. ER 2004. Lecture Notes in Computer Science, vol 3289. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30466-1_38

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-30466-1_38

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-23722-8

  • Online ISBN: 978-3-540-30466-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation