Invention Grant
- Patent Title: Transactional processing of change tracking data
-
Application No.: US17491106Application Date: 2021-09-30
-
Publication No.: US11294882B2Publication Date: 2022-04-05
- Inventor: Subramanian Muralidhar , Istvan Cseri , Torsten Grabs , Benoit Dageville
- 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/245 ; G06F16/27 ; G06F9/46 ; G06F16/18

Abstract:
Systems, methods, and devices for transactional processing of change tracking data for a database are discussed. A method includes generating a micro-partition based on execution of a transaction on a table of a database, the micro-partition reflecting changes made to the table by the transaction. A change tracking entry is generated in response to the execution of the transaction. The change tracking entry includes an indication of one or more modifications made to the table by the transaction and an indication of the micro-partition generated based on the execution of the transaction. The change tracking entry is stored in the micro-partition as metadata. At least one existing micro-partition is removed from the table, responsive to storing the change tracking entry.
Public/Granted literature
- US20220019570A1 TRANSACTIONAL PROCESSING OF CHANGE TRACKING DATA Public/Granted day:2022-01-20
Information query