An algebraic approach to static analysis of active database rules

• Published in: ACM transactions on database systems Vol. 25; no. 3; pp. 269 - 332
• Main Authors: Baralis, Elena, Widom, Jennifer
• Format: Journal Article
• Language: English
• Published: New York, NY, USA ACM 01.09.2000; Association for Computing Machinery, Inc; Association for Computing Machinery
• Subjects: Data base management systems; Data management systems; Database design; Database management system engines; Database query languages (principles); Database theory; Design and construction; Functions, Algebraic; Information systems; Methods; Query languages; Statistical analysis; Theory and algorithms for application domains; Theory of computation; Triggers and rules; United States; termination; database rule processing; confluence; database trigger processing; active database systems
• ISSN: 0362-5915; 1557-4644
• DOI: 10.1145/363951.363954

Rules in active database systems can be very difficult to program due to the unstructured and unpredictable nature of rule processing. We provide static analysis techniques for predicting whether a given rule set is guaranteed to terminate and whether rule execution is confluent (guaranteed to have a unique final state). Our methods are based on previous techniques for analyzing rules in active database systems. We improve considerably on the previous techniques by providing analysis criteria that are much less conservative: our methods often determine that a rule set will terminate or is confluent when previous methods could not make this determination. Our improved analysis is based on a "propagation" algorithm, which uses an extended relational algebra to accurately determine when the action of one rule can affect the condition of another, and determine when rule actions commute. We consider both conditon-action rules and event-condition-action-rules, making our approach widely applicable to relational active database rule languages and to the trigger language in the SQL:1999 standard.