Invention Grant
- Patent Title: Tracking changes in database data
-
Application No.: US17660132Application Date: 2022-04-21
-
Publication No.: US11874818B2Publication Date: 2024-01-16
- Inventor: 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/27 ; G06F16/2455

Abstract:
A method includes partitioning a database table into a first plurality of partitions. A plurality of changes are executed on the database table in response to a transaction. The changes occur at a corresponding plurality of timestamps and result in a second plurality of partitions. The database table is updated to include a log with the plurality of changes. For each change of the plurality of changes, the log includes and an identification of a portion of the database table the change is applied to. A selection of a first timestamp and a second timestamp of the plurality of timestamps is detected. A delta is generated in response to the selection. The delta indicates a total change occurring to the database table between a first change of the plurality of changes corresponding to the first timestamp and a second change of the plurality of changes corresponding to the second timestamp.
Public/Granted literature
- US20220245121A1 TRACKING CHANGES IN DATABASE DATA Public/Granted day:2022-08-04
Information query