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.

• Type: Conference
• Year: 2007
• Where: ICDE
• Authors: Baoning Niu, Patrick Martin, Wendy Powley, Paul Bird, Randy Horman
• Keywords: Autonomic Database Management, Database, ICDE 2007, Service Level Objectives, Workload Adaptation