Skip to main content
SpringerLink
Log in

Temporal Data in Relational Database Systems: A Comparison

  • Conference paper
  • First Online:
New Advances in Information Systems and Technologies

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 444))

Abstract

Several database systems have implemented temporal data support, partly according to the model specified in the last SQL standard and partly according to other, older temporal models. In this article we use the most important temporal concepts to investigate their implementations in enterprise database systems. Also, we discuss strengths and weaknesses of these implementations and give suggestions for future extensions.

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 259.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.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. Allen,J.-Maintaining knowledge about temporal intervals,in CACM, 1983

    Google Scholar 

  2. Böhlen, M.,Snodgrass,R.-Coalescing in Temporal Databases, VLDB, 1996

    Google Scholar 

  3. ISO/IEC 9075-2:Information technology–DB languages–Part 2, 2011

    Google Scholar 

  4. Nicola, M.; Sommerlandt, M. - Managing time in DB2 with temporal consistency, www.ibm.com/developerworks/data/library/techarticle/dm-1207/index.html, 2012

  5. Multitemporal Features in Oracle 12c, www.salvis.com/blog/2014/01/04/multi-temporal-database-features-in-oracle-12c/

  6. Oracle Flashback Data Archive, http://www.oracle-dba-online.com

  7. Petković, D. – Modern Temporal Data Models: Strengths and Weaknesses, BDAS 2015, Springer, Communication in Computer Science, Vol. 521

    Google Scholar 

  8. Petković, D.-SQL Server 2016, Beginner’s Guide, McGraw-Hill, 2016 (to appear)

    Google Scholar 

  9. Saracco, C., Nicola, M., Gandhi, L. - A matter of time: Temporal data management in DB2, www.ibm.com/developerworks/data/library/techarticle, 2012

  10. Sannik, G.; Daniels, F. - Enabling the Temporal Data Warehouse, http://www.teradata.com/white-papers/Enabling-the-Temporal-Data-Warehouse

  11. Snodgrass -Developing Time-Oriented Applications in SQL, Morgan Kaufman

    Google Scholar 

  12. Snodgrass, R. - A Case Study of Temporal Data, http://www.teradata.com/white-papers/A-Case-Study-of-Temporal-Data-eb6237/?type=WP

  13. Snodgrass, R. - The TSQL2 Temporal Query Language, Springer Verlag, 1995

    Google Scholar 

  14. Teradata: SQL Functions, http://tunweb.teradata.ws/tunstudent/Terad ataUserManuals/SQL_Reference__Functions_Operators_Expressions_Predicates.pdf

  15. Wijsen, J. – Temporal Integrity Constraints, www.informatique.umons.ac.be/jef

  16. Kateb, M. Ghazal, A.- An Efficient SQL rewrite approach for temporal coalescing in Teradata, DEXA 2012, LNCS, Vol 7447, pp.375-383

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Applied Sciences, Hochschulstr. 1, Rosenheim, 83024, Germany

    Dušan Petkovic

Authors
  1. Dušan Petkovic
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Dušan Petkovic .

Editor information

Editors and Affiliations

  1. DEI/FCT, Universidade de Coimbra, Coimbra, Portugal

    Álvaro Rocha

  2. ISEGI,, Universidade Nova de Lisboa, Lisboa, Portugal

    Ana Maria Correia

  3. College of Engineering, The Ohio State University, Columbus, Ohio, USA

    Hojjat Adeli

  4. DSI, Universidade do Minho, Guimarães, Portugal

    Luis Paulo Reis

  5. Rua Dom Manoel de Medeiros, s/n, DoisIrm, Universidade Federal Rural de Pernambuco, Recife, Brazil

    Marcelo Mendonça Teixeira

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Petkovic, D. (2016). Temporal Data in Relational Database Systems: A Comparison. In: Rocha, Á., Correia, A., Adeli, H., Reis, L., Mendonça Teixeira, M. (eds) New Advances in Information Systems and Technologies. Advances in Intelligent Systems and Computing, vol 444. Springer, Cham. https://doi.org/10.1007/978-3-319-31232-3_2

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-31232-3_2

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-31231-6

  • Online ISBN: 978-3-319-31232-3

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation