作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2009, Vol. 35 ›› Issue (17): 25-27. doi: 10.3969/j.issn.1000-3428.2009.17.008

• 博士论文 • 上一篇    下一篇

一种新的数据库访问图算法及其应用

邓亚丹,景 宁,熊 伟   

  1. (国防科技大学电子科学与工程学院,长沙 410073)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2009-09-05 发布日期:2009-09-05

New Database Call Graph Algorithm and Its Application

DENG Ya-dan, JING Ning, XIONG Wei   

  1. (College of Electronic Science and Engineering, National University of Defense Technology, Changsha 410073)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-09-05 Published:2009-09-05

摘要: 针对目前数据库无法预测将要访问的页面,提出应用程序访问图模型及相关的访问图算法,分析访问图相关算法的性能。在数据库GKD-Base中实现访问图算法,基于访问图算法预测未来一段时间不会被访问的页面,根据预测便可将这些页面提前交换出缓存,达到优化缓存空间的目的。实验结果表明,在数据库内核中引入CG算法后,由于缓存空间优化,SQL执行速度得到一定程度的提高。

关键词: 访问图算法, 性能分析, 缓存优化

Abstract: Aiming at the problem that current database could not predict pages will be access, this paper presents application Call Graph(CG) model and correlative CG algorithms, and the performance of CG algorithm is analyzed. In the experiments, basing on GKD-Base, this paper realizes CG algorithms, and predicts the pages which will not be accessed in a period of time, then according to the prediction, these pages could be replaced out of page buffer ahead of schedule to optimize buffer space. Experimental results show that the database performance does not reduce after adding CG algorithms in database kernel, and instead, due to buffer space optimization, SQL execution speed is improved.

Key words: Call Graph(CG) algorithm, performance analysis, buffer optimization

中图分类号: