Invention Grant
- Patent Title: Accelerating change data capture determination using row bitsets preliminary
-
Application No.: US18158627Application Date: 2023-01-24
-
Publication No.: US12216638B2Publication Date: 2025-02-04
- Inventor: Tyler Arthur Akidau , Istvan Cseri , Fabian Hueske , Tyler Jones , Yevgeniy Kogan , Dzmitry Pauliukevich , Daniel E. Sotolongo
- 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/23
- IPC: G06F16/23 ; G06F16/22 ; G06F16/2455

Abstract:
Techniques described herein can accelerate change data capture determinations such as stream reads, which show changes made to a table between two points in time. Three distinct row bitests that mark deleted, updated, inserted, rows in micro-partitions can be added as metadata for the table. These bitsets can be generated during DML operations and then stored as metadata of the new partition generated by the DML operations. The bitsets can then be used to generate streams showing the changes in the table between two points in time (changes interval).
Public/Granted literature
- US20230237043A1 ACCELERATING CHANGE DATA CAPTURE DETERMINATION USING ROW BITSETS Public/Granted day:2023-07-27
Information query