Designing Triggers with Trigger-By-Example

Authors:
Dongwon Lee;Wenlei Mao;Henry Chiu;Wesley W. Chu
Affiliations:
Penn State University, School of Information Sciences and Technology, 16802, PA, USA;University of California at Los Angeles, Department of Computer Science, 16802, CA, USA;IBM Silicon Valley Lab, Department of Computer Science, 16802, CA, USA;University of California at Los Angeles, Department of Computer Science, 16802, CA, USA
Venue:
Knowledge and Information Systems
Year:
2005

Citing 12
Cited 0

NFQL: the natural forms query language

ACM Transactions on Database Systems (TODS)
ODE (Object Database and Environment): the language and the data model

SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
RBE: a rule-by-example active database system

Software—Practice & Experience
FORMANAGER: an office forms management system

ACM Transactions on Information Systems (TOIS)
Active Rules in Database Systems

Active Rules in Database Systems
Towards Event-Driven Modelling for Database Design

VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Promises and Realities of Active Database Systems

VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Integrating Triggers and Declarative Constraints in SQL Database Sytems

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Definition and Manipulation of Forms with FO2

Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II
TBE: A Graphical Interface for Writing Trigger Rules in Active Databases

VDB 5 Proceedings of the Fifth Working Conference on Visual Database Systems: Advances in Visual Information Management
The translation and compatibility of SEQUEL and Query by Example

ICSE '76 Proceedings of the 2nd international conference on Software engineering
TBE: Trigger-By-Example

ER'00 Proceedings of the 19th international conference on Conceptual modeling

Quantified Score

Hi-index	0.00

Visualization

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 languages 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.