System design from first principles to design review · check

Know Data under concurrent use already?

One question for each of the 4 puzzles in this module. A right answer marks that puzzle as passed, so you can jump ahead. A wrong one tells you which puzzle to start with. Nothing is sent anywhere: it's saved in this browser.

Puzzle 3: How does the database choose a winner?

Why can a valid update affect zero rows?

Right. A successfully executed statement can match nothing.

Not quite. A successfully executed statement can match nothing. Learn it in puzzle 3 →

Puzzle 4: What if a successful reply disappears?

What identity should the phone send on retry?

Not quite. A fresh value looks like another intention. Learn it in puzzle 4 →

Right. A fresh value looks like another intention.

Puzzle 5: Where does the next page of history begin?

Why include a unique number in the cursor?

Right. The number completes the ordering.

Not quite. The number completes the ordering. Learn it in puzzle 5 →

Puzzle 6: Why does a confirmed space still look free?

What can hide a committed write?

Not quite. The copy may not have applied the change yet. Learn it in puzzle 6 →

Right. The copy may not have applied the change yet.

Back to the overview →