摘要
在分布式数据库查询优化中,数据传输和多连接次序往往决定了查询执行速度,以通信代价最小为目标的代价模型一直是研究的重点。随着大数据时代的到来,如何提高数据库的查询效率成为我们所要面对的首要问题。为此,利用蚁群算法优化查询计划,以多元连接查询操作为例,进行了模型建立和算法实现。在Oracle数据库中进行了仿真实验,实验结果表明该算法有较好的寻优效果,并对分布式数据库的查询优化具有实际意义。
In the distributed database query optimization, the speed of query depends on the data transfer and join sequence. The price model minimizing communication cost is the emphasis of research. Since the era of big data is coming, the first important problem is how to enhance the speed of database query. Seeking the best query path by using the ant colony algorithm, and taking multiple connection query as an example, model building and algorithm implementation are carried on. The experimental results show that this algorithm has the better effect in selecting path and is practically meaningful for the query optimization of distribute database.
出处
《计算机时代》
2014年第5期47-49,共3页
Computer Era
关键词
分布式数据库
查询优化
多元连接
蚁群算法
distributed database
query optimization
multiple connection
ant colony algorithm
