朴兴国数据库讲义06.pdfVIP

DATABASE PARK, HUNG PARK, HUNG KOOKKOOK Professor in Software College of Professor in Software College of SangmyungSangmyung UniversityUniversity Ph.D. in Information Science from CGUPh.D. in Information Science from CGU MBA from Claremont Graduate UnivMBA from Claremont Graduate Univ BA from Seoul National UniversityBA from Seoul National University parkh@smu.ac.krparkh@smu.ac.kr Chapter Six Database Administration Chapter Objectives •• Understand the need for and importance of Understand the need for and importance of database administrationdatabase administration •• Learn different ways of processing a databaseLearn different ways of processing a database •• Understand the need for concurrency control, Understand the need for concurrency control, security, and backup and recoverysecurity, and backup and recovery •• Learn typical problems that can occur when Learn typical problems that can occur when multiple users process a database concurrentlymultiple users process a database concurrently •• Understand the use of locking and the problem of Understand the use of locking and the problem of deadlockdeadlock 6-3 Chapter Objectives (continued) •• Learn the difference between optimistic and Learn the difference between optimistic and pessimistic lockingpessimistic locking •• Know the meaning of Know the meaning of ACID transactionACID transaction •• Learn the four 1992 ANSI standard isolation Learn the four 1992 ANSI standard isolation levelslevels •• Understand the need for security and learn a Understand the need for security and learn a ge