US 12,380,084 B2
Delta transition table for database triggers
Douglas Doole, Livermore, CA (US); and Simon Y. Wong, San Carlos, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by Salesforce, Inc., San Francisco, CA (US)
Filed on Jan. 19, 2023, as Appl. No. 18/156,895.
Claims priority of provisional application 63/375,356, filed on Sep. 12, 2022.
Prior Publication US 2024/0086387 A1, Mar. 14, 2024
Int. Cl. G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/24 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 16/2365 (2019.01); G06F 16/24565 (2019.01)] 15 Claims
OG exemplary drawing
 
1. A method, comprising:
storing, by a computer system, trigger information that identifies a database trigger that is executable to perform a set of post-processing routines with respect to a particular database table after an update database statement has been executed to update the particular database table;
executing, by the computer system, a particular update database statement to update at least one value in one or more rows of the particular database table;
constructing, by the computer system, a delta table that includes at least an original version of the one or more rows prior to the executing of the particular update database statement and an updated version of the one or more rows resulting from the executing of the particular update database statement, wherein the constructing of the delta table includes:
as a part of updating a first one of the one or more rows, producing a concatenated row by concatenating the first row and an updated version of the first row; and
inserting the concatenated row into the delta table, wherein the concatenated row is inserted into the delta table before updating a second one of the one or more rows as a part of the executing of the particular update database statement; and
subsequent to the executing of the particular update database statement, the computer system executing the database trigger with the delta table as an input to the database trigger to enable the set of post-processing routines to access the original and updated versions of the one or more rows using the delta table.