News for hackers. Stuff that matters.
Re:5NF and Database Design by abirch on Tuesday April 14, 2026 @01:57PM (#47768939)
I'm a fan of the sushi principle: raw data is better than cooked data.

Each process should take data from a golden source and not a pre-aggregated or overly normalized non-authorative source.

Re:5NF and Database Design by layer8 on Tuesday April 14, 2026 @02:14PM (#47769179)
Sometimes the role of your system is to be the authoritative source of data that it has aggregated, validated, and canonicalized.
Re:5NF and Database Design by abirch on Tuesday April 14, 2026 @02:28PM (#47769378)
This is great. Then I would consider the aggreated, validated, and canonicalized source as a Golden Source. Where I've seen issues is that someone starts to query from a nonauthoritative source because they know about it, instead of going upstream to a proper source.