Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your friend comes up with the following idea to optimize the performance of 2PC by reducing the time that transactions spend actively holding locks.

image text in transcribed

Your friend comes up with the following idea to optimize the performance of 2PC by reducing the time that transactions spend actively holding locks. In order to decide whether transaction T is ready to commit, the server checks if all the relevant locks are unlocked, but it doesn't actually lock them. If they are all unlocked, it writes Ilready TII, and responds to the coordinator with the Ilready Til message. Only when the coordinator responds with llcommit TII, does the server actually obtain the appropriate locks (using strict 2PL), execute the transaction, and finally flushes llcommit Til to the log. However, your company has an isolation requirement that conflicting transactions must always be committed in the same order across all servers in the cluster. E.g., T1 and T2 conflict, and if T1 is executed before T2 in server 1, T1 also has to be executed before T2 in server 2. Q5.1 5 Points Does the new proposal guarantee or break this isolation property? Explain your answer.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Networking A Top-Down Approach

Authors: James Kurose, Keith Ross

7th edition

978-0133594140

More Books

Students also viewed these Computer Network questions

Question

What is your greatest weakness?

Answered: 1 week ago