摘要
查询优化是数据库应用的基础,针对当前数据库查询效率低,难以获得最优查询优化方案的局限性,提出基于改进和声搜索算法的数据库查询优化方法。首先对当前数据库查询优化研究现状进行分析,找出当前算法存在的一些不足;然后构建数据查询优化的数学模型,采用和声搜索算法进行求解,并对标准和声搜索算法的缺陷进行改进;最后采用VC++编程实现数据库查询优化性能测试。结果表明,该算法可以提高数据库的查询效率,尤其对大型数据库查询优化的优势更加显著。
The database query optimization is the foundation of the database application. Since the database query has low efficiency,and it is difficult to obtain the optimal query scheme,a new database query optimization method based on improved harmony search algorithm is proposed. The research status of the database query optimization is analyzed to find out the short?comings existing in the current algorithms. The mathematical model of the database query optimization was constructed,and solved with the harmony search algorithm. The defect of the standard harmony search algorithm was improved. The VC++ pro?gramming is used to test the performance of the database query optimization. The results show that the algorithm can improve the database query efficiency,and has more significant advantage especially for the large?scale database query optimization.
作者
高洁
GAO Jie(University of Electronic Science and Technology of China,Chengdu 611731,China;Department of Modern Service,Hebei Women′s Vocational College,Shijiazhuang 050091,China)
出处
《现代电子技术》
北大核心
2017年第3期114-116,120,共4页
Modern Electronics Technique
关键词
数据库
数学模型
查询优化
和声搜索算法
database
mathematical model
query optimization
harmony search algorithm
