8 Unleashing DB2 10 for Linux, UNIX, and Windows
2.1 Overview of Time Travel Query
A standard SELECT query against a table in a DB2 database retrieves the
currently committed value of each data row within that table. In certain instances,
an organization cannot use the currently committed value of the data, but wants
to use the data results
as of a specific point in time. In addition to allowing system
time, which is automatically provided by DB2, to be used within temporal tables,
DB2 10 provides a business time component or a combination of system time
and business time. With system time, both past and present information can be
queried; with business time, past, present, and future information can be queried.
Although business time provides ...