hagg3n

This has always been a pet peeve of mine. Every time I had to model the database for a business I'm not familiar with I ended up wasting dozens of hours reading wikipedia and scattered blogs to get to know it, only to just scratch the surface and having to guess most of it. Sometimes I find an open source project related to the industry and that gets me going, but it's often particular to some country and lacks generality.

"But isn't it the way it's supposed to be?" you ask me. Well, kinda of. I do think to model the data for any given business you should study it a bit first. But the way I'm doing it isn't optimal at all.

If you're wondering what I mean by that I have a simple, often overlooked example: geographical addresses. If you're just addressing your own country, it's usually straightforward enough. But if you're addressing several countries oh oh. My go to reference is the Google Places API and their address components[1].

So my question is: is there a place where we gather data modelling guides for different industries? Like introduction to their workflow, so you understand how entities relate to one another and how to best split the data, and a glossary to name the fields appropriately? I know businesses work differently around the world but I also often find that the core idea and consequently its data stays largely the same.

Other industries I had to work with in the past are:

- Postal and courier services - Multi-level marketing model - Tourism - HR, recruiting and selection

For all of these I had to scramble with hundreds of Google searches to understand just enough so I could provide a decent data model. I just wish I had a guide for it.

Thanks and happy new year.

1. https://developers.google.com/places/web-service/supported_types#table2