AI engineering glossary · SQL databases
What is non-repeatable read?
Non-repeatable read: An anomaly where a transaction reads the same row twice and gets different values because another transaction committed a change in between. Repeatable read isolation prevents it. It affects a single row read twice.
Non-repeatable read: an example
A report reads a product price as ₹100, another user updates it to ₹120, and the report's second read shows ₹120.
Related terms
More SQL databases terms
- Normalization
- NoSQL
- NOT NULL
- NULL
- Object-relational mapper
- One-to-many relationship
- ORDER BY
- Parameterised query
Where you learn it
Non-repeatable 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.