ACID Tests

• TPC-C requires transactions be ACID.

• Tests included to demonstrate ACID properties met.

• Atomicity

  • Verify that all changes within a transaction commit or abort.

• Consistency

• Isolation

  • ANSI Repeatable reads for all but Stock-Level transactions.
  • Committed reads for Stock-Level.

• Durability

  • Must demonstrate recovery from
    • Loss of power
    • Loss of memory
    • Loss of media (e.g., disk crash)

Previous slide

Next slide

Back to first slide

View graphic version