计算机工程与应用 ›› 2015, Vol. 51 ›› Issue (13): 118-121.

• 数据库、数据挖掘、机器学习 • 上一篇    下一篇

基于BACS算法的数据库查询优化

王  磊   

  1. 宿迁学院,江苏 宿迁 223800
  • 出版日期:2015-07-01 发布日期:2015-06-30

Database query optimization based on Bat Algorithm and Cuckoo Search Algorithm

WANG Lei   

  1. Suqian College, Suqian, Jiangsu 223800, China
  • Online:2015-07-01 Published:2015-06-30

摘要: 针对布谷鸟算法局部搜索能力弱、寻优精度低等缺陷,提出一种蝙蝠算法和布谷鸟算法相融合的数据库查询优化算法(BACS)。按照布谷鸟优化算法对鸟巢位置进行更新,利用蝙蝠算法的动态转换策略对鸟巢位置进一步更新,避免算法陷入局部最优;最后将BACS应用于数据库查询优化问题求解,并通过仿真实验对BACS的性能进行测试。实验结果表明,BACS加快了数据库查询优化求解的收敛速度,获得了质量更高的查询优化方案。

关键词: 数据库查询优化, 蝙蝠算法, 布谷鸟搜索算法

Abstract: In order to solve the problems of bat algorithm which has low optimizing accuracy and weak local search ability, a novel query optimization method of database is proposed based on Bat Algorithm and Cuckoo Search Algorithm(BACS). Firstly, nest location is updated according to the cuckoo search optimization algorithm, and then cuckoo nest location is further replaced according to the dynamic conversion strategy in the bat algorithm and avoids falling into local optimum, finally it is applied to solve the query optimization problem of database, and the performance of BACS is tested by simulation experiments. The results show that, BACS accelerates the convergence speed of database query optimization and can obtain higher quality query optimization scheme.

Key words: database optimization query, Bat Algorithm(BA), Cuckoo Search(CS) Algorithm