Active Rule Termination Analysis: An Implementation and Evaluation of the Refined Triggering Graph Method

This paper describes the implementation of the Refined Triggering Graph (RTG) method for active rule termination analysis and provides an evaluation of the approach based on the application of the method to a sample active application. The RTG method has been defined in the context of an active-deductive, object-oriented database language known as CDOL (Comprehensive, Declarative, Object Language). The RTG method studies the contents of rule pairs and rule cycles in a triggering graph and tests for: (1) the successful unification of one rule's action with another rule's triggering event, and (2) the satisfiability of active rule conditions, asking whether it is possible for the condition of a triggered rule to evaluate to true in the context of the triggering rule's condition. If the analysis can provably demonstrate that one rule cannot trigger another rule, the directed vector connecting the two rules in a basic triggering graph can be removed, thus refining the triggering graph. An important aspect in the implementation of the method is the development of a satisfiability algorithm for CDOL conditions. This paper presents the tool that was developed based on the RTG method, describing how techniques from constraint logic programming are integrated with other techniques for testing the satisfiability of rule triggering conditions. The effectiveness of the approach within the context of a sample application is also addressed.

[1]  Anton Petar Karadimce Termination and confluence of active rules in active object databases , 1997 .

[2]  Sin Yeung Lee,et al.  A Path Removing Technique for Detecting Trigger Termination , 1998, EDBT.

[3]  Jennifer Widom,et al.  Active Database Systems: Triggers and Rules For Advanced Database Processing , 1994 .

[4]  Harry B. Hunt,et al.  Processing Conjunctive Predicates and Queries , 1980, VLDB.

[5]  Amy Sundermier,et al.  Object Deltas in an Active Database Development Environment , 1997, DOOD.

[6]  Jennifer Widom,et al.  An Algebraic Approach to Rule Analysis in Expert Database Systems , 1994, VLDB.

[7]  Jennifer Widom,et al.  Deriving Production Rules for Constraint Maintainance , 1990, VLDB.

[8]  Wei Sun,et al.  Solving satisfiability and implication problems in database systems , 1996, TODS.

[9]  Jennifer Widom,et al.  Behavior of database production rules: termination, confluence, and observable determinism , 1992, SIGMOD '92.

[10]  Suzanne W. Dietrich,et al.  CDOL: A Comprehensive Declarative Object Language , 1997, Data Knowl. Eng..

[11]  Suzanne W. Dietrich,et al.  PEARD: A Prototype Environment for Active Rule Debugging , 1996, Journal of Intelligent Information Systems.

[12]  Lobel Crnogorac,et al.  Abstract Interpretation of Active Rules and its Use in Termination Analysis , 1997, ICDT.

[13]  Jennifer Widom,et al.  Active Database Systems , 1995, Modern Database Systems.

[14]  Elena Baralis,et al.  Design of Active Rule Applications: Issues and Approaches , 1995, DOOD.

[15]  Susan Darling Urban,et al.  Refined triggering graphs: a logic-based approach to termination analysis in an active object-oriented database , 1996, Proceedings of the Twelfth International Conference on Data Engineering.

[16]  Jennifer Widom,et al.  Static analysis techniques for predicting the behavior of active database rules , 1995, TODS.

[17]  Hans-Jürgen Bürckert,et al.  A Resolution Principle for a Logic with Restricted Quantifiers , 1991, Lecture Notes in Computer Science.

[18]  Danilo Montesi,et al.  A transaction transformation approach to active rule processing , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[19]  Seif Haridi,et al.  Efficient Implementation of Unification of Cyclic Structures , 1984, Implementations of Prolog.

[20]  Bernhard Thalheim,et al.  Selected Papers from the Fourth International Workshop on Foundations of Models and Languages for Data and Objects: Modelling Database Dynamics , 1992 .

[21]  Andreas Heuer,et al.  An Algorithm for the Analysis of Termination of Large Trigger Sets in an OODBMS , 1995, ARTDB.

[22]  Suzanne W. Dietrich,et al.  An Implenentation and Evaluation of the Refined Triggering Graph Method for Active Rule Termination Analysis , 1997, Rules in Database Systems.

[23]  Jennifer Widom,et al.  Static Analysis Techniques for Predicting the Behavior of Database Production Rules , 1995 .

[24]  Suzanne W. Dietrich,et al.  On Control Flow Testing of Active Rules in a Declarative Object-Oriented Framework , 1997, Rules in Database Systems.

[25]  Jennifer Widom,et al.  Better Termination Analysis for Active Databases , 1993, Rules in Database Systems.

[26]  Letizia Tanca,et al.  Automatic Rule Generation for Constraint Enforcement in Active Databases , 1993, SEBD.

[27]  Elena Baralis,et al.  Improving Rule Analysis by Means of Triggering and Activation Graphs , 1995, Rules in Database Systems.

[28]  Susan Darling Urban,et al.  Diagnosing Anomalous Rule Behavior in Databases with Integrity Maintenance Production Rules , 1991, FMLDO.

[29]  Jennifer Widom,et al.  The Starburst Rule System , 1996, Active Database Systems: Triggers and Rules For Advanced Database Processing.

[30]  Elena Baralis,et al.  Run-time Detection of Non-Terminating Active Rule Systems , 1995, DOOD.

[31]  Suzanne W. Dietrich,et al.  An Application of Fragmentation Transparency in a Distributed Database System: A Case Study , 1996, J. Syst. Softw..

[32]  Tom Atwood,et al.  Object Database Standard: ODMG-93, Release 1.2 , 1995 .

[33]  Jennifer Widom,et al.  Better Static Rule Analysis for Active Database Systems , 2000 .

[34]  Letizia Tanca,et al.  Active Rule Management in Chimera , 1996, Active Database Systems: Triggers and Rules For Advanced Database Processing.