发明名称 |
Method of executing before-triggers in an active database |
摘要 |
A method for executing before-triggers in an active database. A tree of actions is constructed for each activated before-rigger and a tree of operators is constructed for the statement that activates the trigger. A table affecting operator that is included in the activating statement is removed from the statement tree and a temporary execution operator is formed from any remaining actions of the activating statement. The temporary execution operator and the activated before-triggers are then included in an insertion operator that is configured to send updated rows into a temporary table. The table affecting operator is then interconnected to execute subsequent to the insertion operator. Any activated row-after and statement-after triggers are interconnected to execute subsequent to the execution of the table-affecting operator.
|
申请公布号 |
US2002143731(A1) |
申请公布日期 |
2002.10.03 |
申请号 |
US20010822996 |
申请日期 |
2001.03.29 |
申请人 |
LEVY ELIEZER;SHERMAN YUVAL;PELEG NITZAN |
发明人 |
LEVY ELIEZER;SHERMAN YUVAL;PELEG NITZAN |
分类号 |
G06F7/00;G06F17/30;(IPC1-7):G06F7/00 |
主分类号 |
G06F7/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|