Query processing in time-dependent spatial networks

Recent advances in online map services and their wide deployment in hand-held devices and car-navigation systems have led to extensive use of location-based services. The most popular class of such services are route planning and k-nearest neighbor(kNN) queries where users search for geographical points of interests (e.g., restaurants, gas stations) with corresponding travel-times to these locations. Accordingly, many recent studies focused on developing efficient techniques to answer point-to-point fastest path and k-nearest neighbor search queries in the spatial network space. However, most of the existing approaches in spatial networks make the simplifying assumption that the cost of traveling each edge of the spatial network is constant (e.g., corresponding to the length of the edge). Whereas in real world, the actual travel cost of a network edge is time-dependent i.e., the cost of a network edge depends on the arrival-time to that edge. Unfortunately, once we consider the time-dependent edge weights in road networks, all proposed kNN and shortest path query solutions assuming constant edge weights fail. With time-dependent edge costs, the network distance between two nodes is not unique and varies based on the departure time from the source. This dynamism of the distance introduces great challenges in developing precomputation techniques to expedite spatial query processing in time-dependent spatial networks. In this thesis, for the first time we study the problem of k-nearest neighbor search in time-dependent road networks where the weight of each edge is a function of time. We propose series of index structures that efficiently and accurately answer the k nearest neighbor queries in time-dependent road networks and effectively handle the database updates where points of interests are added or removed. In addition, we study the problem of point-to-point shortest path computation in time-dependent spatial networks and present a technique which speeds-up the path computation using a bidirectional time-dependent A* search based on a novel heuristic function. In this thesis, the efficacy of all proposed techniques for both kNN search and point-to-point shortest path computation have been verified with extensive experiments using real data-sets including a variety of large spatial networks with real traffic data.

[1]  Yang Du,et al.  Finding Fastest Paths on A Road Network with Speed Patterns , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[2]  Nick Roussopoulos,et al.  Nearest neighbor queries , 1995, SIGMOD '95.

[3]  Shashi Shekhar,et al.  Spatio-temporal Network Databases and Routing Algorithms: A Summary of Results , 2007, SSTD.

[4]  Farnoush Banaei Kashani,et al.  Efficient K-Nearest Neighbor Search in Time-Dependent Spatial Networks , 2010, DEXA.

[5]  Dorothea Wagner,et al.  Landmark-Based Routing in Dynamic Graphs , 2007, WEA.

[6]  Stuart E. Dreyfus,et al.  An Appraisal of Some Shortest-Path Algorithms , 1969, Oper. Res..

[7]  Susanne E. Hambrusch,et al.  Main Memory Evaluation of Monitoring Queries Over Moving Objects , 2004, Distributed and Parallel Databases.

[8]  Ariel Orda,et al.  Shortest-path and minimum-delay algorithms in networks with time-dependent edge-length , 1990, JACM.

[9]  Leo Liberti,et al.  Bidirectional A* Search for Time-Dependent Fast Paths , 2008, WEA.

[10]  Nick Roussopoulos,et al.  K-Nearest Neighbor Search for Moving Query Point , 2001, SSTD.

[11]  Edsger W. Dijkstra,et al.  A note on two problems in connexion with graphs , 1959, Numerische Mathematik.

[12]  Hanan Samet,et al.  Foundations of multidimensional and metric data structures , 2006, Morgan Kaufmann series in data management systems.

[13]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.

[14]  Hanan Samet,et al.  Scalable network distance browsing in spatial databases , 2008, SIGMOD Conference.

[15]  Andrew V. Goldberg,et al.  Computing the shortest path: A search meets graph theory , 2005, SODA '05.

[16]  Atsuyuki Okabe,et al.  Spatial Tessellations: Concepts and Applications of Voronoi Diagrams , 1992, Wiley Series in Probability and Mathematical Statistics.

[17]  Farnoush Banaei Kashani,et al.  Efficient Continuous Nearest Neighbor Query in Spatial Networks Using Euclidean Restriction , 2009, SSTD.

[18]  David Taniar,et al.  Voronoi-based reverse nearest neighbor query processing on spatial networks , 2009, Multimedia Systems.

[19]  Jeffrey Xu Yu,et al.  Finding time-dependent shortest paths over large graphs , 2008, EDBT '08.

[20]  Daniel Delling Time-Dependent SHARC-Routing , 2008, ESA.

[21]  Walid G. Aref,et al.  SEA-CNN: scalable processing of continuous k-nearest neighbor queries in spatio-temporal databases , 2005, 21st International Conference on Data Engineering (ICDE'05).

[22]  Jonathan Halpern,et al.  Shortest route with time dependent length of edges and limited delay possibilities in nodes , 1977, Math. Methods Oper. Res..

[23]  Chin-Wan Chung,et al.  An Efficient and Scalable Approach to CNN Queries in a Road Network , 2005, VLDB.

[24]  Lars Kulik,et al.  Local network Voronoi diagrams , 2010, GIS '10.

[25]  Cyrus Shahabi,et al.  Alternative Solutions for Continuous K Nearest Neighbor Queries in Spatial Network Databases , 2005, STDBM.

[26]  Dorothea Wagner,et al.  Geometric Speed-Up Techniques for Finding Shortest Paths in Large Sparse Graphs , 2003, ESA.

[27]  Cyrus Shahabi,et al.  Voronoi-Based K Nearest Neighbor Search for Spatial Network Databases , 2004, VLDB.

[28]  Peter Sanders,et al.  Engineering Fast Route Planning Algorithms , 2007, WEA.

[29]  Jon Louis Bentley,et al.  Quad trees a data structure for retrieval on composite keys , 1974, Acta Informatica.

[30]  Torben Bach Pedersen,et al.  Nearest neighbor queries in road networks , 2003, GIS '03.

[31]  Atsuyuki Okabe,et al.  Generalized network Voronoi diagrams: Concepts, computational methods, and applications , 2008, Int. J. Geogr. Inf. Sci..

[32]  Xiaohui Yu,et al.  Monitoring k-nearest neighbor queries over moving objects , 2005, 21st International Conference on Data Engineering (ICDE'05).

[33]  Nils J. Nilsson,et al.  A Formal Basis for the Heuristic Determination of Minimum Cost Paths , 1968, IEEE Trans. Syst. Sci. Cybern..

[34]  Walid G. Aref,et al.  SINA: scalable incremental processing of continuous queries in spatio-temporal databases , 2004, SIGMOD '04.

[35]  Cyrus Shahabi,et al.  A Road Network Embedding Technique for K-Nearest Neighbor Search in Moving Object Databases , 2003, GeoInformatica.