Welcome to the home page for TBE (Trigger-By-Example) Project @ CoBase research group.
Active Database, Visual Query Interface
Triggers have been adopted as a part of the important
database features and implemented by most major database
vendors. Despite its diverse potential usages, one of the obstacles
that hinder the triggers from its wide deployment is the lack of tools
to aid users to create complex trigger rules in a simple
manner. Although the majority of the users of triggers are DBAs or
savvy end-users, writing trigger rules is still a daunting task.
On the other hand, QBE (Query-By-Example) has been very popular as a user interface for creating queries in an interactive and intuitive manner since its introduction decades ago. It is being used in most modern database products in its disguised form. Since its underlying theory is based on the relational calculus, its expressive power is proved to be equivalent to that of SQL. Therefore, it is an ideal tool for novice users to create simple queries in visual fashion. At the same time, expert users do not have to compromise anything because QBE supports full capability to create complex queries.
In the TBE project, we propose a novel user interface for creating trigger rules, by marrying the triggers and QBE in a seamless fashion. The visual nature of the TBE makes writing trigger rules much easier. We show how trigger rules in the emerging SQL standard (SQL3) can be represented using the TBE with minimal introduction of new constructs. Further, an algorithm to translate from the TBE to the SQL3 triggers is developed and illustrated along with examples. Finally, a preliminary implementation of the TBE is presented as a proof of the concept.
|: Principal Investigator|
|: Ph.D Student|
|: Ph.D Student|
|: M.S. Student|
|Dongwon Lee, Wenlei Mao, Henry Chiu, Wesley W. Chu, |
"TBE: The Graphical Interface for Writing Trigger Rules in Active Databases",
Proc. 5th IFIP 2.6 Working Conf. on Visual Database Systems (VDB), Fukuoka, Japan, May, 2000 (ps, pdf), UCLA CS-TR 990041 (ps, pdf)
|Dongwon Lee, Wenlei Mao, Wesley W. Chu, "TBE: Trigger-By-Example",
Proc. 19th Int'l Conf. on Conceptual Modeling (ER), Salt Lake City, Utah, October, 2000 (ps, pdf), UCLA CS-TR 990029, 1999. (ps, pdf)