Title :
Poster Session: Adapting Mixed Workloads to Meet SLOs in Autonomic DBMSs
Author :
Niu, Baoning ; Martin, Patrick ; Powley, Wendy ; Bird, Paul ; Horman, Randy
Author_Institution :
Queen´´s Univ. Kingston, Kingston
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.
Keywords :
database management systems; query processing; OLTP queries; SLO; adapting mixed workloads; autonomic DBMS; database management system; service level objectives; workload controlling; workload filtering; Automatic control; Birds; Control systems; Cost function; Database systems; Filtering; Monitoring; Prototypes; Quadratic programming; Resource management;
Conference_Titel :
Data Engineering Workshop, 2007 IEEE 23rd International Conference on
Conference_Location :
Istanbul
Print_ISBN :
978-1-4244-0832-0
Electronic_ISBN :
978-1-4244-0832-0
DOI :
10.1109/ICDEW.2007.4401031
