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.

Transaction Processing and Concurrency Control – Database Management System

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: