《数据库原理（第6版）英文版》教学课件—ch06Database Administration.pptxVIP

Chapter SixDatabase AdministrationChapter Objectives6-Understand the need for and importance of database administrationLearn different ways of processing a databaseUnderstand the need for concurrency control, security, and backup and recoveryLearn about typical problems that can occur when multiple users process a database concurrentlyUnderstand the use of locking and the problem of deadlockChapter Objectives (Cont’d)6-Learn the difference between optimistic and pessimistic lockingKnow the meaning of ACID transactionLearn the four 1992 ANSI standard isolation levelsUnderstand the need for security and specific tasks for improving database security Know the difference between recovery via reprocessing and recovery via rollback/rollforwardChapter Objectives (Cont’d)6-Understand the nature of the tasks required for recovery using rollback/rollforwardKnow basic administrative and managerial DBA functionsHeather Sweeney DesignsDatabase Design5-Heather Sweeney Designs:HSD Database in Microsoft SQL Server 2012 Figure 6-1: The HSD Database in Microsoft SQL Server 20126-Heather Sweeney Designs:HSD Database Diagram in SQL Server 2012 6-The Database Processing EnvironmentFigure 6-2: The Database Processing Environment6-Control, Security and Reliability6-Three necessary database administration functions are:Concurrency controlSecurityBackup and RecoveryConcurrency Control6-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.Concurrency Control (continued)6-InterdependencyChanges required by one user may impact others.ConcurrencyPeople or applications may try to update the same information at the same time.Record retentionWhen information should