Abstract:Conventional spatial indexes, represented by the R-tree, employ multidimensional tree structures that are complicated and require enormous efforts to implement in a full-fledged database management system (DBMS). An alternative approach for supporting spatial queries is mapping-based indexing, which maps both data and queries into a one-dimensional space such that data can be indexed and queries can be processed through a one-dimensional indexing structure such as the B + . Mapping-based indexing requires implementing only a few mapping functions, incurring much less effort in implementation compared to conventional spatial index structures. Yet, a major concern about using mapping-based indexes is their lower efficiency than conventional tree structures. In this article, we propose a mapping-based spatial indexing scheme called Size Separation Indexing (SSI). SSI is equipped with a suite of techniques including size separation, data distribution transformation, and more efficient mapping algorithms. These techniques overcome the drawbacks of existing mapping-based indexes and significantly improve the efficiency of query processing. We show through extensive experiments that, for window queries on spatial objects with nonzero extents , SSI has two orders of magnitude better performance than existing mapping-based indexes and competitive performance to the R-tree as a standalone implementation. We have also implemented SSI on top of two off-the-shelf DBMSs, PostgreSQL and a commercial platform, both having R-tree implementation. In this case, SSI is up to two orders of magnitude faster than their provided spatial indexes. Therefore, we achieve a spatial index more efficient than the R-tree in a DBMS implementation that is at the same time easy to implement. This result may upset a common perception that has existed for a long time in this area that the R-tree is the best choice for indexing spatial objects.

Inverted-file R-tree Index Nodes Clustering Based on Multi-objective Optimization.

Node Splitting of R-tree with Form and Position, Multi-objective

Nodes Splitting of R*-Tree Based on Multi-objective Genetic Algorithm

Optimization Research of Spatial Index Structure of R*-tree

Application of the Optimized Packed R-tree Spatial Index in Forest Resource Management

A Brand-New Node-Choosing Algorithm in R-tree Spatial Index

The Node Splitting Optimization Algorithm of R*-tree Based on Mean Shift

A New Approach to Creating Spatial Index with R-Tree

Studies on R-tree Spatial Index for 3D GIS

Hilbert R-tree Spatial Index Algorithm Based on Clustering

A Clustering-Ranking Method for Many-Objective Optimization

Improved Index Mechanism for Moving Object

Scalable Top-K Spatial Keyword Search

LAZY R-tree: the R-tree with Lazy Splitting Algorithm

A Novel Implementation of Dynamic R-tree Based on Lazy Splitting and Clustering

Node splitting algorithm for R~* -tree based on united expression of all geometry objects

Research on R-Tree node assignment algorithm based on minimum of K-Means clustering distance

Research of IRT Tree Index Structure

A Forced Transplant Algorithm for Dynamic R-Tree Implementation

Towards a Painless Index for Spatial Objects

An underground space object-oriented three-dimensional hybrid spatial indexing method