Resource Selection for Autonomic Database Tuning

Jeong Seok Oh, Sang Ho Lee
2005 21st International Conference on Data Engineering Workshops (ICDEW'05)  
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
more » ... e. 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.
doi:10.1109/icde.2005.274 dblp:conf/icde/OhL05 fatcat:w2sxrlkxyjbevkca4n7tklztbq