Question: 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

Suppose that 2PC is used as a commit protocol.

Suppose that 2PC is used as a commit protocol. 4. [20 pts]

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 coordinator C and two participating sites P1 and P2: 11 P2 checks its log and then aborts. 12 P1 sends query status request to P2 and then commits. 1.3 P1 sends query status request to P2 and then waits for messages from C 14 P1 doesn't checks its log, but do T. Consider the following cases (a) P1 fails after receiving a commit message for T. (b) Pl fails after receiving an abort message for T. (c) The coordinator site for T fails before sending a commit message. (d) P1 fails after sending a ready message for T, and then the coordinator site for T fails after sending a commit message Pl fails after sending a ready message for T, and at the same time, the coordinator site for T also fails. (e) For each of the recovery sub-scenarios specify a group of above cases that are possible for that sub-scenario. Your answer should be represented as the following table with an explanation Sub-scenario Possible cases (e.g., (a).(b),...) 1.2 1.3 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 coordinator C and two participating sites P1 and P2: 11 P2 checks its log and then aborts. 12 P1 sends query status request to P2 and then commits. 1.3 P1 sends query status request to P2 and then waits for messages from C 14 P1 doesn't checks its log, but do T. Consider the following cases (a) P1 fails after receiving a commit message for T. (b) Pl fails after receiving an abort message for T. (c) The coordinator site for T fails before sending a commit message. (d) P1 fails after sending a ready message for T, and then the coordinator site for T fails after sending a commit message Pl fails after sending a ready message for T, and at the same time, the coordinator site for T also fails. (e) For each of the recovery sub-scenarios specify a group of above cases that are possible for that sub-scenario. Your answer should be represented as the following table with an explanation Sub-scenario Possible cases (e.g., (a).(b),...) 1.2 1.3

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!

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...

Cash Flows From Working It may surprise you that there are cash flows associated with holding a job. Using the examples provided in Chapter 6, construct a simple cash flow statement and payback...

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...

answer the question clearly Implement a videogame called JavaConk, a computerised version of the game of conkers. Two round conkers should be displayed on the screen. One conker is controlled by the...

) Explain the collision detection mechanism applied in standard wired medium access control associated with CSMA and indicate why this might be unsuitable for wireless networks. [2 marks] (ii)...

) Consider integer division of one two's-complement binary number by another. Programming languages may vary in the result when one argument is negative. What differing conventions might they be...

answer the question clearly What is a hierarchical address space? Give an example of an address space which is hierarchical and one which is not. [3 marks] What is the Address Resolution Protocol?...

QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...

For monotone functions f, f0: P Q between posets (P, vP ) and (Q, vQ), let f v f(i) Prove that the binary relation v is a partial order. [3 marks] (ii) For monotone functions between posets p : P 0...

MUST BE CORRECT ANSWERS A small software company has the following simplified cashflow, funded by shareholders' equity of 20,000 and a bank overdraft of 5000: Invoiced money received 2 months after...

Part A Henry Ford had some innovative ideas about costs and pricing. Discuss these ideas in the context of modern manufacturing.

Find the x-values at which f is not continuous. Which of the discontinuities are removable? (Enter your answers from smallest to largest. Enter NONE in any unused answer blanks.) + 0/1 points |...

22. Recently, Verizon Wireless ran a pricing trial in order to estimate the elasticity of demand for its services. The manager selected three states that were representative of its entire service...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Suppose that you are president of a newly established local union about to bargain with an employer for the first time. List the basic areas you want covered in the work agreement. Why might you...

Suppose Ann and Becky are applicants to your university and that they have identical admission qualifications (SAT scores, high school GPA, etc.). Ann, who is African American, grew up in a public...

KEY QUESTION The labor demand and supply data in the following table relate to a single occupation. Use them to answer the questions that follow. Base your answers on the taste-for-discrimination...