Bitemporal data

From Wikipedia, the free encyclopedia
Jump to: navigation, search

In a temporal database, bitemporal data is 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. Normally each time interval is closed at its lower bound, and open at its upper bound.

Bitemporal Table[edit]

A bitemporal table[1] is a table that combines the historical tracking of a system-period temporal table(transaction time table) with the time-specific data storage capabilities of an application-period temporal table(valid time table). Bitemporal tables are used to keep user-based period information as well as system-based historical information.

Bitemporal tables behave as a combination of system-period temporal tables and application-period temporal tables. All the restrictions that apply to system-period temporal tables and application temporal tables also apply to bitemporal tables.

See also[edit]

  1. ^ "Bitemporal tables". Retrieved 31 March 2014.