Articles & Content

Archives

Temporal Data Management with DB2 10 - A Deep Dive

Topic: DB2 for LUW

Subtopic: 2012



Time is a critical dimension in data management. Many enterprises are required to be able to go back in time and look at past states of their data. Companies also need to manage time as it relates to business records, such as "effective dates" to indicate that information is valid for certain periods in the past, presence, or future. This session describes the new temporal data management capabilities in DB2 LUW and explains new temporal SQL operations through a series of examples. This session also explains the differences between system time, business time, and bitemporal data management, and when to use which one. You also learn how applications can easily see different points in time through the use of DB2 special registers.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.