A Comparison of Different Forms of Temporal Data Management

  • Florian KünznerEmail author
  • Dušan Petković
Part of the Communications in Computer and Information Science book series (CCIS, volume 521)


Recently, the ANSI committee for the standardization of the SQL language has published the specification for temporal data support. This new ability allows users to create and manipulate temporal data in a significantly simpler way instead of implementing the same features using triggers and database applications. In this article we examine the creation and manipulation of temporal data using built-in temporal logic and compare its performance with the performance of equivalent hand-coded applications. For this study, we use an existing commercial database system, which supports the standardized temporal data model.


Temporal data SQL:2011 Performance Trigger 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Atay, C.: A Comparison of Attribute and Tuple Time Stamped Bitemporal Relational Data Models. In: Int. Conf. on Applied Computer Science (2010)Google Scholar
  2. 2.
    Boehlen, M., Snodgrass, R.: Coalescing in Temporal Databases, VLDB (1996)Google Scholar
  3. 3.
    Darwen, H., Date, C.: An Overview and Analysis of Proposals Based on the TSQL2 Approach (1996), (last visit: February 14, 2014)
  4. 4.
    Gadia, S.: Ben-Zvi’s Pioneering Work in Relational Temporal Databases. In: Tansel, A., et al. (eds.) Temporal Databases. Benjamin/Cummings (1993)Google Scholar
  5. 5.
    Grandi, F.: Introducing an Annotated Bibliography on Temporal and Evolution Aspects in the Semantic Web. SIGMOD Records 41(4) (2012)Google Scholar
  6. 6.
    Kulkarni, K., Michels, J.: Temporal Features in SQL:2011. SIGMOD Records 41(3) (2012)Google Scholar
  7. 7.
    ISO/IEC 9075-2:2011: Database languages: SQL, Part 2 (2011)Google Scholar
  8. 8.
    Jensen, C.S., et al.: The consensus glossary of temporal database concepts - February 1998 version. In: Etzion, O., Jajodia, S., Sripada, S. (eds.) Temporal Databases - Research and Practice. LNCS, vol. 1399, pp. 367–405. Springer, Heidelberg (1998)Google Scholar
  9. 9.
    Lorentzos, N.: The Interval-extended Relational Model and Its Applications to Valid-time. In: Temporal Databases (1993)Google Scholar
  10. 10.
    Nicola, M., Sommerlandt, M.: Managing time in DB2 with temporal consistency. IBM Developers Works (2011)Google Scholar
  11. 11.
    Petković, D.: Was lange währt, wird endlich gut: Temporale Daten im SQL-Standard. Datenbank-Spektrum 13(2), 131–138 (2013) (in German)Google Scholar
  12. 12.
    Saracco, C., Nicola, M., Gandhi, L.: A matter of time: Temporal data management in DB2 (2012), (last visit: February 14, 2014)
  13. 13.
    Snodgrass, R., Ahn, I.: Performance Evaluation of a Temporal Database Management System. Communications of ACM (1986)Google Scholar
  14. 14.
    Snodgrass, R.: The TSQL2 Temporal Query Language. Kluwer (1995)Google Scholar
  15. 15.
    Tansel, A., Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R.: Temporal Databases (1993)Google Scholar
  16. 16.
    Toman, D.: A Point-based Temporal Extension of SQL. In: Bry, F., Ramakrishnan, R., Ramamohanarao, K. (eds.) DOOD 1997. LNCS, vol. 1341, pp. 103–121. Springer, Heidelberg (1997)Google Scholar
  17. 17.
    Bach, M., Werner, A.: Standardization of NoSQL Database Languages. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2014. CCIS, vol. 424, pp. 50–60. Springer, Heidelberg (2014)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  1. 1.University of Applied SciencesRosenheimGermany

Personalised recommendations