Invention Grant
- Patent Title: Dynamic lineage tracking of database data
-
Application No.: US17232927Application Date: 2021-04-16
-
Publication No.: US11194782B2Publication Date: 2021-12-07
- 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:
The subject technology executes a change on an existing micro-partition of a table, the executing of the change comprising generating a new micro-partition that embodies the change and deleting the existing micro-partition. The subject technology receives a request for a delta for the table between a first timestamp and a second timestamp. The subject technology responsively determines the delta based on a table history, the delta including information indicating at least one operation that was performed to at least one row of a set of rows of the table, without including information as to intermediate changes made to at least one row of the set of rows of the table between the first timestamp and the second timestamp, that facilitates a reduction in storage of historical versions of the set of rows of the table.
Public/Granted literature
- US20210248127A1 DYNAMIC LINEAGE TRACKING OF DATABASE DATA Public/Granted day:2021-08-12
Information query