Skip to Main Content
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
book

Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

by Whei-Jen Chen, Pat Bates, Timothy Donovan, Garrett Fitzsimons, Jon Lind, Rogerio Silva
October 2012
Beginner to intermediate content levelBeginner to intermediate
506 pages
12h 43m
English
IBM Redbooks
Content preview from Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick

Publisher Resources

ISBN: 0738437255Purchase book