1 votes 1 votes I had a doubt. In the case of lost update problem (special case of write – write problem, where a transaction commits to a blind write and the other transaction rollsback without commiting) , is the schedule recoverable or not?? Databases transaction-and-concurrency databases + – Rutuja Desai asked Dec 2, 2021 Rutuja Desai 705 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes In the case of lost update problem (special case of write – write problem, where a transaction commits to a blind write and the other transaction rollsback without commiting) , is the schedule recoverable .... Schedules in which transactions commit only after all transactions whose changes they read commit are called recoverable schedules... Concurrency control is the process of managing simultaneous execution of transactions (such as queries, updates, inserts, deletes and so on) in a multiprocessing database system without having them interfere with one another. This property of DBMS allows many transactions to access the same database at the same time without interfering with each other... The primary goal of concurrency is to ensure the atomicity of the execution of transactions in a multi-user database environment... Concurrency controls mechanisms attempt to interleave (parallel) READ and WRITE operations of multiple transactions so that the interleaved execution yields results that are identical to the results of a serial schedule execution…. The five concurrency problems that can occur in database are: (i). Temporary Update Problem (ii). Incorrect Summary Problem (iii). Lost Update Problem (iv). Unrepeatable Read Problem (v). Phantom Read Problem 1. https://gateoverflow.in/240287/Transaction-cascadeless 2. https://gateoverflow.in/102090/Dbms-schedules-lost-update-vs-ww-conflict 3. https://gateoverflow.in/191804/Database-question-transactions 4. https://gateoverflow.in/17082/Difference-between-strict-schedule-cascadeless-schedule?show=17085#a17085 aaa 1 answered Dec 2, 2021 aaa 1 comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Yes it is recoverable. No dirty read is sufficient condition for schedule to be recoverable i.e if no dirty read exits then it is recoverable schedule but if dirty read exists it may or may not be recoverable. aaaakash001 answered Nov 21, 2022 aaaakash001 comment Share Follow See all 0 reply Please log in or register to add a comment.