Discussion about this post

User's avatar
Ramona C. Truta's avatar

I never tire of reading articles like this; this used to be my bread and butter, and I miss it.

A Note on the query in https://practicaldatamodeling.substack.com/i/221364335/two-one-to-many-joins-are-worse-than-one, and why it's enough to include just the `customer_id` attribute. (Also a reminder to myself to publish the experiment results on this, something we talked about during our first podcast recording take :))

https://ramonactruta.substack.com/i/165972943/a-note-for-modern-sql-users-when-the-database-is-smarter

Juha Korpela's avatar

I'd go even further with your "state the grain" advice - if you can't state the grain, your design has failed and you should just scrap it and restart.

Also, fully agreed that "deduplication" is a red flag. A total antipattern!

7 more comments...

Ready for more?