Query Processing in Spatial Databases Containing Obstacles

• Main Authors: ZHANG, Jun, Papadias, Dimitris, Mouratidis, Kyriakos, ZHU, Manli
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 2005
• Subjects: spatial databases; query processing; visibility graph; Databases and Information Systems; Numerical Analysis and Scientific Computing
• Online Access: https://ink.library.smu.edu.sg/sis_research/174; https://ink.library.smu.edu.sg/context/sis_research/article/1173/viewcontent/IJGIS05_SODB.pdf
• Institution: Singapore Management University

Despite the existence of obstacles in many database applications, traditional spatial query processing assumes that points in space are directly reachable and utilizes the Euclidean distance metric. In this paper, we study spatial queries in the presence of obstacles, where the obstructed distance between two points is defined as the length of the shortest path that connects them without crossing any obstacles. We propose efficient algorithms for the most important query types, namely, range search, nearest neighbours, e-distance joins, closest pairs and distance semi-joins, assuming that both data objects and obstacles are indexed by R-trees. The effectiveness of the proposed solutions is verified through extensive experiments.