|
 |
| 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 Concurrency Control
|
|
 |
| Slide 8:
Model 204 Data Structures Protected by Concurrency Control
|
|
 |
| 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 Conflicts
|
|
 |
| 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 (Improved)
|
|
 |
| Slide 22:
Setting MAXSPINS
|
|
 |
| Slide 23:
MP Locks Practical Advice
|
|
 |
| Slide 24:
Complex File Related Structures with Concurrency Issues
|
|
 |
| Slide 25:
Complex File Related Structures with Concurrency Issues
|
|
 |
| Slide 26:
Complex File Related Structures Concurrency Issues
|
|
 |
| 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 Resources
|
|
 |
| Slide 32:
How Updaters Get Nailed by Critical FIle Resource Waits
|
|
 |
| 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 ?
|
|
