Invention Grant
- Patent Title: Tracking changes in database data
-
Application No.: US16182112Application Date: 2018-11-06
-
Publication No.: US11347714B2Publication Date: 2022-05-31
- 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: G06F17/30
- IPC: G06F17/30 ; 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.
Information query