Skip to main content

Temporal Compatibility

  • Reference work entry
Encyclopedia of Database Systems

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 non-temporal 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 has 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.

Foundations

Motivation

Most data management...

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 2,500.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

  1. Ariav G. A temporally oriented data model. ACM Trans. Database Syst., 11(4):499–527, December 1986.

    Article  Google Scholar 

  2. Bair J., Böhlen M., Jensen C.S., and Snodgrass R.T. Notions of upward compatibility of temporal query languages. Bus. Inform. (Wirtschafts Informatik), 39(1):25–34, February 1997.

    Google Scholar 

  3. Böhlen M.H., Jensen C.S., and Snodgrass R.T. Temporal statement modifiers. ACM Trans. Database Syst., 25(4):407–456, December 2000.

    Article  MATH  Google Scholar 

  4. Chomicki J., Toman D., and Böhlen M.H. Querying ATSQL databases with temporal logic. ACM Trans. Database Syst., 26(2):145–178, 2001.June

    Article  MATH  Google Scholar 

  5. Gadia S.K. and Nair S.S. Temporal databases: A prelude to parametric data. In Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, R.T. Snodgrass (eds.). Benjamin/Cummings, Redwood City, CA, USA, 1993, pp. 28–66.

    Google Scholar 

  6. Jensen C.S., Soo M.D., and Snodgrass R.T. Unifying temporal data models via a conceptual model. Inf. Syst., 19(7):513–547, December 1994.

    Article  Google Scholar 

  7. Lorentzos N.A. and Mitsopoulos Y.G. SQL extension for interval data. IEEE Trans. Knowl. Data Eng., 9(3):480–499, 1997.

    Article  Google Scholar 

  8. McKenzie E. and Snodgrass R.T. An evaluation of relational algebras incorporating the time dimension in databases. ACM Comput. Surv., 23(4):501–543, December 1991.

    Article  Google Scholar 

  9. Melton J. and Simon A.R. Understanding the New SQL: A Complete Guide. Morgan Kaufmann, San Mateo, CA, USA, 1993.

    Google Scholar 

  10. Navathe S. and Ahmed R. Temporal extensions to the relational model and SQL. In Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, R.T. Snodgrass (eds.). Benjamin/Cummings, Redwood City, CA, USA, 1993, pp. 92–109.

    Google Scholar 

  11. Sarda N. HSQL: A historical query language. In Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, R.T. Snodgrass (eds.). Benjamin/Cummings, Redwood City, CA, USA, 1993, pp. 110–140.

    Google Scholar 

  12. Snodgrass R.T. The TSQL2 Temporal Query Language. Kluwer, Boston, USA, 1995.

    MATH  Google Scholar 

  13. Snodgrass R.T. Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann, San Francisco, CA, USA, July 1999.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer Science+Business Media, LLC

About this entry

Cite this entry

Böhlen, M.H., Jensen, C.S., Snodgrass, R.T. (2009). Temporal Compatibility. In: LIU, L., ÖZSU, M.T. (eds) Encyclopedia of Database Systems. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-39940-9_1059

Download citation

Publish with us

Policies and ethics