Invention Grant
- Patent Title: Indexed geospatial predicate search
-
Application No.: US17804248Application Date: 2022-05-26
-
Publication No.: US12050605B2Publication Date: 2024-07-30
- 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
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/2455 ; G06F16/28 ; G06F16/9035 ; G06F17/18

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
- US20220284025A1 INDEXED GEOSPATIAL PREDICATE SEARCH Public/Granted day:2022-09-08
Information query