基于网络数据库的存储过程和触发器应用研究  

On Application of Stored Procedure and trigger in Network Database

作　　者：沈黎[1] 

机构地区：[1]四川民族学院计算机科学系,四川康定626001

出　　处：《西南师范大学学报（自然科学版）》2016年第3期51-55,共5页Journal of Southwest China Normal University(Natural Science Edition)

基　　金：2014年四川民族学院自然科学基金项目(XYZB14002)

摘　　要：以成都市西南书城会员购书管理系统为例,针对该系统存在的不足,分析了存储过程和触发器的特征,最终提出了基于存储过程和触发器技术的解决方案.实践表明存储过程和触发器技术在网络数据库应用中能提高数据库的运行效率和解决数据库中较为复杂的业务规则.To Illustrate the disadvantages of the system based on the example of the member management system of South-West Book Store in Chengdu,the functions of stored procedure has been analyzed in this paper,and trigger proposed.Finally,the solution based on storage process and trigger technology has been put forward.Experience shows that stored procedure and trigger can improve the running efficiency of databases and can cope with the complicated business rules.

关 键 词：存储过程 触发器 会员管理系统 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]