Quadtree and R-tree Indexes in Oracle Spatial: A Comparison using GIS Data
Summary: Implementation and optimization of Quadtree and R-tree indexes in Oracle Spatial. Empirical comparison across GIS queries and large datasets, highlighting trade-offs and practical guidance for index choice in spatial workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Ravi Kanth V Kothuri (Oracle)
- 2. Siva Ravada (Oracle)
- 3. Daniel Abugov (Oracle)
BibTeX Citation
@inproceedings{kothuri_sigmod02,
title = {{Quadtree and R-tree Indexes in Oracle Spatial: A Comparison using GIS Data}},
author = {Kothuri, Ravi Kanth V and Ravada, Siva and Abugov, Daniel},
series = {{SIGMOD} '02},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/564691.564755},
url = {https://dl.acm.org/doi/10.1145/564691.564755},
year = {2002}
}
Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 562 | SRS: Solving c-Approximate Nearest Neighbor Queries in High Dimensional Euclidean Space with a Tiny Index | 2015 | VLDB | 0.00016335405 |
| 2,319 | Hardware Acceleration for Spatial Selections and Joins | 2003 | SIGMOD | 8.6460188e-05 |
| 3,034 | A Revised R*-tree in Comparison with Related Index Structures | 2009 | SIGMOD | 7.7330662e-05 |
| 5,963 | Spatial Indexing in Microsoft SQL Server 2008 | 2008 | SIGMOD | 5.9330399e-05 |
| 8,804 | SwiftSpatial: Spatial Joins on Modern Hardware | 2025 | SIGMOD | 5.2732683e-05 |
| 8,852 | Rapidash: Efficient Detection of Constraint Violations | 2024 | VLDB | 5.2641151e-05 |
| 9,283 | AT-GIS: Highly Parallel Spatial Query Processing with Associative Transducers | 2016 | SIGMOD | 5.203265e-05 |
| 9,544 | Rethinking Choices for Multi-dimensional Point Indexing: Making the Case for the Often Ignored Quadtree | 2007 | CIDR | 5.1611019e-05 |
| 12,549 | Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects | 2013 | VLDB | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 11 of 11 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,905 | Benchmarking Spatial Join Operations with Spatial Output | 1995 | VLDB |
| 2 | 2,358 | Spatial Joins Using Seeded Trees | 1994 | SIGMOD |
| 3 | 101 | Spatial Query Processing in an Object-Oriented Database System | 1986 | SIGMOD |
| 4 | 12,549 | Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects | 2013 | VLDB |
| 5 | 146 | Efficient Processing of Spatial Joins Using R-trees | 1993 | SIGMOD |
| 6 | 2,205 | A Qualitative Comparison Study of Data Structures for Large Line Segment Databases | 1992 | SIGMOD |
| 7 | 10,048 | Adaptive Indexing of Objects with Spatial Extent | 2023 | VLDB |
| 8 | 9,405 | Indexing Medium-dimensionality Data in Oracle | 1999 | SIGMOD |
| 9 | 13,111 | Improving Performance with Bulk-Inserts in Oracle R-Trees | 2003 | VLDB |
| 10 | 2 | R-Trees: A Dynamic Index Structure For Spatial Searching | 1984 | SIGMOD |