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

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?
Avery Corporations northwestern factory provided the following information for the last calendar year: Beginning inventory: Direct materials ...... $50,800 Work in process ...... 58,500 Ending...
Suppose the probabilities are 0.89,0.09, and 0.02 that the finish on a new car will be rated acceptable, easily repairable, or unacceptable. Find the probability that, among 20 cars painted one...
Longworth Manufacturing has two producing departments, machining and assembly, and two service departments, personnel and custodial. The companys budget for April 20X1 is as follows: Longworth...
Q. Today, social, mobile, and local marketing are the fastest-growing forms of online marketing. This assignment is to plan your own business. A. Describe its business model mentioning the comparison...
Heat flow in a solid bounded by two conical surfaces (Fig. 11B.9). A solid object has the shape depicted in the figure. The conical surfaces 1 = constant and 2 = constant are held at temperatures T...
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...
What characteristics do auditors consider in reviewing a clients inventory- taking instructions?
A parabolic reflector (see Figure 15.43) is constructed so that a cross section along its axis is a parabola with the light source at the focus. Find the location of the focus if the reflector is...
What is the eccentricity for each of the given conics? Also, explain how changes in the eccentricity affect the curve. a. parabola b. ellipse c. hyperbola
Tell what the output value is for each of the function machines in Problems 15-20 for (a) 4 , (b) 6 , (c) -8 , (d) $\frac{1}{2}$, (e) $t$ 3x S X+X+X O +X+X __xx+x+x_x+x+
A parabolic archway has the dimensions shown in Figure 15.42. If we draw coordinate axes as shown, it can be shown that the equation of the archway portion is \[x^{2}=-4 c(y+3)\] for some constant...
If the path of a baseball is parabolic and is $200 \mathrm{ft}$ wide at the base and $50 \mathrm{ft}$ high at the vertex, write an equation that specifies the path of the baseball if the origin...
Find a basis for the orthogonal complement to the following subspaces of R3: (a) The plane 3x + 4y - 5z = 0 (b) The line in the direction (- 2, 1, 3)T (c) The range of the matrix (d) The cokemel of...
Evaluate the function at the given value(s) of the independent variable. Simplify the results. (x) = cos 2x (a) (0) (b) (- /4) (c) (/3) (d) ()
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...
4. A stock provides a dividend yield of 5.0% paid semi- annually. The spot price of the stock is currently $500, and the risk-free rate is 7.5% with continuous compounding for all maturities. 1. What...
1. A 1000 bond issued on January 10, 2021 is paying coupons at a nominal interest rate of 7% payable semiannually. The bond is redeemed at par and matures on January 10, 2031. The nominal yield rate...
Ruzgar Inc., bonds were selling at $1,040 a year ago. A friend of yours invested into this bond and just received a $100 coupon payment. She sold the bond today for $1,200.If the inflation rate for...

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