System and method for implementing multi-temporal database functionality

摘要

A computer-implemented method, computer program product, and computing system for implementing multi-temporal tables in a database is described. One or more databases are utilized, wherein the one or more databases implement a first temporal table that includes a first and a second time domain. The one or more databases are enabled to implement a second temporal table that includes at least a third time domain, wherein the second temporal table is associated with the first temporal table.

主权项

1. A computer-implemented method comprising:
utilizing, by a computing device, one or more databases, wherein the one or more databases implement a first temporal table that includes a first and a second time domain; and enabling, by the computing device, the one or more databases to implement a second temporal table that includes at least a third time domain, wherein the second temporal table is associated with the first temporal table, wherein the third time domain defines a visibility time, wherein data is entered into the one or more databases prior to the data being publicized, wherein at least the first temporal tables includes one or more tuples of data; and upon implementing the second temporal table, ordering the one or more tuples of data based, at least in part, upon selecting only the one or more tuples of data that are active as of a start of the third time domain.