The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Feb. 18, 2025
Filed:
Jul. 03, 2023
Sap SE, Walldorf, DE;
Eun Kyung Chi, Seoul, KR;
Heeyeon Jo, Seoul, KR;
SAP SE, Walldorf, DE;
Abstract
Techniques and solutions are provided for executing database triggers. In particular, disclosed techniques allow for the creation of database triggers with multiple insert statements. For a trigger that includes first and second insert statements, first and second tables are created, respectively for the first and second insert statements, that each include a sequence column. At least the first insert statement references a sequence that is incremented during trigger execution. The sequence columns of the first and second tables have a number of elements corresponding to a number of times a given insert operation will execute as a result of a database operation that satisfies the conditions of the trigger. The first and second insert operations are executed using the respective first and second tables.