Ying Hu
ABSTRACT
Although geographic information systems (GIS) and spatial database communities have extensively studied topological relationships for more than two decades, there is little literature describing how to efficiently implement them in GIS and spatial database systems. This is rather surprising considering that topological relationship queries are supported in many GIS and spatial database systems including IBM Informix Spatial and Geodetic DataBlades, ESRI SDE, Microsoft SQL server 2008, Oracle Spatial and PostGIS. In order to bridge this gap, we report our experience with implementing several optimization techniques in Oracle Spatial to speed up topological relationship query processing for query windows represented by complex regions (such as polygons or multi-polygons). Our experiments, utilizing real-world data sets, demonstrate that topological relationship query performance can be significantly improved using the proposed techniques.
- Wael M. Badawy, Walid G. Aref: On Local Heuristics to Speed Up Polygon-Polygon Intersection Tests. ACM-GIS 1999:97--102 Google Scholar
Digital Library
- Mark de Berg, Otfried Cheong, Marc van Kreveld, Mark Overmars: Computational Geometry: Algorithms and Applications, Springer-Verlag, New York (2008) Google ScholarDigital Library
- 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 Google ScholarDigital Library
- Thomas Brinkhoff, Hans-Peter Kriegel, Ralf Schneider, Bernhard Seeger: Multi-Step Processing of Spatial Joins. SIGMOD Conference 1994:197--208 Google ScholarDigital Library
- Edward P. F. Chan, Jimmy N. H. Ng: A General and Efficient Implementation of Geometric Operators and Predicates. SSD 1997: 69--93 Google ScholarDigital Library
- Eliseo Clementini, Jayant Sharma, Max J. Egenhofer: Modeling topological spatial relations: Strategies for query processing. Computers & Graphics 18(6): 815--822 (1994)Google ScholarCross Ref
- Zhan Cui, Anthony G. Cohn, David A. Randell: Qualitative and Topological Relationships in Spatial Databases. SSD 1993: 296--315 Google ScholarDigital Library
- Max J. Egenhofer, John R. Herring: Categorizing Binary Topological Relations Between Regions, Lines, and Points in Geographic Databases. Technical Report. Department of Surveying Engineering, University of Maine, 1991Google Scholar
- ESRI. 1995. ESRI Spatial Database Engine (SDE). Environmental Systems Research Institute, Inc., Redlands, CA: http://edndoc.esri.com/arcsde/9.1/Google Scholar
- Yi Fang, Marc Friedman, Giri Nair, Michael Rys, Ana-Elisa Schmid: Spatial indexing in Microsoft SQL server 2008. SIGMOD Conference 2008: 1207--1216 Google ScholarDigital Library
- Ying Hu, Siva Ravada, Richard Anderson: Geodetic Point-In-Polygon Query Processing in Oracle Spatial. SSTD 2011: 297--312 Google ScholarDigital Library
- IBM Informix, Informix Geodetic and Spatial DataBlades, http://www-01.ibm.com/software/data/informix/blades/Google Scholar
- JTS Topology Suite: http://tsusiatsoftware.net/jts/main.htmlGoogle Scholar
- Ravi Kanth Kothuri, Siva Ravada: Efficient Processing of Large Spatial Queries Using Interior Approximations. SSTD 2001: 404--424 Google ScholarDigital Library
- 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 Google ScholarDigital Library
- Paul A. Longley, Michael F. Goodchild, David J. Maguire, David W. Rhind: Geographic Information Systems and Science. John Wiley & Sons Ltd, West Sussex, UK. (2005)Google Scholar
- Microsoft SQL Server, Spatial Indexing Overview, http://technet.microsoft.com/en-us/library/bb964712.aspxGoogle Scholar
- NAVTEQ, http://www.navteq.com/Google Scholar
- Open Geospatial Consortium Inc.: OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 1: Common architectureGoogle Scholar
- Oracle Spatial, Oracle® Spatial Developer's Guide 11g Release 2 (11.2), Part Number E11830-07, 2010Google Scholar
- Joseph O'Rourke: Computational Geometry in C. Cambridge University Press, Cambridge, UK (1998) Google ScholarDigital Library
- Dimitris Papadias, Yannis Theodoridis, Timos K. Sellis, Max J. Egenhofer: Topological Relations in the World of Minimum Bounding Rectangles: A Study with R-trees. SIGMOD Conference 1995: 92--103 Google ScholarDigital Library
- PostGIS: http://postgis.refractions.net/Google Scholar
- Markus Schneider, Thomas Behr: Topological relationships between complex spatial objects. ACM Trans. Database Syst. 31(1): 39--81 (2006) Google ScholarDigital Library
Index Terms
- Topological relationship query processing for complex regions in Oracle Spatial
Recommendations
Supporting topological relationship queries for complex line and collection geometries in oracle spatial
SIGSPATIAL'13: Proceedings of the 21st ACM SIGSPATIAL International Conference on Advances in Geographic Information SystemsTransportation networks including roads and railways, and linear hydrography features like streams and canals are traditionally represented as complex lines in geographic information systems (GIS) and spatial database systems. In addition, as the Global ...
Topological relationships between complex spatial objects
For a long time topological relationships between spatial objects have been a focus of research in a number of disciplines like artificial intelligence, cognitive science, linguistics, robotics, and spatial reasoning. Especially as predicates they ...
Complex Spatial Query Processing
The user of a Geographical Information System is not limited to conventional spatial selections and joins, but may also pose more complicated and descriptive queries. In this paper, we focus on the efficient processing and optimization of complex ...
Comments