Question: Many applications need to generate sequence numbers for each transaction. a. If a sequence counter is locked in two-phase manner, it can become a concurrency

Many applications need to generate sequence numbers for each transaction.

a. If a sequence counter is locked in two-phase manner, it can become a concurrency bottleneck. Explain why this may be the case.

b. Many database systems support built-in sequence counters that are not locked in two-phase manner; when a transaction requests a sequence number, the counter is locked, incremented and unlocked.

i. Explain how such counters can improve concurrency.

ii. Explain why there may be gaps in the sequence numbers belonging to the final set of committed transactions.

Step by Step Solution

★★★★★

3.34 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a If a sequence counter is locked in twophase manner it can become a concurrency bott... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

For each transaction a through f, identify its impact on the accounting equation (select from 1 through 6 below). _____ a. The company pays cash toward an account payable. _____ b. The company...

When rights such as those in this case become more valuable as a result of new technology, should the law be changed to redistribute the economic benefit of those rights? Why or why not?

How and why did database management systems become the organizational data management standard in organizations? Discuss some of the advantages of the database approach over the file-system approach.

The following variables are used in an implementation of the algorithm: ar is the count of active readers rr is the count of reading readers aw is the count of active writers ww is the count of...

Al-Driven Contextual Advertising: Toward Relevant Messaging Without Personal Data E. Haglund and J. Bjorklund Department of Computing Science, Umea University, Umed, Sweden ABSTRACT In programmatic...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

s sf Define the terms opaque type and concrete type. [5 marks] The following is a shortened version of one of the definition modules described in the Modula-2 user manual: Provide a suitable...

Read the above passage and then answer short questions Summarize and elaborate the research method of this article in concise language Application Research Based on Machine Learning in Network...

Hannoon, a Kuwaiti employee who worked as an information systems manager, requested Friday afternoons off to observe weekly Muslim prayer services. His supervisor noted in his personnel file, first...

Suppose a scientist identified two yeast mutants, called huh 1 and huh2. The mutants have constitutive expression of the nop operon, which includes the genes nop 1 and nop 2. One of the mutants is a...

47. A financial manager made two new investmentsone in the oil industry and one in municipal bonds. After a one-year period, each of the investments will be classified as either successful or...

What is the mean (average) retention rate for PRODUCTION on your Excel printout?

Explain the purpose of the checkpoint mechanism. How often should checkpoints be performed? How does the frequency of checkpoints affect System performance when no failure occurs The time it takes...

When the system recovers from a crash, it constructs an undo-list and a redo-list. Explainwhy log records for transactions on the undolist must be processed in reverse order, while those log records...

Compare the shadow-paging recovery scheme with the log-based recovery schemes in terms of ease of implementation and overhead cost.

(5 Points) You are given the following information: U.S. France Japan Nominal one year interest rate 1% 4% 2% Spot rate ----- $1.14 $0.0093 Interest rate parity exists between the U.S. and France as...

Consider the following three stocks: A, B,and C. The Prices are $70, 80,30 respectively and no of shares outstanding 200, 500,600. the Value weighted index was constructed with the three stocks using...

You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2019 and the bond has a par value of $1,000. Rate Maturity Mo/Yr May 23...