You are given data of actions of total 3 transactions i.e, Tp, Tq and Tr. R for read and W for write. As you know the concept of strict two-phase locking: after all the actions are completed, only then transaction is unlocked. So to solve this you have exclusive and shared locks i.e, "xl(data item)" and "sl(data item)" respectively. Each of the action's order is interleaved. Write down for all the given questions, how the transactions should perform using the necessary locks and unlocks so that the given actions occur. Also mention to write the action too. i. ii. iv. v. vi. Tp: Rp (A) Tq: Wq (B) Tp: Wp (B) Tr. Wr (C) Tp: Wp (A) Tr. Wr (B)

You are given data of actions of total 3 transactions i.e, Tp, Tq and Tr. R for read and W for write. As you know the concept of strict two-phase locking: after all the actions are completed, only then transaction is unlocked. So to solve this you have exclusive and shared locks i.e, "xl(data item)" and "sl(data item)" respectively. Each of the action's order is interleaved. Write down for all the given questions, how the transactions should perform using the necessary locks and unlocks so that the given actions occur. Also mention to write the action too. i. ii. iv. v. vi. Tp: Rp (A) Tq: Wq (B) Tp: Wp (B) Tr. Wr (C) Tp: Wp (A) Tr. Wr (B)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

q8- Choose ALL that apply.
Suppose that a DBMS recognizes increment, which increments an in- teger-valued object by 1, and decrement as actions, in addition to reads and writes. A transaction that increments an object need not know the value of the object; incre- ment and decrement are versions of blind writes. In addition to shared and exclusive locks, two special locks are supported: An object must be locked in I mode before incrementing it and locked in D mode before decrementing it. An I lock is compatible with another I or D lock on the same object, but not with S and X locks. 1. Illustrate how the use of I and D locks can increase concurrency. (Show a schedule allowed by Strict 2PL that only uses S and X locks. Explain how the use of I and D locks can allow more actions to be interleaved, while continuing to follow Strict 2PL.) 2. Informally explain how Strict 2PL guarantees serializability even in the presence of I and D locks. (Identify which pairs of actions conflict, in the sense that their relative…
Murach's MySQL 3. Write a script that creates and calls a stored procedure named test. This procedure should use a transaction that includes the statements necessary to combine two musicians. These statements should do the following: Select a row from the Musicians table for the musician with a musician_id value of 6. This statement should lock the row so other transactions can’t read or modify it until the transaction commits, and it should fail immediately if the row is locked from another session. Update the Orders table so any orders for the selected musician are assigned to the musician with a musician_id value of 3. Update the Addresses table so any addresses for the selected musician are assigned to the musician with a musician_id value of 3. Delete the selected musician from the Musicians table. If these statements execute successfully, commit the changes. Otherwise, rollback the changes.
Consider the following two transactions: T1-R(B), W(B), R(C), R(A) T2-R(B). W(B) Say that sharing lock, exclusive lock, and unlock actions are inserted by the scheduler, resulting in the following annotated transactions: T1= X(B), R(B), W(B), S(C), R(C), S(A), U(B), R(A), U(C), U(A) T2-X(B), R(B), W(B), U(B) Cascading rollback is not possible for the above schedule. True False
Task 1: The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENACE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team.