1 votes 1 votes Essential differences in the Lock based Protocols and Time-stamp based proctols? Databases databases transaction-and-concurrency + – LavTheRawkstar asked Mar 17, 2017 LavTheRawkstar 3.1k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
2 votes 2 votes There can be Deadlock in case of Lock based protocol whereas Time stamp based protcols are free from this. akash.dinkar12 answered Mar 17, 2017 akash.dinkar12 comment Share Follow See all 0 reply Please log in or register to add a comment.
2 votes 2 votes 2 phase locking protocol (Simple) :- Deadlock and cascade rollback There are various version 2PL :- Strict, Conservative and rigirous Timestamping protocol :- Free from deadlock but starvation may occur utk0203 answered Mar 17, 2017 utk0203 comment Share Follow See all 3 Comments See all 3 3 Comments reply LavTheRawkstar commented Mar 17, 2017 reply Follow Share how starvation occurs give example with two transaction ? 0 votes 0 votes LavTheRawkstar commented Mar 17, 2017 reply Follow Share Can you please explain why time-stamping cannot lead to deadlock and why Locking can ? 0 votes 0 votes utk0203 commented Mar 17, 2017 reply Follow Share TS protocol doesnot lead to deadlock because Resources are assigned a number by accessing transaction , once it got incremented it will not allow less younger transaction to access it (it will simply abort) , so doesnot occurs here 2 votes 2 votes Please log in or register to add a comment.