Invention Grant
- Patent Title: Performing geospatial-function join using implied interval join
-
Application No.: US17334339Application Date: 2021-05-28
-
Publication No.: US11709837B2Publication Date: 2023-07-25
- Inventor: Matthias Carl Adams , Simon Holm Jensen , Spyridon Triantafyllis
- 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/00
- IPC: G06F16/00 ; G06F7/00 ; G06F16/2453

Abstract:
Disclosed herein are systems and methods for performing a geospatial-function join using an implied interval join. In an embodiment, a database platform receives a query that includes a geospatial-function join, which applies a geospatial-function predicate to a first geography data object of a first relation and a second geography data object of a second relation. The database platform processes the first and second relations through an interval join that applies an interval-join predicate that is implied by the geospatial-function predicate. The database platform obtains query results at least in part by implementing a filter that applies the geospatial-function predicate to an output of the interval join, and outputs the query results.
Public/Granted literature
- US20210374139A1 PERFORMING GEOSPATIAL-FUNCTION JOIN USING IMPLIED INTERVAL JOIN Public/Granted day:2021-12-02
Information query