Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 5: Consider the two transactions T1 and T2 given below, with their order of operations: ( R1 means Read of T1, W2 means Write

image text in transcribed Question 5: Consider the two transactions T1 and T2 given below, with their order of operations: ( "R1" means Read of T1", "W2 means Write of T2", etc) [15 mc (a) (b) Following are the possible different schedules of the operations for the transactions shown above. Determine which among these are; conflict serializable; not conflict serializable and which are serial. S 1: R 1 (X); W 1 (X); R 1 (Y); W 1 (Y); R 2 (X); W 2 (X); S 2 : R 2 (X); R 1 (X); W 2 (X); W 1 (X); R 1 (Y); W 1 (Y); S 3: R 1 (X); W 1 (X); R 1 (Y); R 2 (X); W 1 (Y); W 2 (X); S 4 : R 2 (X); R 1 (X); W 1 (X); R 1 (Y); W 1 (Y); W 2 (X); S 5: R 1 (X); W 1 (X); R 1 (Y); R 2 (X); W 2 (X); W 1 (Y); S 6 : R 1(X); W 1 (X); R 2 (X); R 1 (Y); W 2 (X); W 1 (Y); S 7: R 2 (X); R 1 (X); W 1 (X); R 1 (Y); W 2 (X); W 1 (Y); S 8 : R 1 (X); W 1 (X); R 2 (X); W 2 (X); R 1 (Y); W 1 (Y); S 9 : R 1 (X); R 2(X); W 1 (X); R 1 (Y); W 1 (Y); W 2 (X); S 10 : R 1 (X); R 2 (X); W 1 (X); R 1 (Y); W 2 (X); W 1 (Y); S 11 : R 1 (X); R 2 (X); W 1 (X); W 2 (X); R 1 (Y); W 1 (Y); S 12 : R 1 (X); W 1 (X); R 2 (X); R 1 (Y); W 1 (Y); W 2 (X); S 13 : R 1 (X); R 2 (X); W 2 (X); W 1 (X); R 1 (Y); W 1 (Y); S 14 : R 2 (X); R 1 (X); W 1 (X); W 2 (X); R 1 (Y); W 1 (Y); S 15 : R 2 (X): W 2 (X); R 1 (X); W 1 (X); R 1 (Y): W 1 (Y)

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

Step: 3

blur-text-image

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

Professional Microsoft SQL Server 2012 Administration

Authors: Adam Jorgensen, Steven Wort

1st Edition

1118106881, 9781118106884

More Books

Students also viewed these Databases questions

Question

1. How will you, as city manager, handle these requests?

Answered: 1 week ago