SitePoint Sponsor

User Tag List

Results 1 to 13 of 13
  1. #1
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Database design & normalization resources

    Here are some excellent articles on database design & normalisation - most are written with Access in mind, but 99% of the principles and techniques apply to every database under the sun, so they are well worth a read no matter which DB you use!

    Understanding Relational Database Design

    <snip/>

    How the Table Analyzer Wizard Works

    Database Normalization Basics

    GeekGirls.com Database Tutorials


    Some tip-style pages:

    <snip/>

    Database Design and Modeling Fundamentals


    Does anyone else know of any quality articles/resources on these topics? Also, could one of the moderators could mark this thread "Important"? Cheers!


    M@rco

    EDIT: Added tips pages
    EDIT: Removed the mailing list links, which are now sadly deceased.

    EDIT:

    SitePoint article:
    Concepts of Database Design and Management

    Wikipedia:
    Database normalization

    Mittineague
    Last edited by Mittineague; Dec 18, 2010 at 14:42. Reason: pre-new-sticky cleanup

  2. #2
    SitePoint Evangelist cyngon's Avatar
    Join Date
    Aug 2001
    Location
    Livonia, MI, USA
    Posts
    513
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The best resource I've found for learning these topics is Part 5 (entitled "Relational Database Design") of Kevin Yank's book Building a Database-Driven Web Site Using PHP and MySQL.

    <snip/>

    -Bryan
    Last edited by Mittineague; Dec 18, 2010 at 14:35. Reason: pre-new-sticky cleanup

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,328
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)

    normalization

    there's a great normalization resource which covers data modelling and the relational model here --

    http://www.utexas.edu/its/archive/wi...ng/rm/rm7.html
    Last edited by ScallioXTX; Sep 16, 2010 at 15:14. Reason: updated link
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Addict
    Join Date
    Sep 2000
    Location
    Ontario, Canada
    Posts
    320
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I just found some good articles about normalization posted on the DevShed forums:

    <snip/>
    Last edited by Mittineague; Nov 9, 2010 at 23:27. Reason: pre-new-sticky cleanup
    Jason Dulberg
    Extreme MTB
    http://extreme.nas.net

  5. #5
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I swear by Data Modelling Essentials ( which means it's never been opened - j/king )

    But if someone knows the url for the e-book then that's a fairly good resource.

    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---

  6. #6
    SitePoint Enthusiast
    Join Date
    Jan 2003
    Posts
    38
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It is sometimes interesting to browse comp.databases.theory

    And for those who want the heavy stuff: http://www.dbdebunk.com/. This site focuses heavily on the fundamentals of relational data theory. It has good information for those interested in the serious side of database design, and also for those possibly even interested in developing database management systems themselves (one of my future dreams ).

    (WARNING: might cause you to rethink much of what you think you know about databases)

  7. #7
    SitePoint Member
    Join Date
    Feb 2003
    Location
    Groningen, Netherlands
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OOP and datamodeling: http://www.agiledata.org/

  8. #8
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    See about database design www.configure-all.com
    There is also about MySQL security

  9. #9
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Lots of database design and normalization articles here:

    http://www.databasedev.co.uk/general.html

  10. #10
    SitePoint Member
    Join Date
    Jan 2007
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Didn't see this in the thread, but I found it in another thread. Amazing list of data model samples for many different applications

    http://www.databaseanswers.org/data_models/index.htm

  11. #11
    SitePoint Enthusiast
    Join Date
    Apr 2008
    Location
    Morristown, NJ
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I know this thread is a bit dated, but I do have a very pertinent article on this subject, and good database design never goes out of style:

    http://www.barrywise.com/2008/01/dat...gn-techniques/

  12. #12
    SitePoint Member WeatherSquareCom's Avatar
    Join Date
    Sep 2008
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm a believer in normalizing to 3NF then turn around and denormilize for performance. Don't get to caught up in the "rules".

    http://blog.makezine.com/archive/200...normalize.html
    Sort of shares my belief.
    Last edited by ScallioXTX; Sep 16, 2010 at 15:27. Reason: updated URL

  13. #13
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,328
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    nice link, weathersquare

    i should like to suggest that the correct strategy is as follows:
    normalize to 3NF and then stop

    don't denormalize right away -- that'd be silly

    wait until you hit a few million rows

    this strategy is completely supported by that article:
    Only when you find there are performance problems do you need to think about optimizing. Usually this can be accomplished through smarter querying. When it cannot, you derive a denormalized data set from the normalized source.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

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