Results 1 to 7 of 7
  1. #1
    Registered User
    Join Date
    Oct 2015
    Location
    India
    Posts
    177

    The Type Of De-normalization?

    Hello Dear,

    Please Tel Me What Is The Type Of De-normalization ?

  2. #2
    Senior Member dennis123's Avatar
    Join Date
    Apr 2013
    Location
    Bangalore
    Posts
    3,391
    In computing, denormalization is the process of trying to improve the read performance of a database, at the expense of losing some write performance, by adding redundant copies of data or by grouping data. ... Denormalization should not be confused with Unnormalized form.

  3. #3
    Registered User
    Join Date
    Apr 2014
    Posts
    167
    In two dimensional information system we use the normalization but in decision support systems we use de-normalization

  4. #4
    Registered User
    Join Date
    Mar 2019
    Location
    Ahmedabad
    Posts
    180
    Denormalization is a database optimization technique where we add redundant data in the database to get rid of the complex join operations. This is done to speed up database access speed. Denormalization is done after normalization for improving the performance of the database.

    In a traditional normalized database, we store data in separate logical tables and attempt to minimize redundant data. We may strive to have only one copy of each piece of data in database.

  5. #5
    Senior Member
    Join Date
    Nov 2018
    Posts
    1,348
    Denormalization is a strategy used on a previously-normalized database to increase performance. In computing, denormalization is the process of trying to improve the read performance of a database, at the expense of losing some write performance, by adding redundant copies of data or by grouping data.

  6. #6
    Senior Member
    Join Date
    Aug 2020
    Posts
    1,007
    Denormalization is a database optimization technique in which we add redundant data to one or more tables. ... For example, in a normalized database, we might have a Courses table and a Teachers table. Each entry in Courses would store the teacherID for a Course but not the teacherName.

  7. #7
    Denormalization is a database optimization technique in which we add redundant data to one or more tables. This can help us avoid expensive joins in relational databases. In traditional normalized databases, we store data in separate logical tables and try to minimize redundant data.

Posting Permissions

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

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.