# Database Transaction Management
## Agenda

### Transactions
- Why transactions?
- ACID properties of transactions
- Internal Transaction states
- Autocommit
- Syntax of SQL transaction control
- What about data consistency?
- Transaction Isolation Levels
- READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE
### Locking and Synchronisation
- Lock-based Concurrency Control
- Deadlock Prevention
- Two-phase locking
- Transaction Scheduling
- Database Recovery

## References

Silberschatz, Korth and Sudarshan: Database System Concepts, 7th Ed. [Chapter 18 : Concurrency Control](https://www.db-book.com/slides-dir/PDF-dir/ch18.pdf)

[Transaction Isolation Levels in DBMS](https://www.geeksforgeeks.org/transaction-isolation-levels-dbms/)

[Transactional and Locking Statements](https://dev.mysql.com/doc/refman/8.0/en/sql-transactional-statements.html)

[InnoDB Locking and Transaction Model](https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-transaction-model.html)

[Deciphering the Inner Workings of Transaction Processing in MySQL](https://medium.com/itnext/deciphering-the-inner-workings-of-transaction-processing-in-mysql-bb2f59c40bff?source=tag_recommended_feed---------16-107----------mysql----------766e7f9e_31a6_4cea_a561_86b284318890-------)

[Lock-Based Concurrency Control in Databases](https://gpttutorpro.com/lock-based-concurrency-control-in-databases/)

[Two-Phase Locking(2PL)](https://salemal.medium.com/two-phase-locking-9d71d5cd7b86)

[DBMS - Concurrency Control](https://www.tutorialspoint.com/dbms/dbms_concurrency_control.htm)

## Flashcards

[Transaction Management - AnkiWeb](https://ankiweb.net/shared/info/1406842930?cb=1738340695500)