Consider a database system that includes an atomic increment

Assignment Help Basic Computer Science

Reference no: EM131224351

Consider a database system that includes an atomic increment operation, in addition to the read and write operations. Let V be the value of data item X. The operation
increment(X) by C
sets the value of X to V + C in an atomic step. The value of X is not available to the transaction unless the latter executes a read(X). Figure 15.23 shows a lock-compatibility matrix for three lock modes: share mode, exclusive mode, and incrementation mode.

a. Show that, if all transactions lock the data that they access in the corresponding mode, then two-phase locking ensures serializability.

b. Show that the inclusion of increment mode locks allows for increased concurrency. (Hint: Consider check-clearing transactions in our bank example.)

Reference no: EM131224351

Questions Cloud

Develop a problem definition for angus : You have heard what Angus had to say about his customers. There are certainly more preferences that he can keep track of. Develop a problem definition for Angus, similar to the one developed for Catherine's Catering in this chapter.

Evaluate feasibility and effectiveness of sport programs : Evaluate the feasibility and effectiveness of using sport programs at municipal recreation centres to help reduce youth violence?

Nortel the rise and fall of a telecommunications company : In the Nortel the Rise and fall of a telecommunications company Discuss how to prioritize the following remedies to stop such recurrences: business education, regulation of accounting/financial markets, regulation of incentives, or regulation of ..

Find a credible source that provides useful information : Find a credible source that provides useful information about your topic of interest. You will explain how the information from your source can be used to enhance your own professional development endeavors.

Consider a database system that includes an atomic increment : Consider a database system that includes an atomic increment operation, in addition to the read and write operations. Let V be the value of data item X.

Thanksgiving coffee paul katzeff : In your opinion, is Thanksgiving Coffee's Paul Katzeff doing the right thing in working against the U.S. embargo? Explain your opinion. If your answer is yes, can you think of any additional steps that Katzeff might take?

Persuasion model and four persuasion factors : Think about McGuire’s Persuasion Model and its four persuasion factors: 1. Source 2. Message 3. Channel 4. Receiver Which one of these four factors is most important to advertising? Why is it most important?

Additional procurement risk that a pm : Name an additional procurement risk that a PM should foresee with the type of procurements mentioned in the first part of your answer.

Approaches to eliminate bias and stick to supporting data : i. Why is past experience so important to managers today, and how applicable is it in decision making? ii. Develop three approaches to eliminate bias and stick to supporting data to improve one's decision making abilities.

User Account

All Pages