Adaptive Geospatial Joins for Modern Hardware

02/26/2018
by   Andreas Kipf, et al.
0

Geospatial joins are a core building block of connected mobility applications. An especially challenging problem are joins between streaming points and static polygons. Since points are not known beforehand, they cannot be indexed. Nevertheless, points need to be mapped to polygons with low latencies to enable real-time feedback. We present an adaptive geospatial join that uses true hit filtering to avoid expensive geometric computations in most cases. Our technique uses a quadtree-based hierarchical grid to approximate polygons and stores these approximations in a specialized radix tree. We emphasize on an approximate version of our algorithm that guarantees a user-defined precision. The exact version of our algorithm can adapt to the expected point distribution by refining the index. We optimized our implementation for modern hardware architectures with wide SIMD vector processing units, including Intel's brand new Knights Landing. Overall, our approach can perform up to two orders of magnitude faster than existing techniques.

READ FULL TEXT

page 4

page 5

research
04/13/2021

PAGANI: A Parallel Adaptive GPU Algorithm for Numerical

We present a new adaptive parallel algorithm for the challenging problem...
research
09/01/2020

ParIS+: Data Series Indexing on Multi-Core Architectures

Data series similarity search is a core operation for several data serie...
research
01/16/2019

SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning

SkinnerDB is designed from the ground up for reliable join ordering. It ...
research
09/18/2022

Scaling and Load-Balancing Equi-Joins

The task of joining two tables is fundamental for querying databases. In...
research
04/20/2016

CLAASIC: a Cortex-Inspired Hardware Accelerator

This work explores the feasibility of specialized hardware implementing ...
research
03/01/2023

fpgaDDS: An Intra-FPGA Data Distribution Service for ROS 2 Robotics Applications

Modern computing platforms for robotics applications comprise a set of h...
research
10/23/2020

The Case for Distance-Bounded Spatial Approximations

Spatial approximations have been traditionally used in spatial databases...

Please sign up or login with your details

Forgot password? Click here to reset