Try OpenEdge Now
skip to main content
Database Essentials
Database Design : Normalization
 

Normalization

Normalization is an iterative process during which you streamline your database to reduce redundancy and increase stability. During the normalization process, you determine in which table a particular piece of data belongs based on the data itself, its meaning to your business, and its relationship to other data. Normalizing your database results in a data-driven design that is more stable over time.
Normalization requires that you know your business and know the different ways you want to relate the data in your business. When you normalize your database, you eliminate columns that:
*Contain more than one value
*Are duplicates or repeat
*Do not describe the table in which they currently reside
*Contain redundant data
*Can be derived from other columns
The result of each iteration of the normalization process is a table that is in a normal form. After one complete iteration, your table is said to be in first normal form; after two, second normal form; and so on. The sections that follow describe the rules for the first, second, and third normal forms.
A perfectly normalized database represents the most stable data-driven design, but it might not yield the best performance. Increasing the number of tables and keys, generally leads to higher overhead per query. If performance degrades due to normalization, you should consider denormalizing your data. See the Denormalization for more information.
* First normal form
* Second normal form
* Third normal form
* Denormalization