
226 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
used like any other views in DB2, but they have two different usage scenarios
with distinct restrictions on how each can be used.
Figure 5-55 Two types of view on temporal tables
Shown in Figure 5-55, the two types of view usages are characterized as
described here; in both cases, the view can defined on the base temporal table of
either system-period or application-period types:
Restrict on temporal period
Define the view on either a certain point of time or a time period using the
FOR SYSTEM_TIME or FOR BUSINESS_TIME clauses to restrict on time.
Any othe ...