Invention Grant
- Patent Title: Tracking intermediate changes in database data
-
Application No.: US17656960Application Date: 2022-03-29
-
Publication No.: US11620281B2Publication Date: 2023-04-04
- Inventor: Torsten Grabs , Istvan Cseri , 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/00
- IPC: G06F16/00 ; G06F16/23 ; G06F16/22 ; G06F16/2455

Abstract:
Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.
Public/Granted literature
- US20220222247A1 TRACKING INTERMEDIATE CHANGES IN DATABASE DATA Public/Granted day:2022-07-14
Information query