Share
Explore BrainMass

Triggers & Operational Data

Briefly describe three types of triggers. What is a stored procedure? How do they differ?

Why is operational data sometimes unusable for Business Intelligence use?

Solution Preview

Briefly describe three types of triggers. What is a stored procedure? How do they differ?
Three types of triggers include insert triggers, update triggers, and delete triggers. A trigger is a "stored procedure that may be configured to automatically execute (or "fire" in tech lingo) when certain events take place" (Chapple, 2012). To create a basic trigger, the trigger command is used as a trigger statement. The specific details of the trigger to be executed are then added to the trigger statement, which is the insert, update, or delete. The details inserted after the trigger tell the trigger when to execute or fire. Triggers are very useful and they are relatively simple to use, which makes their use ideal for novice programmers. An ideal use for a trigger would be if we wanted an email generated after a specific action took place, like a name was removed from our system. The following statement would be used: CREATE TRIGGER NameAdded ON NameList AFTER DELETE AS EXEC xp_sendmail [email address removed by system]. The system would then generate an automated ...

Solution Summary

The solution provides a detailed discussion for the following two data communications questions:

Briefly describe three types of triggers. What is a stored procedure? How do they differ?
Why is operational data sometimes unusable for Business Intelligence use?

$2.19