1 votes 1 votes What is the difference between Phantom read Problem and Unrepeatable read problem? Databases serializability + – Shubhanshu asked Apr 2, 2017 Shubhanshu 335 views answer comment Share Follow See 1 comment See all 1 1 comment reply Tesla! commented Apr 2, 2017 reply Follow Share please follow this article http://stackoverflow.com/questions/11043712/what-is-difference-between-non-repeatable-read-and-phantom-read 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes Unrepeatable Read means that when a txn 'T1' reads a data twice , the 2nd time data is changed by another Txn say T2. Phantom Read (phantom itself means smth that doesnt exist in real) means the data item gets deleted on the second read request. ianand answered Apr 3, 2017 ianand comment Share Follow See 1 comment See all 1 1 comment reply Shubhanshu commented Apr 4, 2017 reply Follow Share I got it. ur unrepeatable read is correct. but in phantom read problem the numbers of tuples in first read opr are different and the number of tuples in second read opr are different. 1 votes 1 votes Please log in or register to add a comment.