Computer Science / Unit 8 CS 0428 short lesson, about 20 seconds
Denormalization
Captions available
The idea
Denormalization deliberately adds redundant data — extra attributes, new tables, copies — to decrease query running time by making data more accessible.
In practice
A leaderboard storing each player's name beside every score answers faster than one that must go asking.
Where people slip
The redundancy is intentional and budgeted, or it is a mistake.
Your place on the trail
Every lesson rests on earlier ones and opens later ones. Tap any to jump.
Builds on
Unlocks
Something wrong in this lesson? Flag it · Sources for Computer Science