|
 |
| Slide 1: Alex Kodat |
|
 |
| Slide 2: Some Key Terms |
|
 |
| Slide 3: Concurrency Control |
|
 |
| Slide 4: Protecting Integrity of Data Structures |
|
 |
| Slide 5: Preventing View of Incomplete Update |
|
 |
| Slide 6: Concurrency Control Objectives |
|
 |
| Slide 7: Model 204 Data Structures Protected by Concurre
|
|
 |
| Slide 8: Model 204 Data Structures Protected by Concurre
|
|
 |
| Slide 9: Disk Buffer Monitor Concurrency Controls |
|
 |
| Slide 10: Disk Buffer Monitor Page Level Controls |
|
 |
| Slide 11: Disk Buffer Monitor Page Level Controls |
|
 |
| Slide 12: DKBM Hash Table |
|
 |
| Slide 13: DKBM Updated Page Queues |
|
 |
| Slide 14: DKBM Re-use Queue |
|
 |
| Slide 15: MP Locks |
|
 |
| Slide 16: MP Locks - When Things Work Well - No Conflict
|
|
 |
| Slide 17: When MP Lock Conflict Happens |
|
 |
| Slide 18: MP Locks - When Things Go Wrong - Conflicts |
|
 |
| Slide 19: When MP Lock Conflicts Happen |
|
 |
| Slide 20: MP Lock Improvement In Model 204 4.1 |
|
 |
| Slide 21: MP Locks - When Things Go Wrong - Conflicts (I
|
|
 |
| Slide 22: Setting MAXSPINS |
|
 |
| Slide 23: MP Locks Practical Advice |
|
 |
| Slide 24: Complex File Related Structures with Concurren
|
|
 |
| Slide 25: Complex File Related Structures with Concurren
|
|
 |
| Slide 26: Complex File Related Structures Concurrency Is
|
|
 |
| Slide 27: Protecting Complex File Related Structures |
|
 |
| Slide 28: Critical File Resources |
|
 |
| Slide 29: Critical File Resources |
|
 |
| Slide 30: Critical File Resources |
|
 |
| Slide 31: How Updaters Get Nailed by Critical File Resou
|
|
 |
| Slide 32: How Updaters Get Nailed by Critical FIle Resou
|
|
 |
| Slide 33: Protecting Updaters from CFR Problems |
|
 |
| Slide 34: The Direct Resource |
|
 |
| Slide 35: What to Do About Direct Resource Conflicts |
|
 |
| Slide 36: What to Do About Direct Resource Conflicts |
|
 |
| Slide 37: What to Do About Direct Resource Conflicts |
|
 |
| Slide 38: The Index Resource |
|
 |
| Slide 39: What to Do About Index Resource Conflicts |
|
 |
| Slide 40: Exists Resource |
|
 |
| Slide 41: Recenq resource |
|
 |
| Slide 42: Recenq resource |
|
 |
| Slide 43: Recenq resource |
|
 |
| Slide 44: What to Do About Recenq Resource Conflicts |
|
 |
| Slide 45: What to Do About Recenq Resource Conflicts |
|
 |
| Slide 46: Critical File Resources - General Concepts |
|
 |
| Slide 47: Other File Level Locks |
|
 |
| Slide 48: The Update Resource |
|
 |
| Slide 49: The Update Resource |
|
 |
| Slide 50: The Update Resource at Low Load |
|
 |
| Slide 51: Update Resource at Low Load |
|
 |
| Slide 52: The Update Resource at High Load |
|
 |
| Slide 53: The Update Resource at High Load |
|
 |
| Slide 54: The Update Resource at High Load |
|
 |
| Slide 55: The Update Resource at High Load |
|
 |
| Slide 56: The DKUPDTWT Parameter |
|
 |
| Slide 57: The DKUPDTWT Parameter |
|
 |
| Slide 58: The File Resource |
|
 |
| Slide 59: FPL Lock |
|
 |
| Slide 60: Procedure Locks |
|
 |
| Slide 61: Record Locks |
|
 |
| Slide 62: Huff, puff... questions, comments ? |
|
