TBE (Trigger-By-Example)

[ Last Updated at 07/1/2000 01:06 AM ]

since 12/11/1999

Welcome to the home page for TBE (Trigger-By-Example) Project @ CoBase research group.

Research Areas

Active Database, Visual Query Interface

Overview

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.

Members

Wesley W. Chu
: Principal Investigator
Dongwon Lee
: Ph.D Student
Wenlei Mao
: Ph.D Student
Henry Chiu
: M.S. Student

Publications

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)

Screen Dump

tbe.jpg (83883 bytes)