© Copyright IBM Corp. 2012. All rights reserved. 173
Chapter 5. Temporal data management
and analytics in an
operational warehouse
In this chapter we provide an in-depth discussion of a brand-new feature in
InfoSphere Warehouse 10.1 known as temporal table support (or more popularly
as “time travel query”). Temporal-awareness in the data warehouse makes it
possible for business applications to employ time-sensitive logic for more robust
and effective applications and business intelligence reporting.
The InfoSphere Warehouse data warehouse is now able to track and act on the
notions of both system time and business time, as those terms are defined here:
???? System time: This term refers to the start and end time stamps denoting when
a record or transaction is valid in the database.
???? Business time: This term refers to the start and end time stamps or dates
when a given database record is valid from a business perspective.
The use cases for this capability are broad-based and are examined. A detailed
technical description is also provided with examples
5
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset