Invention Application
- Patent Title: INDEXED GEOSPATIAL PREDICATE SEARCH
-
Application No.: US17804248Application Date: 2022-05-26
-
Publication No.: US20220284025A1Publication Date: 2022-09-08
- Inventor: Matthias Carl Adams , Mahmud Allahverdiyev , Ismail Oukid , Peter Popov , Alejandro Salinger
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/9035 ; G06F16/28 ; G06F17/18 ; G06F16/22

Abstract:
Provided herein are systems and methods for indexed geospatial predicate search. An example method performed by at least one hardware processor includes decoding a query with a geospatial predicate. The geospatial predicate is configured between a geography data column and a constant geography object. The method further includes computing a first covering for a data value of a plurality of data values in the geography data column. The first covering includes a first set of cells in a hierarchical grid representation of a geography. The first set of cells represents a surface of the geography associated with the data value. A second covering is computed for the constant geography object. A determination is made on whether to prune at least one partition of a database organized into a set of partitions and including the geography data column based on a comparison between the first covering and the second covering.
Public/Granted literature
- US12050605B2 Indexed geospatial predicate search Public/Granted day:2024-07-30
Information query