answersLogoWhite

0

LOST UPDATE problem occurs when two transactions both read old value of variable and use that value to calculate new value .


INCONSISTENT RETRIEVAL problem occurs when a retreival transaction observes value that are involved in an ongoing updating transaction.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What are the three most common concurrent transaction execution problems?

The three most common concurrent transaction executive problems are uncommitted data, lost updates, and inconsistent retrievals. It is believed that concurrency control can help these problems.


How does the points of concurrency in triangles solve problems?

a\jghfgkk


What is concurrency control techniques?

several problems can occur when concurrent transaction execute in an uncontrolled manner.


What is the advantage of concurrency control?

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.


WHAT problems did they have with measuring?

Some problems with measuring include inaccuracies due to human error, inconsistent measurement techniques, equipment calibration issues, and environmental factors that can affect measurements.


What are some drawbacks of inconsistent parenting?

Some problems might arise if a parent is inconsistent in his/her style. The child might become confused as to what he/she needs to do. The child might not understand when the parent is being serious, or is joking. The ever changing atmosphere in the house can surely be detrimental to a child.


What is incomplete locking?

Incomplete locking refers to a situation in a database management system where a transaction does not acquire all the necessary locks on the resources it needs before it begins its operations. This can lead to issues such as lost updates, dirty reads, or other concurrency problems, as other transactions may modify the data while the first transaction is in progress. Incomplete locking can compromise data integrity and lead to inconsistent states within the database. To prevent this, proper locking protocols and isolation levels should be implemented.


What are common problems experienced with Samsung side by side refrigerators?

Common problems experienced with Samsung side by side refrigerators include issues with the ice maker, temperature control, and water dispenser. These problems can lead to inconsistent cooling, leaks, and ice buildup, requiring maintenance or repairs.


Why is my refilled ink cartridge printing poorly?

Your cartridges may not be working properly because refilling ink cartridges is not recommended by the manufacturer. The consistency of these inks can be inconsistent, causing the printing problems. Purchasing the recommended cartridges should fix your problems.


What are common issues that can arise with well pump pressure switch problems?

Common issues that can arise with well pump pressure switch problems include inconsistent water pressure, frequent cycling of the pump, and potential damage to the pump motor.


What are the common problems with the IRB system?

Common problems with the Institutional Review Board (IRB) system include delays in the review process, inconsistent interpretations of regulations, lack of diversity in IRB membership, and potential conflicts of interest among board members.


What are common issues that can arise with water pressure reducing valve problems?

Common issues that can arise with water pressure reducing valve problems include inconsistent water pressure, water hammering noises, leaks, and damage to appliances and plumbing fixtures.