Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN: 9781285196145
Author: Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher: Cengage Learning
bartleby

Concept explainers

Expert Solution & Answer
Book Icon
Chapter 10, Problem 2P

Explanation of Solution

Concurrency control:

The purpose of concurrency control is to ensure the serializability of transaction in a multiuser database environment and it is the process of coordinating the simultaneous execution.

Common problems with concurrent transaction execution:

Concurrency transaction is one or more transactions are processed on same time. During the concurrency transaction execution the following problems can occur in the transaction. They are:

  • Lost updates
  • Uncommitted data
  • Inconsistent retrievals

Lost updates:

A data can be lost when the two different transactions want to update same field or row within the database at the same time.

  • For example: if the transactions “T1” and “T2” want to update the same element and one of the updates is lost or overwritten by other transactions.

Uncommitted data:

The data of the transactions are not committed when the transactions are executed concurrently...

Blurred answer
Students have asked these similar questions
Explain the three most prevalent problems with concurrent transaction execution. Explain how you can avoid these issues by using concurrency control.
Describe the three most common problems with concurrent transaction execution.Explain how concurrency control can be used to avoid those problems.
Optimistic concurrency management sometimes delays transactions. Explain?
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning