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
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;
Conference_Titel :
Database and Expert Systems Applications, 1998. Proceedings. Ninth International Workshop on
Conference_Location :
Vienna
Print_ISBN :
0-8186-8353-8
DOI :
10.1109/DEXA.1998.707502