About Bitemporal Data Model

This article was originally published on bmf-tech.com . Overview This post summarizes what I have researched about the Bitemporal Data Model. What is Bitemporal Data Model It is one of the data models handled in the field of Temporal Data Models, referring to a data model with two timelines among those that handle time axes. Non-Temporal Holds only the current state Does not retain information about past history or future changes Uni-Temporal Has a single timeline Retains the start date when the data is valid and the end date when the validity period ends Bi-Temporal Has two timelines Retains transaction time (system time), which is the time recorded in the database, and valid time, which is the time the event occurred Unlike Uni-Temporal, where transaction time and valid time are the same, Bi-Temporal has different timelines The background for adopting a bitemporal data model includes the following requirements: Tracking changes in data history Legal and audit requirements Improved fl