The following is only my opinion, what is yours?
I really detest using of euphemisms in Computer Science to describe poor practices. Equally question the wisdom of using performance to justify poor practices.
Not a distant third, using the existence of a blog to support questionable database solutions.
"Denormalized" is a misused euphemism. It may mean an "OK" design( < 3% denormalized) or a "trashed" (lack of) design (>30% denormalized).
I always get irritated when I read the great wisdom: "First we design 3NF, then we denormalize for performance."
There are other considerations besides performance such as data integrity and maintainability of data and design. In addition performance objectives can be met by other means. In star-schema data warehousing we use flat (not normalized) dimension design
for the reason of performance. But a DW database is based on second-hand data, it is a static database, unlike a dynamic OLTP database!
Would you see that many di
View Complete Post