规范化与反规范化

规范化：其目的是减少容易，同时保证数据的完整性。其通过将大的实体分解为若干小的实体，这些小的实体与原先的实体含有相同的信息，但没有重复。

反规范化：基于正则化的数据库，来修改表的结构，实现可控的冗余度。其唯一目的是提高性能。

 

Normalization and Denormalization

The purpose of normalization is to reduce redundancy, and secure data integrity. This is achieved by reducing large entries into several other, lesser entities which together contains the same information, but without repeating it.

Denormalization is the process of taking a normalized database and modifying table structure to allow controlled redundancy. The only purpose of denormalization is to improve performance.