AI engineering glossary · SQL databases

What is atomicity?

Atomicity: The ACID property that a transaction's changes happen entirely or not at all. If any step fails, everything done so far is undone, so the database never shows half-finished work.

Level: intermediateTopic: SQL databases

Atomicity: an example

If the second of two UPDATE statements in a money transfer fails, the first is rolled back.

Related terms

More SQL databases terms

Where you learn it

Atomicity 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.