Denormalization Patterns

"A denormalized database is one that has been meticulously normalized to eliminate redundancies, only to have redundancies deliberately put back in to meet other needs."

http://database-programmer.blogspot.com/2008/04/denormalization-patterns.html