计算机工程与应用 ›› 2008, Vol. 44 ›› Issue (4): 184-186.

• 数据库与信息处理 • 上一篇    下一篇

自优化查询处理器的研究与实现

李 健,施 磊,柏文阳   

  1. 计算机软件新技术国家重点实验室,南京 210093
    南京大学 计算机科学与技术系,南京 210093
  • 收稿日期:2007-06-04 修回日期:2007-07-05 出版日期:2008-02-01 发布日期:2008-02-01
  • 通讯作者: 李 健

Research and implementation of self-optimize query processor

LI Jian,SHI Lei,BAI Wen-yang   

  1. State Key Laboratory for Novel Software Technology,Nanjing University,Nanjing 210093,China
    Department of Computer Science and Technology,Nanjing University,Nanjing 210093,China
  • Received:2007-06-04 Revised:2007-07-05 Online:2008-02-01 Published:2008-02-01
  • Contact: LI Jian

摘要: 自主管理是目前数据库系统亟需解决的重要问题之一,解决数据库系统自主管理的核心是使得系统能够自动调度资源,以达到系统运行优化的目标。提出并实现了一个自优化查询处理器模型SMO,该模型能够对实际查询结果进行分析,自动调整统计信息,从而准确估计查询开销,提供更优执行计划,增强系统的稳定性。

关键词: 自优化, 查询优化, 反馈

Abstract: Self-management is currently a critical problem of database management system.The key solution to self-management is to make database system manage itself and use its resources effectively.This paper proposes and implements a self-optimization mode of query processor SMO which can get more accurate cost estimate,provide optimizer execution plan based on feedback loop.

Key words: self-optimization, query optimization, feedback