Query Processing Using Distance Oracles for Spatial Networks

Abstract

The popularity of location-based services and the need to do real-time processing on them has led to an interest in performing queries on transportation networks, such finding shortest paths and finding nearest neighbors. The challenge here is that the efficient execution of spatial operations usually involves the computation of distance along a spatial network instead of as the crow flies, which is not simple. Techniques are described that enable the determination of the network distance between any pair of points (i.e., vertices) with little O(n) space rather than having to store the n2 distances between all pairs. This is done by being willing to expend a bit more time to achieve this goal such O(log n) instead of O(1), well by accepting an error e in the accuracy of the distance that is provided. The strategy that is adopted reduces the space requirements and is based on the ability to identify groups of source and destination vertices for which the distance is approximately the same within some e. The reductions are achieved by introducing a construct termed a distance oracle that yields an estimate of the network distance (termed the e-approximate distance) between any two vertices in the spatial network. The distance oracle is obtained by showing how to adapt the well-separated pair technique from computational geometry to spatial networks. Initially, an e-approximate distance oracle of size O(n/(e2)) is used that is capable of retrieving the approximate network distance in O(log n) time using a B-tree. The retrieval time can be theoretically reduced further to O(1) time by proposing another e-approximate distance oracle of size O((n log n)/(e2)) that uses a hash table. Experimental results indicate that the proposed technique is scalable and can be applied to sufficiently large road networks. For example, a 10-percentapproximate oracle (e = 0.1) on a large network yielded an average error of 0.9 percent with 90 percent of the answers having an error of 2 percent or less and an average retrieval time of 68 μ seconds. The fact that the network distance can be approximated by one value is used to show how a number of spatial queries can be formulated using appropriate SQL constructs and a few built-in primitives. The result is that these operations can be executed on almost any modern database with no modifications, while taking advantage of the existing query optimizers and query processing strategies.