Book recommendations for designing databases?

This is a discussion on Book recommendations for designing databases? within the General Discussions forums, part of the Community Boards category; Any good book recommendations for designing an SQL database for a website? I'm not a complete novice on the issue, ...

  1. #1
    l'Anziano DavidP's Avatar
    Join Date
    Aug 2001
    Location
    Plano, Texas, United States
    Posts
    2,738

    Book recommendations for designing databases?

    Any good book recommendations for designing an SQL database for a website? I'm not a complete novice on the issue, of course. I have SQL experience and have done quite a bit of web development, but I am currently working on a web project and am having trouble designing a good scalable database for the site.
    My Website

    "Circular logic is good because it is."

  2. #2
    C++ Witch laserlight's Avatar
    Join Date
    Oct 2003
    Location
    Singapore
    Posts
    21,725
    Quote Originally Posted by DavidP
    Any good book recommendations for designing an SQL database for a website?
    I must point out that this is rather vague: a website might not even need a database, or it might need a database to compete with the likes of say, Facebook, Google, etc.

    Quote Originally Posted by DavidP
    I'm not a complete novice on the issue, of course. I have SQL experience and have done quite a bit of web development, but I am currently working on a web project and am having trouble designing a good scalable database for the site.
    I might suggest Beginning Database Design: From Novice to Professional by Clare Churcher. Even if it turns out to be too much of a beginner's book for you, at least you would get a refresher in the basics.
    C + C++ Compiler: MinGW port of GCC
    Version Control System: Bazaar

    Look up a C++ Reference and learn How To Ask Questions The Smart Way

  3. #3
    (?<!re)tired Mario F.'s Avatar
    Join Date
    May 2006
    Location
    Portugal
    Posts
    7,467
    Over the years I've always fell back to Mastering SQL by Martin Gruber, Sybex. It's a 1,000 page book on everything SQL and database design. Other books try to do the same thing, but in my opinion none so comprehensively and with such a broad scope (note the title) as this book.

    Other than the one above, two other books have been inspirational/instrumental in my understanding of the relational model and how to best apply it:

    Data Model Patterns, Conventions of Though by David C. Hay, Dorset House. It's to database what Design Patterns is to software engineering. There's a slight exaggeration in there, but you get the gist.

    Trees and Hierarchies in SQL for Smarties by Joe Celko, Elsevier. It gets you into highly productive designs to better represent data structures and relationships that are hard to represent in relational database.

    I never bought any other SQL book than those three.
    The programmer’s wife tells him: “Run to the store and pick up a loaf of bread. If they have eggs, get a dozen.”
    The programmer comes home with 12 loaves of bread.


    Originally Posted by brewbuck:
    Reimplementing a large system in another language to get a 25% performance boost is nonsense. It would be cheaper to just get a computer which is 25% faster.

  4. #4

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. need book recommendations
    By mdennis10 in forum Windows Programming
    Replies: 9
    Last Post: 05-16-2011, 01:40 PM
  2. Book recommendations
    By davidjg in forum General Discussions
    Replies: 0
    Last Post: 04-02-2011, 09:32 AM
  3. Book Recommendations :D
    By jsewell94 in forum C++ Programming
    Replies: 4
    Last Post: 11-27-2010, 12:38 PM
  4. C# Book Recommendations
    By scycon in forum C# Programming
    Replies: 1
    Last Post: 04-28-2009, 06:52 PM
  5. C# book recommendations
    By ChaosEngine in forum C# Programming
    Replies: 1
    Last Post: 07-07-2007, 01:09 PM

Tags for this Thread


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21