Upon completion of this lesson, the successful participant will be able to: Understand the need for and importance of database administration; learn different ways of processing a database; understand the need for concurrency control, security, and backup and recovery; learn typical problems that can occur when multiple users process a database concurrently; understand the use of locking and the problem of deadlock; | Database Administration Chapter Six DAVID M. KROENKE and DAVID J. AUER DATABASE CONCEPTS, 3rd Edition Chapter Objectives Understand the need for and importance of database administration Learn different ways of processing a database Understand the need for concurrency control, security, and backup and recovery Learn typical problems that can occur when multiple users process a database concurrently Understand the use of locking and the problem of deadlock 6- Chapter Objectives (continued) Learn the difference between optimistic and pessimistic locking Know the meaning of ACID transaction Learn the four 1992 ANSI standard isolation levels Understand the need for security and learn a generalized model of database security Know the difference between DBMS and application security Know the difference between recovery via reprocessing and recovery via rollback/rollforward 6- Chapter Objectives (continued) Understand the nature of the tasks required for recovery using rollback/rollforward Know basic administrative and managerial DBA functions Understand distributed database processing Understand the concept of object-relational databases 6- Heather Sweeney Designs: Database Design 6- Heather Sweeney Designs: HSD Database Diagram in SQL Server 2005 6- The Database Processing Environment 6- Control, Security and Reliability Three necessary database administration functions Concurrency control Security Backup and Recovery 6- Concurrency Control Concurrency control ensures that one user’s actions do not adversely impact another user’s actions At the core of concurrency is accessibility In one extreme, data becomes inaccessible once a user touches the data This ensures that data that is being considered for update is not shown In the other extreme, data is always readable The data is even readable when it is locked for update 6- Concurrency Control (continued) Interdependency Changes required by one user may impact others Concurrency People or | Database Administration Chapter Six DAVID M. KROENKE and DAVID J. AUER DATABASE CONCEPTS, 3rd Edition Chapter Objectives Understand the need for and importance of database administration Learn different ways of processing a database Understand the need for concurrency control, security, and backup and recovery Learn typical problems that can occur when multiple users process a database concurrently Understand the use of locking and the problem of deadlock 6- Chapter Objectives (continued) Learn the difference between optimistic and pessimistic locking Know the meaning of ACID transaction Learn the four 1992 ANSI standard isolation levels Understand the need for security and learn a generalized model of database security Know the difference between DBMS and application security Know the difference between recovery via reprocessing and recovery via rollback/rollforward 6- Chapter Objectives (continued) Understand the nature of the tasks required for recovery using .
