Reference no: EM132430937

Problem: Working With Database Views, Triggers, Functions, and Procedures

Databases become larger every year. As the size and user access of databases increase, performance and the user experience become more and more critical. Improving these items requires a DBA who is familiar with the content of the database, how the database is accessed, and the various tools available to improve the overall system operation.

Assume you are the DBA in charge of a large corporate database. As you saw in the previous discussion in this unit, indexes are the first consideration when tuning the database and providing faster user access. However, views, triggers, functions, and procedures can all play a role in improving both performance and the user experience.

• Comparing views, triggers, functions, and procedures, list at least one similarity in how they are created or used and at least one difference.
• Upon reviewing recent user access of the database, you find that users are accessing the same set of data items regularly. You want to simplify the process for users. How will you determine if the creation of views, triggers, functions, or procedures is most appropriate to simplify user access and possibly improve overall database performance when retrieving the data items?