Invention Grant
- Patent Title: Pre-filter deduplication for multidimensional two-sided interval joins
-
Application No.: US17239529Application Date: 2021-04-23
-
Publication No.: US11494379B2Publication Date: 2022-11-08
- 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
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F16/2455 ; G06F16/2458

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
- US20220300511A1 PRE-FILTER DEDUPLICATION FOR MULTIDIMENSIONAL TWO-SIDED INTERVAL JOINS Public/Granted day:2022-09-22
Information query