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