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 new release offers SQL-standard database triggers, enhanced developer tools, improved performance, and multi-byte character support for international languages, through compliance with the Unicode standard.
Traditional data auditing means - application modification, database triggers, and packet sniffing - are costly, incomplete, and introduce risk.
Using database triggers solves the two problems inherent in the sampling model: inaccurate information, and bandwidth demands that impact system performance.
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.
Database Triggers that automatically call stored procedures before data is either entered or deleted from the database;
0 provides a comprehensive alternative to more traditional and less comprehensive means for data auditing, such as database triggers, which are expensive and difficult to create and manage, or costly and time-consuming application modifications.

Full browser ?