Invention Grant
- Patent Title: System and method for disjunctive joins
-
Application No.: US17327521Application Date: 2021-05-21
-
Publication No.: US11429605B2Publication Date: 2022-08-30
- 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
- US20210326340A1 SYSTEM AND METHOD FOR DISJUNCTIVE JOINS Public/Granted day:2021-10-21
Information query