What is denormalization?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is denormalization?
Rating:
Denormalization is usually done to decrease the time required to execute complex queries. Drawbacks of a normalized database are mostly in performance. In a normalized database, more joins are required to gather all the information from multiple entities, as data is divided and stored in multiple entities rather than in one large table. Queries that have a lot of complex joins will require more CPU usage and will adversely affect performance. Sometimes, it is good to denormalize parts of the database. Examples of design changes to denormalize the database and improve performance are:
- Add a column (or columns) to the table that contains pre-aggregated data to be used only for a report.
- Partition the table with many columns to multiple tables.
- Add duplicate keys to tables. This will reduce the number of joins required to get complete information.
Rating:
Was this information helpful?
Other articles
- What is Data Protection Application Programming Interface (DPAPI)?
- What is project scope?
- What is IIS?
- What is parent-child relationship between two tables?
- What is the Snapshot agent?