Implementations in Databases
The following implementations implement a bitemporal database in a relational database management system (RDBMS).
- Oracle Workspace Manager Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and historical versions of data in the same database.
- TimeDB TimeDB is a free temporal relational DBMS by TimeConsult. It runs as a frontend to Oracle that accepts TSQL2 statements and generates SQL92 statements.
- PostgreSQL PostgreSQL has an open-source contributed package that can be installed in the database to manage temporal data. The function reference is here.
- Teradata version 13.10 and Teradata version 14 has temporal features built into the database.
- Anchor Modeling emulates temporal features and automates the implementation in databases that lack support.
- The SQL:2011 standard added (belated) support for temporal features in synchronicity with an implementation in IBM DB2 version 10 as the so-called "time travel query".
Read more about this topic: Temporal Database