Quadtree and R-tree indexes in oracle spatial: a comparison using GIS data

  • Authors:
  • Ravi Kanth V Kothuri;Siva Ravada;Daniel Abugov

  • Affiliations:
  • Oracle Corporation, NEDC, Nashua NH;Oracle Corporation, NEDC, Nashua NH;Oracle Corporation, Nashua NH

  • Venue:
  • Proceedings of the 2002 ACM SIGMOD international conference on Management of data
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

Spatial indexing has been one of the active focus areas in recent database research. Several variants of Quadtree and R-tree indexes have been proposed in database literature. In this paper, we first describe briefly our implementation of Quadtree and R-tree index structures and related optimizations in Oracle Spatial. We then examine the relative merits of two structures as implemented in Oracle Spatial and compare their performance for different types of queries and other operations. Finally, we summarize experiences with these different structures in indexing large GIS datasets in Oracle Spatial.