| 基于影响图的数据库参数的自调节 |
| |
| 引用本文： | 张国平,孙德全. 基于影响图的数据库参数的自调节[J]. 计算机工程与设计, 2007, 28(16): 3812-3814,3817 |
| |
| 作者姓名： | 张国平 孙德全 |
| |
| 作者单位： | 中国石油大学(华东)计算机与通信工程学院,山东,东营,257061;中国石油大学(华东)计算机与通信工程学院,山东,东营,257061 |
| |
| 摘 要： | 根据负载的变化,对数据库系统所提供的可调参数或选项进行手动调节是一项很困难的任务.把以概率推理为基础的图形化模型-影响图应用到数据库参数的自调节中,主要分为以下5个步骤:影响图模型的设计,实验数据集的获取,实验数据集的离散化,影响图参数的学习,影响图的评价及使用.以Oracle的重做日志模块的参数调节做实验,结果表明,影响图可以很好地解决这类问题.
|
| 关 键 词： | 自调节 影响图 自调优 自管理 重做日志 |
| 文章编号： | 1000-7024（2007）16-3812-03 |
| 修稿时间： | 2006-09-13 |
Adaptive adjustment of DBMS parameters based on influence diagram |
| |
| ZHANG Guo-ping,SUN De-quan. Adaptive adjustment of DBMS parameters based on influence diagram[J]. Computer Engineering and Design, 2007, 28(16): 3812-3814,3817 |
| |
| Authors: | ZHANG Guo-ping SUN De-quan |
| |
| Affiliation: | College of Computer and Communication Engineering, China University of Petroleum (East China |
| |
| Abstract: | Adjusting the parameters or "knobs" of DBMS manually in response to the changing workload is a difficult task.A probabilistic,graphical model known as influence diagram is introduced to adaptively adjust the parameters of DBMS.It divided into five steps: De-signing the structure of the model,collecting the experimental data,discretizing the data,learning the model's parameters,evaluating and using the model.The experiment using this methodology to simultaneously adjust two knobs from redo log subsystem of Oracle sho-wed that the influence diagram could effectively solve such problems. |
| |
| Keywords: | adaptive adjustment influence diagram autonomic tuning self-management redo log |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
