Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    70

    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.

    Thanks

  2. #2
    Join Date
    Nov 2005
    Posts
    4

    Good DB design book

    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

    Paperback, 448 pages, publication date: MAR-2007
    ISBN-13: 978-0-12-369389-1
    ISBN-10: 0-12-369389-6

    Series: The Morgan Kaufmann Series in Data Management Systems

    Link on Amazon:
    http://www.amazon.com/Physical-Datab.../dp/0123693896

    Link on the publisher's web site:
    http://www.elsevier.com/wps/find/boo...on#description

    There's a companion book that focuses on logical design. A classic, already in its 4th edition. If you search Amazon.com for "database lightstone" you'll see both books.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    http://www.databasedesign-resource.com/index.html

    and his blog

    http://blogs.ittoolbox.com/database/design

    are good ..

    Fabian Pascal's Practical Issues in Database Management is an interesting read as well.

    Sathyaram
    Last edited by sathyaram_s; 03-28-07 at 18:28.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Jan 2004
    Posts
    70
    Sorry for the late reply, this was put on the backburner. Thanks for the suggestions. I'm more interested in logical design. Just subscribed to databasedesign-resource.com Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •