ACID Properties

Preparation

Fundamentals of Database Management Systems

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

Learning Objectives

• Describe the following read phenomena:
  • dirty read
  • nonrepeatable read
  • phantom read
• Define the following terms:
  • Atomicity
  • Consistency
  • Isolation
  • Durability
• Describe the following transaction isolation levels
  • read uncommitted
  • read committed
  • repeatable read
  • serializable
• Describe techniques used by relational databases to provide the ACID properties

Practice

Complete the handout on data anomalies.