发明授权
- 专利标题: Method of executing before-triggers in an active database
- 专利标题(中): 在活动数据库中执行触发前的方法
-
申请号: US09822996申请日: 2001-03-29
-
公开(公告)号: US06745174B2公开(公告)日: 2004-06-01
- 发明人: Eliezer Levy , Yuval Sherman , Nitzan Peleg
- 申请人: Eliezer Levy , Yuval Sherman , Nitzan Peleg
- 主分类号: G06F1730
- IPC分类号: G06F1730
摘要:
A method for executing before-triggers in an active database. A tree of actions is constructed for each activated before-trigger 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.
公开/授权文献
信息查询