Denormalisierung (EN)

Concept

Intentional reduction of normalization to improve query performance

Architecture

flowchart TD     A[Normalized Table] -->|JOIN| B[Query Result]     C[Denormalized Table] -->|Direct Access| D[Faster Query Result]     E[Redundant Data] -->|Risk| F[Data Consistency Issues]     D -->|Performance| G[Better Read Speed]     F -->|Disadvantage| H[Increased Maintenance Costs]

In Context

  • Typically used together with indexing and caching
  • Related to: Normalization, Database Optimization, OLAP Systems
  • Example Use Case: Data warehousing applications with many read accesses
Quelle: AI Generated