
220 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
The results are shown in Figure 5-45.
Figure 5-45 Results of FOR BUSINESS_TIME BETWEEN ... AND .. query
5.2.5 Bitemporal tables
It is possible to define temporal tables for use as both system-period and
application-period. These are known as
bitemporal tables. These are used in
cases where you have to capture both the
system time at which a data record is
entered or valid in the database system, and the
business time for which the
record is valid or in force. As a simple example, you might want to track the time
period that customer loyalty program terms are ...