SQL 200n和商用(对象-)关系DBMS中的触发器

Triggers in SQL 200n and Commercial (Object-)Relational DBMS

触发器是当前商用DBMS用于完整性实施和主动控制的一个主要机制。作为ISO/IEC:9075SQL200n标准的一个重要组成部分,它的标准化指导意义已引起人们的关注。笔者以信息产业部数据库标准制修订工作为契机,深入研究了触发器的标准语法定义和执行模型,并将它与Oracle、DB2、Informix、MSSQL、Sybase和Ingres等常见商用(对象-)关系DBMS进行详细的比较。

Trigger is a n important mechanism of integrity enforcement and active control for commercial DBMS.As part of ISO/IEC:9075SQL200n standards,trigger has come to people's attention for its standardization guidance.Here taking advantage of th e database standard edit under national Information Industry Department ,we de scribe its syntax definition and execution model and compared it with those of m ajor commercial(object-)relational DBMS including Oracle,DB2,Informix,MS SQL,Sybase and Ingres.