What is phantom read problem?

A concurrency control problem in which a transaction executes a query with record conditions but another transaction inserts new rows or modifies existing rows while the first transaction is still executing. The first transaction then reexecutes the original query again, but the results are different than the results for the first execution. The new rows are phantom because they did not exist for the first execution of the query.

Tags: Database, Education, Software

Related