News for hackers. Stuff that matters.
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.