Normalization - CI/CD Glossary Definition
Normalization is the process of organizing a schema to remove redundancy by splitting data into related tables, so each fact is stored once and updated in one place.
Versus denormalization
Normalized schemas avoid update anomalies but require joins to reassemble data. Denormalization deliberately duplicates data to make reads faster, accepting the cost of keeping copies in sync.
Related guides
Denormalization - CI/CD Glossary DefinitionDenormalization: Denormalization deliberately duplicates or pre-joins data so reads avoid expensive joins, tr…
Foreign Key - CI/CD Glossary DefinitionForeign Key: A foreign key is a column that references the primary key of another table, enforcing that the r…