作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2009, Vol. 35 ›› Issue (10): 80-82. doi: 10.3969/j.issn.1000-3428.2009.10.026

• 软件技术与数据库 • 上一篇    下一篇

基于图的适应性多连接查询优化算法

陈恕胜,刘卫东   

  1. (清华大学计算机科学与技术系,北京 100084)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2009-05-20 发布日期:2009-05-20

Graph-based Adaptive Multi-join Query Optimization Algorithm

CHEN Shu-sheng, LIU Wei-dong   

  1. (Dept. of Computer Science & Technology, Tsinghua University, Beijing 100084)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-05-20 Published:2009-05-20

摘要: 提出一种基于图的适应性多连接查询优化算法,分析关系结果集到达时间和结果集大小之间的关系,借鉴适应性查询优化的动态调整思想,对基于图的多连接查询进行改进。仿真实验结果表明,该算法在最好情况下的时间复杂度为O(n),且能有效提高查询效率。

关键词: 基于图的优化算法, 多连接查询, 数据集成

Abstract: A novel graph-based adaptive multi-join query optimization algorithm is proposed. The relationship between the arrival time of relation result set and its size is analyzed. The graph-based multi-join query is improved with the idea of adaptive query optimization and dynamic adjustment. Simulation experimental results show the time complexity of this algorithm is O(n) in case of best situation, and improves the efficiency of query.

Key words: graph-based optimization algorithm, multi-join query, data integration

中图分类号: