Advantages of Conflict Serializability
- Consistency: Conflict serializability guarantees that the transactions’ outcomes correspond to the sequence in which they were carried out.
- Correctness: Regardless of the order in which transactions were submitted, conflict serializability guarantees that transactions are executed correctly.
- Decreased Overhead: By doing away with pointless locking and other conflict resolution techniques, conflict serializability lowers overhead.
- Enhanced Concurrency: By enabling concurrent execution of operations without causing conflicts, conflict serializability enhances concurrency.
Conflict Serializability in DBMS
As discussed in Concurrency control, serial schedules have less resource utilization and low throughput. To improve it, two or more transactions are run concurrently. However, concurrency of transactions may lead to inconsistency in the database. To avoid this, we need to check whether these concurrent schedules are serializable or not.