ndeed, a bitemporal database is much more powerful than a temporal database. While a temporal database tracks valid time, capturing data “as it happened in the real world,” a bitemporal database involves valid time and system time. System time records when something was recorded to the database.
In other words, bitemporal databases capture information “as it actually was.” For example, a temporal database can tell us where John Smith lived on Dec. 6, but a bitemporal database can tell us where John Smith lived on Dec. 6 as we knew it on Dec. 15. With a bitemporal database, organizations can answer the critical questions: What did you know, and when did you know it? It helps ensure that there is always a full and accurate picture of data at every point in time.
Bitemporal design is about historical data, but it’s really much more than that. It’s about strong data governance, strategic planning, risk management, and competitive advantage.