公开(公告)号：US20250013628A1

公开(公告)日：2025-01-09

申请号：US18217943

申请日：2023-07-03

Applicant: SAP SE

Inventor： Eun Kyung Chi ,  Heeyeon Jo

IPC: G06F16/22

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.

公开(公告)号：US12229115B2

公开(公告)日：2025-02-18

申请号：US18217943

申请日：2023-07-03

Applicant: SAP SE

Inventor： Eun Kyung Chi ,  Heeyeon Jo

IPC: G06F16/23 ,  G06F16/2455

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.