In this lecture we look at...
[Section notes PDF 86Kb]
- 4.1.01. Distributed Databases
- 4.1.02. Transactions
- 4.1.04. Desirable properties of transactions
- 4.1.05. ACID test continued
- 4.1.06. Commit
- 4.1.07. PL/SQL overview
- 4.1.08. PL/SQL
- 4.1.09. Declaration
- 4.1.10. Execution
- 4.1.11. Exception passing
- 4.1.12. Exception handling
- 4.1.13. Cursors
- 4.1.14. Impact
- 4.1.15. PL Cursors
- 4.1.16. Cursors execution
- 4.1.17. Concurrency Introduction
- 4.1.18. Notation
- 4.1.19. Transaction processing
- 4.1.20. Transactions
- 4.1.21. Concurrency issues
- 4.1.22. Lost update
- 4.1.23. Dirty read (or Temporary update)
- 4.1.24. Incorrect summary
- 4.1.25. Serializability
- 4.1.26. Serializability
- 4.1.27. Distribution
- 4.1.28. Advantages
- 4.1.29. Fragmentation
- 4.1.30. Concurrency control in DDBs
- 4.1.31. Distributed commit
- 4.1.32. Query processing
- 4.1.33. Concurrency control
- 4.1.34. Definition of terms
- 4.1.35. Definition
- 4.1.36. Rules of Multimode locks