trigger

(redirected from Database trigger)
Also found in: Dictionary, Thesaurus, Medical, Legal, Wikipedia.

trigger

Machinery a device that releases a spring-loaded mechanism or a similar arrangement

trigger

[′trig·ər]
(computer science)
To execute a jump to the first instruction of a program after the program has been loaded into the computer. Also known as initiate.
(electronics)
To initiate an action, which then continues for a period of time, as by applying a pulse to a trigger circuit.
The pulse used to initiate the action of a trigger circuit.
(ordnance)
A metallic item, part of the firing mechanism of a firearm, designed to release a firing pin by the application of pressure by the finger.

Trigger

Roy Roger’s horse. [TV: “The Roy Rogers Show” in Terrace, II, 260]
See: Horse

trigger

(database)
An action causing the automatic invocation of a procedure, for instance to preserve referential integrity. A triggers goes into effect when a user attempts to modify data with an insert, delete, or update command. A trigger can instruct the system to take any number of actions when a specified change is attempted. By preventing incorrect, unauthorized, or inconsistent changes to data, triggers help maintain the integrity of the database.

[Sybase SQL Server Release 10.0 Transact-SQL User's Guide].

trigger

(1) A mechanism that initiates an action when an event occurs such as reaching a certain time or date or upon receiving some type of input. A trigger generally causes a program routine to be executed.

(2) In a database management system (DBMS), a trigger is an SQL procedure that is executed when a record is added or deleted. It is used to maintain referential integrity in the database. A trigger may also execute a stored procedure. Triggers and stored procedures are built into DBMSs used in client/server environments. See intelligent database.

(3) A condition that initiates the harmful effects of a logic bomb such as many viruses and worms. Many forms of malicious software use particular dates as triggers. Some viruses count the number of infections and trigger their payloads at a specific number.
References in periodicals archive ?
The access managers perform operations on the data on behalf of applications, including simple retrieval and update operations, complex searches, and support for persistent queries that function as database triggers.
Teradata has also enhanced the flexibility of using join indexes along with database triggers to further improve query performance, which is especially important for time-sensitive front-line workloads.
New database integration capabilities that monitor and automate database processing with full support for database triggers, stored procedures, and SQL queries.
Traditional data auditing means - application modification, database triggers, and packet sniffing - are costly, incomplete, and introduce risk.
The new version also adds intelligent event reduction with advanced procedural language and database triggers to allow for batch processing and more complex data manipulations, which facilitate a solid foundation for advanced business service management and service quality management.

Full browser ?