Advanced Database Management System - Tutorials and Notes: Optimistic concurrency control protocols in real-time database

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Monday, 28 March 2016

Optimistic concurrency control protocols in real-time database

Optimistic concurrency control protocols in real-time database, real-time database variants of optimistic concurrency control (OCC) protocols, OCC-Broadcast Commit, OCC-Sacrifice, OCC-Wait, and Wait-50 protocols

Optimistic Concurrency Control Protocols

They follow a concept called validation (or certification) of transactions’ operations. This validation is done at the end of the transaction. As the name suggests, these protocols do not prevent any transactions from accessing any data items they require. The idea is to check all the necessary formalities at the end of the transaction before commit.
In optimistic concurrency control, any numbers of concurrent transactions are permitted (even some of the transactions work on same data items). The conflict of transactions, i.e., read-write, write-write on same data items, is validated at the end of the transaction. If any conflict is found during validation, the victims are chosen and rolled back. This avoids the unnecessary blocking of resources.
The following are the variants of OCC protocol where the classical OCC algorithm is slightly changed to accommodate real-time database environments;

  • OCC – Wait
  • Wait – 50



No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents