Abstract:Shortest path query is one of the most fundamental queries in spatial network databases. There exist algorithms that can process shortest path queries in real time. However, many complex applications require more than just the calculation of a single shortest path. For example, one of the common ways to determine the importance (or price) of a vertex or an edge in spatial network is to use Vickrey pricing, which intuitively values the vertex v (or edge e ) based on how much harder for travelling from the sources to the destinations without using v (or e ). In such cases, the alternative shortest paths without using v (or e ) are required. In this article, we propose using a precomputation based approach for both single pair alternative shortest path and all pairs shortest paths processing. To compute the alternative shortest path between a source and a destination efficiently, a naïive way is to precompute and store all alternative shortest paths between every pair of vertices avoiding every possible vertex (or edge), which requires O ( n 4 ) space. Currently, the state of the art approach for reducing the storage cost is to choose a subset of the vertices as center points, and only store the single-source alternative shortest paths from those center points. Such approach has the space complexity of O ( n 2 log n ). We propose a storage scheme termed iSPQF , which utilizes shortest path quadtrees by observing the relationships between each avoiding vertex and its corresponding alternative shortest paths. We have reduced the space complexity from the naïive O ( n 4 ) (or the state of the art O ( n 4 log n )) to O (min( γ, L ) n 1.5 ) with comparable query performance of O ( K ), where K is the number of vertices in the returned paths, L is the diameter of the spatial network, and γ is a value that depends on the structure of the spatial network, which is empirically estimated to be 40 for real road networks. Experiments on real road networks have shown that the space cost of the proposed iSPQF is scalable, and both the algorithms based on iSPQF are efficient.

An Incremental Approach to Closest Pair Queries in Spatial Networks Using Best-First Search.

Constrained All-k-Nearest-Neighbor Search

Discovery of Regional Co-location Patterns with k-Nearest Neighbor Graph.

Efficient parallel processing for K-nearest-neighbor search in spatial databases

Best-First Based Parallel Nearest Neighbor Queries.

On efficient mutual nearest neighbor query processing in spatial databases

Efficient Parallel Processing of High-Dimensional Spatial K NN Queries

Efficient K -Closest Pair Queries in General Metric Spaces

Keyword-based k-nearest neighbor search in spatial databases.

Efficient Approximate Algorithms for the Closest Pair Problem in High Dimensional Spaces.

K-nearest Neighbor Query Algorithm in Spatio-temporal Databases

Indexing Fast Moving Objects for kNN Queries Based on Nearest Landmarks

Path–Based Continuous Spatial Keyword Queries

Optimal-Nearest-Neighbor Queries

Effective Reverse K-nearest Neighbor Query Based on Revised R<sup>&#x2217;</sup>-tree in Spatial Databases

Finding Alternative Shortest Paths in Spatial Networks

The Moving K Diversified Nearest Neighbor Query.

Approximate k-Nearest Neighbor Query over Spatial Data Federation.

Aggregate Farthest-Neighbor Queries Over Spatial Data

Efficient k NN Search in Public Transportation Networks

Processing Incomplete K Nearest Neighbor Search