News for hackers. Stuff that matters.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by OJFord on Saturday May 13, 2023 @07:15AM (#35927305)
There was me assuming it was about normal form, you know, what everyone else means when they talk about 'normalising' in a database context...

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.

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.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by OJFord on Saturday May 13, 2023 @09:09AM (#35928013)
By source data I meant as originally supplied, that's perhaps not normal and which you have no control over.