What is Denormalisation?
Deliberately adding redundant data to a database to improve read performance.
Why It Matters
Denormalisation speeds up queries by avoiding expensive joins, at the cost of some data duplication.
Real-World Example
Storing the customer name directly in the orders table so you do not need to join tables for every order listing.
“Understanding terms like Denormalisation matters because it helps you have better conversations with developers and make smarter decisions about your software. You do not need to be technical. You just need to know enough to ask the right questions.”
Related Terms
Normalisation
Organising a database to reduce redundancy by splitting data into related tables.
Database
An organised collection of data that your application can store, retrieve, and update
Query Optimisation
The process of making database queries run faster and use fewer resources.
Indexing
Creating a data structure that makes database lookups much faster, like an index in a book.
Learn More at buildDay Melbourne
Want to understand these concepts hands-on? Join our one-day workshop and build a real web application from scratch.
Related Terms
Database
An organised collection of data that your application can store, retrieve, and update
Normalisation
Organising a database to reduce redundancy by splitting data into related tables.
Indexing
Creating a data structure that makes database lookups much faster, like an index in a book.
Query Optimisation
The process of making database queries run faster and use fewer resources.
SQL
A language for communicating with databases, used to create, read, update, and delete data
NoSQL
Databases that store data differently from traditional tables, often as flexible documents or key-value pairs