大规模数据库查询优化算法的设计与研究

Design and Research of Query Optimization Algorithm for Large Scale Database

针对布谷鸟算法局部搜索能力弱、寻优精度低等缺陷,设计了一种大规模数据库查询的优化算法。首先对当前数据库查询优化的研究现状进行分析,找到其它方法存在的局限性,然后将数据库查询优化问题看作是一个多约束条件的优化问题,选择布谷鸟搜索算法对该问题进行求解,将对标准布谷鸟搜索算法存在的不足进行相应的改善,最后通过具体数据库查询优化仿真实验对其有效性和优越性进行测试与分析。结果表明,改进布谷鸟搜索算法大幅度改善数据库查询优化效率,获得比较理想的数据库查询优化结果,而且结果要明显优于当前其它数据库查询优化方法,具有更高的实际应用价值。

Aiming at the shortcomings of the local search ability and low precision of the cuckoo algorithm,An optimization algorithm for large-scale database query is designed..Firstly,the current research on database query optimization analysis,find the limitations existing in other methods,then the database query optimization problem as an optimization problem of multi constraint conditions,choose the cuckoo search algorithm is used to solve this problem,the standard of cuckoo search algorithm’s deficiency of the corresponding improvement,finally through the database query optimization simulation experiment on the validity and superiority of testing and analysis.The results show that the improved cuckoo search algorithm can greatly improve the efficiency of database query optimization,obtain the ideal database query optimization results,and the result is better than the other database query optimization method has higher practical application value.