DocumentCode :
2287099
Title :
Are your trigger rules correct?
Author :
Lee, Sin-Yeung ; Ling, Tok-Wang
Author_Institution :
Dept. of Inf. Syst. & Comput. Sci., Nat. Univ. of Singapore, Singapore
fYear :
1998
fDate :
25-28 Aug 1998
Firstpage :
837
Lastpage :
842
Abstract :
Triggers can be used to enforce integrity constraints. Users need only to specify some trigger rules to execute some amendment actions if an update violates a constraint. Rules may be written incorrectly, however it is hard to verify the rule correctness. We first propose the restoring condition to detect when the trigger rules can restore the validity of a given constraint after an update. Finally, we investigate the combined effect of the restoring conditions and propose a method to confirm which constraint may not be enforced correctly by the given trigger rules
Keywords :
active databases; data integrity; database theory; relational databases; active databases; amendment actions; integrity constraints; relational database; restoring conditions; rule correctness verification; trigger rules; update; Computer science; Condition monitoring; EMP radiation effects; Electrical capacitance tomography; Identity management systems; Information systems; Prototypes; Relational databases; Remuneration; Testing;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Database and Expert Systems Applications, 1998. Proceedings. Ninth International Workshop on
Conference_Location :
Vienna
Print_ISBN :
0-8186-8353-8
Type :
conf
DOI :
10.1109/DEXA.1998.707502
Filename :
707502
Link To Document :
بازگشت