Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    1

    about normalization

    hi,

    i want to know that in what circumstances we do not need to normalize our tables

    thnx

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You always normalise your tables. Always.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you do not need to normalize your tables when they have only a few rows

    the definition of "a few" varies, depending on the size of your server

    a couple of hundred unnormalized rows, and you'll still be okay

    however, despite the foregoing, you should normalize anyway
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    "Always normalize, then only denormalize if necessary"

    However, data warehousing has somewhat different requirements than does an OLTP system
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I can't think of any situation where you truly have to normalize a schema.

    If you have infinite resources for problem resolution in your data (people), infinite disk for storage, infinite processing power to brute force crunch your data, and infinite memory to do the aforementioned crunching in, then there isn't much need for normalization.

    I've never been blessed with a situation like what I've described, so I tend to be rather finicky about normalization myself.

    -PatP

Posting Permissions

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