Abstract
One of the obstacles that hinder trigger systems from their wide deployment is the lack of tools that aid users to create 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 language as SQL3. In this paper, we propose TBE (Trigger-By-Example) to remedy such problems in writing trigger rules by using QBE (Query-ByExample) ideas. TBE is a graphical trigger rule specification language and system to help 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.
This research is supported in part by DARPA contract No. N66001-97-C-8601 and SBIRF 30602-99-C-0106.
Chapter PDF
Similar content being viewed by others
References
Agrawal, R. and Gehani, N. (1989) Ode (Object Database and Environment): The Language and the Data Model, Proc. SIGMOD.
Codd, E. F. (1972) Relational Completeness of Data Base Languages,Data Base Systems, Courant Computer Symposia Series, Prentice Hall, 6: 65–98.
Collet, C. and Brunel, E. (1992) Definition and Manipulation of Forms with F02, Proc. IFIP Visual Database Systems.
Chang, Y.-I. and Chen, F.-L. (1997) RBE: A Rule-by-example ActionDatabase System, Software–Practice and Experience, 27 (4): 365–394.
Ceri, S., et al (1996) Active Rule Management in Chimera, In J. Widomand S. Ceri (ed.) Active Database Systems: Triggers and Rules for Active Database Processing, Morgan Kaufmann.
Cochrane, R., Pirahesh, H. and Mattos, N. (1996) Integrating Triggers and Declarative Constraints in SQL Database Systems, Proc. VLDB.
Embley, D. W. (1989) NFQL: The Natural Forms Query Language, ACM TODS, 14 (2): 168–211.
Embury, S. M. and Gray, P. M. D. (1998) Database Internal Applications, In N. W. Paton (ed.), Active Rules In Database Systems, Springer-Verlag.
Gatziu, S. and Dittrich, K. R. (1998) SAMOS, In N. W. Paton (ed.), Active Rules In Database Systems, Springer-Verlag.
Lee, D., Mao, W. and Chu, W. W. (1999) TBE: Trigger-By-Example
UCLA-CS-TR-990029McLeod, D. (1976) The Translation and Compatibility of SEQUEL and
Query by Example, Proc. Int’l Conf. Software Engineering,CA. Melton, J. (ed.) (1999) (ANSI/ISO Working Draft) SQL/Foundation,ANSI X3H2–99–079/WG3: YGJ–011,March.
Paton, N. W. (ed.) (1998) Active Rules in Database Systems, Springer-Verlag.
Simon, E. and Kotz-Dittrich, A. (1995) Promises and Realities of Active Database Systems, Proc. VLDB.
Teisseire, M., et al. (1994) Towards Event-Driven Modelling for Database Design, Proc. VLDB.
Zloof, M. M. (1977) Query-by-Example: a data base language, IBM System J., 16 (4): 342–343.
Zaniolo, C., et al. (1997) Advanced Database Systems, Morgan Kaufmann.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer Science+Business Media New York
About this chapter
Cite this chapter
Lee, D., Mao, W., Chiu, H., Chu, W.W. (2000). TBE: A Graphical Interface for Writing Trigger Rules in Active Databases. In: Arisawa, H., Catarci, T. (eds) Advances in Visual Information Management. VDB 2000. IFIP — The International Federation for Information Processing, vol 40. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-35504-7_23
Download citation
DOI: https://doi.org/10.1007/978-0-387-35504-7_23
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4757-4457-6
Online ISBN: 978-0-387-35504-7
eBook Packages: Springer Book Archive