denormalization


denormalization

A relational database design that duplicates data in the tables for enhanced performance. Normalization eliminates redundancy, which although efficient for storage can slow down certain kinds of queries. For faster lookups, denormalization adds redundant data in multiple tables or uses redundant tables. See normalization.