ACID

Question 1

ACID

Answer 1

Atomicity Consistency Isolation Durability

A set of properties that guarantees that database transactions are processed reliably. Provides a way to handle errors, recover from failures and coordinate concurrent transactions.

Question 2

LSN

Answer 2

Log Sequence Number

Question 3

Disjoint-access

Answer 3

A set of transactions is disjoint-access if it has no shared object

Question 4

Atomicity

Answer 4

This property ensures that a transaction is treated as a single, indivisible operation, which either succeeds completely or fails completely.

Question 5

Consistency

Answer 5

This property ensures that a transaction brings the database from one valid state to another. The database has a set of contraints that that define valid state

Question 6

Isolation

Answer 6

This property ensures that concurrent execution of transactions leave the database in the same state that if the transactions had been executed sequentially.

Question 7

Durability

Answer 7

This property ensures that once a transaction has been committed it will remain so even in the event of a system failure, error, crash, power loss etc