Denormalisation
/ˌdiːˌnɔːməlaɪˈzeɪʃən/
Definition
Intentionally introducing redundancy into a database for read performance — trading consistency complexity for query speed.
Example in context
"We denormalised the order total — instead of summing line items each query, we store the pre-calculated total."
Related terms
Practice this term
Master Denormalisation in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.