Reddit reviews The Data Model Resource Book, Vol. 3: Universal Patterns for Data Modeling

I'm currently working through this one: https://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0470178450/ref=sr_1_12?keywords=data+modeling&qid=1572274601&sr=8-12

​

It's pretty long... but has some interesting points. Idk if it's a "good" or "recommended" book to be honest. I kinda just picked one since I wasn't able to find a consistent answer on what books were suggested for solidifying data modeling.

One thing is that this book really forces you to think about how to break apart and modularize them so they are flexible enough to cover _many_ use cases.

For your particular application I would look at OpenStreetMaps. Otherwise...

David Hay's

• [Enterprise Model Patterns][1]. This is a beast of a book, but has some great patterns.
  
• [Conventions of Thought][2]. More stuff on MRP.
  
• [A Meta-Data Map][3] . Haven't read this one.
  
  Len Silverston's
  
  
• [Data Model Resource Book Vol. 1][4]. Your main data model patterns.
  
• [Data Model Resource Book Vol. 2][5]. Case studies by industry.
  
• [Data Model Resource Book Vol. 3][6]. A deeper explanation of Vol 1.
  
  Michael Blaha's [Patterns of Data Modeling][7]. This one has some interesting temporal, graph, and tree models.
  
  Martin Fowler's [Analysis Patterns][8]. This one skims some of the other patterns, but gives accounting a solid treatment.
  
  They are all well-rated, and I have read all but one, and they are all very good. Several of them are available on [safaribooksonline][9].
  
  Also, OASIS's [Universal Business Language][10], schemas
  
  
  [1]: http://www.amazon.com/Enterprise-Model-Patterns-Describing-Version/dp/1935504053/ref=sr_1_1?s=books&ie=UTF8&qid=1346950468&sr=1-1&keywords=enterprise%20model%20patterns
  [2]: http://www.amazon.com/Data-Model-Patterns-David-Hay/dp/0932633749/ref=pd_sim_b_2?ie=UTF8&refRID=1PQPGE4E6T2RPR2XTN80
  [3]: http://www.amazon.com/Data-Model-Patterns-Metadata-Management/dp/0120887983/ref=pd_sim_b_3?ie=UTF8&refRID=1PQPGE4E6T2RPR2XTN80
  [4]: http://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0471380237/ref=pd_sim_b_3?ie=UTF8&refRID=08T9TEZJNZM2EMKZV3AB
  [5]: http://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0471353485/ref=pd_sim_b_3?ie=UTF8&refRID=1D5TDG7479G7TQMBPNWF
  [6]: http://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0470178450/ref=pd_sim_b_4?ie=UTF8&refRID=08T9TEZJNZM2EMKZV3AB
  [7]: http://www.amazon.com/Patterns-Modeling-Emerging-Directions-Applications/dp/1439819890/ref=sr_1_1?s=books&ie=UTF8&qid=1346950554&sr=1-1&keywords=patterns%20of%20data%20modeling
  [8]: http://www.amazon.com/Analysis-Patterns-Reusable-Object-Models/dp/0201895420/ref=sr_1_1?s=books&ie=UTF8&qid=1346961699&sr=1-1&keywords=analysis+patterns
  [9]: http://my.safaribooksonline.com/search?q=data%20model
  [10]: http://en.wikipedia.org/wiki/Universal_Business_Language
  

I highly recommend http://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0470178450/ref=sr_1_2?ie=UTF8&qid=1458584943&sr=8-2&keywords=universal+data+models

It's a deep dive, you will learn a lot. Most DBAs (I'm looking at you, Oracle consultants,) don't know these patterns for database design very well, if at all.