Results 1 to 4 of 4

Thread: Concept of Denormalization

  1. #1
    Expert Member
    Join Date
    May 2006
    Answers
    114

    Concept of Denormalization

    Is the concept of Denormalization an exact opposite of normalization? If not what is it? Does denormalization means redundancy of data is involved in the tables considered. Anyone describe on the topic.


  2. #2
    Contributing Member
    Join Date
    May 2006
    Answers
    72

    Re: Concept of Denormalization

    Denormalization is the process of achieving optimization in database by including redundant data. But denormalization can occur only after some levels of normalization have been applied to database. In other words relying completely on denormalization is not efficient to database design.


  3. #3
    Contributing Member
    Join Date
    May 2006
    Answers
    64

    Re: Concept of Denormalization

    Also I think denormalization mostly apply to logical design rather than physical design. Am I right in my statement? If not correct me!!!!


  4. #4
    Junior Member
    Join Date
    Apr 2006
    Answers
    24

    Arrow Re: Concept of Denormalization

    Denormalization is a data model designing technique. It is used for Data Warehouse designing. your transactional systems ([OLTP] - Billing or online booking systems for example) are in generally 3NF normalized database.

    When you are designing a DWH, you turn your OLTP system which is in normalized format, to denormalized state. lets take an example,
    your online booking system (OLTP) has customer information as well as say travel destinations information.
    so you will have different tables for
    --Country, state, City, County, Zipcodes etc.
    which will be connected to each other in uniformed hirarchey.
    In DWH, You create a dimension for Locations/Regions under which you will have all the data of locations together.
    it means in physical table "Locations" in each row you will have Country, state, City, County, Zipcode.
    though values are not atomic, it serves purpose of DWH by reducing tables & hence joins & so improving performance.

    Denormalized database exists in phisical tables.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact