Distance browsing in spatial databases
The authors compare two different techniques for browsing through a collection of spatial objects stored in an R-tree spatial data structure on the basis of their distances from an arbitrary spatial query object. The conventional approach is one that makes use of a k-nearest neighbor algorithm where k is known prior to the invocation of the algorithm. Thus if m {gt} k neighbors are needed, the k-nearest neighbor algorithm has to be reinvoked for m neighbors, thereby possibly performing some redundant computations. The second approach is incremental in the sense that having obtained the k nearest neighbors, the k + 1{sup st} neighbor can be obtained without having to calculate the k + 1 nearest neighbors from scratch. The incremental approach is useful when processing complex queries where one of the conditions involves spatial proximity (e.g., the nearest city to Chicago with population greater than a million), in which case a query engine can make use of a pipelined strategy. The authors present a general incremental nearest neighbor algorithm that is applicable to a large class of hierarchical spatial data structures. This algorithm is adapted to the R-tree and its performance is compared to an existing k-nearest neighbor algorithm for R-trees. Experiments show that the incremental nearest neighbor algorithm significantly outperforms the k-nearest neighbor algorithm for distance browsing queries in a spatial database that uses the R-tree as a spatial index. Moreover, the incremental nearest neighbor algorithm usually outperforms the k-nearest neighbor algorithm when applied to the k-nearest neighbor problem for the R-tree, although the improvement is not nearly as large as for distance browsing queries. In fact, they prove informally that at any step in its execution the incremental nearest neighbor algorithm is optimal with respect to the spatial data structure that is employed. Furthermore, based on some simplifying assumptions, they prove that in two dimensions the number of distance computations and leaf nodes accesses made by the algorithm for finding k neighbors is O (k + k).
- Research Organization:
- Univ. of Maryland, College Park, MD (US)
- Sponsoring Organization:
- National Science Foundation (NSF); USDOE
- DOE Contract Number:
- FG02-95ER25237
- OSTI ID:
- 20005653
- Journal Information:
- ACM Transactions on Database Systems, Vol. 24, Issue 2; Other Information: PBD: Jun 1999; ISSN 0362-5915
- Country of Publication:
- United States
- Language:
- English
Similar Records
Unified many-worlds browsing of arbitrary physics-based animations
Evaluation of Potential LSST Spatial Indexing Strategies