Based on a whitepaper by Mathias Nicola.
Time Travel Query - Temporal data management with IBM InfoSphere Warehouse 10
“The only reason for time is so that everything doesn’t happen at once.” - Albert Einstein
Today, organizations need to track and capture time for the critical purpose of understanding and measuring change and also achieving greater business accuracy using historic data through temporal data management (time travel). The key organizational drivers for this ‘time travel’ include:
- Governance, risk and compliance (GRC) initiatives and the often-associated need to meet auditing requirements
- Improved decision making by means of management of an organization’s time dimension, such as past and future effective dates of business information
InfoSphere Warehouse 10 and the underlying database DB2 10 engine’s Time Travel Query includes temporal queries, temporal updates and temporal constraints, among many new features to enable time travel.
Organizations often must manage business time periods while retaining a full history of all changes and corrections. Therefore, data needs to be managed along two dimensions of time: business time and system time. This powerful combination is known as bitemporal data management. DB2 is designed for bitemporal data management, integrating system time and business time features. It also supports the SQL:2011 standard, which helps simplify management of data along both dimensions of time.
For example the ‘FOR PORTION OF BUSINESS_TIME’ clause is one of several language constructs in the SQL:2011 standard that simplify temporal data management. DB2 10 support for this SQL standard provides several advantages:
Also listen to Mathias Nicola's podcast on the IBM Data Magazine here: PODCAST: Time Travel Query for DB2 10
- Standardization of temporal processing logic across applications, which helps increase consistency and protect IT investments
- High-quality data across the enterprise and reduced business risk
- Exceptional performance, because temporal operations are deeply integrated in the DB2 engine