US 12,393,569 B2
Operation statement analysis for database trigger firing
Douglas Doole, Livermore, CA (US); and Simon Y. Wong, San Carlos, CA (US)
Assigned to Salesforce, Inc.
Filed by Salesforce, Inc., San Francisco, CA (US)
Filed on Jan. 16, 2024, as Appl. No. 18/413,540.
Prior Publication US 2025/0231927 A1, Jul. 17, 2025
Int. Cl. G06F 16/00 (2019.01); G06F 16/23 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/2379 (2019.01); G06F 16/24565 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
storing, by a computer system, trigger information relating to initiating execution of at least one trigger instruction for a database, in connection with a database update operation specified by a database operation statement for the database, wherein
at least a portion of the trigger information corresponds to elements of a trigger definition provided to the computer system,
the elements of the trigger definition include a name of a procedure containing the at least one trigger instruction, and
the trigger information includes a first set of one or more database field identifiers for a respective first set of one or more fields in the database;
receiving, by the computer system, a first database operation statement;
making, by the computer system, a first determination that the first database operation statement specifies the database update operation;
making, by the computer system, a second determination that at least one database field identifier within the first set of one or more database field identifiers is not included in the first database operation statement; and
initiating, by the computer system, execution of the procedure containing the at least one trigger instruction based on the first determination and the second determination.