Invention Grant
- Patent Title: Triggers of scheduled tasks in database systems
-
Application No.: US17389234Application Date: 2021-07-29
-
Publication No.: US11308078B2Publication Date: 2022-04-19
- 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 ; G06F9/46

Abstract:
Systems, methods, and devices for executing a task on database data in response to a trigger event are disclosed. A method includes executing a transaction on a table comprising database data, wherein executing the transaction comprises generating a new table version. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or more modifications made to the table by the transaction and storing the change tracking entry in a change tracking stream. The method includes executing a task on the new table version in response to a trigger event.
Public/Granted literature
- US20210357391A1 TRIGGERS OF SCHEDULED TASKS IN DATABASE SYSTEMS Public/Granted day:2021-11-18
Information query