Patent ID: 6711560
Filing Date: 2004-03-23
Classification: G06F,Y10S

Abstract:
A method of forming an execution plan for a plurality of triggers in an active database having at least one table, each table having at least one row, comprising:identifying the plurality of triggers that are activated by the activating statement; forming an operator tree for the activating statement; forming a tree for each trigger of the plurality of activated triggers, wherein the activated triggers are after-triggers each having a creation time stamp; determining the tables that are accessed by the plurality of activated triggers; determining any conflicting triggers based on the tables accessed by the activated triggers; separating the activated triggers into at least two parallel groups including a first group and a second group, each group containing at least one trigger that conflicts with at least one trigger in another group; and interconnecting the parallel groups of triggers to the operator tree for the activating statement such that the parallel groups execute in the order of the creation time stamp of the at least one conflicting trigger contained therein.