Invention Application
- Patent Title: PRE-FILTER DEDUPLICATION FOR MULTIDIMENSIONAL TWO-SIDED INTERVAL JOINS
-
Application No.: US17239529Application Date: 2021-04-23
-
Publication No.: US20220300511A1Publication Date: 2022-09-22
- Inventor: Matthias Carl Adams , Spyridon Triantafyllis , Lars Volker , Kevin Wang
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2458 ; G06F16/2455

Abstract:
Disclosed herein are systems and methods for pre-filter deduplication for multidimensional two-sided interval joins. In an embodiment, a data platform receives query instructions for a two-sided N dimensional interval join, where N is an integer greater than 1. The two-sided N dimensional interval join has an interval-join predicate that compares intervals determined from the input relations in each of N dimensions. The data platform implements the two-sided N dimensional interval join as a query-plan section that includes an N dimensional band join that is followed by a deduplication operator that is followed by a filter that applies the interval-join predicate. The N dimensional band join includes a hash join keyed to N dimensional domain cells overlapped at least in part by intervals determined from the input relations in each of the N dimensions. The deduplication operator removes duplicate rows from a potential-duplicates subset of the output of the N dimensional band join.
Public/Granted literature
- US11494379B2 Pre-filter deduplication for multidimensional two-sided interval joins Public/Granted day:2022-11-08
Information query