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
Chapter 5. Temporal data management and analytics in an operational warehouse 233
This situation is brought into stark relief when we consider rows that have the
following items:
򐂰 Large objects (BLOBs, CLOBs) or large XML columns
Though rarely updated, they are copied to the history table for each
UPDATE/DELETE on the base table row.
򐂰 A large number of columns (in the hundreds) with a significant majority that
are rarely or never updated
Again, even though they never change, they are copied over and over to the
history table for each row UPDATE/DELETE.
You can split the base table into two tables:
򐂰 One table to manage the columns that do change ...
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