What is a Transaction?

A transaction in a database represents a single, logical unit of work. It ensures that a series of operations either completes successfully as a whole or fails entirely, leaving the database unchanged. This concept is fundamental to maintaining the database's integrity, ensuring consistency, and allowing safe retries without side effects.

A transaction can either be:

• Committed: All operations within the transaction are successfully executed and changes are permanently saved.