Understanding Transactions in Databases

Transactions in Databases

A transaction is a collection of logically connected operations that work together to accomplish a goal, functioning as a single unit of work. It is a series of actions performed to access or modify data in a database.

DBMS Tutorial:-
SQL Tutorial:-

Real-World Example: Bank Transfer

Transferring 800 from Account X to Account Y involves several low-level steps ÔÇö reading balances, updating them, and writing back. Both the debit from X and the credit to Y must succeed together, or neither should apply.

Core Operations

• Read(X) ÔÇö retrieves the value of X from the database into a memory buffer.
• Write(X) ÔÇö writes the buffer value of X back to the database.

Example: Debit Operation

R(X)         // Read X (4000) into buffer
X = X - 500  // Update buffer to 3500
W(X)         // Write 3500 back to database

Commit and Rollback

• Commit: Permanently records all modifications made during the transaction.
• Rollback: Reverses changes, restoring data to its previous state if the transaction fails.

ACID Properties

• Atomicity: All operations complete, or none do.
• Consistency: The database moves from one valid state to another.
• Isolation: Concurrent transactions do not interfere with each other.
• Durability: Committed changes survive system failures.

Download New Real Time Projects:- Click here
Complete Python Course:-

Conclusion

Transactions group operations into reliable units. With Commit, Rollback, and the ACID properties, databases maintain accuracy and dependability even during failures. For more DBMS concepts, stay connected with .

what is transaction in database with example
properties of transaction in dbms
transaction management in dbms
acid properties in dbms
transaction states in dbms
database transaction sql
commit rollback dbms
transaction in dbms geeksforgeeks