in Databases
638 views
0 votes
0 votes
Explain the phantom phenomenon. Why may this phenomenon lead to an incorrect concurrent execution despite the use of the two-phase locking protocol ?
in Databases
638 views

2 Answers

1 vote
1 vote

 

Why may this phenomenon lead to an incorrect concurrent execution despite the use of the two-phase locking protocol?

The phantom phenomenon arises when two transaction logically conflict even though they do not lock a common data item.

This usually happens due to insertion or deletion...

by
0 votes
0 votes
Phantom Read occurs when two same queries are executed, but the rows retrieved by the two, are different. For example, suppose transaction T1 retrieves a set of rows that satisfy some search criteria. Now, Transaction T2 generates some new rows that match the search criteria for transaction T1. If transaction T1 re-executes the statement that reads the rows, it gets a different set of rows this time.

Related questions