Question on database systems - concurrency controla popular, Ask an Expert

Engineering

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.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M93104617

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Question 1 your organization has approximately 10 tb of

Question: 1. Your Organization has approximately 10 TB of data, and you need to decide if your organization should have on-site or off-site tape storage. 2. Your organization must be able to easily recover data no older ...

Meannbsp3290 milesstandard deviation ofnbsp384 mileswhat is

Mean 3290 miles Standard Deviation of 384 miles What is the probability that the mean of a sample of 33 cars would be less than 3160 miles?

What are the three most significant aspects of threat which

What are the three most significant aspects of threat which will continue to evolve for the next 20 years?

What does the super keyword represents and where can it be

What does the super keyword represents and where can it be used? Give an example of a superclass and subclass. Be sure to make all the instances variables of the super class private. Include at least one constructor in e ...

Titan mining corporation has 75 million shares of common

Titan Mining Corporation has 7.5 million shares of common stock outstanding, 275,000 shares of 4.7 percent preferred stock outstanding, and 160,000 bonds with a semiannual coupon rate of 5.6 percent outstanding, par valu ...

Reading the biographybook where the body meets memory by

Reading the Biography Book : "Where the Body Meets Memory" by David Mura Questions: 1. The internment camps were a very painful experience for Japanese Americans. They were also a very important and awkward chapter in Am ...

Be sure to answer all partsphosgenenbspcocl2nbspis a toxic

Be sure to answer all parts. Phosgene (COCl 2 ) is a toxic substance that forms readily from carbon monoxide and chlorine at elevated temperatures: CO( g ) + Cl 2 ( g ) ? COCl 2 ( g ) If 0.490 mol of each reactant is pla ...

Question resource security planning and risk management

Question: Resource: Security Planning and Risk Management Template The CIO of the organization you chose is ready for you to take a look at the organization's potential vulnerabilities and threats. Complete the 1.5- to 2 ...

Many high school students take the ap tests in different

Many high school students take the AP tests in different subject areas. In 2007, of the 144,796 students who took the biology exam 84,199 of them were female. In that same year, of the 211,693 students who took the calcu ...

Diacussion 1 how would one distinguish between an

Diacussion: 1) How would one distinguish between an organizational weekness and threat to the organization? The response must be typed, single spaced, must be in times new roman font (size 12) and must follow the APA for ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert