{"title":"你的触发规则是否正确?","authors":"Sin Yeung Lee, T. Ling","doi":"10.1109/DEXA.1998.707502","DOIUrl":null,"url":null,"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.","PeriodicalId":194923,"journal":{"name":"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)","volume":"93 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1998-08-26","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"2","resultStr":"{\"title\":\"Are your trigger rules correct?\",\"authors\":\"Sin Yeung Lee, T. Ling\",\"doi\":\"10.1109/DEXA.1998.707502\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":194923,\"journal\":{\"name\":\"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)\",\"volume\":\"93 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1998-08-26\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"2\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/DEXA.1998.707502\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/DEXA.1998.707502","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
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.