Sorry, I rarely do link posts, but this is a must read (even if it is old news).
It’s a tongue and cheek look at database normalization. Ironically enough, it was given as a presentation to the data storage guys over at Microsoft.
As for the author, it was none other than Pat Helland. If you aren’t familiar with him, one of his other well-known works was Life Beyond Distributed Transactions: An Apostate’s Opinion. You can find a profile of him here.
He designed the architecture for the MS DTC, the new SQL Server Broker, and spent a couple years working on the product catalog over at Amazon.
You can find the presentation slides on his blog.
Arnon had a good writeup on this over at InfoQ.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Good deal. I came across this last week when another developer suggested normalizing tagged videos in one of my applications. Of course it didn’t make sense and I knew denormalization made more sense in my case, so it was nice to read Arnon’s writeup. Um why did you move your blog to this site anyways?