Denormalization is the process of storing redundant data in a
relational database.
Database designers often denormalize data for performance
? reasons.
Doing this at the logical level can easily break the consistency of the data (see
ACID properties);
however, you can safely denormalize at the physical level with an
SQL indexed view and let the
database management system handle updating it when the tables change.
note from Damian Yerrick:
When Everything2 comes back up, I'll copy my better writeup from there to here.