Seamless Integration of Archiving Functionality in OLTP/OLAP Database Systems Using Accelerator Technologies.
Knut Stolze, Oliver Koeth, Felix Beier, Carlos Caballero Grolimund, Ruiping Li · 2013
Performance Storage Saver asanew product feature. It paves another part of the way towards integrating OLTP and OLAP into asingle database system. We present the technical details of this approach, which integrates archiving functionality into the DB2 relational database systems with seamless and transparent access to the archive data. The IBM DB2 Analytics Accelerator for DB2 for z/OS offers the storage area for the archive and also delivers exceptional performance for querying the data online, archived and non-archived data alike. In this paper, wedescribe the administrative interfaces controlling which table partitions shall be archived(or restored) and the associated monitoring interfaces. Enhancements in the DB2 optimizer provide control whether archive data shall be considered for query processing or not. Strong focus was laid on using simple interfaces, and we present our approach taken during product design and development. 1