Skip to main content

Temporal Algebras

  • Reference work entry
  • First Online:
Encyclopedia of Database Systems
  • 40 Accesses

Synonyms

Bitemporal algebras; Historical algebras; Transaction-time algebras; Valid-time algebras

Definition

Temporal algebra is a generic term for an algebra defined for a data model that organizes temporal data. A temporal data model may support valid-time (the time over which a data value is valid), transaction-time (time when a data value is recorded in the database), or both (bitemporal). So an algebra can be defined for each case, a valid-time relational algebra, a transaction-time relational algebra, or a bitemporal relational algebra, respectively. For the relational data model, temporal algebras include the temporal versions of relational algebra operations in addition to new operations for manipulating temporal data like time-slice, rollback, temporal coalesce, temporal restructuring operations, and others. For a temporal algebra, it is desirable to be closed (common algebras are closed), a consistent extension of the relational algebra, and to reduce to relational algebra...

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 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover 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

Recommended Reading

  1. Böhlen MH, Jensen CS, Snodgrass RT. Temporal statement modifiers. ACM Trans Database Syst. 2000;25(4):407–56.

    Article  MATH  Google Scholar 

  2. Böhlen MH, Snodgrass RT, Soo MD. Coalescing in temporal databases. In: Proceedings of the 22nd International Conference on Very Large Data Bases; 1996. p. 180–91.

    Google Scholar 

  3. Clifford J, Croker A. The historical relational data model (HRDM) and algebra based on lifespans. In: Proceedings of the 3rd International Conference on Data Engineering; 1987. p. 528–37.

    Google Scholar 

  4. Clifford J, Croker A, Tuzhilin A. On completeness of historical data models. ACM Trans Database Syst. 1993;19(1):64–116.

    Article  Google Scholar 

  5. Clifford J, Tansel A.U. On an algebra for historical relational databases: two views. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1985. p. 247–65.

    Article  Google Scholar 

  6. Gadia SK. A homogeneous relational model and query languages for temporal databases. ACM Trans Database Syst. 1988;13(4):418–48.

    Article  MathSciNet  MATH  Google Scholar 

  7. Gadia SK, Nair SS. Algebraic identities and query optimization in a parametric model for relational temporal databases. IEEE Trans Knowl Data Eng. 1998;10(5):793–807.

    Article  Google Scholar 

  8. Jensen CS, Soo MD, Snodgrass RT. Unifying temporal data models via a conceptual model. Inf Syst. 1994;19(7):513–47.

    Article  Google Scholar 

  9. Lorentzos NA, Johnson RG. Extending relational algebra to manipulate temporal data. Inf Syst. 1988;13(3):289–96.

    Article  MATH  Google Scholar 

  10. McKenzie E, Snodgrass RT. Evaluation of relational algebras incorporating the time dimension in databases. ACM Comput Surv. 1991;23(4):501–43.

    Article  Google Scholar 

  11. Soo MD, Jensen C, Snodgrass RT. 1An algebra for TSQL2. In: Snodgrass RT, editor. TSQL2 temporal query language. Norwell: Kluwer; 1995. p. 505–46.

    Chapter  Google Scholar 

  12. Tansel AU. Adding time dimension to relational model and extending relational algebra. Inf Syst. 1986;11(4):343–55.

    Article  MATH  Google Scholar 

  13. Tansel AU. Temporal relational data model. IEEE Trans Knowl Database Eng. 1997;9(3):464–79.

    Article  Google Scholar 

  14. Tansel AU, Arkun ME, Ozsoyoglu G. Time-by-example query language for historical databases. IEEE Trans Softw Eng. 1989;15(4):464–78.

    Article  MATH  Google Scholar 

  15. Tansel AU, Eren-Atay C. Nested bitemporal relational algebra. In: Proceedings of the 21st International Symposium on Computer and Information Sciences; 2006. p. 622–33.

    Chapter  Google Scholar 

  16. Tansel AU, Tin E. Expressive power of temporal relational query languages. IEEE Trans Knowl Data Eng. 1997;9(1):120–34.

    Article  Google Scholar 

  17. Tuzhilin A, Clifford J. A temporal relational algebra as basis for temporal relational completeness. In: Proceedings of the 16th International Conference on Very Large Data Bases; 1990. p. 13–23.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Abdullah Uz Tansel .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

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

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Tansel, A.U. (2018). Temporal Algebras. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_387

Download citation

Publish with us

Policies and ethics