Discuss the two-phase commit protocol used for transaction management in a DDBMS. List its limitations and explain

Question:

Discuss the two-phase commit protocol used for transaction management in a DDBMS. List its limitations and explain how they are overcome using the three-phase commit protocol.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Fundamentals Of Database Systems

ISBN: 9780133970777

7th Edition

Authors: Ramez Elmasri, Shamkant Navathe

See More Books

Question Posted: Feb 16, 2022 07:16 AM

See More Questions

Discuss constructive bailments and explain how they differ from other kinds of bailments.
(a) Describe cash equivalents and explain how they are reported. (b) How should restricted cash funds be reported on the balance sheet?
Define the following terms and explain how they are used to find the risk-free rate of return and the required rate of return for a given investment. a. Real rate of return b. Expected inflation...
Mrs. Ridhima had a factory situated in Delhi which he transferred to Uttar Pradesh and closed all operations in Delhi. Whether it will constitute a slump sale and whether it is liable to tax under...
Discuss how emotions can be used in developing marketing strategies?
OMalley Services, Inc., began 2014 with total assets of $216 million and ended 2014 with assets of $358 million. During 2014, OMalley Services earned revenues of $398 million and had expenses of $167...
Are present channels of distribution reliable and cost effective?
The shelf supports the electric motor which has mass m 1 and mass center at Gm. The platform upon which it rests has mass m 2 and mass center at Gp. Assuming that a single bolt B holds the shelf up...
Hurtt's Java Seeds is an independent roaster of specialty coffee beans. During March, the company plans to sell 13,000 pounds of beans at $12 per pound. Internet sales account for 55 percent of total...
During a manufacturing process 15 units are randomly selected each day from the production line to check the percent defective. From historical information it is known that the probability of a...
List the support offered by operating systems to a DDBMS and also the benefits of these supports.
Figure 22.6 shows the log corresponding to a particular schedule at the point of a system crash for four transactions T 1 , T 2 , T 3 , and T 4 . Suppose that we use the immediate update protocol...
VF is a small accounting firm supporting wealthy individuals in their preparation of annual income tax statements. Every December, VF sends out a short survey to their customers, asking for the...
ProForm acquired 70 percent of ClipRite on June 30, 2020, for $1,470,000 in cash. Based on ClipRite's acquisition-date fair value, an unrecorded intangible of $600,000 was recognized and is being...
Consider the function f(x) = e^(cos(x)) USING MATLAB a) Write code that will approximate the definite integral of f(x) over [0, 1] using Simpson's rule with 100 evenly spaced subintervals. Compare...
What type of research funding method involves shared responsibility for conducting a research project and may grant the funder the authority to withdraw funding if the researcher does not adhere to...
Chapter 6 Assignment i 5 Problem 6-52 (LO 6-4) 12.5 points Jordan took a business trip from New York to Denver. She spent two days in travel, conducted business for nine days, and visited friends for...
need help completing my one-month project. anyone willing help me. Ellipses Corp One Month Project Ellipses Corp is a small business that operates in Herndon, VA. The company is located at10 Period...
John Goodheart wishes to provide for 6 annual withdrawals of $3,000 each beginning January 1, 2029. He wishes to make 10 annual deposits beginning January 1, 2019, with the last deposit to be made on...
(a) Find the equation of the tangent line to f(x) = x 3 at the point where x = 2. (b) Graph the tangent line and the function on the same axes. If the tangent line is used to estimate values of the...
Suppose that TCP is being run over IPsec between headquarters and the branch office in Figure 8.28. If TCP re-transmits the same packet, then the two corresponding packets sent by R1 packets will...
Consider sending a stream of packets from Host A to Host B using IPsec. Typically, a new SA will be established for each packet sent in the stream. True or false?
Consider the example in Figure 8.28. Suppose Trudy is a woman-in-the middle. Who can insert data-grams into the stream of data-gram going from Rl and R2. As part of a reply attack, Trudy sends a...
nformation pertaining to Noskey Corporation s sales revenue follows: November 2 0 2 1 ( Actual ) December 2 0 2 1 ( Budgeted ) January 2 0 2 2 ( Budgeted ) Cash sales $ 1 0 5 , 0 0 0 $ 1 1 5 , 0 0 0...
The management team of Netflix maintains a stable dividend using the Lintner model: Dt+1 = Dt + EPS Target Payout Where Dt (Dt+1) = dividend in the current period t (the next period t + 1) EPSt =...
#1 #2 hapter 50 10 D Werences lav Help Required information [The following information applies to the questions displayed below) Archer Company is a wholesaler of custom-built air-conditioning units...

Discuss the two-phase commit protocol used for transaction management in a DDBMS. List its limitations and explain

Question:

Step by Step Answer:

What is twophase commit protocol how it is used in database A twophase ...View the full answer

Fundamentals Of Database Systems

Students also viewed these Computer science questions