validityInterval
Validity interval, sometimes written as validityInterval, is a term used in temporal data management to describe the span of time during which a fact, value, or assertion is considered true in the real world. It is often used in contrast to transaction time, which records when data was stored or observed. The validity interval focuses on the temporal extent of the reality the data reflects, not merely when the data was recorded.
A validity interval is typically represented as a time interval with a start and an end, such
In database design, validity intervals are central to temporal and bitemporal databases. They enable queries like
Common examples include a person’s job title valid from 2015-01-01 to 2019-12-31, or a product price valid