De-normalization

De-normalization is a technique to move from higher to lower normal forms of database modeling in order to speed up database access. In other words, it is a user selectivly adding back specific instances of redundant data after it has been normalized. It is used to to speed up read performance by removing joins.

A Star Schema is de-normalized: