Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
ACT-NET Consortium: The Active Database Management System Manifesto: A Rulebase of ADBMS Features. SIGMOD Record Vol. 25, 1996, pp. 40–49
Aiken, A., Widom, J., Hellerstein, J.: Behavior of database production rules: Termination, confluence, and observable determinism. SIGMOD Record, Vol. 21, 1992, pp. 59–68
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–273
Baralis, E.: Rule Analysis. Norman W. Paton (Ed.): Active Rules in Database Systems. Springer, New York, 1999, pp. 51–67
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–180
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–127
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–212
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–42
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–193
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–231
GemStone Systems Inc.: http://www.gemstone.com/products/s/, 2001
Grabner, S., Kranzlmüller, D., Volkert, J.: Debugging parallel programs using ATEMPT. Proceedings of HPCN Europe 95 Conference, Milano, Italy, May, 1995
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–125
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–219
Kappel, G., Retschitzegger, W.: The TriGS Active Object-Oriented Database System-An Overview. ACM SIGMOD Record, Vol. 27,No. 3, September, 1998, pp. 36–41
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, 2000
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–609
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–493
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, 1999
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, 2000
Paton, N.W., Diaz, O.: Active Database Systems. ACM Computing Surveys Vol. 31, 1999, pp. 63–103
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, 2000
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–445
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–164
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2001 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kappel, G., Kramler, G., Retschitzegger, W. (2001). TriGS Debugger - A Tool for Debugging Active Database Behavior1 . In: Mayr, H.C., Lazansky, J., Quirchmayr, G., Vogel, P. (eds) Database and Expert Systems Applications. DEXA 2001. Lecture Notes in Computer Science, vol 2113. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44759-8_41
Download citation
DOI: https://doi.org/10.1007/3-540-44759-8_41
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-42527-4
Online ISBN: 978-3-540-44759-7
eBook Packages: Springer Book Archive