BitemporalDB: A Bitemporal Database in the Cloud for Financial Services Data

There is tremendous pressure on financial services organizations to ensure the highest quality of data on which to base their risk and capital adequacy calculations. The widely used method to persist data is known as mono-temporally in which the database tracks the time of data insertion. This approach does not allow for subsequent data adjustments to be tracked, however. The BitemporalDB is a Bitemporal database that uses two time-dimensions to track data: database dimension and business dimension. Together, one is able to provide data lineage that is required for most financial audit purposes. In addition, as the volume and velocity of datapoints could vary greatly, the BitemporalDB schema allows for quick search that is able to find a desired data with only two lookups that span the entire dataset.