Multi-Version Schemes of Concurrency Control with example

Multi-version protocol minimizes the delay for reading operation and maintains different versions of data items. For each writes operation performed, it creates a new version of transaction data so that whenever any transaction performs read operation to read that data then the appropriate created data version is selected by the control manager to make that … Read more

Timestamp ordering of transactions in DBMS

Timestamp ordering is a unique value given to every transaction whenever it comes into the system to execute. There are two types of timestamp values Read timestamp: It is the value of the last transaction which successfully performed the read operation. Write timestamp: It is the value of the last transaction which successfully performed the … Read more