
Data Model Patterns
by David C. Hay · first published 1995
8mentions
3recommended by
4HN commenters
2019–2021first – last mentioned
75% recommend25% neutral
Affiliate links. As an Amazon Associate I earn from qualifying purchases.




…written by Davids. 1. "Object Thinking" by David West (http://davewest.us/product/object-thinking/) 2. "Introduction to Computing" by David Evans (free PDF available: https://computingbook.org/) 3. "Data Model Patterns: Conventions of Thought" by David Hay (https://www.amazon.com/Data-Model-Patterns-David-Hay/dp/0932...). He also gives a great talk about this here: https://www.youtube.com/watch?v=fLFXewSpltw
on “Ask HN: Best book for software engineers (besides the well-known ones)?” ↗I think what's missing is something like "Data Model Patterns: A Metadata Map" by David C. Hay It's like C. Alexander's "Pattern Language" but for data models. > ...I was modeling the structure— the language —of a company, not just the structure of a database.…
on “Data-Oriented Design (2018)” ↗…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 Hay's "Data Model Patterns" is also excellent, although less concrete.
on “Ask HN: What are some examples of good database schema designs?” ↗I like this talk: "Domain Modeling Made Functional" by Scott Wlaschin https://www.youtube.com/watch?v=Up7LcbGZFuo He's working in F# but the concepts map. There's a fascinating book "Data Model Patterns: A Metadata Map" by David C. Hay that's pretty much a Pattern Language or catalog for data models. You can just implement the subset of Hay's patterns that make sense for your application.
on “Write code. Not too much. Mostly functions.” ↗Take something like the design discipline Scott Wlaschin describes in this talk "Domain Modeling Made Functional"[1]. Combine it with a catalog of standard models like David Hay's "Data Model Patterns: A Metadata Map"[2] which is like a Pattern Language for data models combined with a catalog covering most (enterprise) needs. Specify the binary formats with Erlang "bit syntax"[3]. Eh? [1] https://www.youtube.com/watch?v=Up7LcbGZFuo…
on “One Way to Represent Things” ↗…question is how to drive convergence? How to alleviate https://xkcd.com/927/ ? (The "Standards" comic.) Who shall forge the "one true ring to bind them"? - - - - Also, I think Data Model catalogs (like "Data Model Patterns: A Metadata Map" by David C. Hay) should be part of the answer. Instead of rolling your own data models you should be able to just pull models from a standard catalog. - - - - In sum, if we're lucky,…
on “Bring Your Own Client” ↗…promises. As I mentioned above, I'm working on Joy-in-Prolog, and I'm right at the point where I'm thinking about how to represent data (as in DBs) using Category Theory along with the standard meta-data in "Data Model Patterns: A Metadata Map" by David C. Hay.
on “Adventure in Prolog Tutorial (2016)” ↗Data Model Patterns looks very interesting. I just ordered a copy. What was your favorite takeaway from the book?
on “Ask HN: Best book for software engineers (besides the well-known ones)?” ↗