skip to main content
research-article

EAR-Oracle: On Efficient Indexing for Distance Queries between Arbitrary Points on Terrain Surface

Published:30 May 2023Publication History
Skip Abstract Section

Abstract

Due to the advancement of geo-positioning technology, the terrain data has become increasingly popular and has drawn a lot of research effort from both academia and industry. The distance computation on the terrain surface is a fundamental and important problem that is widely applied in geographical information systems and 3D modeling. As could be observed from the existing studies, online computation of the distance on the terrain surface is very expensive. All existing index-based methods are only efficient under the case where the distance query must be performed among a small set of predefined points-of-interest known apriori. But, in general cases, they could not scale up to sizable datasets due to their intolerable oracle building time and space consumption.

In this paper, we studied the arbitrary point-to-arbitrary point distance query on the terrain surface in which no assumption is imposed on the query points, and the distance query could be performed between any two arbitrary points. We propose an indexing structure, namely Efficient Arbitrary Point-to-Arbitrary Point Distance Oracle (EAR-Oracle), with theoretical guarantee on the accuracy, oracle building time, oracle size and query time. Our experiments demonstrate that our oracle enjoys excellent scalability and it scales up to enormous terrain surfaces but none of the existing index-based methods could be able to. Besides, it significantly outperforms all existing online computation methods by orders of magnitude in terms of the query time.

Skip Supplemental Material Section

Supplemental Material

PACMMOD-V1mod14.mp4

mp4

20.6 MB

References

  1. A. Al-Badarneh, H. Najadat, and A. Alraziqi. 2012. A classifier to detect tumor disease in MRI brain images. In The international conference series on Advances in Social Network Analysis and Mining (ASONAM). 784--787.Google ScholarGoogle Scholar
  2. Lyudmil Aleksandrov, Hristo N Djidjev, Hua Guo, Anil Maheshwari, Doron Nussbaum, and Jörg-Rüdiger Sack. 2010. Algorithms for approximate shortest path queries on weighted polyhedral surfaces. In Discrete & Computational Geometry. 762--801.Google ScholarGoogle Scholar
  3. Lyudmil Aleksandrov, Hristo N Djidjev, Hua Guo, Anil Maheshwari, Doron Nussbaum, and Jörg-Rüdiger Sack. 2010. Algorithms for approximate shortest path queries on weighted polyhedral surfaces. In Discrete & Computational Geometry. 762--801.Google ScholarGoogle Scholar
  4. Lyudmil Aleksandrov, Anil Maheshwari, and J-R Sack. 2005. Determining approximate shortest paths on weighted polyhedral surfaces. Journal of ACM, 25--53.Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. Paul B Callahan and S Rao Kosaraju. 1995. A decomposition of multidimensional point sets with applications to k-nearest-neighbors and n-body potential fields. Journal of ACM, 67--90.Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. Marcel Campen, Martin Heistermann, and Leif Kobbelt. 2013. Practical Anisotropic Geodesy. Comput. Graph. Forum, 63--71.Google ScholarGoogle Scholar
  7. Nathaniel Chaney, Laura Torres-Rojas, and Jason Simon. 2021. Leveraging clustering and geostatistics to improve the modeling of sub-grid land-atmosphere interactions in Earth system models. In EGU General Assembly Conference Abstracts. EGU21--14039.Google ScholarGoogle ScholarCross RefCross Ref
  8. Jindong Chen and Yijie Han. 1990. Shortest paths on a polyhedron. In International Symposium on Computational Geometry (SoCG). 360--369.Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. Paolo Cignoni, Marco Callieri, Massimiliano Corsini, Matteo Dellepiane, Fabio Ganovelli, and Guido Ranzuglia. 2008. MeshLab: an Open-Source Mesh Processing Tool. In Eurographics Italian Chapter Conference, Vittorio Scarano, Rosario De Chiara, and Ugo Erra (Eds.). The Eurographics Association. https: //doi.org/10.2312/LocalChapterEvents/ItalChap/ItalianChapConf2008/129--136Google ScholarGoogle Scholar
  10. Keenan Crane, Marco Livesu, Enrico Puppo, and Yipeng Qin. 2020. A Survey of Algorithms for Geodesic Paths and Distances. arXiv preprint arXiv:2007.10430 (2020).Google ScholarGoogle Scholar
  11. Ke Deng, Heng Tao Shen, Kai Xu, and Xuemin Lin. 2006. Surface k-NN query processing. In IEEE International Conference on Data Engineering (ICDE). 78.Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. Ke Deng and Xiaofang Zhou. 2004. Expansion-based algorithms for finding single pair shortest path on surface. In International Conference on Web and Wireless Geographical Information Systems (WWGIS). 151--166.Google ScholarGoogle Scholar
  13. Ke Deng, Xiaofang Zhou, Heng Tao Shen, Qing Liu, Kai Xu, and Xuemin Lin. 2008. A multi-resolution surface distance model for k-NN query processing. ACM International Journal on Very Large Data Bases (VLDBJ), 1101--1119.Google ScholarGoogle Scholar
  14. Brett G Dickson and Paul Beier. 2007. Quantifying the influence of topographic position on cougar (Puma concolor) movement in southern California, USA. Journal of Zoology, 270--277.Google ScholarGoogle ScholarCross RefCross Ref
  15. Hristo N Djidjev and Christian Sommer. 2011. Approximate distance queries forweighted polyhedral surfaces. In The European Symposium on Algorithms (ESA). 579--590.Google ScholarGoogle Scholar
  16. Robert Geisberger, Peter Sanders, Dominik Schultes, and Daniel Delling. 2008. Contraction hierarchies: Faster and simpler hierarchical routing in road networks. In Experimental Algorithms.Google ScholarGoogle Scholar
  17. Robert Geisberger, Peter Sanders, Dominik Schultes, and Christian Vetter. 2012. Exact routing in large road networks using contraction hierarchies. Transportation Science (2012).Google ScholarGoogle Scholar
  18. Wei Hu. 2008. Co-location Pattern Discovery. Springer US, 98--103.Google ScholarGoogle Scholar
  19. Bo Huang, Victor Junqiu Wei, Raymond Chi-Wing Wong, and Bo Tang. 2022. On Efficient Indexing for Distance Queries between Arbitrary Points on Terrain Surface (Technical Report). https://github.com/ ItakEjgo/weighted_distance_oracle/tree/master/technicalreportGoogle ScholarGoogle Scholar
  20. S. A. Huettel, A. W. Song, and G. McCarthy. 2004. Functional magnetic resonance imaging. In Sinauer Associates.Google ScholarGoogle Scholar
  21. Takashi Kanai and Hiromasa Suzuki. 2000. Approximate shortest path on a polyhedral surface based on selective refinement of the discrete graph and its applications. In Proceedings Geometric Modeling and Processing 2000. Theory and Applications (GMPTA). 241--250.Google ScholarGoogle ScholarCross RefCross Ref
  22. Manohar Kaul, Raymond Chi-WingWong, and Christian S Jensen. 2015. New lower and upper bounds for shortest distance queries on terrains. ACM International Conference on Very Large Data Bases (VLDB), 168--179.Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. Manohar Kaul, Raymond Chi-Wing Wong, Bin Yang, and Christian S Jensen. 2013. Finding shortest paths on terrains by killing two birds with one stone. In ACM International Conference on Very Large Data Bases (VLDB). 73--84.Google ScholarGoogle ScholarDigital LibraryDigital Library
  24. Stephen Kiazyk, Sébastien Loriot, and Éric Colin de Verdière. 2021. Triangulated Surface Mesh Shortest Paths. In CGAL User and Reference Manual. CGAL Editorial Board. https://doc.cgal.org/5.3/Manual/packages.html# PkgSurfaceMeshShortestPathGoogle ScholarGoogle Scholar
  25. M. Kortgen, G. J. Park, M. Novotni, and R. Klei. 2003. 3D shape matching with 3D shape contexts. In Central European Seminar on Computer Graphics (CESCG). 5--17.Google ScholarGoogle Scholar
  26. Mark Lanthier, Anil Maheshwari, and J-R Sack. 2001. Approximating shortest paths on weighted polyhedral surfaces. Algorithmica, 527--562.Google ScholarGoogle Scholar
  27. Lik-Hang Lee, Zijun Lin, Rui Hu, Zhengya Gong, Abhishek Kumar, Tangyao Li, Sijia Li, and Pan Hui. 2021. When Creators Meet the Metaverse: A Survey on Computational Arts. ArXiv abs/2111.13486 (2021). https://arxiv.org/abs/2111.13486Google ScholarGoogle Scholar
  28. Lik-Hang Lee, Tristan Braud, Pengyuan Zhou, Lin Wang, Dianlei Xu, Zijun Lin, Abhishek Kumar, Carlos Bermejo, and Pan Hui. 2021. All One Needs to Know about Metaverse: A Complete Survey on Technological Singularity, Virtual Ecosystem, and Research Agenda. ArXiv abs/2110.05352 (2021).Google ScholarGoogle Scholar
  29. Lian Liu and Raymond Chi-WingWong. 2011. Finding shortest path on land surface. In ACM Conference on Management of Data (SIGMOD). 433--444.Google ScholarGoogle ScholarDigital LibraryDigital Library
  30. Anders Mårell, John P Ball, and Annika Hofgaard. 2002. Foraging and movement paths of female reindeer: insights from fractal analysis, correlated random walks, and Lévy flights. Canadian Journal of Zoology, 854--865.Google ScholarGoogle Scholar
  31. Joseph SB Mitchell, David M Mount, and Christos H Papadimitriou. 1987. The discrete geodesic problem. SIAM J. Comput., 647--668.Google ScholarGoogle Scholar
  32. Zaw Lin Oo and Mya Sandar Kyin. 2020. Discovery and comparative study on spatial co-location and association rule mining of spatial data mining. International Journal for Advance Research and Development (2020), 16--19.Google ScholarGoogle Scholar
  33. L Tiina Sarjakoski, Pyry Kettunen, Hanna-Marika Flink, Mari Laakso, Mikko Rönneberg, and Tapani Sarjakoski. 2012. Analysis of verbal route descriptions and landmarks for hiking. Personal and Ubiquitous Computing, 1001--1011.Google ScholarGoogle Scholar
  34. Cyrus Shahabi, Lu-An Tang, and Songhua Xing. 2008. Indexing land surface for efficient knn query. In ACM International Conference on Very Large Data Bases (VLDB). 1020--1031.Google ScholarGoogle ScholarDigital LibraryDigital Library
  35. J. Shotton, J. Winn, C. Rother, and A. Criminisi. 2006. Textonboost: Joint appearance, shape and context modeling for multi-class object recognition and segmentation. In European Conference on Computer Vision (ECCV). 1--15.Google ScholarGoogle Scholar
  36. Michiel H. M. Smid. 2018. The Well-Separated Pair Decomposition and Its Applications. In Handbook of Approximation Algorithms and Metaheuristics, Second Edition, Volume 2: Contemporary and Emerging Applications, Chapter 4. Chapman and Hall/CRC.Google ScholarGoogle Scholar
  37. United States Geological Survey. 2021. 3D Elevation Program 1 arc-second Digital Elevation Model. In United States Geological Survey. Distributed by OpenTopography. https://doi.org/10.5069/G98K778DGoogle ScholarGoogle Scholar
  38. The CGAL Project. 2021. CGAL User and Reference Manual. CGAL Editorial Board. https://doc.cgal.org/5.3/ Manual/packages.htmlGoogle ScholarGoogle Scholar
  39. Nguyet Tran, Michael J Dinneen, and Simone Linz. 2020. Close Weighted Shortest Paths on 3D Terrain Surfaces. In The ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems 2021 (SIGSPATIAL). 597--607.Google ScholarGoogle ScholarDigital LibraryDigital Library
  40. Chuyuan Wang, Yubin Li, Soe W Myint, Qunshan Zhao, and Elizabeth A Wentz. 2019. Impacts of spatial clustering of urban land cover on land surface temperature across Köppen climate zones in the contiguous United States. Landscape and urban planning 192 (2019), 103668.Google ScholarGoogle Scholar
  41. Victor Junqiu Wei, Raymond Chi-Wing Wong, Cheng Long, David M. Mount, and Hanan Samet. 2022. Proximity Queries on Terrain Surface. ACM Trans. Database Syst. 47, 4 (2022), 15:1--15:59. https://doi.org/10. 1145/3563773Google ScholarGoogle ScholarDigital LibraryDigital Library
  42. Victor Junqiu Wei, Raymond Chi-Wing Wong, Cheng Long, and David M. Mount. 2017. Distance Oracle on Terrain Surface. In ACM Conference on Management of Data (SIGMOD). 1211--1226.Google ScholarGoogle Scholar
  43. Shi-Qing Xin and Guo-Jin Wang. 2009. Improving Chen and Han's Algorithm on the Discrete Geodesic Problem. ACM Transactions on Graphics (TOG), 104:1--104:8.Google ScholarGoogle ScholarDigital LibraryDigital Library
  44. S. Xing, C. Shahabi, and B. Pan. 2009. Continuous monitoring of nearest neighbors on land surface. In ACM International Conference on Very Large Data Bases (VLDB). 1114--1125.Google ScholarGoogle Scholar
  45. D. Yan, Z. Zhao, and W. Ng. 2012. Monochromatic and bichromatic reverse nearest neighbor queries on land surfaces. In The Conference on Information and Knowledge Management (CIKM). 942--951.Google ScholarGoogle Scholar

Index Terms

  1. EAR-Oracle: On Efficient Indexing for Distance Queries between Arbitrary Points on Terrain Surface

    Recommendations

    Comments

    Login options

    Check if you have access through your login credentials or your institution to get full access on this article.

    Sign in

    Full Access

    • Published in

      cover image Proceedings of the ACM on Management of Data
      Proceedings of the ACM on Management of Data  Volume 1, Issue 1
      PACMMOD
      May 2023
      2807 pages
      EISSN:2836-6573
      DOI:10.1145/3603164
      Issue’s Table of Contents

      Copyright © 2023 ACM

      Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

      Publisher

      Association for Computing Machinery

      New York, NY, United States

      Publication History

      • Published: 30 May 2023
      Published in pacmmod Volume 1, Issue 1

      Permissions

      Request permissions about this article.

      Request Permissions

      Qualifiers

      • research-article
    • Article Metrics

      • Downloads (Last 12 months)220
      • Downloads (Last 6 weeks)15

      Other Metrics

    PDF Format

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader