3 votes 3 votes Draw the polygraph and explain whether it is view-serializable or not? Databases view-serializable databases serializability + – shashank023 asked Jul 24, 2017 edited Jun 26, 2019 by Cristine shashank023 572 views answer comment Share Follow See 1 comment See all 1 1 comment reply pawan kumarln commented Jul 24, 2017 reply Follow Share https://gateoverflow.in/9429/problem-on-view-serializability 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes It's not view serializable schedule because if we consider T1->T2 then we lose Last Updated By, and if we consider T2->T1 then we lose Initial Read on x. Manu Thakur answered Jul 24, 2017 Manu Thakur comment Share Follow See all 6 Comments See all 6 6 Comments reply Show 3 previous comments Manu Thakur commented Jul 25, 2017 reply Follow Share It's not view serializable schedule because if T1->T2 then we will lose W-R sequence, T2 will read value of x updated by second write not the first write. and if T2->T1 then T2 will read initial value of x. Hence it's not view serializable schedule. 2 votes 2 votes shashank023 commented Jul 25, 2017 reply Follow Share ok now its clear Thanks manu00x 0 votes 0 votes dharmesh7 commented Jan 6, 2019 reply Follow Share @Chhotu @Shaik Masthan Can you please provide polygraph diagram for above schedule? 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes it is not view serializability because T1 starting & again T1 is updaing it form a cycle Raghava45 answered Oct 10, 2018 Raghava45 comment Share Follow See all 0 reply Please log in or register to add a comment.