Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Temporal Compatibility

  • Michael H. Böhlen
  • Christian S. Jensen
  • Richard T. Snodgrass
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1059

Definition

Temporal compatibility captures properties of temporal languages with respect to the nontemporal languages that they extend. Temporal compatibility, when satisfied, ensures a smooth migration of legacy applications from a nontemporal system to a temporal system. Temporal compatibility dictates the semantics of legacy statements and constrains the semantics of temporal extensions to these statements, as well as the language design.

Historical Background

Since the very early days of temporal database research, the compatibility with legacy languages and systems have been considered, but the first comprehensive investigation was reported by Bair et al. [2]. Compatibility issues are common for work done in the context of systems and commercial languages, such as SQL or Quel. Theoretical or logic-based approaches usually do not explore compatibility notions since they tend to strictly separate temporal from nontemporal structures.

Scientific Fundamentals

Motivation

Most data...

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

Recommended Reading

  1. 1.
    Ariav G. A temporally oriented data model. ACM Trans Database Syst. 1986;11(4):499–527.CrossRefGoogle Scholar
  2. 2.
    Bair J, Böhlen M, Jensen CS, Snodgrass RT. Notions of upward compatibility of temporal query languages. Bus Inf (Wirtschafts Informatik). 1997;39(1):25–34.Google Scholar
  3. 3.
    Böhlen MH, Jensen CS, Snodgrass RT. Temporal statement modifiers. ACM Trans Database Syst. 2000;25(4):407–456.zbMATHCrossRefGoogle Scholar
  4. 4.
    Chomicki J, Toman D, Böhlen MH. Querying ATSQL databases with temporal logic. ACM Trans Database Syst. 2001;26(2):145–178.zbMATHCrossRefGoogle Scholar
  5. 5.
    Gadia SK, Nair SS. Temporal databases: a prelude to parametric data. In: Tansel A, Clifford J, Gadia S, Jajodia S, Segev A, Snodgrass RT, editors. Temporal databases: theory, design, and implementation. Redwood City: Benjamin/Cummings Publishing Company; 1993. p. 28–66.Google Scholar
  6. 6.
    Jensen CS, Soo MD, Snodgrass RT. Unifying temporal data models via a conceptual model. Inf Syst. 1994;19(7):513–47.CrossRefGoogle Scholar
  7. 7.
    Lorentzos NA, Mitsopoulos YG. SQL extension for interval data. IEEE Trans Knowl Data Eng. 1997;9(3):480–99.zbMATHCrossRefGoogle Scholar
  8. 8.
    McKenzie E, Snodgrass RT. An evaluation of relational algebras incorporating the time dimension in databases. ACM Comput Surv. 1991;23(4):501–43.CrossRefGoogle Scholar
  9. 9.
    Melton J, Simon AR. Understanding the new SQL: a complete guide. San Mateo: Morgan Kaufmann Publishers; 1993.Google Scholar
  10. 10.
    Navathe S, Ahmed R. Temporal extensions to the relational model and SQL. In: Tansel A, Clifford J, Gadia S, Jajodia S, Segev A, Snodgrass RT, editors. Temporal databases: theory, design, and implementation. Redwood City: Benjamin/Cummings Publishing Company; 1993. p. 92–109Google Scholar
  11. 11.
    Sarda N. HSQL: a historical query language. In: Tansel A, Clifford J, Gadia S, Jajodia S, Segev A, Snodgrass RT, editors. Temporal databases: theory, design, and implementation. Redwood City: Benjamin/Cummings Publishing Company; 1993.Google Scholar
  12. 12.
    Snodgrass RT. The TSQL2 temporal query language. Boston: Kluwer Academic Publishers; 1995.zbMATHCrossRefGoogle Scholar
  13. 13.
    Snodgrass RT. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann Publishers; 1999.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  • Michael H. Böhlen
    • 1
    • 2
  • Christian S. Jensen
    • 3
  • Richard T. Snodgrass
    • 4
    • 5
  1. 1.Free University of Bozen-BolzanoBozen-BolzanoItaly
  2. 2.University of ZurichZürichSwitzerland
  3. 3.Department of Computer ScienceAalborg UniversityAalborgDenmark
  4. 4.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  5. 5.Dataware VenturesTucsonUSA