Tagged articles
Denormalization
13 articles · Page 1 of 1
This article breaks down the interview expectations around database normalization, explains the theory and trade‑offs of normalization versus denormalization, provides SQL code examples, compares design impacts, offers best‑practice guidelines, and warns against common misconceptions.
Database DesignDenormalizationInterview Preparation
0 likes · 11 min read

This article explores the origins of the "no more than three‑table JOIN" rule, explains MySQL's join algorithm limitations, shows real‑world performance pain points in distributed architectures, and presents practical solutions such as step‑wise queries, denormalization, and materialized views to safely break the restriction.
Database PerformanceDenormalizationMySQL
0 likes · 11 min read

This article explains why excessive MySQL joins can cause performance problems and provides a comprehensive set of techniques—including query splitting, temporary tables, denormalization, index tuning, query rewriting, result‑set reduction, configuration tweaks, big‑data tools, and summary tables—to effectively optimize multi‑table join queries.
Database PerformanceDenormalizationMySQL
0 likes · 10 min read

The article compares redundant and normalized storage, explains their trade‑offs, and introduces an in‑memory aggregation technique implemented via a repository "fill" method in Java, showing how to replace costly SQL joins with flexible, code‑driven data merging while preserving consistency and performance.
Database DesignDenormalizationIn-Memory Join
0 likes · 11 min read

This guide explains the six relational database normal forms, focusing on the first three—1NF, 2NF, and 3NF—detailing their requirements, practical examples, visual illustrations, and the concept of denormalization to balance redundancy and query performance.
1NF2NF3NF
0 likes · 5 min read

The article explains the drawbacks of strict relational normalization, introduces the concept of anti‑normalization (controlled redundancy) to simplify queries, demonstrates it with a set of employee, department, salary tables and four typical query scenarios, and shows how denormalizing the schema can dramatically improve MySQL query performance.
Anti-NormalizationDatabase DesignDenormalization
0 likes · 11 min read


ITPUBJul 29, 2020 · Databases
This article explains the concepts of the first, second, and third normal forms in relational databases, shows concrete table examples, discusses why normalization is important for consistency and storage efficiency, and explores denormalization trade‑offs and modern JSON support in MySQL and NoSQL systems.
1NF2NF3NF
0 likes · 10 min read


ITPUBJul 27, 2020 · Databases
This article explains the concepts of the first, second, and third normal forms, shows how to identify violations with concrete table examples, discusses why normalization is important for consistency and storage efficiency, and explores anti‑normalization techniques that trade redundancy for performance.
1NF2NF3NF
0 likes · 11 min read

This multi‑part guide explains how to model One‑to‑N relationships in MongoDB, covering basic patterns for one‑to‑few, one‑to‑many, and one‑to‑squillions, then advancing to two‑way referencing and denormalization, and finally offering a concise set of rules of thumb for choosing the right schema design.
DenormalizationEmbeddingMongoDB
0 likes · 21 min read

The article explains why the Alibaba Java Development Manual restricts joins to three tables, discusses MySQL’s join algorithm limitations, and offers practical alternatives such as query decomposition, denormalization, and using IN or hash joins to improve performance.
Database DesignDenormalizationMySQL
0 likes · 6 min read

This comprehensive guide explores essential database design principles—including normalization, denormalization, data partitioning, routing, and scaling techniques—offering practical strategies to optimize schema structures, reduce redundancy, and improve performance for both relational and NoSQL systems.
Database DesignDenormalizationSchema Optimization
0 likes · 27 min read

This article explores core database design concepts, covering normalization principles, denormalization tactics, schema simplification, MySQL architecture, various data partitioning methods—including vertical, horizontal, logical, and time‑based sharding—and practical routing and storage optimizations for high‑performance systems.
Denormalizationdatabasesnormalization
0 likes · 27 min read


ITPUBDec 18, 2015 · Databases
This article explains essential database design principles—including normalization, denormalization, join avoidance, and various sharding techniques—while also covering scaling strategies such as vertical upgrades, horizontal partitioning, and the use of flash storage to boost performance.
Database DesignDenormalizationSQL
0 likes · 27 min read
