Invention Grant
- Patent Title: System and method for disjunctive joins
-
Application No.: US17105406Application Date: 2020-11-25
-
Publication No.: US11599537B2Publication Date: 2023-03-07
- Inventor: Thierry Cruanes , Florian Andreas Funke , Guangyan Hu , Jiaqi Yan
- Applicant: Snowflake Inc.
- Applicant Address: US CA San Mateo
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Womble Bond Dickinson (US) LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F16/2455

Abstract:
Joining data using a disjunctive operator is described. An example computer-implemented method can include receiving a query that includes a first disjunctive predicate involving a first table and a second table. The method may also include determining a first set of rows from the first table and generating a filter from the first set of rows. The method may also further include applying the filter to the second table to generate a second set of rows. Additionally, the method may also include joining the first set of rows and the second set of rows using a first disjunctive operator of the first disjunctive predicate to generate a first results set.
Public/Granted literature
- US20210286816A1 SYSTEM AND METHOD FOR DISJUNCTIVE JOINS Public/Granted day:2021-09-16
Information query