News for hackers. Stuff that matters.
Re:Ask HN: Is DBA still a good job? by throw0101a on Monday May 09, 2022 @07:18AM (#31312784)
> 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?

Re:Ask HN: Is DBA still a good job? by NikolaNovak on Monday May 09, 2022 @08:18AM (#31313184)
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

Re:Ask HN: Is DBA still a good job? by gglitch on Monday May 09, 2022 @10:31AM (#31314456)
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-..., HN discussion at https://news.ycombinator.com/item?id=30251747.

Re:Ask HN: Is DBA still a good job? by hobs on Monday May 09, 2022 @09:17AM (#31313639)
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-Pragmati...
Re:Ask HN: Is DBA still a good job? by mr_gibbins on Monday May 09, 2022 @08:08AM (#31313125)
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.
Re:Ask HN: Is DBA still a good job? by panda888888 on Monday May 09, 2022 @04:33PM (#31319338)
The classic is Ralph Kimball's "The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling." Be sure you get the 3rd Edition.
Re:Ask HN: Is DBA still a good job? by tmaly on Monday May 09, 2022 @03:42PM (#31318793)
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.