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 8P
Textbook Problem
372 views

Assuming that pessimistic locking is being used but the two-phase locking protocol is not, 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 6a.

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.

Explanation of Solution

Chronological list:

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

Time Action
1 Lock INVOICE
2 Insert row 10983 into INVOICE
3 Unlock INVOICE
4 Lock LINE
5 Insert tow 10983, 1 into LINE
6 Unlock LINE
7 Lock...

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 are some basic database functions that a spreadsheet cannot perform?

Database Systems: Design, Implementation, & Management

What taper turning methods allow use of the lathes power feed?

Precision Machining Technology (MindTap Course List)

For the ideal gas law given in Problem 6.31, if the units of P, V, m, and T are expressed in lbf/ft2, ft3, lbm,...

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

Explain Apple’s view of user interface design, especially for apps.

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

Solve Problem 8.4-7 by the ultimate strength method (use the tables in Part 8 of the Manual).

Steel Design (Activate Learning with these NEW titles from Engineering!)

Define the term, Internet of Things (IoT). List IoT-enabled devices and technologies.

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)