Definition
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.
INSERT INTO EMPLOYEE
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...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Snodgrass R.T. (ed) The TSQL2 Temporal Query Language. Kluwer Academic, 1995.
Snodgrass R.T., Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann, 1999.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer Science+Business Media, LLC
About this entry
Cite this entry
Jensen, C.S., Snodgrass, R.T. (2009). Applicability 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_1049
Download citation
DOI: https://doi.org/10.1007/978-0-387-39940-9_1049
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-35544-3
Online ISBN: 978-0-387-39940-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering