Database Denormalization

What is denormalization?

• Denormalization is the process of increasing the redundancy in the database.
• It is the opposite process of normalization.
• It is mostly done for improving the performance.
• It is a strategy that database managers use to increase the performance of a database structure.
• Denormalization adds redundant data normalized database for reducing the problems with database queries which combine data from the various tables into a single table.
• The process of adding redundant data to get rid of complex join, in order to optimize database performance. This is done to speed up database access by moving from higher to lower form of normalization.
• Data is included in one table from another in order to eliminate the second table which reduces the number of JOINS in a query and thus achieves performance.