Abstract
One of the obstacles that hinder database trigger systems from their wide deployment is the lack of tools that aid users in creating trigger rules. Similar to understanding and specifying database queries in SQL3, it is difficult to visualize the meaning of trigger rules. Furthermore, it is even more difficult to write trigger rules using such text-based trigger rule languages as SQL3. In this paper, we propose TBE (Trigger-By-Example) to remedy such problems in writing trigger rules visually by using QBE (Query-By-Example) ideas. TBE is a visual trigger rule composition system that helps the users understand and specify active database triggers. TBE retains benefits of QBE while extending features to support triggers. Hence, TBE is a useful tool for novice users to create simple triggers in a visual and intuitive manner. Further, since TBE is designed to hide the details of underlying trigger systems from users, it can be used as a universal trigger interface.
Similar content being viewed by others
References
Agrawal R, Gehani N (1989) Ode (Object Database and Environment): The Language and the Data Model. ACM SIGMOD. Portland, OR
Benzi F, Maio D, Rizzi S (1999) VISIONARY: a Viewpoint-Based Visual Language for Querying Relational Databases. J Vis Lang Comput 10(2):117–145
Ceri S, Fraternali P, Paraboschi S, Tanca L (1996) Active Rule Management in Chimera. In Active Database Systems: Triggers and Rules for Active Database Processing, Morgan Kaufmann, pp 151–176
Chang Y-I, Chen F-L (1997) RBE: A Rule-by-example Action Database System. Softw Pract Exp 27:365–394
Cochrane R, Pirahesh H, Mattos N (1996) Integrating Triggers and Declarative Constraints in SQL Database Systems. VLDB. Mumbai (Bombay), India
Codd EF (1972) Relational Completeness Of Data Base Languages. Data Base Systems, Courant Computer Symposia Serie 6:65–98
Collet C, Brunel E (1992) Definition and Manipulation of Forms with FO2. IFIP Working Conf on Vis Database Syst (VDB)
Embley DW (1989) NFQL: The Natural Forms Query Language. ACM Trans Database Syst 14(2):168–211
Gatziu S, Dittrich KR (1998) SAMOS. In Active Rules In Database Syst, Springer, Berlin Heidelberg New York, pp 233–248
Lee D, Mao W, Chiu H, Chu WW (2000a) TBE: A Graphical Interface for Writing Trigger Rules in Active Databases. IFIP Working Conf on Vis Database Syst (VDB). Fukuoka, Japan
Lee D, Mao W, Chu WW (2000b) TBE: Trigger-By-Example. Int Conf on Conceptual Modeling (ER). Salt Lake City, UT
McLeod D (1976) The Translation and Compatibility of SEQUEL and Query by Example. Int Conf on Softw Eng (ICSE). San Francisco, CA
Melton J (ed) (1999) ANSI/ISO Working Draft) Foundation (SQL/Foundation). Tech rep, ANSI X3H2-99-079/WG3:YGJ-011, ftp://jerry.ece.umassd.edu/isowg3/dbl/BASEdocs/public/sql-foundation-wd-1999-03.pdf
Paton NW (ed) (1998) Active Rules in Database Systems. Springer, Berlin Heidelberg New York
Simon E, Kotz-Dittrich A (1995) Promises and Realities of Active Database Systems. VLDB. Zurich, Switzerland
Teisseire M, Poncelet P, Cichetti R (1994) Towards Event-Driven Modelling for Database Design. VLDB. Santiago de Chile, Chile
Yao SB, Hevner AR, Shi Z, Luo D (1984) FORMANAGER: An Office Forms Management System. ACM Trans Inf Syst 2(3):235–262
Zloof MM (1977) Query-by-Example: a data base language. IBM Syst J 16(4):342–343
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Lee, D., Mao, W., Chiu, H. et al. Designing Triggers with Trigger-By-Example. Know. Inf. Sys. 7, 110–134 (2005). https://doi.org/10.1007/s10115-003-0126-5
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10115-003-0126-5