• 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