RIDS 1995: Rules in Database Systems pp 197-209 | Cite as
A visualization and explanation tool for debugging ECA rules in active databases
Abstract
Using ECA rules in active database systems for real-life applications involves implementing, debugging, and maintaining large numbers of rules. Experience in developing large production rule systems has amply demonstrated the need for understanding the behavior of rules especially when their execution is non-deterministic. Availability of rules in active database systems and their semantics creates additional complexity for both modeling and verifying the correctness of such systems. As part of Sentinel — an Object-Oriented Active DBMS, we have developed a visualization tool to help understand the behavior of rules defined as part of an active database application. This is especially important in active databases as rules are invoked (as a side effect) based on event occurrences (both primitive and composite) and are executed concurrently based on user-provided priority information. In this paper, we describe the rationale for the development of the tool, how it has been implemented exploiting the architecture of Sentinel, functionality of the resulting tool, and show several screen dumps to provide a feel for the information presented by the visualization tool.
Keywords
Visualization Tool Composite Event Event Object Database Object Active DatabasePreview
Unable to display preview. Download preview PDF.
References
- [AMC93]E. Anwar, L. Maugis, and S. Chakravarthy. A New Perspective on Rule Support for Object-Oriented Databases. In Proceedings, International Conference on Management of Data, pages 99–108, Washington, D.C., May 1993.Google Scholar
- [AWH92]A. Aiken, J. Widom, and J. M. Hellerstein. Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism. In Proceedings, International Conference on Management of Data, pages 59–68, May 1992.Google Scholar
- [Bad93]R. Badani. Nested Transactions for Concurrent Execution of Rules: Design and Implementation. Master's thesis, Database Systems R&D Center, CIS Department, University of Florida, Gainesville, FL 32611, October 1993.Google Scholar
- [Cha91]S. Chakravarthy. Active Database Management Systems: Requirements, State-Of-The-Art, and an Evaluation. In H. Kangassalo, editor, Entity-Relationship Approach: The Core of Conceptual Modeling, pages 461–473. Elsevier Science Publishers, North-Holland, 1991.Google Scholar
- [CKAK94]S. Chakravarthy, V. Krishnaprasad, E. Anwar, and S.-K. Kim. Composite Events for Active Databases: Semantics, Contexts, and Detection. In Proceedings, International Conference on Very Large Data Bases, pages 606–617, August 1994.Google Scholar
- [CKTB95]S. Chakravarthy, V. Krishnaprasad, Z. Tamizuddin, and R. Badani. ECA Rule Integration into an OODBMS: Architecture and Implementation. In Proceedings, International Conference on Data Engineering, Feb. 1995.Google Scholar
- [CM94]S. Chakravarthy and D. Mishra. Snoop: An Expressive Event Specification Language for Active Databases. Data and Knowledge Engineering, 14(10):1–26, October 1994.Google Scholar
- [DJP93]O. Diaz, A. Jaime, and N. W. Paton. Dear: A debugger for active rules in an object-oriented context. In Proc. of the 1st International Conference on Rules in Database Systems, September 1993.Google Scholar
- [Ins93]Texas Instruments. Open OODB Toolkit, Release 0.2 (Alpha) Document, September 1993.Google Scholar
- [Tam94]Z. Tamizuddin. Rule Execution and Visualization in Active OODBMS. Master's thesis, Database Systems R&D Center, CIS Department, University of Florida, Gainesville, FL 32611, May 1994.Google Scholar
- [WBT92]D. Wells, J. A. Blakeley, and C. W. Thompson. Architecture of an Open Object-Oriented Database Management System. IEEE Computer, 25(10):74–81, October 1992.Google Scholar