Denormalization
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Denormalization

  1. #1
    Join Date
    Mar 2002
    Posts
    38
    Hi friends,

    Can you please explain me What is Denormalization?
    Are there any advantages?

    Can you give some examples in the real time where denormalizing is required?

    Thank You

    Suroop
    SUROOP B

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Denormalization generally refers to bending the rules of third normal form (3NF) in order to improve performance.

    There are many posts that will explain normalization (3NF), but in general, it means

    the key, the whole key, and nothing but the key, so help me Codd.



    [Edited by dknight on 03-13-2002 at 12:11 PM]
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Something interesting on Denormalization:

    http://www.firstsql.com/dbdebunk/fp5a.htm

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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