- Patent Title: Incremental reclustering based on local maxima of partition overlap
-
Application No.: US17243795Application Date: 2021-04-29
-
Publication No.: US11442917B2Publication Date: 2022-09-13
- Inventor: Jiaqi Yan , Thierry Cruanes , Jeffrey Rosen , William Waddington , Prasanna Rajaperumal , Abdul Munir
- 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/22
- IPC: G06F16/22 ; G06F16/27 ; G06F16/28 ; G06F7/08

Abstract:
Disclosed herein are systems and methods for incremental reclustering of database tables based on local maxima of partition overlap. In an embodiment, a database platform makes a determination, based on one or more incremental-reclustering criteria, to incrementally recluster a database table, which has a clustering key and which is stored across a plurality of partitions. In response to making the determination, the database platform selects a subset of the partitions, and at least incrementally reclusters the selected subset. The selecting of the subset includes identifying a local maximum of a quantity of overlapping partitions in the plurality of partitions with respect to a domain of the clustering key of the table, where the overlapping partitions overlap with respect to the clustering key.
Public/Granted literature
- US20210248126A1 INCREMENTAL RECLUSTERING BASED ON LOCAL MAXIMA OF PARTITION OVERLAP Public/Granted day:2021-08-12
Information query