Capacity planning for Web performance: metrics, models, and methods
Capacity planning for Web performance: metrics, models, and methods
The evolution of workload management in data processing industry: a survey
ACM '86 Proceedings of 1986 ACM Fall joint computer conference
A methodology for workload characterization of E-commerce sites
Proceedings of the 1st ACM conference on Electronic commerce
Preserving QoS of e-commerce sites through self-tuning: a performance model approach
Proceedings of the 3rd ACM conference on Electronic Commerce
Multiclass Query Scheduling in Real-Time Database Systems
IEEE Transactions on Knowledge and Data Engineering
Towards Automated Performance Tuning for Complex Workloads
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Performance management for cluster-based web services
IEEE Journal on Selected Areas in Communications
Dynamic workload management for very large data warehouses: juggling feathers and bowling balls
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Adaptive quality of service management for enterprise services
ACM Transactions on the Web (TWEB)
Towards self-tuning of dynamic resources for workloads
Proceedings of the 1st international conference on Forensic applications and techniques in telecommunications, information, and multimedia and workshop
DBMS workload control using throttling: experimental insights
CASCON '08 Proceedings of the 2008 conference of the center for advanced studies on collaborative research: meeting of minds
Using economic models to allocate resources in database management systems
CASCON '08 Proceedings of the 2008 conference of the center for advanced studies on collaborative research: meeting of minds
System Models for Goal-Driven Self-management in Autonomic Databases
KES '09 Proceedings of the 13th International Conference on Knowledge-Based and Intelligent Information and Engineering Systems: Part II
Adaptive query scheduling for mixed database workloads with multiple objectives
Proceedings of the Third International Workshop on Testing Database Systems
System models for goal-driven self-management in autonomic databases
Data & Knowledge Engineering
Interaction-aware scheduling of report-generation workloads
The VLDB Journal — The International Journal on Very Large Data Bases
Workload management: a technology perspective with respect to self-* characteristics
Artificial Intelligence Review
Hi-index | 0.00 |
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). This paper presents a framework and a prototype implementation of a query scheduler that performs workload adaptation in a DBMS. The system manages multiple classes of queries to meet their performance goals by allocating DBMS resources through admission control in the presence of workload fluctuation. The resource allocation plan is derived by maximizing the objective function that encapsulates the performance goals of all classes and their importance to the business. A first-principle performance model is used to predict the performance under the new resource allocation plan. Experiments with IBM® DB2® Universal Database™ are conducted to show the effectiveness of the framework.