Computer Engineering and Applications ›› 2010, Vol. 46 ›› Issue (5): 117-119.DOI: 10.3778/j.issn.1002-8331.2010.05.035

• 数据库、信号与信息处理 • Previous Articles     Next Articles

Spatial topological relation join methods based on ArcSDE

WEN Yuan-qiao1,ZHOU Chun-hui2   

  1. 1.Navigation College,Wuhan University of Technology,Wuhan 430063,China
    2.State Key Lab of Information Engineering in Surveying,Mapping and Remote Sensing,Wuhan University,Wuhan 430079,China
  • Received:2009-09-16 Revised:2009-12-08 Online:2010-02-11 Published:2010-02-11
  • Contact: WEN Yuan-qiao

基于ArcSDE的空间拓扑关系连接方法研究

文元桥1,周春辉2   

  1. 1.武汉理工大学 航运学院,武汉 430063
    2.武汉大学 测绘遥感信息工程国家重点实验室,武汉 430079
  • 通讯作者: 文元桥

Abstract: This paper introduces the standard topological relation model,and analyses the characteristics of the spatial topological relation join.According to the spatial query technique and the topological predicates supported by ArcSDE,three methods are proposed for implementing topological join with ArcSDE,including Spatial Constraints Query Topological Join(SCQTJ),Predicates Nested Loop Topological Join(PNLTJ),and Filter-Refining 2 Phases Topological Join(FR2PTJ).Finally the three methods are tested by experiments,and the PNLTJ method shows the best performance.

Key words: topological relation, spatial join, ArcSDE, optimal method

摘要: 简要介绍了标准的拓扑关系模型,分析了空间拓扑关系连接的特点。根据ArcSDE提供的空间查询技术和拓扑关系谓词,提出了在ArcSDE平台下实现拓扑连接的三种方法,包括基于空间约束查询的拓扑连接方法(SCQTJ)、基于谓词的嵌套循环拓扑连接方法(PNLTJ)和过滤精化两阶段拓扑连接方法(FR2PTJ)。最后通过试验对三种方法进行检验,试验结果表明PNLTJ方法具有最优的性能。

关键词: 拓扑关系, 空间连接, ArcSDE, 优化方法

CLC Number: