0
By having concurrency control you avoid dirty writes (or inconsistent data). It is like your traffic signal - allows one set of users (drivers) to pass through at a time. In computer terms, if a user wants to update some data then the following steps are taken: (a) the data is fetched along with the timestamp (the date, time when it was last modified) (b) the data is modified by the user who then submits the data for update / storage in the system (c) the system verifies the original timestamp with the current timestamp. (i) If both are same, the new data (including the new timestamp) is updated/stored in the system. (ii) If they are different, then obviously the data had changed between the time it was fetched and now - meaning that someone else had updated in the meanwhile. The system typically informs the user that the data had been modified by a different user and asks him/her to submit the modifications once again. The system would implicitly do step (a) above allowing the user to start from step (b) onwards.
Wiki User
∙ 18y ago
Wiki User
∙ 12y agoavoid the main problems with transaction the lost update problem and the inconsistent retrievals
Wiki User
∙ 12y agoThe Lost update problem: This occurs when two transactions access the same database items have their operations interleaved in a way that makes the value of some database item incorrect.
Wiki User
∙ 12y agoLess time to access to your data
Add your answer:
Earn +20 pts
What is concurrency control techniques?
several problems can occur when concurrent transaction execute in an uncontrolled manner.
What are the advantages of system?
The advantage of system software is it is made for the os. so it will run smother than some others.
What do you understand by the term concurrency?
The term concurrency means the property of being concurrent; concurrent means happening at the same time. It is often used in respect to jail sentences. Some people get to serve two or more jail sentences for different crimes at the same time. Or, someone could hold two different offices at the same time. One could therefore be serving concurrent jail sentences, or holding concurrent offices. We could then question the wisdom of the concurrency of the sentences or the offices.
It is being said that in token passing access control the main advantage of such networks is that are deterministic. Disscuss the truth of the said statement?
yes
Advantage and disadvantage of gadget?
the advatage is youre and disadvantage is advantage the gadget is moaso advantage is mind in powering objects..
Differentiate Optimistic concurrency control and pessimistic concurrency control?
concurrency control algorithm
What are disadvantages of concurrency control?
I think the following could be the disadvantages of concurrency control: 1: resource consumption
What is concurrency control techniques?
several problems can occur when concurrent transaction execute in an uncontrolled manner.
What is a perpendicular bisector concurrency conjecture?
The Perpendicular bisector concurrency conjecture is the circumcenter
The Point of Concurrency of the Angle Bisectors of a Triangle?
The point of concurrency is the point intersection.
The dbms or some other related software components which enforce certain recovery and concurrency control are called are?
that's auto-recovery!
Pram model allows exploitation of concurrency?
do you thing that pram allows exploitation of concurrency
What is the point of concurrency of an altitude of a triangle?
The point of concurrency of the altitudes in a triangle is the orthocenter, while the point of concurrency for the perpendicular bisectors is the centroid/circumcenter. Sorry if this is late! xD
Is it true that the point of concurrency of any triangle only happens inside the triangle?
Depends on the point of concurrency of what. The point of concurrency of altitudes will be outside in any obtuse triangle.
Where can one learn more about Java concurrency in practice?
One may learn about Java concurrency in the book 'Java concurrency in practice' which can be purchased from various online retailers. Additionally, Java concurrency is often discussed in various formal training classes.
What is the point of concurrency of the altitudes of a triangle is called the?
the point of concurrency of the altitudes of a triangle is called the orthocenter.
What is a wrong-way concurrency?
A wrong-way concurrency is a road concurrency in the United States in which two numbered highway routes are signed in opposite, conflicting directions on the same stretch of roadway.
