The data model resource book
by Len Silverston · first published 1997
10mentions
8recommended by
10HN commenters
2012–2022first – last mentioned
80% recommend20% neutral
Why HN recommends it
Reusable data model patterns and industry case studies for enterprise databases, covering party, finance, insurance, ecommerce and data warehouses; for designers wanting proven starting points over starting fresh.
Summarised by Claude from recommending comments
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
…patterns, I recommend these: David Hay's Enterprise Model Patterns (and his earlier ones). This is a beast of a book, but has some great patterns. http://www.amazon.com/dp/1935504053/ Len Silverston's Data Model Resource Book Vols. 1, 2, 3. Good case studies by industry in the last 2 books. http://www.amazon.com/dp/0471380237/ Michael Blaha's Patterns of Data Modeling . This one has some interesting temporal, graph, and tree…
on “Show HN: create, share, explore database patterns” ↗There are three volumes of "The Data Model Resource Book" by Len Silverston, and despite being about 20 years old they remain industry best practices. All sorts of data model design patterns - insurance, ecommerce, data warehouses, party, finance, etc. David…
on “Ask HN: What are some examples of good database schema designs?” ↗…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"
on “Ask HN: What are some examples of good database schema designs?” ↗If anyone is interested, there is a 2-volume set of books called "The Data Model Resource Book". They've been around for a while, so for more traditional businesses, but very thorough and broken out by industry: http://www.wiley.com/WileyCDA/WileyTitle/productCd-047138023... http://www.wiley.com/WileyCDA/WileyTitle/productCd-047135348...
on “Design better databases” ↗>> "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+...
on “Ask HN: What are some examples of good database schema designs?” ↗Data Model Resource book by Len Silverstone. Would advise to read and understand all three volumes though.
on “Ask HN: Where to Learn Database Design?” ↗I've long recommended this book: "The Data Model Resource Book": https://amzn.to/2tXNiuF You can look at an implementation of a number of the ideas here: https://ofbiz.apache.org/ It's kind of complicated - probably overly so for some things - but there are a lot…
on “Ask HN: What are some examples of good database schema designs?” ↗The Data Model Resource Book [1] is a good resource how to design database. It is a kind of reference book [1] https://www.wiley.com/en-us/The+Data+Model+Resource+Book%2C+...
on “A humble guide to database schema design” ↗…a mess with it Yes, we needed to reinforce it at the infra/deployment level to get any meaningful separation. But as soon as a deadline looms, environments start to blur... [1] Silverston, Len. The Data Model Resource Book (Revised Edition). Volume 1. Wiley. 2001. [2] https://github.com/google/rune
on “Why Domain Driven Design?” ↗…The Oracle optimizer quits optimizing after the first ~7 joins so we had to do manual optimization after that. Almost every query was at least 7 joins. The guy running the DBA group was following the Data Model Resource Book to a "T", which I think is appropriate for an OLAP database, but is not cool for OLTP.
on “Understanding database normalisation: a very short tutorial” ↗