Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Unanswered: Flattening the data (denormalizing)

    Hello all,

    What are the considerations to take if i have to flatten (denormalize) the data?

    Is there any guidelines or documentation available in net?

    Any lead on this is highly appreciated.

    Thank you,
    Venugopal

  2. #2
    Join Date
    Dec 2003
    Posts
    5

    Re: Flattening the data (denormalizing)

    Hi Venugopal,

    The decision to denomalise and which columns to include / repeat depends on the kind of queries you would run on your data. The aim should be to minimise joins to improve performance.

    You might want to also revise the rationale for the normal forms once, to decide your candidates for denormailsation and the type of denormalisation to be applied to each.

    Regards.

  3. #3
    Join Date
    Sep 2003
    Posts
    364
    Here's another trick (see link) you can try before denormalising along:

    http://www.sqlservercentral.com/colu...dexedviews.asp

    Also take a look at these articles,

    http://dmreview.com/master.cfm?NavID=193&EdID=5251

    http://dmreview.com/master.cfm?NavID=55&EdID=5337

Posting Permissions

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