Question

Between the two concurrency control protocols: 2-phase locking and Time-stamp ordering, which protocol ensures both conflict serializability and freedom from deadlock? Give reasons.

no hand write plz i need a Unique and simple ans thank u

Answer 1

Time stamp protocols is the concurrency ptotocol which ensures both conflict serializability and freedom of dead lock as no transaction ever waits while using time stamp protocoln, a time schedule is alloted to every transaction and it will participated according to that , this alogorithm must ensure , for each item is accessed does not violate ordering. In this the older transaction is always given priority. It manage conflicts as well

where as 2 phase locking protocol provides serializability but it does not ensure deadlocks to happen