34 Unleashing DB2 10 for Linux, UNIX, and Windows
2.4 Summary
DB2 10 Time Travel Query uses temporal tables to provide the mechanism to
track either business time, system time, or both. Using system time and business
time together in a bitemporal table enables time to be used for business logic
requirements and to provide for data auditing to identify data changes over time.
This combination provides an organization with flexible data analysis over past,
present, and future time periods.
Time Travel Query provides special registers, CURRENT TEMPORAL
BUSINESS_TIME and CURRENT TEMPORAL SYSTEM_TIME, that can be
used to change the current time for a particular query session. This feature
allows database queries as of a point-in-time in the past ...