DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Denormailzed columns


    what is meant by denormalized columns?
    When it's required/when we'll create it & how the values for these columns are obtained?

    Can anyone explain this concept with an example?

    Last edited by davey23uk; 12-12-2006 at 11:50 AM.

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    I'm guessing you mean to say denormalized table. An example would be for phone number. Any person can have a home, cell, work, and fax numbers. Given that the is a one to many relationship between person and phone number, you could store phone number as a separate table from person with a primary key consisting of person id, and phone number type. But doing so will require a join to bring back person and phone number, so instead you can denormalize the table by making 4 extra columns in your person table. One for each type of number that you track.
    this space intentionally left blank

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.