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
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 ...
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