Abstract
TBE (Trigger-By-Example) is proposed to assist users in writing trigger rules. TBE is a graphical trigger rule specification language and system to help users understand and specify active database triggers. Since TBE borrowed its basic idea from QBE, it retained many benefits of QBE while extending the features to support triggers. Hence, TBE is a useful tool for novice users to create simple trigger rules easily. Further, since TBE is designed to insulate the details of underlying trigger systems from users, it can be used as a universal trigger interface for rule formation.
This research is supported in part by DARPA contract No. N66001-97-C-8601 and SBIR F30602-99-C-0106.
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
Agrawal, R., Gehani, N. “Ode (Object Database and Environment): The Language and the Data Model”, Proc. SIGMOD, Portland, Oregon, 1989.
Codd, E. F. “Relational Completeness of Data Base Languages”, Data Base Systems, Courant Computer Symposia Series, Prentice-Hall, 6:65–98, 1972.
Collet, C., Brunel, E. “Definition and Manipulation of Forms with FO2”, Proc. IFIP Visual Database Systems, 1992.
Chang, Y.-I., Chen, F.-L. “RBE: A Rule-by-example Action Database System”, Software-Practice and Experience, 27(4):365–394, 1997.
Ceri, S., Fraternali, P., Paraboschi, S., Tanca, L. “Active Rule Management in Chimera”, In J. Widom and S. Ceri (ed.), Active Database Systems: Triggers and Rules for Active Database Processing, Morgan Kaufmann, 1996.
Cochrane, R., Pirahesh, H., Mattos, N. “Integrating Triggers and Declarative Constraints in SQL Database Systems”, Proc. VLDB, 1996.
Embley, D. W. “NFQL: The Natural Forms Query Language”, ACM TODS, 14(2):168–211, 1989.
Embury, S. M., Gray, P. M. D. “Database Internal Applications”, In N. W. Paton (ed.), Active Rules In Database Systems, Springer-Verlag, 1998.
Gatziu, S., Dittrich, K. R. “SAMOS”, In N. W. Paton (ed.), Active Rules In Database Systems, Springer-Verlag, 1998.
Lee, D., Mao, W., Chiu, H., Chu, W. W. “TBE: A Graphical Interface for Writing Trigger Rules in Active Databases”, 5th IFIP 2.6 Working Conf. on Visual Database Systems (VDB), 2000.
Lee, D., Mao, W., Chu, W. W. “TBE: Trigger-By-Example (Extended Version)”, UCLA-CS-TR-990029, 1999. http://www.cs.ucla.edu/_dongwon/paper/
McLeod, D. “The Translation and Compatibility of SEQUEL and Query by Example”, Proc. Int’l Conf. Software Engineering, San Francisco, CA, 1976.
Melton, J. (ed.), “(ANSI/ISO Working Draft) Foundation (SQL/Foundation)”, ANSI X3H2-99-079/WG3:YGJ-011, March, 1999. ftp://jerry.ece.umassd.edu/isowg3/dbl/BASEdocs/public/sql-foundation-wd-1999-03.pdf
Paton, N. W. (ed.), “Active Rules in Database Systems”, Springer-Verlag, 1998.
Simon, E., Kotz-Dittrich, A. “Promises and Realities of Active Database Systems”, Proc. VLDB 1995.
Teisseire, M., Poncelet, P., Cichetti, R. “Towards Event-Driven Modelling for Database Design”, Proc. VLDB, 1994.
Zloof, M. M. “Query-by-Example: a data base language”, IBM System J., 16(4):342–343, 1977.
Zaniolo, C., Ceri, S., Faloutsos, C., Snodgrass, R. R., Subrahmanian, V.S., Zicari, R. “Advanced Database Systems”, Morgan Kaufmann, 1997.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lee, D., Mao, W., Chu, W.W. (2000). TBE: Trigger-By-Example. In: Laender, A.H.F., Liddle, S.W., Storey, V.C. (eds) Conceptual Modeling — ER 2000. ER 2000. Lecture Notes in Computer Science, vol 1920. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45393-8_9
Download citation
DOI: https://doi.org/10.1007/3-540-45393-8_9
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-41072-0
Online ISBN: 978-3-540-45393-2
eBook Packages: Springer Book Archive