What is a Database Transaction?
Whenever information or data is stored, manipulated, or “managed” in a database, the operation is considered to be a database transaction. The term indicates that there has been work accomplished within the database management system or in the database itself. In order to ensure security, a database transaction occurs separately from other transactions within the system to ensure that all information stored remains accessible, secure, and coherent.
The idea of conducting transactions with a database rises from the need to provide the end-user or administrator with a means to cohesively and coherently transfer information in a secure manner that is not corrupted by potential system failures. The core properties of database transactions are: atomic, coherent, isolated, and durable, or ACID for short. If a database transaction fails, it will have no impact on the information stored in the database to help ensure these core properties are met.