Bitemporal data
Encyclopedia
Bitemporal data is a concept used in a temporal database
. It denotes both the valid time
and transaction time
of the data.
In a database table bitemporal data is often represented by four extra table-columns StartVT and EndVT, StartTT and EndTT. Each time interval is closed at its lower bound, and open at its upper bound
.
Temporal database
A temporal database is a database with built-in time aspects, for example a temporal data model and a temporal version of Structured Query Language.More specifically the temporal aspects usually include valid-time and transaction-time...
. It denotes both the valid time
Valid time
Valid time , a concept originated by Richard T. Snodgrass and his doctoral student, is used in temporal databases. It denotes the time period during which a database fact was, is, or will be valid in the modeled reality....
and transaction time
Transaction time
Transaction time , a concept originated by Richard T. Snodgrass and his doctoral student, is used in temporal databases. It denotes the time period during which a database fact is/was stored in the database....
of the data.
In a database table bitemporal data is often represented by four extra table-columns StartVT and EndVT, StartTT and EndTT. Each time interval is closed at its lower bound, and open at its upper bound
Upper bound
In mathematics, especially in order theory, an upper bound of a subset S of some partially ordered set is an element of P which is greater than or equal to every element of S. The term lower bound is defined dually as an element of P which is lesser than or equal to every element of S...
.