Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/3318464.3389774acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
short-paper
Public Access

A GPU-friendly Geometric Data Model and Algebra for Spatial Queries

Published: 31 May 2020 Publication History

Abstract

The availability of low cost sensors has led to an unprecedented growth in the volume of spatial data. Unfortunately, the time required to evaluate even simple spatial queries over large data sets greatly hampers our ability to interactively explore these data sets and extract actionable insights. While Graphics Processing Units~(GPUs) are increasingly being used to speed up spatial queries, existing solutions have two important drawbacks: they are often tightly coupled to the specific query types they target, making it hard to adapt them for other queries; and since their design is based on CPU-based approaches, it can be difficult to effectively utilize all the benefits provided by the GPU. As a first step towards making GPU spatial query processing mainstream, we propose a new model that represents spatial data as geometric objects and define an algebra consisting of GPU-friendly composable operators that operate over these objects. We demonstrate the expressiveness of the proposed algebra and present a proof-of-concept prototype that supports a subset of the operators, which shows that it is orders of magnitude faster than a CPU-based implementation and outperforms custom GPU-based approaches.

Supplementary Material

MP4 File (3318464.3389774.mp4)
Presentation Video

References

[1]
David W. Adler. 2001. DB2 Spatial Extender - Spatial Data Within the RDBMS. In Proc. VLDB. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA, 687--690.
[2]
Walid G. Aref and Hanan Samet. 1991 a. Extending a DBMS with Spatial Operations. In Proc. SSD. Springer-Verlag, London, UK, UK, 299--318.
[3]
Walid G. Aref and Hanan Samet. 1991 b. Optimization for Spatial Query Processing. In Proc. VLDB. Morgan Kaufmann Publishers Inc., San Francisco, CA, USA, 81--90.
[4]
B. Bustos, O. Deussen, S. Hiller, and D. Keim. 2006. A Graphics Hardware Accelerated Algorithm for Nearest Neighbor Search. In Proc. ICCS, V. N. Alexandrov, G. D. van Albada, P. M. A. Sloot, and J. Dongarra (Eds.). Springer Berlin Heidelberg, Berlin, Heidelberg, 196--199.
[5]
Harish Doraiswamy and Juliana Freire. 2020. A GPU-friendly Geometric Data Model and Algebra for Spatial Queries: Extended Version. arxiv: 2004.03630 [cs.DB]
[6]
H. Doraiswamy, H. T. Vo, C. T. Silva, and J. Freire. 2016. A GPU-based index to support interactive spatio-temporal queries over historical data. In Proc. ICDE. IEEE, 1086--1097.
[7]
Max J. Egenhofer and Robert D. Franzosa. 1991. Point-set topological spatial relations. Int. J. Geogr. Inf. Syst., Vol. 5, 2 (1991), 161--174.
[8]
Max J. Egenhofer and Jayant Sharma. 1993. Topological relations between regions in $R^2$ and $Z^2$. In Adv. Spatial Databases, David Abel and Beng Chin Ooi (Eds.). Springer Berlin Heidelberg, Berlin, Heidelberg, 316--336.
[9]
A. Eldawy and M. F. Mokbel. 2016. The Era of Big Spatial Data: A Survey. Found. Trends databases, Vol. 6, 3--4 (Dec. 2016), 163--273.
[10]
Jean-Daniel Fekete and Claudio Silva. 2012. Managing Data for Visual Analytics: Opportunities and Challenges. IEEE Data Eng. Bull., Vol. 35, 3 (2012), 27--36.
[11]
Nivan Ferreira, Jorge Poco, Huy T Vo, Juliana Freire, and Cláudio T Silva. 2013. Visual exploration of big spatio-temporal urban data: A study of new york city taxi trips. IEEE TVCG, Vol. 19, 12 (2013), 2149--2158.
[12]
M Gargano, E Nardelli, and M Talamo. 1991. Abstract data types for the logical modeling of complex data. Information Systems, Vol. 16, 6 (1991), 565 -- 583.
[13]
R. H. Güting. 1988. Geo-Relational Algebra: A Model and Query Language for Geometric Database Systems. In Proc. EDBT. Springer-Verlag, London, UK, UK, 506--527.
[14]
Ralf Hartmut Güting and Markus Schneider. 1993. Realms: A foundation for spatial data types in database systems. In Adv. Spatial Databases, David Abel and Beng Chin Ooi (Eds.). Springer Berlin Heidelberg, Berlin, Heidelberg, 14--35.
[15]
Ralf Hartmut Güting and Markus Schneider. 1995. Realm-based spatial data types: The ROSE algebra. VLDBJ, Vol. 4, 2 (01 Apr 1995), 243--286.
[16]
Wolfgang Kainz, Max J. Egenhofer, and Ian Greasley. 1993. Modelling spatial relations and operations with partially ordered sets. Int. J. Geogr. Inf. Syst., Vol. 7, 3 (1993), 215--229.
[17]
Zhicheng Liu and J. Heer. 2014. The Effects of Interactive Latency on Exploratory Visual Analysis. IEEE TVCG, Vol. 20, 12 (2014), 2122--2131.
[18]
Jeremy M., Roland V., and C. D. Tomlin. 2005. Cubic Map Algebra Functions for Spatio-Temporal Analysis. CaGIS, Vol. 32, 1 (2005), 17--32.
[19]
Jan Kristof Nidzwetzki and Ralf Hartmut Güting. 2017. Distributed secondo: an extensible and scalable database management system. Distributed and Parallel Databases, Vol. 35, 3 (01 Dec 2017), 197--248.
[20]
Varun Pandey, Andreas Kipf, Thomas Neumann, and Alfons Kemper. 2018. How Good Are Modern Spatial Analytics Systems? PVLDB, Vol. 11, 11 (July 2018), 1661--1673.
[21]
H. Samet and W. G. Aref. 1995. Spatial Data Models and Query Processing. In Modern Database Systems, Won Kim (Ed.). ACM Press/Addison-Wesley Publishing Co., New York, NY, USA, 338--360.
[22]
Dave Shreiner, Graham Sellers, John M. Kessenich, and Bill M. Licea-Kane. 2013. OpenGL Programming Guide: The Official Guide to Learning OpenGL, Version 4.3 8th ed.). Addison-Wesley Professional.
[23]
C D. Tomlin. 1994. Map algebra: one perspective. Landscape and Urban Planning, Vol. 30, 1--2 (1994), 3--12.
[24]
E. Tzirita Zacharatou, H. Doraiswamy, A. Ailamaki, C. T. Silva, and J. Freire. 2017. GPU Rasterization for Real-time Spatial Aggregation over Arbitrary Polygons. PVLDB, Vol. 11, 3 (2017), 352--365.
[25]
A. Voisard and B. David. 2002. A database perspective on geospatial data modeling. IEEE TKDE, Vol. 14, 2 (March 2002), 226--243.
[26]
Jianting Zhang and Simin You. 2012. Speeding up large-scale point-in-polygon test based spatial join on GPUs. In Proc. BigSpatial. 23--32.
[27]
Jianting Zhang, Simin You, and Le Gruenwald. 2012a. High-performance online spatial and temporal aggregations on multi-core CPUs and many-core GPUs. In Proc. DOLAP. 89--96.
[28]
Jianting Zhang, Simin You, and Le Gruenwald. 2012b. High-Performance Spatial Join Processing on GPGPUs with Applications to Large-Scale Taxi Trip Data. Technical Report. The City College of New York.

Cited By

View all
  • (2024)Geospatial indexing for sea–land navigation based on machine learningComputers and Electrical Engineering10.1016/j.compeleceng.2024.109433118(109433)Online publication date: Sep-2024
  • (2023)Efficient spatial queries over complex polygons with hybrid representationsGeoInformatica10.1007/s10707-023-00508-228:3(459-497)Online publication date: 27-Dec-2023
  • (2022)ShaderNetProceedings of the 5th ACM SIGMOD Joint International Workshop on Graph Data Management Experiences & Systems (GRADES) and Network Data Analytics (NDA)10.1145/3534540.3534688(1-5)Online publication date: 12-Jun-2022
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGMOD '20: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data
June 2020
2925 pages
ISBN:9781450367356
DOI:10.1145/3318464
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 31 May 2020

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. GPU processing
  2. spatial query model

Qualifiers

  • Short-paper

Funding Sources

  • National Science Foundation
  • DARPA
  • NYU Moore Sloan Data Science Environment

Conference

SIGMOD/PODS '20
Sponsor:

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)242
  • Downloads (Last 6 weeks)20
Reflects downloads up to 30 Aug 2024

Other Metrics

Citations

Cited By

View all
  • (2024)Geospatial indexing for sea–land navigation based on machine learningComputers and Electrical Engineering10.1016/j.compeleceng.2024.109433118(109433)Online publication date: Sep-2024
  • (2023)Efficient spatial queries over complex polygons with hybrid representationsGeoInformatica10.1007/s10707-023-00508-228:3(459-497)Online publication date: 27-Dec-2023
  • (2022)ShaderNetProceedings of the 5th ACM SIGMOD Joint International Workshop on Graph Data Management Experiences & Systems (GRADES) and Network Data Analytics (NDA)10.1145/3534540.3534688(1-5)Online publication date: 12-Jun-2022
  • (2022)SPADE: GPU-Powered Spatial Database Engine for Commodity Hardware2022 IEEE 38th International Conference on Data Engineering (ICDE)10.1109/ICDE53745.2022.00245(2669-2681)Online publication date: May-2022
  • (2022)Optimized Closest Pair Computation with CPU-GPU Combined ModelICT Analysis and Applications10.1007/978-981-19-5224-1_74(743-755)Online publication date: 6-Nov-2022
  • (2021)Spatial Data Sequence Selection Based on a User-Defined Condition Using GPGPUISPRS International Journal of Geo-Information10.3390/ijgi1012081610:12(816)Online publication date: 2-Dec-2021
  • (2021)The art of balanceProceedings of the VLDB Endowment10.14778/3476311.347637814:12(2999-3013)Online publication date: 28-Oct-2021
  • (2021)IDEAL: a Vector-Raster Hybrid Model for Efficient Spatial Queries over Complex Polygons2021 22nd IEEE International Conference on Mobile Data Management (MDM)10.1109/MDM52706.2021.00024(99-108)Online publication date: Jun-2021
  • (2020)How Good Are Modern Spatial Libraries?Data Science and Engineering10.1007/s41019-020-00147-96:2(192-208)Online publication date: 7-Nov-2020

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media