TriGS Debugger - A Tool for Debugging Active Database Behavior1

  • G. Kappel
  • G. Kramler
  • W. Retschitzegger
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2113)


Active database systems represent a powerful means to respond automatically to events that are taking place inside or outside the database. However, one of the main stumbling blocks for their widespread use is the lack of proper tools for the verification of active database behavior. This paper copes with this need by presenting TriGS Debugger, a tool which supports mechanisms for predicting, understanding and manipulating active database behavior. First, TriGS Debugger provides an integrated view of both active and passive behavior by visualizing their interdependencies, thus facilitating preexecution analysis. Second, post-execution analysis is supported by tracing and graphically representing active behavior including composite events and rules which are executed in parallel. Third, TriGS Debugger allows to interactively examine and manipulate the active behavior at run-time.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    ACT-NET Consortium: The Active Database Management System Manifesto: A Rulebase of ADBMS Features. SIGMOD Record Vol. 25, 1996, pp. 40–49Google Scholar
  2. 2.
    Aiken, A., Widom, J., Hellerstein, J.: Behavior of database production rules: Termination, confluence, and observable determinism. SIGMOD Record, Vol. 21, 1992, pp. 59–68CrossRefGoogle Scholar
  3. 3.
    Bailey, J., Dong, G., Ramamohanarao, K.: Decidability and Undecidability Results for the termination problem of active database rules. Proc. of the 17th ACM SIGMOD-SIGACTSIGART Symposium on Principles of Database Systems, Seattle, 1998, pp. 264–273Google Scholar
  4. 4.
    Baralis, E.: Rule Analysis. Norman W. Paton (Ed.): Active Rules in Database Systems. Springer, New York, 1999, pp. 51–67Google Scholar
  5. 5.
    Behrends, H.: Simulation-based Debugging of Active Databases. In Proceedings of the 4th International Workshop on Research Issues in Data Engineering (RIDE)-Active Database Systems, Houston, Texas, IEEE Computer Society Press, 1994, pp. 172–180Google Scholar
  6. 6.
    Berndtsson, M., Mellin, J., Högberg, U.: Visualization of the Composite Event Detection Process. In Paton, N.W. and Griffiths, T. (eds.): International Workshop on User Interfaces to Data Intensive Systems (UIDIS’99). IEEE Computer Society, 1999, pp. 118–127Google Scholar
  7. 7.
    Chakravarthy, S., Tamizuddin, Z., Zhou, J.: A Visualization and Explanation Tool for Debugging ECA Rules in Active Databases. In Sellis, T. (ed.): Proc. of the 2nd Int. Workshop on Rules in Database Systems. Springer LNCS Vol. 985, 1995, pp. 197–212Google Scholar
  8. 8.
    Coupaye, T., Roncancio, C.L., Bruley, C., Larramona, J.: 3D Visualization Of Rule Processing In Active Databases. Proc. of the workshop on New paradigms in information visualization and manipulation, 1998, pp. 39–42Google Scholar
  9. 9.
    Diaz, O., Jaime, A., Paton, N.: DEAR: a DEbugger for Active Rules in an object-oriented context. In Proceedings of the 1st International Workshop on Rules in Database Systems, Workshops in Computing, Springer, 1993, pp. 180–193Google Scholar
  10. 10.
    Fors, T.: Visualization of Rule Behavior in Active Databases. In Proceedings of the IFIP 2.6 3rd Working Conference on Visual Database Systems (VDB-3), 1995, pp. 215–231Google Scholar
  11. 11.
    GemStone Systems Inc.:, 2001
  12. 12.
    Grabner, S., Kranzlmüller, D., Volkert, J.: Debugging parallel programs using ATEMPT. Proceedings of HPCN Europe 95 Conference, Milano, Italy, May, 1995Google Scholar
  13. 13.
    Kappel, G., Rausch-Schott, S., Retschitzegger, W., Sakkinen, M.: A Transaction Model For Handling Composite Events. Proc. of the Int. Workshop of the Moscow ACM SIGMOD Chapter on Advances in Databases and Information Systems (ADBIS), MePhI, Moscow, September, 1996, pp. 116–125Google Scholar
  14. 14.
    Kappel, G., Rausch-Schott, S., Retschitzegger, W.: A Tour on the TriGS Active Database System-Architecture and Implementation. J. Carroll et al (eds.): Proc. of the 1998 ACM Symposium on Applied Computing (SAC). Atlanta, USA, March, 1998, pp. 211–219Google Scholar
  15. 15.
    Kappel, G., Retschitzegger, W.: The TriGS Active Object-Oriented Database System-An Overview. ACM SIGMOD Record, Vol. 27,No. 3, September, 1998, pp. 36–41CrossRefGoogle Scholar
  16. 16.
    Kappel, G., Kramler, G., Retschitzegger, W.: TriGS Debugger-A Tool for Debugging Active Database Behavior. Technical Report 09/00, Dept. of Information Systems, University of Linz, Austria, March, 2000Google Scholar
  17. 17.
    Lang, P., Obermair, W., Kraus, W., Thalhammer, T.: A Graphical Editor for the Conceptual Design of Business Rules. Proc. of the 14th Int. Conference on Data Engineering (ICDE), Orlando, Florida, IEEE Computer Society Press, February, 1998, pp. 599–609Google Scholar
  18. 18.
    Lee, S.Y., Ling, T.W.: Unrolling cycle to decide trigger termination. In Proceedings of the 25th International Conference on Very Large Data Bases, 1999, pp. 483–493Google Scholar
  19. 19.
    Montesi, D., Bagnato, M., Dallera, C.: Termination Analysis in Active Databases. Proceedings of the 1999 International Database Engineering and Applications Symposium (IDEAS’99), Montreal, Canada, August, 1999Google Scholar
  20. 20.
    Obermair, W., Retschitzegger, W., Hirnschall, A., Kramler, G., Mosnik, G.: The AOODB Workbench: An Environment for the Design of Active Object-Oriented Databases. Software Demonstration at the Int. Conference on Extending Database Technology (EDBT 2000), Konstanz, Germany, March, 2000Google Scholar
  21. 21.
    Paton, N.W., Diaz, O.: Active Database Systems. ACM Computing Surveys Vol. 31, 1999, pp. 63–103CrossRefGoogle Scholar
  22. 22.
    W. Retschitzegger: TriGS Developer-A Development Environment for Active Object-Oriented Databases. Proceedings of the 4th World Multiconference on Systemics, Cybernetics and Informatics (SCI’2000) and the 6th International Conference on Information Systems Analysis and Synthesis (ISAS’2000), Orlando, USA, July 23–26, 2000Google Scholar
  23. 23.
    Thomas, I.S. and Jones, A.C.: The GOAD Active Database Event/Rule Tracer. Proc. of the 7th Int. Conference on Database and Expert Systems Applications, Springer LNCS Vol. 1134, 1996, pp. 436–445Google Scholar
  24. 24.
    Vaduva, A., Gatziu, S., Dittrich, K.R.: Investigating Termination in Active Database Systems with Expressive Rule Languages. In Proceedings of the 3rd International Workshop on Rules In Database Systems, Skovde, Sweden, 1997, pp. 149–164Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2001

Authors and Affiliations

  • G. Kappel
    • 1
  • G. Kramler
    • 1
  • W. Retschitzegger
    • 1
  1. 1.Institute of Applied Computer Science, Department of Information Systems (IFS)University of LinzLinzAUSTRIA

Personalised recommendations