Advertisement

TBE: Trigger-By-Example

  • Dongwon Lee
  • Wenlei Mao
  • Wesley W. Chu
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1920)

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.

Keywords

Active Rule Leftmost Column Active Database Relational Calculus Trigger Rule 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [1]
    Agrawal, R., Gehani, N. “Ode (Object Database and Environment): The Language and the Data Model”, Proc. SIGMOD, Portland, Oregon, 1989.Google Scholar
  2. [2]
    Codd, E. F. “Relational Completeness of Data Base Languages”, Data Base Systems, Courant Computer Symposia Series, Prentice-Hall, 6:65–98, 1972.Google Scholar
  3. [3]
    Collet, C., Brunel, E. “Definition and Manipulation of Forms with FO2”, Proc. IFIP Visual Database Systems, 1992.Google Scholar
  4. [4]
    Chang, Y.-I., Chen, F.-L. “RBE: A Rule-by-example Action Database System”, Software-Practice and Experience, 27(4):365–394, 1997.CrossRefMathSciNetGoogle Scholar
  5. [5]
    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.Google Scholar
  6. [6]
    Cochrane, R., Pirahesh, H., Mattos, N. “Integrating Triggers and Declarative Constraints in SQL Database Systems”, Proc. VLDB, 1996.Google Scholar
  7. [7]
    Embley, D. W. “NFQL: The Natural Forms Query Language”, ACM TODS, 14(2):168–211, 1989.CrossRefGoogle Scholar
  8. [8]
    Embury, S. M., Gray, P. M. D. “Database Internal Applications”, In N. W. Paton (ed.), Active Rules In Database Systems, Springer-Verlag, 1998.Google Scholar
  9. [9]
    Gatziu, S., Dittrich, K. R. “SAMOS”, In N. W. Paton (ed.), Active Rules In Database Systems, Springer-Verlag, 1998.Google Scholar
  10. [10]
    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.Google Scholar
  11. [11]
    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/
  12. [12]
    McLeod, D. “The Translation and Compatibility of SEQUEL and Query by Example”, Proc. Int’l Conf. Software Engineering, San Francisco, CA, 1976.Google Scholar
  13. [13]
    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
  14. [14]
    Paton, N. W. (ed.), “Active Rules in Database Systems”, Springer-Verlag, 1998.Google Scholar
  15. [15]
    Simon, E., Kotz-Dittrich, A. “Promises and Realities of Active Database Systems”, Proc. VLDB 1995.Google Scholar
  16. [16]
    Teisseire, M., Poncelet, P., Cichetti, R. “Towards Event-Driven Modelling for Database Design”, Proc. VLDB, 1994.Google Scholar
  17. [17]
    Zloof, M. M. “Query-by-Example: a data base language”, IBM System J., 16(4):342–343, 1977.Google Scholar
  18. [18]
    Zaniolo, C., Ceri, S., Faloutsos, C., Snodgrass, R. R., Subrahmanian, V.S., Zicari, R. “Advanced Database Systems”, Morgan Kaufmann, 1997.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2000

Authors and Affiliations

  • Dongwon Lee
    • 1
  • Wenlei Mao
    • 1
  • Wesley W. Chu
    • 1
  1. 1.Department of Computer ScienceUniversity of California, Los AngelesLos AngelesUSA

Personalised recommendations