Self-Tuning Performance of Database Systems Based on Fuzzy Rules
Self-tuning performance of the database management system is a challenging and time-consuming work since multiple performance parameters need to be automatically adjusted.In this paper,we present a new self-tuning method based on fuzzy rules.We first automatically extract Automatic Workload Repository(AWR)report from a database system,and then construct fuzzy rules by identifying the relationship among the performance parameters and performance indicators.Finally,we develop an adaption algorithm to reconfigure the performance parameters with the fuzzy rules.Experiments on TPC-C workload show that the proposed method is feasible and effective.
Database Management System(DBMS) Performance Self-Tuning Fuzzy Rules
Zhijie Wei Zuohua Ding Jueliang Hu
Lab of Intelligent Computing and Software Engineering Zhejiang Sci-Tech University Hangzhou,Zhejiang 310018,China
国际会议
厦门
英文
195-199
2014-08-19(万方平台首次上网日期,不代表论文的发表时间)