Research and implementation of self-optimize query processor

Computer Engineering and Applications ›› 2008, Vol. 44 ›› Issue (4): 184-186.

• 数据库与信息处理 • Previous Articles Next Articles

Research and implementation of self-optimize query processor

LI Jian,SHI Lei,BAI Wen-yang

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

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

李健,施磊,柏文阳

计算机软件新技术国家重点实验室，南京 210093
南京大学计算机科学与技术系，南京 210093

通讯作者: 李健

Abstract

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

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

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

LI Jian,SHI Lei,BAI Wen-yang. Research and implementation of self-optimize query processor[J]. Computer Engineering and Applications, 2008, 44(4): 184-186.

李健,施磊,柏文阳. 自优化查询处理器的研究与实现[J]. 计算机工程与应用, 2008, 44(4): 184-186.

[1]	YAN Xiaoshen, GAO Qiang, ZHU Simeng, XI Xuecheng, ZHAO Wansheng. Study on Character Segmentation Algorithm of Pressed Character on Uneven Brightness Low Quality Images [J]. Computer Engineering and Applications, 2021, 57(8): 185-191.
[2]	SU Fei, WANG Hong, ZU Linlu, WANG Jiang, LIU Chen. Closed-Loop Modulation of Parkinson’s State Based on Fuzzy Control [J]. Computer Engineering and Applications, 2021, 57(22): 273-280.
[3]	LIANG Xinrong, XIAO Long, WANG Xueqi, YANG Shiwu, DONG Hairong. Design of Neural Network PID Controller for Speed Tracking of High-Speed Train [J]. Computer Engineering and Applications, 2021, 57(10): 252-258.
[4]	CHENG Xiaona, SUN Zhifeng. LFM-XGB-LR Hybrid Recommendation Algorithm in Implicit Feedback Scenario [J]. Computer Engineering and Applications, 2020, 56(5): 85-92.
[5]	HUANG Taoyi, LI You, SONG Hao, LIN Yuming. Organization and Query Optimization of Large-Scale Product Knowledge [J]. Computer Engineering and Applications, 2020, 56(21): 154-163.
[6]	SHI Feifei, ZHANG Songlong, PENG Li. Deep Convolution Saliency Detection Combined with Edge Feature Prior-Based Inspection [J]. Computer Engineering and Applications, 2020, 56(14): 199-206.
[7]	Event-Triggered Output Feedback H∞ Control for Networked Markov Type Systems. Event-Triggered Output Feedback H∞ Control for Networked Markov Type Systems [J]. Computer Engineering and Applications, 2019, 55(6): 231-236.
[8]	WU Qifan1, ZHANG Jing1, LIU Kai1, TANG Wei2, TIAN Weidong2. Studies of Mandible Joint and Guide Plate Design in Haptic Feedback Virtual Surgery [J]. Computer Engineering and Applications, 2019, 55(5): 226-231.
[9]	XUE Wenyan, ZHAO Jiang, HAO Chongqing, LIU Huixian. Hyper Heuristic Ant Colony Optimization Algorithm Based on Pheromone Negative Feedback [J]. Computer Engineering and Applications, 2019, 55(4): 163-172.
[10]	AN Weihua. Survey of Computer Aided Technology for Teaching Chinese Characters Handwriting [J]. Computer Engineering and Applications, 2019, 55(23): 1-6.
[11]	WANG Hongji, DAI Bingrong, LI Chao, ZHANG Shaohua. Query Optimization Model for Blockchain Applications [J]. Computer Engineering and Applications, 2019, 55(22): 34-39.
[12]	XING Boyang, PAN Feng, FENG Xiaoxue. Improved ZMP Crawling Gait Algorithm for Quadruped Robot Based on Intelligent Decision Making [J]. Computer Engineering and Applications, 2019, 55(22): 206-211.
[13]	ZHANG Tao, WANG Xin, WANG Zhenlei. Hierarchy Feedback Ant Colony Algorithm for Solving Secondary Delivery Problem of Petroleum Product [J]. Computer Engineering and Applications, 2019, 55(21): 261-270.
[14]	YANG Kang, YOU Xiaoming, LIU Sheng. Self-Adaptive Double-Population Ant Colony Algorithm with Entropy [J]. Computer Engineering and Applications, 2019, 55(19): 66-73.
[15]	ZOU Shanhua, GAO Yi, PENG Li. Research and Design of Event-Driven Control Strategy for Stochastic Systems [J]. Computer Engineering and Applications, 2019, 55(17): 100-106.

Research and implementation of self-optimize query processor

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

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics