|
1. |
Poster Session: Adapting Mixed Workloads to Meet SLOs in Autonomic DBMSs
Baoning Niu; Martin, P.; Powley, W.; Bird, P.; Horman, R.;
Data Engineering Workshop, 2007 IEEE 23rd International Conference on
17-20 April 2007
Page(s):478
-
484
Abstract:
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.
|