13

I'm looking for a book/site/tutorial on best practices for relational database design, tuning for performance etc. It turns out this kind of resource is a bit difficult to find; there's a lot of "here's normalization, here's ER diagrams, have at it," but not much in the way of real examples. Anyone have any ideas?

Chris
  • 6,761
  • 6
  • 52
  • 67
eplawless
  • 4,225
  • 7
  • 34
  • 35

4 Answers4

10

Book: Database Design for Mere Mortals

Neall
  • 26,428
  • 5
  • 49
  • 48
6

Take a look at the Library of Free Data Models. There are tons of example database designs, with diagrams that cover real-world scenarios (and some just fun/funny ones as well). I haven't ever used one as-is, but it's often been handy to get an idea of how to approach the problem of mapping the needs of the situation into a data model.

J Wynia
  • 10,464
  • 4
  • 40
  • 38
2

Check out the "The Art of SQL". A pleasure to read.

Greg Mattes
  • 33,090
  • 15
  • 73
  • 105
1

Here are some resources I could find on the web. They include examples you are looking for:

Matt
  • 70
  • 6
Pascal
  • 4,127
  • 8
  • 33
  • 29