期刊文献+

基于混合遗传算法的关系型数据库多连接查询优化

Optimization for Multi -join Queries of Relation Database Based on Hybrid Genetic Algorithm
在线阅读 下载PDF
导出
摘要 本文分析了关系型数据库的查询优化问题,针对多连接查询提出将遗传算法和爬山法结合,从而构造了关系型数据库多连接查询优化问题的混合遗传算法,并进行了实验计算。结果表明,用混合遗传算法解决多连接查询优化问题,可以发挥遗传算法和爬山法的不同优势,从而得到较满意的查询优化性能。 In this paper, the optimization for Relation Database is analyzed. A hybrid genetic algorithm which is the combination of genetic algorithm and local search algorithm for solving multi - join queries of relation database problem is built. The results of simulation test show that the hybrid genetic algorithm can overcome the weakness of genetic algorithm and local search algorithm,so we can obtain the high quality solutions to the multi-join queries problems.
出处 《计算机与数字工程》 2003年第5期12-16,共5页 Computer & Digital Engineering
关键词 关系型数据库 数据查询 优化 混合遗传算法 multi-join query, hybrid genetic algorithm, optimization, database
  • 相关文献

参考文献9

  • 1罗上远,徐天亮,陈代芬.零售业库存分布模型及分区配送算法研究[J].物流技术,2000,19(5):22-25. 被引量:21
  • 2郎茂祥,胡思继.用混合遗传算法求解物流配送路径优化问题的研究[J].中国管理科学,2002,10(5):51-56. 被引量:177
  • 3周冬平.[D].南京:南京航空航天大学,.
  • 4E Shekita, H Young and K L Tan. Multi - join optimization for symmetric multiprocessors. In Proc. Of the Cord. on Very Large Data -Bases (VLDB), Dublin, Ireland, 1993,479- 492.
  • 5R Krishnamurthy, H Boral, and C Zaniolo. Optimization of norecursive queries. In Proc. Of the Cord. On Very Large Data Bases(VLDB), Kyoto, Japan, 1986,128- 137.
  • 6A Swami and B lyer. A polynomial time algorithm for optimizing join queries. In Proc. IEEE Conf. on Data Engineering, Vienna, Austria, April, 1993. 345 - 354.
  • 7K Bennett, M C Ferris, and Y loannidis. A genetic algorithm for database of optimization. In Proc. 4^th Int. Conference on Genetic Algorithms, ,San Diego,CA, 1991. 400-407.
  • 8E J Anderson and M C Ferris. A genetic algorithm for the assembly line balancing problem. In Proc. of the integer programmlng/combinatorlal Optimization Conf. Waterloo. Canada, 1990, University of Waterloo Press.
  • 9周冬平.[D].南京:南京航空航天大学,.

二级参考文献12

共引文献194

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部