Encyclopedia of Database Systems

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

Applicability Period

  • Christian S. JensenEmail author
  • Richard T. SnodgrassEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1049


The applicability period (or period of applicability) for a modification (generally an insertion, deletion, or update) is the time period that modification is to be applied. Generally the modification is a sequenced modification and the period applies to valid time. This period should be distinguished from lifespan.

Key Points

The applicability period is specified within a modification statement. In constrast, the lifespan is an aspect of a stored fact.

This illustration uses the TSQL2 language, which has an explicit VALID clause to specify the applicability period within an INSERT, DELETE, or UPDATE statement.

For insertions, the applicability period is the valid time of the fact being inserted. The following states that Ben is in the book department for 1 month in 2007.

  • VALUES (‘Ben’, ‘Book’)

  • VALID PERIOD ‘[15 Feb 2007, 15 Mar 2007]’

For a deletion, the applicability period states for what period of time the deletion is to be applied. The following...
This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Snodgrass RT, editor. The TSQL2 temporal query language. Kluwer; 1995.Google Scholar
  2. 2.
    Snodgrass RT. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann; 1999.Google Scholar

Copyright information

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

Authors and Affiliations

  1. 1.Department of Computer ScienceAalborg UniversityAalborgDenmark
  2. 2.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  3. 3.Dataware VenturesTucsonUSA

Section editors and affiliations

  • Richard T. Snodgrass
    • 1
  • Christian S. Jensen
    • 2
  1. 1.University of ArizonaTucsonUSA
  2. 2.Aalborg UniversityAalborg ØstDenmark