Poster Session: Adapting Mixed Workloads to Meet SLOs in Autonomic DBMSs

Workload adaptation allows an autonomic database management system (DBMS) to efficiently make use of its resources and meet its service level objectives (SLOs) by filtering or controlling the workload presented to it. Workload adaptation has been shown to be effective for OLAP and OLTP workloads. We outline a framework of workload adaptation and explain how it can be extended to manage mixed workloads comprised of both OLAP and OLTP queries. Experiments with IBM DB2 Universal Database are presented that illustrate the effectiveness of our techniques.