||It has been suggested that this article be merged into Temporal database. (Discuss) Proposed since May 2012.|
|This article needs additional citations for verification. (September 2014)|
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.
A bitemporal table 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.
- "Bitemporal tables". Retrieved 31 March 2014.
|This database-related article is a stub. You can help Wikipedia by expanding it.|