005·14

denormalization

/diːˌnɔːr.mə.laɪˈzeɪ.ʃən/ - n.

1 [colloq.] Copying the value into six tables so the dashboard loads faster, then learning which copy is wrong six tables at a time.Keep. Punchy.This is the problem.

Working definition

2. The deliberate introduction of redundancy into a schema to improve read performance, accepting update complexity in exchange for fewer joins.

Filed

See also

normalizationStoring each fact exactly once so that no one can find it, then joining nine tables to prove it was there all along.
single source of truthTerm struck pending the definitions of ownership, metric, and certification it depends on; without them the source is single but the truth is plural.
star schemaA clean diagram at the center of the deck, surrounded on all sides by the joins that did not fit on the slide.