Transactions and Concurrency

Preparation

Fundamentals of Database Management Systems

• Chapter 11: Database Control Issues: Security, Backup and Recovery, Concurrency

Learning Objectives

• Name the necessary conditions for deadlock
• Describe how database management systems (DBMSs) use locks to ensure isolation among transactions
• Describe the two-phase locking protocol and strict two-phase locking
• Create a serializable schedule using the aforementioned locking protocols