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.