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.
Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.
Learn More on Codecademy
Data Scientist: Machine Learning SpecialistMachine Learning Data Scientists solve problems at scale, make predictions, find patterns, and more! They use Python, SQL, and algorithms.
Includes 27 Courses
With Professional Certification