Skip to main content
SpringerLink
Log in

Schema Versioning for Archives in Database Systems

  • Conference paper
Advances in Conceptual Modeling (ER 1999)

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

Included in the following conference series:

Abstract

Extremely large and ever growing databases lead to severe problems in storage, database administration, and performance. The integration of archives into database systems represents a new approach to relieve a database of rarely used data. Archive data is separated from the database logically and physically and can be placed on tertiary storage. Time-related aspects play an important role in the development of functionality and a suitable infrastructure for archiving. One of these aspects stems from schema changes in database or archive which should not affect already archived data. We show how the impact of these changes can be handled by archive schema versioning.

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. C. De Castro, F. Grandi, and M. R. Scalas. Schema versioning for multitemporal relational databases. Information Systems, 22(5):249–290, July 1997.

    Article  MATH  Google Scholar 

  2. R. Cochrane, H. Pirahesh, and N. Mattos. Integrating triggers and declarative constraints in SQL database systems. In Proceedings of the 22nd Int. Conference on Very Large Data Bases (VLDB), pages 567–578, Mumbai (Bombay), India, September 1996.

    Google Scholar 

  3. K. Dittrich, S. Gatziu, and A. Geppert, editors. The active database management system manifesto: A rulebase of ADBMS features. SIGMOD Record, 25(3):40–49, September 1996.

    Google Scholar 

  4. A. Herbst and B. Malle. Electronic archiving in the light of product liability. In Proceedings of Intellectual Property Rights and New Technologies (KnowRight), pages 155–160, Vienna, Austria, August 1995.

    Google Scholar 

  5. ISO/IEC 9075:1992. Information Technology — Database Languages — SQL, 1992.

    Google Scholar 

  6. ISO/IEC 9075:1992/Cor.1:1996(E). Information Technology — Database Languages — SQL — Technical Corrigendum 1, 1996.

    Google Scholar 

  7. J. Lufter. Archive SQL: Eine Spracherweiterung für die Archivierung in Datenbanksystemen. Master’s thesis, Department of Mathematics and Computer Science, University of Jena, Germany, April 1998. In German.

    Google Scholar 

  8. J. F. Roddick. Schema evolution in database systems — An annotated bibliography. SIGMOD Record, 21(4):35–40, December 1992.

    Article  Google Scholar 

  9. J. F. Roddick and R. T. Snodgrass. Schema versioning. In R. T. Snodgrass, editor, The TSQL2 Temporal Query Language, chapter 22, pages 427–449. Kluwer Academic Publishers, Boston, 1995.

    Google Scholar 

  10. R. Schaarschmidt and J. Lufter. An architecture for archives in database systems. Research report Math/Inf/98/18, Department of Mathematics and Computer Science, University of Jena, Germany, June 1998.

    Google Scholar 

  11. R. T. Snodgrass, editor. The TSQL2 Temporal Query Language. Kluwer Academic Publishers, Boston, 1995.

    MATH  Google Scholar 

  12. A. U. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R. Snodgrass. Temporal Databases: Theory, Design, and Implementation. Benjamin/Cummings, Redwood City, CA, 1993.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Mathematics and Computer Science, University of Jena, Ernst-Abbe-Platz 1-4, D-07743, Jena, Germany

    Ralf Schaarschmidt & Jens Lufter

Authors
  1. Ralf Schaarschmidt
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jens Lufter
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, Louisiana State University, 298 Coates Hall, Baton Rouge, LA, 70803, USA

    Peter P. Chen

  2. Department of Computer Science, Brigham Young University, Provo, UT, 84602, USA

    David W. Embley

  3. INSA-LISI, 20 Avenue Albert Einstein, F-69621, Villeurbanne Cedex, France

    Jacques Kouloumdjian

  4. Marriott School of Management, Brigham Young University, P.O. Box 23087, Provo, UT, 84602-3087, USA

    Stephen W. Liddle

  5. School of Computer and Information Science, University of South Australia, Mawson Lakes, 5095, South Australia

    John F. Roddick

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Schaarschmidt, R., Lufter, J. (1999). Schema Versioning for Archives in Database Systems. In: Chen, P.P., Embley, D.W., Kouloumdjian, J., Liddle, S.W., Roddick, J.F. (eds) Advances in Conceptual Modeling. ER 1999. Lecture Notes in Computer Science, vol 1727. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48054-4_8

Download citation

  • DOI: https://doi.org/10.1007/3-540-48054-4_8

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66653-0

  • Online ISBN: 978-3-540-48054-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation