基于改进和声搜索群算法的数据库查询优化  

Database query optimization based on improved harmony search algorithm

作　　者：高洁[1,2] 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)

机构地区：[1]电子科技大学,四川成都611731 [2]河北女子职业技术学院现代服务系,河北石家庄050091

出　　处：《现代电子技术》2017年第3期114-116,120,共4页Modern Electronics Technique

摘　　要：查询优化是数据库应用的基础,针对当前数据库查询效率低,难以获得最优查询优化方案的局限性,提出基于改进和声搜索算法的数据库查询优化方法。首先对当前数据库查询优化研究现状进行分析,找出当前算法存在的一些不足;然后构建数据查询优化的数学模型,采用和声搜索算法进行求解,并对标准和声搜索算法的缺陷进行改进;最后采用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.

关 键 词：数据库 数学模型 查询优化 和声搜索算法 

分 类 号：TN911.34[电子电信—通信与信息系统] TP391[电子电信—信息与通信工程]