Results 1 to 4 of 4

Thread: Denormalisation

  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Denormalisation

    hi there i am doing an assignment about denormalisation and am unable to find much about it and was wondering if any1 knew something about it. i also need to find the drawbacks and benefits of denormalisation

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    When you normalize a database down to third normal form it may be necessary for performance reasons or to accomodate the database management system being used to denormalize certain relationships.

    Denormalization is also a technique used in creating dimensional data warehouses.

    I recommend reading Kimball's books on the topic of data warehouse design and development to learn more about denormalization.

  3. #3
    Join Date
    Nov 2005
    Posts
    3
    sorry will try and find out for you...

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    You could obtain this paper, at a modest cost:

    http://www.dbdebunk.com/page/page/1103793.htm

Posting Permissions

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