期刊文献+

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

Optimization for multi-join queries of relation database basic on hybrid genetic algorithm
下载PDF
导出
摘要 该文分析了关系型数据库的查询优化问题,针对多连接查询提出将遗传算法和爬山法结合,从而构造了关系型数据库多连接查询优化问题的混合遗传算法,并进行了实验计算。结果表明,用混合遗传算法解决多连接查询优化问题,可以发挥遗传算法和爬山法的不同优势,从而得到较满意的查询优化性能。 In this paper, the optimization for relation database is analyzed. A hybrid genetic algorithm which is combined by genetic algorithm and local search algorithm for solving multi-join queries of relation database problem is built. The results of simulation test shows that the hybrid genetic algorithm can overcome the weakness of genetic algorithm and local search algorithm, so it can obtain the high quality solutions to the multi-join queries problems.
作者 倪小剑
出处 《鄂州大学学报》 2005年第6期16-18,28,共4页 Journal of Ezhou University
关键词 多连接查询 混合遗传算法 优化 数据库 multi-join query hybrid genetic algorithm optimization database
  • 相关文献

参考文献7

  • 1[1]周冬平.关系数据库查询优化技术的研究与实现[D].南京:南京航空航天大学,2000.
  • 2[2]E. Shekita, H. Young and K.L. Tan. Multi-join optimization for symmetric multiprocessors. In Proc. Of the Conf. on Very large Data Bases(VLDB)[C]. Dublin, Ireland, 1993. 479~492.
  • 3[3]R. Krishnamurthy, H. Boral, and C. Zaniolo. Optimization of norecursive queries. In Proc. Of the Conf. On Very Large Data Bases(VLDB) [C]. Kyoto, Japan, 1986. 128~137.
  • 4[4]A. Swami and B. Iyer. A polynomial time algorithm for optimizing join queries. In Proc. IEEE Conf. on Data Engineering[C].Vienna, Austria, April, 1993. 345~354.
  • 5[5]K.Bennett, M.C. Ferris, and Y. Ioannidis. A genetic algorithm for database of optimization. In Proc. 4th Int. Conference on Genetic Algorithms[C]. San Diego, CA, 1991. 400~407.
  • 6[6]E.j. Anderson and M.C. Ferris. A genetic algorithm for the assembly line balancing problem. In Proc. of the integer programming/combinatorial Optimization Conf. Waterloo [C].Canada, 1990,University ofWaterloo Press.
  • 7罗上远,徐天亮,陈代芬.零售业库存分布模型及分区配送算法研究[J].物流技术,2000,19(5):22-25. 被引量:21

共引文献20

同被引文献4

引证文献1

二级引证文献3

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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