Invention Grant
- Patent Title: Transactional stores of change tracking data
-
Application No.: US17143054Application Date: 2021-01-06
-
Publication No.: US11615067B2Publication Date: 2023-03-28
- 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 generating a transactional change tracking summary for a database. A method includes executing a transaction on a table of a database, wherein the table includes a micro-partition and the transaction is executed on the micro-partition. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or modifications made to the table by the transaction. The method includes storing the change tracking entry in a change tracking stream, wherein the change tracking stream includes one or more sequential change tracking entries that each correspond to a different transaction that is fully executed on the table.
Public/Granted literature
- US20210157785A1 TRANSACTIONAL STORES OF CHANGE TRACKING DATA Public/Granted day:2021-05-27
Information query