Chapter 18 Concurrency Control Techniques Database Concurrency Cont
Chapter Concurrency Control Techniques Database Concurrency Control Purpose Concurrency Control Enforce Isolation Through Mutual Exclusion Among Conflicting Transactions Preserve Database
File analysis & info
File type
Author
JVMNumber of pages
44
Version
1.3.2
Creation date
Mon Mar 18 2024
Modification date
Wed Nov 07 2012
Language
English
Word count
102
Charachter count
821
Downloadable
Yes
Editable
No
Keywords
Chapter 18 Concurrency Control Techniques Database Concurrency Cont
Views: 58
Size: 2589 Kb
Downloads: 0
Likes: 0
Share with your friends
Suggested reads
Leave a comment
Content breakdown
Chapter 18 Concurrency Control Techniques Database Concurrency Control ➲ 1 Purpose Of Concurrency Control To Enforce Isolation Through Mutual Exclusion Among Conflicting Transactions To Preserve Database Consistency Through Consistency Preserving Execution Of Transactions To Resolve Read Write And Write Write Conflicts ➲ Example In Concurrent Execution Environment If T 1 Conflicts With T 2 Over A Data Item A Then The Existing Concurrency Control Decides If T 1 Or T 2 Should Get The A And If The Other Transaction Is Rolled Back Or Waits Chapter 18 Outline Databases Concurrency Control 1 Purpose Of Concurrency Control 2 Two Phase Locking 3 Limitations Of CC Ms 4 Index Locking 5 Lock Compatibility Matrix 6 Lock Granularity Database Concurrency Control Two Phase Locking Techniques Locking Is An Operation Which Secures A Permission To Read B Permission To Write A Data Item For A Transaction Example Lock X Data Item X Is Locked In Behalf O
Loading content...