Mastering Database Management

0 of 78 lessons complete (0%)

Introduction to Databases

ACID Properties

You don’t have access to this lesson

Please register or sign in to access the course content.

  • Atomic Transaction
    • An atomic transaction is a series of database operations such that either all occur, or nothing occurs. Example: Airline Ticket Booking
  • Consistency
    • The guarantee that database constraints are not violated, particularly once a transaction commits.
  • Isolation
    • Isolation determines how transaction integrity is visible to other users and systems.
      • Serializable
      • Repeatable Reads
      • Read Committed
      • Read Un-Committed
  • Durability
    • Guarantees that transactions that have committed will survive permanently.
    • For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.
    • Durability can be achieved by flushing the transaction’s log records to non-volatile storage before acknowledging commitment.