Triggers & Operational Data
Not what you're looking for?
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?
Purchase this Solution
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?
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 ...
Purchase this Solution
Free BrainMass Quizzes
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.