Statement-level instead-of database triggers

A non-transitory computer readable medium having program instructions stored thereon that are capable of causing a computer system to perform operations comprising:

• storing trigger information associated with a first statement-level database trigger executable to initiate execution of at least one first trigger instruction for a database instead of performing a particular database operation, on a first database view of selected data from the database, specified by a database operation statement;
• receiving a first database operation statement specifying performance of the particular database operation on the first database view;
• identifying a set of first target rows, within the first database view, targeted by the first database operation statement;
• generating a first reference table associated with the first database view, wherein the first reference table includes rows corresponding to the first target rows;
• and
• executing the first statement-level database trigger instead of executing, rather than before or after executing, the first database operation statement, wherein executing the first statement-level database trigger includes accessing the first reference table and wherein a single execution of the first statement-level database trigger is performed instead of execution of the first database operation statement for multiple of the first target rows.

A system, comprising:

• at least one processor;
• and
• memory having program instructions stored thereon that are executable by the at least one processor to cause the system to perform operations comprising:
• storing trigger information associated with a first statement-level database trigger executable to initiate execution of at least one first trigger instruction for a database instead of performing a particular database operation, on a first target arrangement, into rows and columns, of data from the database, specified by a database operation statement;
• receiving a first database operation statement specifying performance of the particular database operation on the first target arrangement;
• identifying a set of first target rows, within the first target arrangement, targeted by the first database operation statement;
• generating a first reference table associated with the first target arrangement, wherein the first reference table includes rows corresponding to the first target rows;
• and
• executing the first statement-level database trigger instead of executing, rather than before or after executing, the first database operation statement, wherein executing the first statement-level database trigger includes accessing the first reference table and wherein a single execution of the first statement-level database trigger is performed instead of execution of the first database operation statement for multiple of the first target rows.