Ask HN: What are some examples of good database schema designs?

Re:Ask HN: What are some examples of good database schema de... by coltnz on Friday February 14, 2020 @04:43AM (#22325235)

I've been using Len Silverstein's Universal Data Models for 15 years. You'll be writing to lots of tables and will want views for your common aggregates. But you'll have the common tables you'll need, the patterns for those you don't and be able to handle new requirements with minimal change.

There is no Customer table.

"The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises"

[ Parent | on HN ]

Re:Ask HN: What are some examples of good database schema de... by deepaksurti on Friday February 14, 2020 @05:15AM (#22325380)

>> "The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises"

[1] https://www.wiley.com/en-us/The+Data+Model+Resource+Book%2C+...

[ Parent | on HN ]

Re:Ask HN: What are some examples of good database schema de... by davidw on Friday February 14, 2020 @12:04PM (#22328137)

As per my comment elsewhere, this open source project implements a lot of that book (I can second the recommendation):

https://ofbiz.apache.org/

[ Parent | on HN ]

Re:Ask HN: What are some examples of good database schema de... by felixyz on Friday February 14, 2020 @06:24AM (#22325693)

In a similar vein, I recommend David Hay's "Data Model Patternns: Conventions of Thought". It's more focused on the concept model side, but with awareness of how models are implemented in db schemas and the trade-offs involved.

[ Parent | on HN ]