Submitted by: Submitted by sobah
Views: 243
Words: 2055
Pages: 9
Category: Science and Technology
Date Submitted: 08/08/2012 01:31 AM
2010 2nd International Conference on Education Technology and Computer (ICETC)
Dynamically Maintain The Teaching Examples of Triggers and Stored Procedures about The Course of Database Application
WuDa-sheng
School of Information Engineering Zhejiang Forestry University Lin'an 3113OO,Zhejiang, China e-mail: wu62390710@263.net
Wu Sheng-yu
Hangzhou ZhiYuan Electrical Co., Ltd. Hangzhou 310013 e-mail: wsyll14@163.com
Abstract-Triggers
and
stored
procedures
have
an
irreplaceable importance in the teaching process about the course of database application, as them can realized a complex program logic and can test student's comprehensive application ability to SQL languages. At present, all kinds of management platforms of DBMS (such as the Enterprise Management) are still some inconvenient aspects: when the users want to input the description information of triggers and stored procedure, Enterprise Management appeared to be inadequate; when users want to track the modified-process of triggers and stored procedures, feature; in particular, EM EM did not provide such a manages to triggers with
by user, so that it execute faste than a single SQL statement[1,5,6]. Trigger is a special kind of stored procedure, the trigger will become effective when data is modified using the following one or more data modification operations in the specified table: UPDATE, INSERT, or DELETE. The trigger has the following advantages: Triggers are self executing, they were activated immediately after the data were changed on the table; the associated table can be related updated in the database through the triggers; triggers can enforce restrictions which are more complex than CHECK constraints, and compared with the check constraints, the triggers can reference columns from other tables[2,3,4]. Triggers and stored procedures can contain variables defined, cursors, statement's block which is composed of the data defmition language, data manipulation language,...