Abstract
In smart phones, vehicles and wearable devices, GPS sensors are ubiquitous and collect a lot of valuable spatial data from the real world. Given a set of weighted points and a rectangle r in the space, a maximizing range sum (MaxRS) query is to find the position of r, so as to maximize the total weight of the points covered by r (i.e., the range sum). It has a wide spectrum of applications in spatial crowdsourcing, facility location and traffic monitoring. Most of the existing research focuses on the Euclidean space; however, in real life, the user’s moving route is constrained by the road network, and the existing MaxRS query algorithms in the road network are inefficient. In this paper, we propose a novel GPU-accelerated algorithm, namely, GAM, to tackle MaxRS queries in road networks in two phases efficiently. In phase 1, we partition the entire road network into many small cells by a grid and theoretically prove the correctness of parallel query results by grid shifting, and then we propose an effective multi-grained pruning technique, by which the majority of cells can be pruned without further checking. In phase 2, we design a GPU-friendly storage structure, cell-based road network (CRN), and a two-level parallel framework to compute the final result in the remaining cells. Finally, we conduct extensive experiments on two real-world road networks, and the experimental results demonstrate that GAM is on average one order faster than state-of-the-art competitors, and the maximum speedup can achieve about 55 times.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
Explore related subjects
Discover the latest articles and news from researchers in related subjects, suggested using machine learning.References
Manyika J, Chui M, Brown B et al. Big data: The next frontier for innovation, competition, and productivity. Technical Report, McKinsey Global Institute, 2011. https://www.mckinsey.com/~/media/mckinsey/business%-20functions/mckinsey%20digital/our%20insights/big%20data%20the%20next%20frontier%20for%20innovation/mgi_big_data_full_report.pdf, Jul. 2022.
Tong Y, Zeng Y, Zhou Z, Chen L, Ye J, Xu K. A unified approach to route planning for shared mobility. Proc. VLDB Endow., 2018, 11(11): 1633-1646. https://doi.org/10.14778/3236187.3236211.
Choi D, Chung C, Tao Y. A scalable algorithm for maximizing range sum in spatial databases. Proc. VLDB Endow., 2012, 5(11): 1088-1099. https://doi.org/10.14778/2350229.2350230.
Choi D, Chung C, Tao Y. Maximizing range sum in external memory. ACM Trans. Database Syst., 2014, 39(3): Article No. 21. https://doi.org/10.1145/2629477.
Abellanas M, Hurtado F, Icking C, Klein R, Langetepe E, Ma L, Palop B, Sacristán V. Smallest color-spanning objects. In Proc. the 9th Annual European Symposium on Algorithms, Aug. 2001, pp.278-289. https://doi.org/10.1007/3-540-44676-1_23.
Tiwari S, Kaushik S. Extracting region of interest (ROI) details using LBS infrastructure and web-databases. In Proc. the 13th IEEE International Conference on Mobile Data Management, Jul. 2012, pp.376-379. https://doi.org/10.1109/MDM.2012.29.
Chai C, Fan J, Li G. Incentive-based entity collection using crowdsourcing. In Proc. the 34th IEEE International Conference on Data Engineering, Apr. 2018, pp.341-352. https://doi.org/10.1109/ICDE.2018.00039.
Chai C, Li G, Li J, Deng D, Feng J. Cost-effective crowdsourced entity resolution: A partial-order approach. In Proc. the 2016 International Conference on Management of Data, Jun. 26-Jul. 1, 2016, pp.969-984. https://doi.org/10.1145/2882903.2915252.
Li G, Chai C, Fan J, Weng X, Li J, Zheng Y, Li Y, Yu X, Zhang X, Yuan H. CDB: Optimizing queries with crowd-based selections and joins. In Proc. the 2017 International Conference on Management of Data, May 2017, pp.1463-1478. https://doi.org/10.1145/3035918.3064036.
Tao Y, Hu X, Choi D, Chung C. Approximate MaxRS in spatial databases. Proc. VLDB Endow., 2013, 6(13): 1546-1557. https://doi.org/10.14778/2536258.2536266.
Hussain M M, Islam K A, Trajcevski G, Ali M E. Towards efficient maintenance of continuous MaxRS query for trajectories. In Proc. the 20th International Conference on Extending Database Technology, Mar. 2017, pp.402-413. https://doi.org/10.5441/002/edbt.2017.36.
Liu Q, Lian X, Chen L. Probabilistic maximum range-sum queries on spatial database. In Proc. the 27th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, Nov. 2019, pp.159-168. https://doi.org/10.1145/3347146.3359376.
Hussain M M, Mostafiz M I, Mahmud S M F, Trajcevski G, Ali M E. Conditional MaxRS query for evolving spatial data. Frontiers Big Data, 2020, 3: Article No. 20. https://doi.org/10.3389/fdata.2020.00020.
Yiu M L, Mamoulis N. Clustering objects on a spatial network. In Proc. the ACM SIGMOD International Conference on Management of Data, Jun. 2004, pp.443-454. https://doi.org/10.1145/1007568.1007619.
Nandy S C, Bhattacharya B B. A unified algorithm for finding maximum and minimum object enclosing rectangles and cuboids. Computers & Mathematics with Applications, 1995, 29(8): 45-61. https://doi.org/10.1016/0898-1221(95)00029-X.
Zhou X, Wang W. An index-based method for efficient maximizing range sum queries in road network. In Proc. the 27th Australasian Database Conference, Sept. 2016, pp.95-109. https://doi.org/10.1007/978-3-319-46922-5_8.
Phan T K, Jung H, Kim U M. An efficient algorithm for maximizing range sum queries in a road network. The Scientific World Journal, 2014, 2014: Article No. 541602. https://doi.org/10.1155/2014/541602.
He B, Yang K, Fang R, Lu M, Govindaraju N, Luo Q, Sander P. Relational joins on graphics processors. In Proc. the 2008 ACM SIGMOD International Conference on Management of Data, Jun. 2008, pp.511-524. https://doi.org/10.1145/1376616.1376670.
He B, Lu M, Yang K, Fang R, Govindaraju N K, Luo Q, Sander P V. Relational query coprocessing on graphics processors. ACM Transactions on Database Systems, 2009, 34(4): Article No. 21. https://doi.org/10.1145/1620585.1620588.
Bogh K S, Chester S, Assent I. Work-efficient parallel skyline computation for the GPU. Proc. VLDB Endow., 2015, 8(9): 962-973. https://doi.org/10.14778/2777598.2777605.
Dong K, Zhang B, Shen Y, Zhu Y, Yu J. GAT: A unified GPU-accelerated framework for processing batch trajectory queries. IEEE Transactions on Knowledge and Data Engineering, 2020, 32(1): 92-107. https://doi.org/10.1109/TKDE.2018.2879862.
Imai H, Asano T. Finding the connected components and a maximum clique of an intersection graph of rectangles in the plane. Journal of Algorithms, 1983, 4(4): 310-323. https://doi.org/10.1016/0196-6774(83)90012-3.
Amagata D, Hara T. Monitoring MaxRS in spatial data streams. In Proc. the 19th International Conference on Extending Database Technology, Mar. 2016, pp.317-328. https://doi.org/10.5441/002/edbt.2016.30.
Chen Z, Liu Y, Wong R C W, Xiong J, Cheng X, Chen P. Rotating MaxRS queries. Information Sciences, 2015, 305: 110-129. https://doi.org/10.1016/j.ins.2015.02.009.
Feng K, Cong G, Bhowmick S S, Peng W, Miao C. Towards best region search for data exploration. In Proc. the 2016 International Conference on Management of Data, Jun. 26-Jul. 1, 2016, pp.1055-1070. https://doi.org/10.1145/2882903.2882960.
Chen Z, Yuan Q, Liu W. Monitoring best region in spatial data streams in road networks. Data Knowl. Eng., 2019, 120: 100-118. https://doi.org/10.1016/j.datak.2019.03.002.
Liu J, Chai C, Luo Y, Lou Y, Feng J, Tang N. Feature augmentation with reinforcement learning. In Proc. the 38th IEEE International Conference on Data Engineering, May 2022, pp.3360-3372. https://doi.org/10.1109/ICDE53745.2022.00317.
Chai C, Cao L, Li G, Li J, Luo Y, Madden S. Human-in-the-loop outlier detection. In Proc. the 2020 ACM SIGMOD International Conference on Management of Data, Jun. 2020, pp.19-33. https://doi.org/10.1145/3318464.3389772.
Chai C, Liu J, Tang N, Li G, Luo Y. Selective data acquisition in the wild for model charging. Proc. VLDB Endow., 2022, 15(7): 1466-1478. https://doi.org/10.14778/3523210.3523223.
Cook S. CUDA Programming: A Developer’s Guide to Parallel Computing with GPUs (1st edition). Morgan Kaufmann, 2012.
Xu Y, Wang R, Goswami N, Li T, Qian D. Software transactional memory for GPU architectures. IEEE Comput. Archit. Lett., 2014, 13(1): 49-52. https://doi.org/10.1109/L-CA.2013.4.
De Berg M, Van Kreveld M, Overmars M, Schwarzkopf O. Computational Geometry: Algorithms and Applications. Springer, 2000.
Brinkhoff T. A framework for generating network-based moving objects. GeoInformatica, 2002, 6(2): 153-180. https://doi.org/10.1023/A:1015231126594.
Li F, Cheng D, Hadjieleftheriou M, Kollios G, Teng S. On trip planning queries in spatial databases. In Proc. the 9th International Symposium of Advances in Spatial and Temporal Databases, Aug. 2005, pp.273-290. https://doi.org/10.1007/11535331_16.
Author information
Authors and Affiliations
Corresponding authors
Additional information
Kai-Qi Zhang perfected the idea and experimental design proposed by Jian Chen, and provided the experimental platform for this research. Hong Gao participated in the revision and polishing of the full paper, and provided funding and equipment support for this research.
Supplementary Information
ESM 1
(PDF 430 kb)
Rights and permissions
About this article
Cite this article
Chen, J., Zhang, KQ., Ren, T. et al. GAM: A GPU-Accelerated Algorithm for MaxRS Queries in Road Networks. J. Comput. Sci. Technol. 37, 1005–1025 (2022). https://doi.org/10.1007/s11390-022-2330-3
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s11390-022-2330-3