Question

Difference between conflict and view serializability in dbms

Answer 1

Differences in conflict and view serializability in DBMS:

A Schedule is a conflict serializable if it is conflict equivalent to any serial schedule.

THE DIFFERENCE BETWEEN CONFLICT AND VIEW SERIALIZABILITY:

• Every conflict serializable is the view serializable but the reverse is not true i.e not possible.

• The Conflict serializability is very easy to achieve but the view serializability is hard to achieve it.

• It is very easy to test the conflict serializability but the expensive to test the view serializability.

• The most of the concurrency control schemes used in practice are based on conflict serializability.

• If schedule is view serializable then it may or may not be conflict serializable.

• If the schedule gets conflict serializable,  it is also viewed serializable schedule.

• THE Conflict equivalence can easily be achieve by the reorderings of the operation  of two transactions therefore, Conflict Serializability is easy for achieving.

• The Viewequivalence is difficult to achieve the both transaction , it should perform similar action in the similar manner. Thus, View Serializability is difficult to be achieved.

#SPJ1