河北省科学院学报
河北省科學院學報
하북성과학원학보
JOURNAL OF THE HEBEI ACADEMY OF SCIENCES
2011年
3期
98-100
,共3页
kalman算法%协方差%关系数据库%数据库性能预测
kalman算法%協方差%關繫數據庫%數據庫性能預測
kalman산법%협방차%관계수거고%수거고성능예측
Kalman algorithm%Covariancet Relational database%Database performance prediction
在数据库系统运行中,由于受系统环境的制约,其性能会慢慢会下降,对于数据库管理员经常为了提高数据库性能而绞尽脑汁,最后达不到应有效果。本文提出应用Kalman原理提前对性能进行预测来减小数据库管理员的盲目性。首先把数据库查询划分为三个“静态SQL模型”,介绍了kalman(卡尔曼)滤波原理和优化器分析中利用kalman原理预测数据库性能的方法。
在數據庫繫統運行中,由于受繫統環境的製約,其性能會慢慢會下降,對于數據庫管理員經常為瞭提高數據庫性能而絞儘腦汁,最後達不到應有效果。本文提齣應用Kalman原理提前對性能進行預測來減小數據庫管理員的盲目性。首先把數據庫查詢劃分為三箇“靜態SQL模型”,介紹瞭kalman(卡爾曼)濾波原理和優化器分析中利用kalman原理預測數據庫性能的方法。
재수거고계통운행중,유우수계통배경적제약,기성능회만만회하강,대우수거고관리원경상위료제고수거고성능이교진뇌즙,최후체불도응유효과。본문제출응용Kalman원리제전대성능진행예측래감소수거고관리원적맹목성。수선파수거고사순화분위삼개“정태SQL모형”,개소료kalman(잡이만)려파원리화우화기분석중이용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.