It is proven to be an effective mechanism in many situations, and provides besides Serializability also Strictness and Commitment ordering properties.
32.
The underlying " Theory of Commitment ordering ", part of Serializability theory, is both sound and distributed applications.
33.
This makes CO a straightforward, natural generalization of SS2PL for any conflict serializability based database system, for all practical purposes.
34.
If any specific order between some transactions is requested by an application, then it is enforced independently of the underlying serializability mechanisms.
35.
In order to meet this requirement special cases of serializability, sufficient conditions for serializability which can be enforced effectively, are utilized.
36.
In order to meet this requirement special cases of serializability, sufficient conditions for serializability which can be enforced effectively, are utilized.
37.
Conflict-serializability is widely utilized because it is easier to determine and covers a substantial portion of the view-serializable schedules.
38.
Two-phase locking is the most common transaction concurrency control method in DBMSs, used to provide both serializability and recoverability for correctness.
39.
However, serializability can be achieved when desired by simply using explicit record read locks to lock read data that updates are based upon.
40.
Mechanisms that enforce serializability need to execute in real time, or almost in real time, while transactions are running at high rates.
