RBE: A Rule-by-example Active Database System

One of the obstacles that hinder trigger systems from their wide deployment is the lack of tools that aid users to create trigger rules. Similar to understanding and specifying database queries in SQL3, it is difficult to visualize the meaning of trigger rules. Furthermore, it is even more difficult to write trigger rules using such text-based trigger rule language as SQL3. In this paper, we propose TBE (Trigger-By-Example) to remedy such problems in writing trigger rules by using QBE (Query-ByExample) ideas. TBE is a graphical trigger rule specification language and system to help the users understand and specify active database triggers. TBE retains benefits of QBE while extending features to support triggers. Hence, TBE is a useful tool for novice users to create simple triggers in a visual and intuitive manner. Further, since TBE is designed to hide the details of underlying trigger systems from users, it can be used as a universal trigger interface.

show abstract

Designing Triggers with Trigger-By-Example

Lee

Mao

Chiu

et al. 2005

Know. Inf. Sys.

View full text Add to dashboard Cite

Abstract. One of the obstacles that hinder database trigger systems from their wide deployment is the lack of tools that aid users in creating trigger rules. Similar to understanding and specifying database queries in SQL3, it is difficult to visualize the meaning of trigger rules. Furthermore, it is even more difficult to write trigger rules using such text-based trigger rule language as SQL3. In this paper, we propose TBE (Trigger-By-Example) to remedy such problems in writing trigger rules visually by using QBE (Query-By-Example) ideas. TBE is a visual trigger rule composition system that helps the users understand and specify active database triggers. TBE retains benefits of QBE while extending features to support triggers. Hence, TBE is a useful tool for novice users to create simple triggers in a visual and intuitive manner. Further, since TBE is designed to hide the details of underlying trigger systems from users, it can be used as a universal trigger interface.

show abstract

RBE: A Rule-by-example Active Database System

Cited by 3 publications

References 33 publications

TBE: Trigger-By-Example

TBE: Trigger-By-Example

TBE: A Graphical Interface for Writing Trigger Rules in Active Databases

Designing Triggers with Trigger-By-Example

Contact Info

Product

Resources

About