Bitemporal modeling

<p>Bitemporal modeling is a specific case of <a href="/facts/Temporal_database/mrT0DKfy">temporal database</a> <a href="/facts/Information_modeling/6LVpQDN6">information modeling technique</a> designed to handle historical data along two different <a href="/facts/Timeline/CrrakQ6K">timelines</a>. This makes it possible to rewind the information to "as it actually was" in combination with "as it was recorded" at some point in time. In order to be able to do so, information cannot be discarded even if it is erroneous. Within, for example, <a href="/facts/Financial_reporting/c6EUpGtV">financial reporting</a> it is often desirable to be able to recreate an old <a href="/facts/Report/Kps1Yfkb">report</a> both as it actually looked at the time of creation and as it should have looked given corrections made to the data after its creation.
</p><p>Implementations of bitemporal modeling can be done using <a href="/facts/Relational_database/pEKGmJLy">relational databases</a> and <a href="/facts/Graph_database/WJfPlV3z">graph databases</a>. As such, bitemporal modeling is considered different from <a href="/facts/Dimensional_modeling/fNywevVS">dimensional modeling</a> and complementary to <a href="/facts/Database_normalization/uLCKbIBz">database normalization</a>. The <a href="/facts/SQL%3a2011/ocV3IJ5F">SQL:2011</a> standard provides language constructs for working with bitemporal data. However, as of 2011 many of the current solutions were still vendor-specific.
</p>

Bitemporal modeling open-in-new

Bitemporal modeling