Chapter 5. Temporal data management and analytics in an operational warehouse 231
5.3.2 System-period temporal tables and history table storage
Although the benefits of using system-period temporal tables in InfoSphere
Warehouse 10.1 have been thoroughly discussed at this point in the chapter, you
also must consider the trade-offs. The introduction and management of history
tables for every system-period temporal tables carries with it the performance
and storage overhead associated with managing that history table. In this
section, we consider these trade-offs and discuss various best practices to use
when selecting and designing for system-pe ...
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.