17 ms·
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
by OJFord 4y ago
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.
- factormeta 4y agoOne of main reason to normalize data is aim to eliminate duplication, and find "the source data" by properly designing the relationships of tables.
- OJFord 4y agoBy source data I meant as originally supplied, that's perhaps not normal and which you have no control over.