Published Jun 9, 2022
Contribute to Docs

A transaction is an encapsulated set of instructions sent to a database that must happen as a unit. If something interrupts the transaction, such as an error, none of the instructions in the transaction occur. This ensures that there are never any partially executed transactions.

Transactions are used to preserve the consistency of a database, so that execution of a complex process, such as debiting one account and crediting another, is never partially completed. In the prior example, without transactions, an error or a resource lock could leave the first account debited without making the corresponding credit. Transactions adhere to ACID properties in order to ensure this doesn’t happen.

All contributors

Looking to contribute?

Learn More on Codecademy