Denormalize

From Oracle FAQ
Jump to: navigation, search

Denormalization is the process of introducing redundancy into a table by incorporating data from a related table. Tables are usually denormalized to prevent expensive SQL join operations between them.

One should always normalize to third-normal form and only apply denormalization selectively as a last resort if performance problems are experienced. Remember that denormalizations is not free and introduces the following problem into the design:

  • More disk space is used as the same data is duplicated in more than one table
  • DML operations are more expensive as the same data must be maintained in more than one table
  • You run the risk that the data can get "out of sync"

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #