Optimistic concurrency control, Database Management System

Optimistic Concurrency Control

Is locking the only way to stop concurrency related problems? There exist some other ways too. One such way is known as an Optimistic Concurrency control.

The basic logic in optimistic concurrency control is to permit the concurrent transactions to update the data items supposing that the concurrency related trouble will not occur. Though, we require to reconfirm our view in the validation phase. Thus, the optimistic concurrency control algorithm has the following phases:

a)   READ Phase: In a read phase, transaction T reads the data items from the database into its private workspace. All the updates of the transaction can only alter the local copies of the data in the private workspace.

b)   VALIDATE Phase: Checking is performed to verify whether the read values have changed during the time transaction was updating the local values. This is performed by evaluating the current database values to the values that were read in the private workspace. In case, the values have altered the local copies are thrown away and the transaction aborts.

c)   WRITE Phase: In a write phase, if validation phase is successful the transaction is committed and updates are applied to the database, otherwise the transaction is rolled back.

 

Posted Date: 3/12/2013 3:12:05 AM | Location : United States







Related Discussions:- Optimistic concurrency control, Assignment Help, Ask Question on Optimistic concurrency control, Get Answer, Expert's Help, Optimistic concurrency control Discussions

Write discussion on Optimistic concurrency control
Your posts are moderated
Related Questions
I need an ERD created for any original database(can be on anything). It needs to be 3NF. I then need all the CREATE STATEMENTS, INSERT STATEMENTS(anything you can think of as long

Define a property that is not a property of transactions? Ans: Concurrency is not a property of transactions

List some instances of collection types? a) sets b) arrays c) multisets

Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th

How can you connect to the MySQL Server? In order to connect to the MySQL server it is necessary to give the username and password so this be able to done with The following

What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

What is transaction? Transaction is a unit of program implementation that accesses and possibly updated several data items.

Problem: a) Briefly describe what you understand by Client-Server environment b) The File Server is a simple form of Client-Server. Describe the principles of the File Serve

Can you assist me in Database management system? I need help in my courses, please email me at and get back me soon...

What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs