Chapter 11. Supporting Temporal Data in DB2 for z/OS

Ever since the first developers wrote the earliest programs and applications, there has been a need to store and access non-current data. Many types of data change over time, and different users and applications have requirements to access the data at different points in time. For some, the current, up-to-date values for the data are sufficient. But for others, accessing earlier versions of the data is needed.

When storing data in a traditional relational database system, various approaches historically have been used to store and access temporal data. Separate history tables are one approach (perhaps ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.