Skip to main content

Synonyms

Time interval

Definition

If the time domain is a totally ordered set T = {t1, t2, t3...} then a time period over T is defined as a convex subset of elements from T.

Example: If T = {d1, d2, d3,...}, where di are consecutive dates, then [d10, d20] and [d30, d80] represent two time periods over T.

Key Points

In the area of temporal databases, a time period over T is usually defined as a distinct data type. Some researchers define a time period data type of the form [tp, tq]. Some others define such a data type of the form [tp, tq), i.e., its right end is closed.

Note that, initially, the term time interval was used instead of time period. This was later abandoned in order to avoid confusion, given that interval is a reserved word in SQL. Instead, time interval in today used with a different meaning (see time interval).

Cross-references

Absolute Time

Chronon

Period-Stamped Temporal Models

Time Domain

Time Interval

Temporal Granularity

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

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

Lorentzos, N.A. (2009). Time Period. In: LIU, L., ÖZSU, M.T. (eds) Encyclopedia of Database Systems. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-39940-9_1425

Download citation

Publish with us

Policies and ethics