摘要
SQL Server数据库是当今信息管理系统中有代表性的大型网络数据库之一。文中讨论在SQL Server 2008中通过触发器技术实现数据完整性的机制,介绍触发器的概念、分类,重点论述DML触发器的实现过程,结合具体实例,设计DML触发器监督财务人员对资金的各种业务操作,包括插入、删除和更新记录,分析了触发器设计的基本步骤,并改进触发器设计,使审计表能够记录全部变化的数据,从而反映了触发器的应用在提高系统性能、维护数据库完整性、有效性等方面的强大功能。
SQL Server database is a representative large-scale network database of the information management system. It discusses, in SQL Server 2008, trigger technology to realize data integrity mechanism,in^-oduces the concept, classification of the trigger, mainly deals with the DML trigger implementation process, combined with specific examples, the design DML triggers supervision of finance staff a variety of business operations including insert, delete and update records. Analyse the trigger design of the basic steps and optimize the design,to use the audittable records all the change data. It reflects the trigger application in improving system performance,maintaining database integrity, validity of the powerful function.
出处
《计算机技术与发展》
2012年第6期229-233,共5页
Computer Technology and Development
基金
国家自然科学基金项目(61070202)
山东省高等学校优秀青年教师国内访问学者项目
