BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 10, Problem 2P
Textbook Problem
56 views

Describe the three most common problems with concurrent transaction execution. Explain how concurrency control can be used to avoid those problems.

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...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 10 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is a Next Generation Firewall (NextGen or NGFW)?

Principles of Information Security (MindTap Course List)

Explain what we mean by a force and give examples of different forces.

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

How would you balance DFDs?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

What advantages do fiber-optic cables have over cables that use wires? (478)

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)