Quality of Service-enabled Management of Database Workloads

Database administrators struggle when managing workloads that have widely different performance requirements. For example, the same database may support short-running OLTP queries and batch jobs containing multitudes of queries with varying complexity. Different workloads may have different performance requirements, expressed in terms of service level objectives (SLOs) that must be fulfilled in order to keep the issuing database users satisfied. In this paper, we identify basic query classes and describe the challenges they pose for SLO-aware workload management. Additionally, we propose a generic architecture for an SLO-aware DBMS. We give an overview of workload management techniques already implemented in today’s DBMS and outline future research directions for as yet unsupported concepts.

[1]  Shivakumar Venkataraman,et al.  Cost-based optimization of decision support queries using transient-views , 1998, SIGMOD '98.

[2]  M. L. Kersten,et al.  A framework for multi query optimization , 1997 .

[3]  Alfons Kemper,et al.  Quality of Service Enabled Database Applications , 2006, ICSOC.

[4]  Surajit Chaudhuri,et al.  Stop-and-Restart Style Execution for Long Running Decision Support Queries , 2007, VLDB.

[5]  Amr El Abbadi,et al.  Multiple query optimization by cache-aware middleware using query teamwork , 2002, Proceedings 18th International Conference on Data Engineering.

[6]  Marcin Zukowski,et al.  Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS , 2007, VLDB.

[7]  KemperAlfons,et al.  Adaptive quality of service management for enterprise services , 2008 .

[8]  WeikumGerhard,et al.  The COMFORT automatic tuning project , 1994 .

[9]  Philip S. Yu,et al.  Multi-query SQL Progress Indicators , 2006, EDBT.

[10]  Goetz Graefe,et al.  Dynamic resource brokering for multi-user query execution , 1995, SIGMOD '95.

[11]  David J. DeWitt,et al.  Dynamic Memory Allocation for Multiple-Query Workloads , 1993, VLDB.

[12]  Surajit Chaudhuri,et al.  When can we trust progress estimators for SQL queries? , 2005, SIGMOD '05.

[13]  Badrish Chandramouli,et al.  Query suspend and resume , 2007, SIGMOD '07.

[14]  Alfons Kemper,et al.  Adaptive quality of service management for enterprise services , 2008, TWEB.

[15]  Patrick Martin,et al.  Workload adaptation in autonomic DBMSs , 2006, CASCON.

[16]  Erich M. Nahum,et al.  Achieving Class-Based QoS for Transactional Workloads , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[17]  Hongjun Lu,et al.  Dynamic Task Allocation in a Distributed Database System , 1985, ICDCS.

[18]  Tirthankar Lahiri,et al.  The Oracle database resource manager: Scheduling CPU resources at the application , 2001 .

[19]  Harumi A. Kuno,et al.  Dynamic Workload Management for Very Large Data Warehouses: Juggling Feathers and Bowling Balls , 2007, VLDB.