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 11P
Textbook Problem
591 views

Assuming that pessimistic locking with the two-phase locking protocol is being used with row-level lock granularity, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the complete processing of the transaction described in Problem 6b.

Program Plan Intro

Pessimistic locking:

It is one of the locking methods in concurrency control. The lock exists in the transaction until the transaction gets committed or rolled back.

Two-phase locking protocol:

It defined the serializability of the transaction but not prevent deadlocks. The process of locking and unlocking can be done using two phases in this protocol. They are: Growing phase and shrinking phase.

Growing phase:

New lock can be occurred on the transaction without unlocking the data items. The data items are locked in this phase.

Shrinking phase:

This phase used to release all transaction but not provide new lock on the transaction.

Row-level lock granularity:

This row-level locking process used to lock the single row in the table. It is used to improve the availability of data and involving in transaction conflict.

Explanation of Solution

Chronological list:

The following chronological list demonstrates locking, unlocking, and data manipulation activities of transaction described in “Problem 6b” using pessimistic locking method with the two-phase locking protocol.

Time Action
1 Lock PAYMENT
2 Lock CUSTOMER
3 Insert row 3428 into PAYMENT
4 Update CUSTOMER 10010, CUS_BALANCE from 464...

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 DcepFace and how is it used?

Fundamentals of Information Systems

What are the main components of a database system?

Database Systems: Design, Implementation, & Management

Name two material shapes that can be properly held in a four-jaw chuck.

Precision Machining Technology (MindTap Course List)

A typical ceiling of a house consists of items shown in the accompanying table. Assume an inside room temperatu...

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

Describe the strategy of defense.

Management Of Information Security

Technology Purchases You are the director of information technology at a company that specializes in designing ...

Enhanced Discovering Computers 2017 (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 is the purpose of grooving a joint before welding on thick plate?

Welding: Principles and Applications (MindTap Course List)