SHSubjectHub

Client-Server Databases & Concurrency Control

AQA 75174.10.5A-levelLesson packSubscription
Also online

This worksheet marks itself

Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.

  • 9 questions
  • 38 marks
  • about 50 minutes
  • marked instantly

Question types: multiple choice, short answer, multi-part, matching, ordering.

Try it with a class, freeHow it works

About this resource

AQA A-level Computer Science (7517) Paper 2, 4.10.5 — client-server database systems providing simultaneous access to multiple clients; the need to control concurrent access to preserve database integrity; the lost update problem; and the concurrency control techniques of record locks, serialisat…

21 slides.

Lesson outline

  1. Do Now — Retrieval from 4.10c
  2. Quick Check — Everyday 'Lock' vs Technical 'Lock'
  3. Client-Server Databases: Simultaneous Access
  4. Hinge Check — Does More Clients Mean Guaranteed Corruption?
  5. The Lost Update Problem
  6. Hinge Check — What Actually Causes the Lost Update?
  7. Sequence the Lost Update
  8. I-Do: Record Locks Prevent the Lost Update
  9. Hinge Check — Are Record Locking and Serialisation the Same Thing?
  10. Serialisation, Timestamp Ordering & Commitment Ordering
  11. Hinge Check — Timestamp Ordering Basics
  12. True or False: Concurrency Control
Unit bundlePaper 2
Part of: Paper 2: the whole unitEvery resource in the unit in one zip.

More from 4.10 Fundamentals of databases