How Normalization Is Beneficial for Physical Databases - Teradata Database

How Normalization Is Beneficial for Physical Databases

The fundamental objective for a relational database management system is to keep data independent of the applications or analysis that use it. There are two reasons for this:

Different applications require different views of the same data.

Data must be extendable, and a framework must exist to support the introduction of new applications and analyses without having to modify existing applications.

This topic develops some of themes described elsewhere in this manual by explaining their relevance to everyday exploratory data analysis problems in data warehousing. The subject matter for this topic is adapted from Russell and Armstrong.