Invention Grant
- Patent Title: Tracking changes in database data
-
Application No.: US16705424Application Date: 2019-12-06
-
Publication No.: US10776340B2Publication Date: 2020-09-15
- Inventor: Istvan Cseri , Torsten Grabs , Benoit Dageville
- Applicant: Snowflake Inc.
- Applicant Address: US CA San Mateo
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/27 ; G06F16/2455

Abstract:
Systems, methods, and devices for tracking changes to database data. A method includes determining a change to be executed on a micro-partition of a table of a database and executing the change on the table by generating a new micro-partition that embodies the change. The method includes updating a table history that includes a log of changes made to the table, wherein each change in the log of changes includes a timestamp, and wherein updating the table history includes inserting the change into the log of changes.
Public/Granted literature
- US10824617B2 Tracking changes in database data Public/Granted day:2020-11-03
Information query