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).
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Lorentzos, N.A. (2018). Time Period. 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_1425
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1425
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering