Designing triggers with Trigger-By-Example

Dongwon Lee, Wenlei Mao, Henry Chiu, Wesley W. Chu

Research output: Contribution to journalArticle

6 Citations (Scopus)

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.

Original languageEnglish (US)
Pages (from-to)110-134
Number of pages25
JournalKnowledge and Information Systems
Volume7
Issue number1
DOIs
StatePublished - Jan 1 2005

Fingerprint

Chemical analysis

All Science Journal Classification (ASJC) codes

  • Software
  • Information Systems
  • Human-Computer Interaction
  • Hardware and Architecture
  • Artificial Intelligence

Cite this

Lee, Dongwon ; Mao, Wenlei ; Chiu, Henry ; Chu, Wesley W. / Designing triggers with Trigger-By-Example. In: Knowledge and Information Systems. 2005 ; Vol. 7, No. 1. pp. 110-134.
@article{5b83891be65f49eeb2724777b6f9c1e1,
title = "Designing triggers with Trigger-By-Example",
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.",
author = "Dongwon Lee and Wenlei Mao and Henry Chiu and Chu, {Wesley W.}",
year = "2005",
month = "1",
day = "1",
doi = "10.1007/s10115-003-0126-5",
language = "English (US)",
volume = "7",
pages = "110--134",
journal = "Knowledge and Information Systems",
issn = "0219-1377",
publisher = "Springer London",
number = "1",

}

Designing triggers with Trigger-By-Example. / Lee, Dongwon; Mao, Wenlei; Chiu, Henry; Chu, Wesley W.

In: Knowledge and Information Systems, Vol. 7, No. 1, 01.01.2005, p. 110-134.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Designing triggers with Trigger-By-Example

AU - Lee, Dongwon

AU - Mao, Wenlei

AU - Chiu, Henry

AU - Chu, Wesley W.

PY - 2005/1/1

Y1 - 2005/1/1

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

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

UR - http://www.scopus.com/inward/record.url?scp=20344396631&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=20344396631&partnerID=8YFLogxK

U2 - 10.1007/s10115-003-0126-5

DO - 10.1007/s10115-003-0126-5

M3 - Article

AN - SCOPUS:20344396631

VL - 7

SP - 110

EP - 134

JO - Knowledge and Information Systems

JF - Knowledge and Information Systems

SN - 0219-1377

IS - 1

ER -