Query Processing in Spatial Network Databases空间网络数据库中的查询处理.pptVIP

Query Processing in Spatial Network Databases Outline Introduction Related work Spatial query processing in Euclidean Space Disk-based graph representations- CCAM structure Spatial query in network databases Architecture Spatial queries: Nearest neighbor query Other queries Performances Summary Introduction Motivation Euclidean distance vs. network distance Euclidean distance = network distance Conventional spatial queries: K Nearest neighbor query: retrieves the k ponits closest to the query location Range query: retrieves the points covered by certain range Intersection join: retrieves all the intersected points from the query location sets Outline Introduction Related work Spatial query processing in Euclidean Space Disk-based graph representations- CCAM structure Spatial query in network databases Architecture Spatial queries: Nearest neighbor query Other queries Performances Summary Spatial query processing in Euclidean Space An R-tree index Multidimentional extension of B-tree (quoted from Query Processing in Spatial Network Databases) MBR: Minimum Bounding Rectangle Spatial points are clustered according to the distances between their MBR Hereby, R-tree is fast for spatial query Spatial query processing in Euclidean Space an example Disk-based graph representations- CCAM structure A graph can be represented as An adjacency list Two-dimensional matrix The Connectivity-clustered Access Method (CCAM) structure Stores the single dimensional lists Stores the lists of neighbor nodes together Disk-based graph representations- CCAM structure An example Outline Introduction Related work Spatial query processing in Euclidean Space Disk-based graph representations- CCAM structure Spatial query in network databases Architecture Spatial queries: Nearest neighbor query Other queries Performances Summary Architecture The above example Architecture Primitive operations Check_entity(seg,p): if entity p is covered by seg, then it returns true Find_segment(p): returns t