It is expensive and technically complex for businesses to develop their own infrastructure for temporal data management, such as additional tables, triggers, and application logic. Time Travel Query makes your database time-aware and keeps a history of your data changes by using temporal tables. You can travel to the past and the future, and query your data as it appeared at different points in time without having to build, maintain, and administer a complex temporal infrastructure.
Time Travel Query helps you:
For example, a database can store the history of a table (deleted rows or the original values of rows that have been updated) so you can query the past state of your data. You can also assign a date range to a row of data to indicate when it is deemed to be valid by your application or business rules. For many businesses there are important reasons to preserve the history of data changes. Without this capability in the database, it is expensive and complex for businesses to maintain audit trails for regulatory compliance.
DB2 Time Travel Query resources
- Improving data quality for exceptional business accuracy and compliance: Temporal data management with IBM DB2 Time Travel Query
- IBM DB2 Time Travel Query podcast
- Infostructure Associates: The new IBM DB2 10 - analyzing user value