

Hi,
De-normalization is a concept used for fast data retrieval as it reduces the number of joins to be performed in the select query. this is the process of taking a normalized database and deliberately introducing redundancies to improve query writing, performance and correctness.
Data denormalization is reverse procedure, carried out purely for reasons of improving performance. It maybe efficient for a high-throughput system to replicate data for certain data.
Thanks.