Optimization of database query application research based on particle swarm algorithm
Lin Gui-ya · Jisuanji yingyong yanjiu · 2012
This paper studied on particle swarm algorithm in database query optimization problems in application.In order to solve large-scale database information retrieval difficult,query efficiency low at the end of the problem,this paper proposed one kind based on the particle swarm optimization algorithm for database query technology.The algorithm mainly proposed a database query execution plan cost model,including the query multiple link order and replica selection problem,accurate definition of database query execution costs,then using the particle swarm algorithm to optimize the execution cost and solving problems,so that the data packet being fewer in number and more accurate positioning.The final test results show that,verified any tea-chers through attribute and irregularities can be accurate positioning,reduces the packet,for the database query provides optimization.