What would you consider to be essential reading for database design?

Question

Aside from a foundational understanding of database operations I really lack the proper knowledge to make proper design descisions for my databases and aplications that interact with those databases. There arent many people at my company that are particularly wise when it comes to this topic and it feels like we are really missing out on some really simple improvements just because we are oblivious to them.Are there any recommedations for essential reading or proper practice guides for improving database skills? I'm reading 'Database Internals' by Alex Petrov and its really interesting so far but not so practically applicable for me at the moment. It would be great to hear any resources that made a real impact on how you went about working with databases.I'm mainly interested in SQL databases but resources on no-SQL would be welcome too.

tuatoru · Accepted Answer

Data and Reality, by William Kent. Earliest edition you can find.For general database design, Stephane Faroult is good. Although he comes from an Oracle background, and underuses domains as a result.Rules of thumb: use up to 30 indexes per table, use views extensively, use schemas to manage access permissions. Use stored procedures for updates.Don't let applications see tables: they should see views only.

hukuuu · Answer

Hands down -> https://dataintensive.net/

gregjor · Answer

All of Chris (C. J.) Date's books.

aintmeit · Answer

I agree with the suggestion Data and Reality. Also, just reality.