Question: Suppose that 2PC is used as the commit protocol. Consider the following parts of recovery scenarios for a distributed transaction T with coordinator C and

Suppose that 2PC is used as the commit protocol. Consider the following parts of recovery scenarios for a distributed transaction T with coordinator C and two participating sites P1 and P2: P2 sends query status request to P1 and then waits P2 sends query status request to P1 and then aborts. Consider the following failures cases (in each case assume that this is the only failure in the system): A coordinator site for T fails after sending a prepare message but before sending a commit message A coordinator site for T fails before sending a prepare message. For each of the recovery scenarios specify a group of above cases that may cause that scenario. Your answer should be represented as the following table (please, do not provide any explanation)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

Suppose that 2PC is used as a commit protocol. 4. [20 pts] Suppose that 2PC is used as a commit protocol. Consider the following parts of recovery sub-scenarios for a distributed transaction T with...

Suppose that 2PC is use as the commit protocol. Consider the following for a distributed transformation T with coordinator and to sites P1 and P2. C aborts. C commits. Consider the following case (in...

distributed database ve Exercise 1 Assume that two concurrent executing transactions T1 and T2 are allowed to update same stock item say 'A' in an uncontrolled manner. In such scenario. Give the...

Which of the following statements best defines a distributed database management system (DDBMS)? a. DDBMS governs the storage and processing of physically related data over interconnected computer...

Federal Emergency Management Policy Changes After Hurricane Katrina: A Summary of Statutory Provisions Keith Bea, Coordinator Section Research Manager March 6, 2007 Congressional Research Service...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

COMPLETE ALL THE QUESTIONS 1) Make a version of X.32[7] where the element type is a template argument. [10] ( 2.5) Given an Itor class like the one in X.32[8], consider how to provide iterators for...

Hi, I am doing a project for derivatives class and I have some questions about a regression and Monte Carlo simulation that I need to come up with. So the goal is to hedge against CDS instruments by...

A certain program has to maintain an array, count, of N counters which are all initialised to zero. The value of counter i can be incremented by one by the call: increment(i), and this is the only...

You are performing an audit of a small Internet start-up company that recently went public. During the audit, you frequently converse with the employees, with whom you have a comfortable...

Consider the condensation of the diamine H2N(CH2)nNH2 with sebacic acid, (HOOC)(CH2)8(COOH), to obtain the polyamide. The polyamide has the following composition: 67.2% C

Is your capital gain different? Why or why not? b . Is your dividend yield different? Why or why not?

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

4. Do you have power relative to this person? Why or why not? Do you need or want more power in this case? If yes, then what are some of the ways in which you might increase your influence and power?

1. On balance, do you think networking is best thought of as a way to meet interesting people or a way of using people to get what you want?

2. Assuming that, after his reassignment, John might have become more open to suggestions on his behavior, how might you advise him?