Invention Grant
- Patent Title: System and method for disjunctive joins
-
Application No.: US17879615Application Date: 2022-08-02
-
Publication No.: US11615086B2Publication Date: 2023-03-28
- Inventor: Thierry Cruanes , Florian Andreas Funke , Guangyan Hu , Jiaqi Yan
- Applicant: SNOWFLAKE INC.
- Applicant Address: US MT Bozeman
- Assignee: SNOWFLAKE INC.
- Current Assignee: SNOWFLAKE INC.
- Current Assignee Address: US MT Bozeman
- 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 generating a query plan for a query, wherein there is a join operator expression for each of a plurality of disjunctive predicates and each join operator expression includes at least a conjunctive predicate and a disjunctive operator. The method may also include generating a bloom filter for each of the plurality of disjunctive operators. The method may further include evaluating each of the plurality of join operator expressions using a corresponding one of the plurality of disjunctive operators and bloom filter for each of the plurality of disjunctive predicates to generate a result set.
Public/Granted literature
- US20220391390A1 SYSTEM AND METHOD FOR DISJUNCTIVE JOINS Public/Granted day:2022-12-08
Information query