3 ms·

> The data model should really always be validated by someone with more knowledge and experience. Are there resources (e.g., books) that one can get ideas abou

> The data model should really always be validated by someone with more knowledge and experience. Are there resources (e.g., books) that one can get ideas about good data modelling?

mr_gibbins 5y ago
Any database primer e.g. intro-level textbook would do, for the basics of relational integrity. But try finding a developer these days who has read a book or shows any interest whatsoever in writing SQL. Most of them just want to work with it behind an abstraction layer.
NikolaNovak 5y ago
TONS. Now, there are I feel couple of different approaches: There's data modelling from a data scientist perspective, which I have limited perspective of. But there's the meat & potatoes of data modelling from regular development / database administration perspective, and honestly any course, book or video worth its salt will start with that. Pick up any well reviewed database administration primer. You can choose any level of detail or depth. One way to get there is look at textbooks from university intro courses. I would use entity relationship or 3rd degree normalization as key words to check what depth it goes into, but I'm old and cranky so take that with a grain of salt :) e.g. https://www.coursera.org/learn/database-management https://www.coursera.org/learn/database-management
hobs 5y ago
One of my favorite books to throw out for noobs is both a pattern and antipattern book for database folks. https://www.amazon.com/SQL-Antipatterns-Programming-Pragmatic-Programmers/dp/1934356557 https://www.amazon.com/SQL-Antipatterns-Programming-Pragmati...
gglitch 5y ago
It's possibly a bit more abstract or philosophical than what you're looking for, but William Kent's _Data and Reality_ is awesome on data modelling. Discussed by Hillel Wayne at https://buttondown.email/hillelwayne/archive/why-you-should-read-data-and-reality/ https://buttondown.email/hillelwayne/archive/why-you-should-..., HN discussion at https://news.ycombinator.com/item?id=30251747 https://news.ycombinator.com/item?id=30251747.
tmaly 5y ago
There is the book Enterprise Rails that has a section on data modeling. Even if you don't use Rails, that section of the book is worth it.
panda888888 5y ago
The classic is Ralph Kimball's "The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling." Be sure you get the 3rd Edition.

> The data model should really always be validated by someone with more knowledge and experience. Are there resources (e.g., books) that one can get ideas about good data modelling?

mr_gibbins 5y ago

Any database primer e.g. intro-level textbook would do, for the basics of relational integrity. But try finding a developer these days who has read a book or shows any interest whatsoever in writing SQL. Most of them just want to work with it behind an abstraction layer.

NikolaNovak 5y ago

TONS. Now, there are I feel couple of different approaches: There's data modelling from a data scientist perspective, which I have limited perspective of. But there's the meat & potatoes of data modelling from regular development / database administration perspective, and honestly any course, book or video worth its salt will start with that. Pick up any well reviewed database administration primer. You can choose any level of detail or depth. One way to get there is look at textbooks from university intro courses. I would use entity relationship or 3rd degree normalization as key words to check what depth it goes into, but I'm old and cranky so take that with a grain of salt :) e.g. https://www.coursera.org/learn/database-management https://www.coursera.org/learn/database-management

hobs 5y ago

One of my favorite books to throw out for noobs is both a pattern and antipattern book for database folks. https://www.amazon.com/SQL-Antipatterns-Programming-Pragmatic-Programmers/dp/1934356557 https://www.amazon.com/SQL-Antipatterns-Programming-Pragmati...

gglitch 5y ago

It's possibly a bit more abstract or philosophical than what you're looking for, but William Kent's _Data and Reality_ is awesome on data modelling. Discussed by Hillel Wayne at https://buttondown.email/hillelwayne/archive/why-you-should-read-data-and-reality/ https://buttondown.email/hillelwayne/archive/why-you-should-..., HN discussion at https://news.ycombinator.com/item?id=30251747 https://news.ycombinator.com/item?id=30251747.

tmaly 5y ago

There is the book Enterprise Rails that has a section on data modeling. Even if you don't use Rails, that section of the book is worth it.

panda888888 5y ago

The classic is Ralph Kimball's "The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling." Be sure you get the 3rd Edition.