Invention Grant
- Patent Title: Incremental clustering of database tables
-
Application No.: US16716989Application Date: 2019-12-17
-
Publication No.: US10853345B2Publication Date: 2020-12-01
- Inventor: Jiaqi Yan , Thierry Cruanes , Jeffrey Rosen , William Waddington , Prasanna Rajaperumal , Abdul Munir
- Applicant: Snowflake Inc.
- Applicant Address: US CA San Mateo
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/27 ; G06F16/28 ; G06F7/08

Abstract:
Automatic clustering of a database table is disclosed. A method for automatic clustering of a database table includes receiving an indication that a data modification task has been executed on a table and determining whether the table is sufficiently clustered. The method includes, in response to determining the table is not sufficiently clustered, selecting one or more micro-partitions of the table to be reclustered. The method includes assigning each of the one or more micro-partitions to an execution node to be reclustered.
Public/Granted literature
- US20200117650A1 INCREMENTAL CLUSTERING OF DATABASE TABLES Public/Granted day:2020-04-16
Information query