Denormalization

As explained in Building Web APIs with ASP.NET Core

Denormalization is the deliberate combination or duplication of related data to simplify retrieval or improve access performance.

Denormalization embeds related child data in a parent document instead of relying mainly on references between separate entities. This can produce a simpler schema with fewer collections and flexible documents. section 4.1.1

Board-game data

A document-oriented design can keep mechanics and domains inside board-game documents. A relational design instead uses separate tables and junction tables for those many-to-many relationships. section 4.1.1

Figure 4.2 MyBGList database schema diagram for a document-oriented NoSQL database

Compare the document-oriented board-game schema with the relational alternative. section 4.1.1

How Building Web APIs with ASP.NET Core covers it

How deep it goes

Explains parent-child embedding and contrasts schema structures, without detailing implementation or retrieval behavior.

Examples

Uses board games, mechanics, and domains to contrast embedded documents with tables and junction tables.

How it connects

Connects denormalization to NoSQL, document databases, relational databases, and many-to-many relationships.

liveBookmanning.com

Read Building Web APIs with ASP.NET Core on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  ScyllaDB in ActionDenormalization is a data-modeling technique that stores related data together, often duplicating information to support access patterns without additional lookups.
• 

  liveBookmanning.com
  Microsoft Azure in ActionDenormalization is the intentional introduction of redundant or combined data into a relational schema to improve read performance or simplify access.
• 

  liveBookmanning.com
  Grokking Relational Database DesignDenormalization is the deliberate introduction of controlled redundancy or less-normalized database structures to improve performance or meet operational needs.
• 

  liveBookmanning.com
  MongoDB 8.0 in Action, Third EditionA denormalized data model stores related data together or redundantly to reduce the need for joins, separate queries, or cross-record operations.
• 

  liveBookmanning.com
  Effective Data AnalysisDenormalization is the deliberate combination or duplication of related data to reduce separation between tables and simplify analytical access.

Compare how 6 books explain denormalization →

Related concepts

• normalizationcontrasts with · Normalization is the process of transforming a value, representation, or data structure to satisfy a specified standard, scale, or structural constraint.
• database normalizationcontrasts with · Database normalization is a relational database design technique that organizes data into related tables to reduce redundancy and prevent update or dependency anomalies.
• joinaddresses · A join is an operation that combines records or rows from multiple data sources according to specified matching conditions or relationships.
• redundancyproduces · Redundancy is the presence of duplicate or overlapping information, components, or resources, whether intentional or unnecessary.
• optimizationkind of · Optimization is the systematic selection or adjustment of values, actions, or system designs to improve a specified objective, often subject to constraints.

This explainer was generated by Manning's knowledge graph from the text of Building Web APIs with ASP.NET Core. The section links point to the parts of the book it draws on.