Ch 12 Concurrency Control

Chapter Concurrency Control Techniques Database Concurrency Control Purpose Concurrency Control Enforce Isolation Through Mutual Exclusion Among Conflicting Transactions Preserve Database

File analysis & info

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...