基于Kalman原理的数据库性能预测模型的研究

摘要

In the database system is running, due to environmental constraints, its performance will gradually decline, In order to solve this problem, the database administrator often rack one＇s brains, but it is difficult to achieve the desired. In this paper the application of Kalman principle is presented. The properties to reduce the blindness of the database administrator are predicted. The database queryinto three＂ static SQL model＂ is divided. Finally, the method of using of Kalman principle is introduced to predict database performance.%在数据库系统运行中，由于受系统环境的制约，其性能会慢慢会下降，对于数据库管理员经常为了提高数据库性能而绞尽脑汁，最后达不到应有效果。本文提出应用Kalman原理提前对性能进行预测来减小数据库管理员的盲目性。首先把数据库查询划分为三个“静态SQL模型”，介绍了kalman（卡尔曼）滤波原理和优化器分析中利用kalman原理预测数据库性能的方法。