Data modelling - Process
Denormalisation
Deliberately duplicating some data to make reading or reporting faster and simpler
What's it for?
Makes frequently read data simpler or faster to retrieve by deliberately storing some information more than once.
For example…
A sales dashboard table keeps region name next to each deal so reports do not join five tables every morning
A reporting table stores the customer's region alongside every order so dashboards do not need an expensive join each time they run.
Think of it like…
Keeping a spare key by the front door even though there is a master set in the office — convenient, but you must update both when locks change