15.00 - Normalization, Denormalization, and Primary Index Usage - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Normalization, Denormalization, and Primary Index Usage

The following example shows how a well‑designed normalized table set can be as high-performing as the equivalent denormalized form while avoiding all the redundancy and update anomaly difficulties of denormalization. Note that denormalization is a logical, not a physical, concept (see Chapter 7: “Denormalizing the Physical Schema”). The term is used here only because it is most commonly understood in such a context, not because it is correct.

The most frequently performed query against these tables determines the current price for a given part.