Denormalize for Simplicity: Ungood idea?
Posted
by yar
on Stack Overflow
See other posts from Stack Overflow
or by yar
Published on 2010-05-20T13:21:55Z
Indexed on
2010/05/20
13:30 UTC
Read the original article
Hit count: 245
denormalization
After reading this question, I've learned that denormalization is not a solution for simplicity. What about this case?
I have news-articles which have a list of sites-article-will-be-published-to. The latter can be expressed in normalized fashion either by table and a many-to-many relationship (via a cross-table, I think). But the simple solution is to just throw a bunch of booleans for the sites-article-will-be-published-to. Assuming the sites are:
- small in number
- will not change over time
- have no fields themselves, except a name
Is this still a terrible idea? The many-to-many relationship seems somewhat cumbersome, but I've done it before in cases like this (and it seemed cumbersome).
Note: I'm doing this in Rails, where it's not that painful.
© Stack Overflow or respective owner