A link-based storage scheme for efficient aggregate query processing on clustered road networks

The need to have efficient storage schemes for spatial networks is apparent when the volume of query processing in some road networks (e.g., the navigation systems) is considered. Specifically, under the assumption that the road network is stored in a central server, the adjacent data elements in the network must be clustered on the disk in such a way that the number of disk page accesses is kept minimal during the processing of network queries. In this work, we introduce the link-based storage scheme for clustered road networks and compare it with the previously proposed junction-based storage scheme. In order to investigate the performance of aggregate network queries in clustered road networks, we extend our recently proposed clustering hypergraph model from junction-based storage to link-based storage. We propose techniques for additional storage savings in bidirectional networks that make the link-based storage scheme even more preferable in terms of the storage efficiency. We evaluate the performance of our link-based storage scheme against the junction-based storage scheme both theoretically and empirically. The results of the experiments conducted on a wide range of road network datasets show that the link-based storage scheme is preferable in terms of both storage and query processing efficiency.

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

[2]  Ümit V. Çatalyürek,et al.  Permuting Sparse Rectangular Matrices into Block-Diagonal Form , 2004, SIAM J. Sci. Comput..

[3]  Ralf Hartmut Güting,et al.  Using Dijkstra's algorithm to incrementally find the k-Nearest Neighbors in spatial network databases , 2006, SAC.

[4]  Shashi Shekhar,et al.  Path computation algorithms for advanced traveller information system (ATIS) , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[5]  Bora Uçar,et al.  Partitioning Sparse Matrices for Parallel Preconditioned Iterative Methods , 2007, SIAM J. Sci. Comput..

[6]  Ümit V. Çatalyürek,et al.  PaToH: Partitioning Tool for Hypergraphs , 1999 .

[7]  Stephan Winter,et al.  Route Specifications with a Linear Dual Graph , 2002 .

[8]  Dimitris Papadias,et al.  Aggregate nearest neighbor queries in road networks , 2005, IEEE Transactions on Knowledge and Data Engineering.

[9]  Bora Uçar,et al.  Revisiting Hypergraph Models for Sparse Matrix Partitioning , 2007, SIAM Rev..

[10]  R. M. Mattheyses,et al.  A Linear-Time Heuristic for Improving Network Partitions , 1982, 19th Design Automation Conference.

[11]  Cevdet Aykanat,et al.  Iterative-improvement-based declustering heuristics for multi-disk databases , 2005, Inf. Syst..

[12]  Cevdet Aykanat,et al.  Hypergraph Models and Algorithms for Data-Pattern-Based Clustering , 2004, Data Mining and Knowledge Discovery.

[13]  Elke A. Rundensteiner,et al.  Effective graph clustering for path queries in digital map databases , 1996, CIKM '96.

[14]  Shashi Shekhar,et al.  CCAM: A Connectivity-Clustered Access Method for Networks and Network Computations , 1997, IEEE Trans. Knowl. Data Eng..

[15]  Julius T. Tou,et al.  Information Systems , 1973, GI Jahrestagung.

[16]  Sung-Ho Woo,et al.  An improved network clustering method for I/O-efficient query processing , 2000, GIS '00.

[17]  Man Lung Yiu,et al.  Clustering objects on a spatial network , 2004, SIGMOD '04.

[18]  Bora Uçar,et al.  Parallel image restoration using surrogate constraint methods , 2007, J. Parallel Distributed Comput..

[19]  Berkant Barla Cambazoglu,et al.  Clustering spatial networks for aggregate query processing: A hypergraph approach , 2008, Inf. Syst..

[20]  Stephan Winther Weighting the Path Continuation in Route Planning , 2001, ACM-GIS.

[21]  Bora Uçar,et al.  Encapsulating Multiple Communication-Cost Metrics in Partitioning Sparse Rectangular Matrices for Parallel Matrix-Vector Multiplies , 2004, SIAM J. Sci. Comput..

[22]  Berkant Barla Cambazoglu,et al.  Multi-level direct K-way hypergraph partitioning with multiple constraints and fixed vertices , 2008, J. Parallel Distributed Comput..

[23]  Curt Jones,et al.  A Heuristic for Reducing Fill-In in Sparse Matrix Factorization , 1993, PPSC.

[24]  Tom Caldwell,et al.  On finding minimum routes in a network with turn penalties , 1961, CACM.

[25]  Lunhui Xu,et al.  Research and Realization of the Optimal Path Algorithm with Complex Traffic Regulations in GIS , 2007, 2007 IEEE International Conference on Automation and Logistics.

[26]  Brian W. Kernighan,et al.  An efficient heuristic procedure for partitioning graphs , 1970, Bell Syst. Tech. J..

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

[28]  Yufei Tao,et al.  Query Processing in Spatial Network Databases , 2003, VLDB.

[29]  Andrew B. Kahng,et al.  Recent directions in netlist partitioning: a survey , 1995, Integr..

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

[31]  Cevdet Aykanat,et al.  Two novel multiway circuit partitioning algorithms using relaxed locking , 1997, IEEE Trans. Comput. Aided Des. Integr. Circuits Syst..

[32]  CambazogluBerkant Barla,et al.  Hypergraph-Partitioning-Based Remapping Models for Image-Space-Parallel Direct Volume Rendering of Unstructured Grids , 2007 .

[33]  Feifei Li,et al.  On Trip Planning Queries in Spatial Databases , 2005, SSTD.

[34]  Berkant Barla Cambazoglu,et al.  Ieee Transactions on Parallel and Distributed Systems Hypergraph-partitioning-based Remapping Models for Image-space-parallel Direct Volume Rendering of Unstructured Grids Ieee Transactions on Parallel and Distributed Systems , 2022 .

[35]  Claude Berge,et al.  Graphs and Hypergraphs , 2021, Clustering.

[36]  Ümit V. Çatalyürek,et al.  Hypergraph-Partitioning-Based Decomposition for Parallel Sparse-Matrix Vector Multiplication , 1999, IEEE Trans. Parallel Distributed Syst..

[37]  Thomas Brinkhoff,et al.  A Framework for Generating Network-Based Moving Objects , 2002, GeoInformatica.

[38]  Sakti Pramanik,et al.  An Efficient Path Computation Model for Hierarchically Structured Topographical Road Maps , 2002, IEEE Trans. Knowl. Data Eng..