DB2 10 and time-travel queries - get it right and reap the business benefits
Speaker: Dan Luksetich, Senior DB2 Consultant
Replay: Available for your convenience, register now.
Developed for: IT and enterprise architects and managers; database administrators and managers; system programmers; and operations managers
Technical level: Advanced
Data volume is increasing at a tremendous rate, and business and regulatory demands are driving the need to maintain large volumes of data, as well as multiple versions of data. Flexibility in an application design is important, especially in the era of the ever-expanding Internet where adaptability and flexibility dictate whether a product, business, or strategy will succeed. Temporal designs give us the flexibility to store time-relative information. In that way, we add another dimension to our data store. Temporal storage not only provides valid current data, but can return to the point in time at which the data is valid. This gives us the ability to stage data for future use, or to go back in time to recreate a data condition when investigating an anomaly or performing analytics. We can also automatically track the history of changes to data for the purpose of auditing or recreating data at a specific point in time. DB2 now provides for this in an automated fashion.
Join us for a complimentary webcast and learn why so many IBM® DB2® professionals are excited about temporal tables and time-travel queries. These are among the most popular features of DB2 10 for z/OS® and LUW, and definitely two of the most powerful automated database features to come out in some time. DB2 10 temporal tables, with their built-in functionality, automatically understand the business time or system time that the data was entered into the system. This functionality is great for finding out the condition of the business as of a certain time.
In this webcast, we will go into depth on what needs to be understood and what to prepare for before using temporal tables, including proper table, index, and table space design and configuration, as well as the ongoing management of these objects. We will also discuss exactly how time-travel queries work, the increased complexity with period specifications, and the performance implications. This is a “must attend” webcast if you want your time-travel queries to perform well.
Join us after the webcast for a live question-and-answer session. The webcast will also be available for replay after the event.