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

计算机工程 ›› 2007, Vol. 33 ›› Issue (02): 90-93. doi: 10.3969/j.issn.1000-3428.2007.02.031

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

空间连接优化方法的研究

姜素芳,陈天滋   

  1. (江苏大学计算机科学与通信工程学院,镇江 212013)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2007-01-20 发布日期:2007-01-20

Research on Optimization Method of Spatial Join

JIANG Sufang, CHEN Tianzi   

  1. (School of Computer Science and Telecommunications Engineering, Jiangsu University, Zhenjiang 212013)
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-01-20 Published:2007-01-20

摘要: 基于MBR及直接查询谓词,提出了能够优化多路R树连接筛选阶段的加权处理方法,扩展了R树结构及MRJ算法。使用该方法能够得到更加有效的候选集,减少磁盘访问次数,节省了CPU及I/O的时间开销,通过实例验证了其在空间数据库查询优化方面的优势。

关键词: 空间连接, 多路R树连接, 派生谓词, 查询图, 加权处理

Abstract: Based on the MBR and the direct query predicate, this paper proposes a weighted processing method which mainly contributes to optimize the filter step of the multi-way R-tree join and extends the structure of R-tree and the MRJ algorithm. This method contributes to get a set of more effective candidates and then reduce the frequency of disk access and the overhead of CPU as well as I/O. Through the experiment of specific application by using this method, the paper shows the significant superiority in optimizing the spatial query of SDBMS.

Key words: Spatial join, Multi-way R-tree join, Derived predicate, Query graph, Weighted processing