We currently have some intentional denormalization in our database e.g.:
- counts such as: user reputation, article issue and follower counts, issue comment and follower counts
- nested sets
These dernormalizations are not ideal, but they make things a bit easier, and some of them are almost certainly faster.
To keep things slightly saner, the web/bin/normalize script can be used to view, check and update dernormalized data.