Re:I Stopped Worrying and Learned to Love Denormalized Tables
by factormeta on Saturday May 13, 2023 @08:59AM
(#35927953)
One of main reason to normalize data is aim to eliminate duplication, and find "the source data" by properly designing the relationships of tables.
Which even more confusingly almost applies but the opposite way around:
> create denormalized analytics datasets on top of them
A common pattern is to have source data 'warehoused' or whatever you want to call it, and then build your, er, normalised schema on top of that.