Back to Tags
Normalization
6 items tagged with "normalization"
Filter by type:
Anti-Patterns5
Anti-Pattern
God Table
A single table accumulating dozens or hundreds of unrelated columns for many concepts, becoming a contention and maintenance bottleneck.
Anti-Pattern
Entity-Attribute-Value (EAV) Abuse
Storing arbitrary attributes as rows of name/value pairs to fake a schemaless model, sacrificing type safety, integrity, and query performance.
Anti-Pattern
One True Lookup Table (OTLT)
Cramming every reference list into one generic lookup table keyed by category, defeating foreign keys and mixing unrelated domains.
Anti-Pattern
Premature Denormalization
Duplicating data across tables for speed before any measured need, creating update anomalies and integrity bugs to solve a problem you may not have.
Anti-Pattern
Over-Normalization
Splitting data into so many tables that every read requires a sprawl of joins, hurting performance and readability with no integrity benefit.