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.

A Mapping Based Approach for Multidimensional Data Indexing

Generalized multidimensional data mapping and query processing

Data Warehouse Native Feature Based OLAP Querying with Keywords

A Survey of Multi-Dimensional Indexes: Past and Future Trends

Towards a Painless Index for Spatial Objects

An Efficient and Compact Indexing Scheme for Large-Scale Data Store.

Indexing multi-dimensional data in a cloud system.

Novel High-Dimensional Indexing Structure Based on Dual-Distance Metric

A Clustered Dwarf Structure to Speed Up Queries on Data Cubes

Hierarchical Bitmap Indexing for Range and Membership Queries on Multidimensional Arrays

MC-Tree: Dynamic Index Structure for Partially Clustered Multi-Dimensional Database

RR-tree: A New Relational Approach of Multi-dimension Index

Query optimization for massively parallel data processing.

Leveraging Column Family to Improve Multidimensional Query Performance in HBase

Scalable Top-K Spatial Keyword Search

Fast and Adaptive Bulk Loading of Multidimensional Points

A High-Dimensional Indexing Model for Multi-Source Remote Sensing Big Data

Indexing high-dimensional data for efficient in-memory similarity search

Composite Distance Transformation for Indexing and K -Nearest-neighbor Searching in High-Dimensional Spaces

Indexing High-Dimensional Data in Dual Distance Spaces

Speed Up Linear Scan in High-Dimensions by Sorting One-Dimensional Projections