Unanswered: Good DB2/general relational DB design book recommendations?
I've never done any DB architecture, just maintenance type stuff. Took some relational db design classes back in college but never used what I learned in the real world so I feel like it sort of went in one ear and out the other.
Can anyone recommend a good book that would help me do a refresher? I won't have to design anything complicated. I need to go through my old text books and re-read the one from my DB class. Was just wondering if there is some must-have book that anyone knew of.
Depends what part you are working on. Database design falls into two categories - logical design and physical design. Most books discuss logical design which is really about relational modelling. There are several to choose from on that front. However, many of the hard and important problems are in the "physical design" whch including picking indexes, memory tuning, materialized views etc.
Morgan Kaufmann publishers have just released a new book on physical database design covering how to design indexes, range and hash partitioning, materialized views, storage layout, RAID, warehouse design and other physical design areas. The book covers Oracle and several other major databases. Lots of diagrams and examples. It's actually a really good book. An excellent book for people who design and administer databases.
Available on Amazon and most other book sellers.
Physical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More