Unit X: Transaction Processing and Concurrency Control | BCA 4th Semester Database Management System (DBMS) Notes Pdf

A transaction is a sequence of one or more SQL statements that Oracle Database treats as a unit - either all of the statements are performed, or none of them are. We need transactions to model business processes that require that several operations be performed as a unit.

In this “Transaction Processing and Concurrency Control – Database Management System” you will learn about the following topics:

1. Introduction to Transaction
2. Operations of Transaction
3. ACID Properties of Transaction
4. Atomicity, Consistency, Isolation, Durability
5. States of Transaction
6. Active State, Partially Committed, Committed, Failed State, Aborted
7. Transaction Schedule
8. Serial Schedule, Non-serial Schedule, Serializable Schedule
9. Serializability
10. Conflict Serializable Schedule
11. Conflicting Operations
12. Conflict Equivalent
13. View Serializability
14. View Equivalent
15. Recoverability of Schedule
16. Irrecoverable Schedule
17. Recoverable With Cascading Rollback
18. Log-Based Recovery
19. Recovery Using Log Records
20. Checkpoint
21. Deadlock in DBMS
22. Concurrency Control
23. Problems of Concurrency Control
24. Lost Update Problem, Dirty Read, Inconsistent Retrievals Problem
25. Concurrency Control Protocol
26. Lock-Based Protocol
27. Types of Lock Protocols
28. Simplistic Lock Protocol, Pre-claiming Lock Protocol, Two-Phase Locking (2PL), Strict Two-Phase Locking (Strict-2PL)
29. Timestamp Ordering Protocol
30. Validation Based Protocol
31. Thomas Write Rule
32. Multiple Granularity

==== Point to Note ====

This article Transaction Processing and Concurrency Control – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at [email protected].

See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students to excel.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester Database Management System (DBMS) Notes Pdf:

• Unit I: Introduction To Database Management System (DBMS)
• Unit II: Data Models
• Unit III: Relational Model
• Unit IV: Relational Database Query Languages
• Unit V: Database Constraints and Relational Database Design
• Unit VI: Database Security
• Unit VII: Query Processing
• Unit VIII: File Organization and Indexing
• Unit IX: Crash Recovery
• Unit XI: Advanced Database Concepts