AI engineering glossary · SQL databases

What is dirty read?

Dirty read: An anomaly where a transaction reads changes another transaction has not yet committed, which may later be rolled back. It only occurs at the weakest isolation level. It is the weakest form of inconsistency.

Level: advancedTopic: SQL databases

Dirty read: an example

Transaction B sees a balance of ₹0 written by A, then A rolls back, and B has acted on a value that never existed.

Related terms

More SQL databases terms

Where you learn it

Dirty read is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.

Before you go

Take the cheat sheet with you

One free PDF: the key AI-engineering terms, formulas and Python idioms. No spam; unsubscribe any time.