Trigger

Trigger : A software device that monitors the values of one or more data elements to detect critical events. A trigger consists of three components : a procedure to check data whenever it changes, a set or range of criterion values or code to determine data integrity or whether a response in called for, and one or more procedures that produce the appropriate response.

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 13-Feb-2009 11:07

---

These advertisers support this free service

---

Trigger - A trigger is a special form of stored procedure that goes into effect when you insert, delete, or update a specified table or column. Triggers can be used to enforce referential integrity.

[Category=Data Governance ]

Source: The Data Governance Institute, 28 December 2009 13:23:14, http://www.datagovernance.com/glossary-governance/

---

trigger - A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm. In a database, a trigger is a set of Structured Query Language (SQL) statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs. A trigger consists of an event (an INSERT, DELETE, or UPDATE statement issued against an associated table) and an action (the related procedure). Triggers are used to preserve data integrity by checking on or changing data in a consistent manner.

Related glossary terms: library

[Category=Data Management ]

Source: WhatIs.com, 13 September 2013 09:27:35, http://whatis.techtarget.com/glossary/Data-and-Data-Management