Denormalizing data

Data denormalization is the process of adjusting data from a structure that is better for transactional processing to a structure that is better for reporting or data science purposes. This section provides a brief overview of data normalization and looks at why we denormalize, what we denormalize, and how to denormalize.

Relational normalization

In relational databases, data should be saved in so-called normalized structures. The normalization of data structures is a process that discovers the best structure that is resistant against any uncertainties in data, user change requests, and so on. The normalization itself is controlled by a set of rules known as normal forms.

Every normal form describes how...