Module 10: Database Administration I

CMPS 160: Databases


One important property of databases is that many people could try to update or query a database at the same time. This results in several issues that are the topic of this module. Some of the issues we look at are deadlocks (an fundamental issue in concurrent programming), locking, and ACID transactions. ACID stands for Atomicity, Consistency, Isolation, and Durability which are four desirable properties for a database management system to possess. Finally, the fundamental goal of database administration is to actually deploy databases and make them accessible to users and we will see how this is done in practice.

Module 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 about typical problems that can occur when multiple users process a database concurrently
  • Understand the use of locking and the problem of deadlock
  • Learn the different 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 specific tasks for improving database security
  • Know the difference between recovery via reprocessing and recovery via rollback/rollforward
  • Know basic administrative and managerial DBA functions

Learning Resources

  • Module 10 Readings: Chapter 6 (first half)
  • Module 10 Slides: Chapter 6 (first half)

Learning Activities

  • Module 10 Quiz: Chapter 6


How to create an actual database out of a database design (forward engineer):

For Further Study

It is highly recommended to work through the exercises at the end of the chapter, specifically:

  • 6.1 – 6.28

Leave A Reply

Your email address will not be published. Required fields are marked *