Enterprise Application Architecture with .NET Core

Denormalization

Normalization is the process of defining database tables and relationships in a way that maintains integrity and avoids redundancy. In enterprise applications, we have some reports or views that use heavy SQL Joins to bring data in one table view. These joins are quite heavy operations on the database, and highly affect performance.

Denormalization is a technique in which data can be saved in a single flat table, and the retrieval of data is considerably faster than making SQL Joins or Sub queries. If a business application is complex in nature, we cannot definitely convert its database into a Non-Relational schema. But we can implement the CQR pattern, and modify our READ model to store the values in flat tables, and use  ...