Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Posts
    7

    Question Denormalise bottle-neck

    Dear friends,

    I am developing a db which appears to have a potential bottleneck. Every person would need to access and update an indexed view based on one table. This table has is star joined to a heirachy of parent-child descriptive lookup tables. Do I de-normalise by adding a set amount of replicate tables to alleviate the bottle neck. This can work as far as the business logic. I just dont know if the db will run effectively. Please advise on standard denormalisation techniques.

    OxyJen

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    rule #1 for denormalization: don't denormalize until you have an actual performance problem, not a "potential" problem
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2006
    Posts
    7
    thankyou very much

    OxyJen

  4. #4
    Join Date
    Jul 2005
    Location
    jakarta
    Posts
    21
    This table is star joined to a heirachy of parent-child descriptive lookup tables
    this table sounds like a fact table joined by a a bunch of dimension tables. if that is true, im going to have to disagree with r937.

    #1 rule on datawarehouse: ALWAYS denormalize.

    if, however, it is just a "simple db" or an OLTP, then, by all means do not denormalize.

    HTH

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    well spotted, duul, i missed the word "star" somehow

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    May 2006
    Posts
    7
    Thanks Guys,

    I am afraid that I am a newbie and I do have star shaped detail tables with nested lookup tables. But they are not dim tables. I am using OLTP cos my clients will need to frequently update their records.

    I have reworked some of the tables so that the schema are trim.

Posting Permissions

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