Temporal Database

Temporal Database is a recent addition to the SQL:2011 standard and Oracle 12c.   However, the current Oracle 12c implementation does not enforce Temporal Constraints (like Primary Key Constraints).  At DMSTX, we can generate native PL/SQL code to perform temporal constraint enforcement.  We call it Temporal Continuity, or the assurance that temporal data is continuous (non-overlapping).

Temporal Continuity

The ability to track Transaction Time and Valid Time is a straight-forward implementation of the temporal and bi-temporal database. However, the ability to enforce temporal continuity of Foreign Key and Unique Key constraints is an important aspect of maintaining temporal continuity within that database.  This whitepaper provides definitions and examples of temporal continuity enforcement in a temporal database implementation of DDGS

DMSTEX, Dallas County, Texas is an Oracle database focused company (DMSTEX.com). Oracle and Java are registered trademarks of Oracle Corporation and/or its affiliates.