Scalable Information Systems. 4th International ICST Conference, INFOSCALE 2009, Hong Kong, June 10-11, 2009, Revised Selected Papers

Research Article

Scalable Workload Adaptation for Mixed Workload

Download
401 downloads
  • @INPROCEEDINGS{10.1007/978-3-642-10485-5_9,
        author={Baoning Niu and Jian Shi},
        title={Scalable Workload Adaptation for Mixed Workload},
        proceedings={Scalable Information Systems. 4th International ICST Conference, INFOSCALE 2009, Hong Kong, June 10-11, 2009, Revised Selected Papers},
        proceedings_a={INFOSCALE},
        year={2012},
        month={5},
        keywords={Workload adaptation Performance management DBMSs},
        doi={10.1007/978-3-642-10485-5_9}
    }
    
  • Baoning Niu
    Jian Shi
    Year: 2012
    Scalable Workload Adaptation for Mixed Workload
    INFOSCALE
    Springer
    DOI: 10.1007/978-3-642-10485-5_9
Baoning Niu1,*, Jian Shi1,*
  • 1: Taiyuan University of Technology
*Contact email: niubaoning@tyut.edu.cn, shijianzhengzhou@126.com

Abstract

Workload adaptation is a performance management process in which an autonomic database management system (DBMS) efficiently makes use of its resources by filtering or controlling the workload presented to it in order to meet its Service Level Objectives (SLOs). The overhead incurred by filtering or controlling the workload is an important factor affecting the effectiveness of workload adaptation. This paper investigates the overhead of AWMF, a framework for workload adaptation and proposes a scalable approach for adapting mixed workload under the framework. The proposed approach allows Query Scheduler, the prototype implementation of AWMF, manage both OLAP and OLTP classes of queries to meet their performance goals by allocating DBMS resources through admission control in the presence of workload fluctuation. Experiments with IBM® DB2® Universal Database are conducted to show the proposed approach is scalable and effective.