Provide a lock compatibility matrix with these three modes

Assignment Help Computer Engineering

Reference no: EM132117149

Question on Database Systems - Concurrency Control

A popular update operation is increment/decrement the numeric value of data object by 1. Suppose we are now to create a lock mode I, along with usual shared and exclusive lock modes. Consider a locking protocol that will require a request for a lock with mode I on a data object Q (with numeric value) before proceeding with the increment/decrement operation on Q.

(i) Provide a lock compatibility matrix with these three modes.

(ii) Will this protocol provide more concurrency (data sharing) than the one with only shared and exclusive lock modes?

(iii) Suppose the increment/decrement operation is modified such that the operation will fail if the value of data object will become negative after the operation. Are your answers to (i) and (ii) still valid? Explain your answer.

Reference no: EM132117149

Questions Cloud

What does one need to know about the element data : What does one need to know about the element data type in order for a bstree data type to be possible.

Describe which bidders would receive shares : In a traditional offering, describe which bidders would receive shares, the price they would pay, and how much of their orders would be filled.

Write l as concatenation of three languages : Describe formally the language L consisting of all binary strings that do contain the string 001 as a substring. Write L as concatenation of three languages.

How many processes are created by the program shown below : Including the initial parent process, how many processes are created by the program shown below?

Provide a lock compatibility matrix with these three modes : Will this protocol provide more concurrency (data sharing) than the one with only shared and exclusive lock modes?

Pick one law of sets and give an every application of it : Pick one law of sets and give an every application of it.Do you think it is useful to personally know?

How do you construct a deterministic finite automaton : How do you construct a deterministic finite automaton with three inputs 1,2,3 such that the string inputs (ex 1111 or 2222) sums up to a multiple of 4?

Two-period binomial model : If European put price using a two-period binomial model assuming the following data is: S0 = 10, T = 2 months, u = 1.5, d = 0.5, r = 0.05, K = 7.

How many users can be supported : Suppose there are 120 users. Find the probability that at any given time, exactly n users are transmitting simultaneously.

User Account

All Pages