skip to main content
10.1145/2666310.2666385acmconferencesArticle/Chapter ViewAbstractPublication PagesgisConference Proceedingsconference-collections
research-article

Distance queries for complex spatial objects in oracle spatial

Published: 04 November 2014 Publication History

Abstract

With the proliferation of global positioning systems (GPS) enabled devices, a growing number of database systems are capable of storing and querying different spatial objects including points, polylines and polygons. In this paper, we present our experience with supporting one important class of spatial queries in these database systems: distance queries. For example, a traveler may want to find hotels within 500 meters of a nearby beach. In addition, this paper presents new techniques implemented in Oracle Spatial for some distance-related problems, such as the maximum distance between complex spatial objects, and the diameter, the convex hull and the minimum bounding circle of complex spatial objects. We conduct our experiments by utilizing real-world data sets and demonstrate that these distance and distance-related queries can be significantly improved.

References

[1]
Dana H. Ballard: Strip Trees: A Hierarchical Representation for Curves. Commun. ACM (CACM) 24(5):310--321 (1981)
[2]
Mark de Berg, Otfried Cheong, Marc van Kreveld, Mark Overmars: Computational Geometry: Algorithms and Applications, Springer-Verlag, New York (2008)
[3]
Thomas Brinkhoff, Holger Horn, Hans-Peter Kriegel, Ralf Schneider: A Storage and Access Architecture for Efficient Query Processing in Spatial Database Systems. SSD 1993: 357--376
[4]
Thomas Brinkhoff, Hans-Peter Kriegel, Ralf Schneider, Bernhard Seeger: Multi-Step Processing of Spatial Joins. SIGMOD Conference 1994: 197--208
[5]
Antonio Corral, Yannis Manolopoulos, Yannis Theodoridis, Michael Vassilakopoulos: Closest Pair Queries in Spatial Databases. SIGMOD Conference 2000: 189--200
[6]
Antonio Corral, Jesús Manuel Aimendros-Jiménez: A performance comparison of distance-based query algorithms using R-trees in spatial databases. Inf. Sci. 177(11): 2207--2237 (2007)
[7]
Edward P. F. Chan: Buffer Queries. IEEE Trans. Knowl. Data Eng. 15(4): 895--910 (2003)
[8]
Tobias Emrich, Hans-Peter Kriegel, Peer Kroger, Matthias Renz, Andreas Züfle: Boosting spatial pruning: on optimal pruning of MBRs. SIGMOD Conference 2010: 39--50
[9]
Brian S. Everitt, Sabine Landau, Morven Leese, Daniel Stahl: Cluster Analysis. Wiley, UK, 2011
[10]
Ronald L. Graham: An Efficient Algorithm for Determining the Convex Hull of a Finite Planar Set. Inf. Process. Lett. 1(4): 132--133 (1972)
[11]
Güting, R. H., An Introduction to Spatial Database Systems. VLDB Journal 3, 4 (1994) (Special Issue on Spatial Database Systems), 357--399.
[12]
Antonin Guttman: R-Trees: A Dynamic Index Structure for Spatial Searching. SIGMOD Conference 1984: 47--57
[13]
Gísli R. Hjaltason, Hanan Samet: Incremental Distance Join Algorithms for Spatial Databases. SIGMOD Conference 1998: 237--248
[14]
Gísli R. Hjaltason, Hanan Samet: Distance Browsing in Spatial Databases. ACM Trans. Database Syst. 24(2): 265--318 (1999)
[15]
Ying Hu, Siva Ravada, Richard Anderson: Geodetic Point-In-Polygon Query Processing in Oracle Spatial. SSTD 2011: 297--312
[16]
Ying Hu, Siva Ravada, Richard Anderson, Bhuvan Bamba: Topological relationship query processing for complex regions in Oracle Spatial. SIGSPATIAL/GIS 2012: 3--12
[17]
Ying Hu, Siva Ravada, Richard Anderson, Bhuvan Bamba: Supporting Topological Relationship Queries for Complex Line and Collection Geometries in Oracle Spatial. SIGSPATIAL/GIS 2013: 94--103
[18]
IBM DB2 Spatial Extender: http://www-03.ibm.com/software/products/en/db2spaext/
[19]
JTS Topology Suite: http://tsusiatsoftware.net/jts/main.html
[20]
Ravi Kanth Kothuri, Siva Ravada, Daniel Abugov: Quadtree and R-tree Indexes in Oracle Spatial: A Comparison Using GIS Data. SIGMOD Conference 2002: 546--557
[21]
Suikai Li, Weiwei Sun, Renchu Song, Zhangqing Shan, Zheyong Chen, Xinyu Zhang: Quick Geo-Fencing Using Trajectory Partitioning and Boundary Simplification. SIGSPATIAL/GIS 2013: 590--593
[22]
Yannis Manolopoulos, Alexandras Nanopoulos, Apostolos N. Papadopoulos, Yannis Theodoridis: R-Trees: Theory and Applications. Springer, London, 2006
[23]
Microsoft SQL Server Spatial Data: http://technet.microsoft.com/en-us/library/bb933790.aspx
[24]
MongoDB Geospatial Indexes and Queries: http://docs.mongodb.org/manual/applications/geospatial-indexes/
[25]
MySQL Spatial Extensions: http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
[26]
Sarana Nutanong, Edwin H. Jacox, Hanan Samet: An Incremental Hausdorff Distance Calculation Algorithm. PVLDB 4(8):506--517 (2011)
[27]
Open Geospatial Consortium Inc.: OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 1: Common architecture
[28]
Oracle Spatial and Graph Developer's Guide 12c Release 1 (12.1): http://docs.oracle.com/cd/E16655_01/appdev.121/e17896/toc.htm
[29]
PostGIS: http://postgis.net/
[30]
Sean Quinlan: Efficient Distance Computation Between Non-Convex Objects. ICRA 1994: 3324--3329
[31]
Siva Ravada, Mohamed H. Ali, Jie Bao, Mohamed Sarwat: ACM SIGSPATIAL GIS Cup 2013. SIGSPATIAL/GIS 2013: 574--577
[32]
Jon Rokne: An Easy Bounding Circle. Graphics Gems II 1991: 14--16.
[33]
Nick Roussopoulos, Stephen Kelley, Frédéic Vincent: Nearest Neighbor Queries. SIGMOD Conference 1995: 71--79
[34]
Hanan Samet: Foundations of Multidimensional and Metric Data Structures. Morgan Kaufmann, San Francisco, CA, 2006
[35]
Erich Schubert, Arthur Zimek, Hans-Peter Kriegel: Geodetic Distance Queries on R-Trees for Indexing Geographic Data. SSTD 2013: 146--164
[36]
Godfried T. Toussaint: Solving geometric problems with the rotating calipers. Proc. MELECON '83, Athens
[37]
Thaddeus Vincenty: Direct and Inverse Solutions of Geodesics on the Ellipsoid with application of nested equations". Survey Review. XXIII (176): 88--93 (1975)
[38]
Emo Welzl: Smallest enclosing disks (balls and ellipsoids). New Results and New Trends in Computer Science, Lecture Notes in Computer Science 555, Springer-Verlag, 359--370 (1991)
[39]
Wikipedia: List of longest rivers of the United States (by main stem). http://en.wikipedia.org/wiki/List_of_longest_rivers_of_the_United_States_%28by_main_stem%29
[40]
Tianyu Zhou, Hong Wei, Heng Zhang, Yin Wang, Yanmin Zhu, Haibing Guan: Point-Polygon Topological Relationship Query using Hierarchical Indices. SIGSPATIAL/GIS 2013: 582--585

Cited By

View all
  • (2022)A Learning-Based POI Recommendation With Spatiotemporal Context AwarenessIEEE Transactions on Cybernetics10.1109/TCYB.2020.300073352:4(2453-2466)Online publication date: Apr-2022

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGSPATIAL '14: Proceedings of the 22nd ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems
November 2014
651 pages
ISBN:9781450331319
DOI:10.1145/2666310
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 ACM 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]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 04 November 2014

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. convex hull
  2. diameter
  3. distance query
  4. maximum distance
  5. minimum bounding circle
  6. within-distance query

Qualifiers

  • Research-article

Conference

SIGSPATIAL '14
Sponsor:
  • University of North Texas
  • Microsoft
  • ORACLE
  • Facebook
  • SIGSPATIAL

Acceptance Rates

SIGSPATIAL '14 Paper Acceptance Rate 39 of 184 submissions, 21%;
Overall Acceptance Rate 257 of 1,238 submissions, 21%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)8
  • Downloads (Last 6 weeks)4
Reflects downloads up to 16 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2022)A Learning-Based POI Recommendation With Spatiotemporal Context AwarenessIEEE Transactions on Cybernetics10.1109/TCYB.2020.300073352:4(2453-2466)Online publication date: Apr-2022

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media