Resource Selection for Autonomic Database Tuning

Authors:
Jeong Seok Oh;Sang Ho Lee
Affiliations:
Soongsil University, Seoul, Korea;Soongsil University, Seoul, Korea
Venue:
ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
Year:
2005

Citing 0
Cited 3

The Psychic-Skeptic Prediction framework for effective monitoring of DBMS workloads

Data & Knowledge Engineering
Surveying the landscape: an in-depth analysis of spatial database workloads

Proceedings of the 20th International Conference on Advances in Geographic Information Systems
Self-protecting and self-optimizing database systems: implementation and experimental evaluation

Proceedings of the 2013 ACM Cloud and Autonomic Computing Conference

Quantified Score

Hi-index	0.00

Visualization

Abstract

Database administrators should be aware of resource usages to maintain database system performance. As database applications become more complex and diverse, managing database systems becomes too costly and prone to error. Autonomic database tuning becomes more important than ever. This paper starts with an analysis on how resource usages respond by changing resource sizes in database systems. Then, we present a simple method that automatically selects resources that affect the system performance. An experiment using the TPC-C and TPC-W workloads has been carried out with a commercial database system. A preliminary analysis shows that our method works.