SGPAC: Generalized Scalable Spatial GroupBy Aggregations over Complex Polygons
SGPAC: Generalized Scalable Spatial GroupBy Aggregations over Complex Polygons
复制标题
SGPAC:通过复杂多边形聚合的广义可扩展空间组
DOI:
10.1007/s10707-023-00491-8
复制
发表时间:
2023
期刊:
影响因子:
2
通讯作者:
Tsotras, Vassilis J.
中科院分区:
文献类型:
--
作者:
Abdelhafeez, Laila;Magdy, Amr;Tsotras, Vassilis J.
This paper studies thespatial group-by queryover complex polygons. Given a set of spatial points and a set of polygons, the spatial group-by query returns the number of points that lie within the boundaries of each polygon. Groups are selected from a set of non-overlapping complex polygons, typically in the order of thousands, while the input is a large-scale dataset that contains hundreds of millions or even billions of spatial points. This problem is challenging because real polygons (like counties, cities, postal codes, voting regions, etc.) are described by very complex boundaries. We propose a highly-parallelized query processing framework to efficiently compute the spatial group-by query on highly skewed spatial data. We also propose an effective query optimizer that adaptively assigns the appropriate processing scheme based on the query polygons. Our experimental evaluation with real data and queries has shown significant superiority over all existing techniques.