Re:Do We Still Have to Denormalize? Have Your Schema and Sea...
by dam_jackalopes on Monday November 16, 2026 @02:15PM
(#50521683)
I manage a pretty heavily denormalized data warehouse and it works pretty well for us, but we have individuals in the org making noise about wanting functionality to write back to the apps. Having to explain why this "simple" functionality will cause significant heartburn to our analytics team isn't at all fun.
At least I didn't design the thing so I have someone to shake my fist at.
You _can_ take this approach on a read-heavy db, but depending on your usecase you are going to struggle with updates and writes.