what is serializability in dbms

what is serializability in dbms

1 year ago 66
Nature

Serializability is a property of a system that describes how different processes operate on shared data in a consistent manner. In database management systems (DBMS), serializability is a way to check if the execution of two or more transactions are maintaining the database consistency or not. A schedule is serialized if it is equivalent to a serial schedule, meaning that the sequence of actions such as read, write, abort, commit are performed in a serial manner. There are two types of serializability in DBMS:

  • Conflict serializability: This type of serializability ensures that the final result is equivalent to the sequential operation of the data. DBMS transactions must follow the ACID properties to be considered serializable.

  • View serializability: This type of serializability is concerned with avoiding database inconsistency. It enables users to see databases in contradictory ways.

Serializability is the major correctness criterion for concurrent transactions executions and is considered the highest level of isolation between transactions. Mechanisms that enforce serializability need to execute in real-time or almost in real-time while transactions are running at high rates. In order to meet this requirement, special cases of serializability, sufficient conditions for serializability which can be enforced effectively, are utilized.

Read Entire Article