Normalization

  • Makes data atomic.
  • Reduces redundancy.

Benefits of Normalization

  • Decreased storage consumption.
    • Removed redundancy means less data.
  • Better / Faster (/Stronger) searches.
    • Less data to scan.
    • Easier searches on (previously) mixed data.
  • Improved data integrity.
    • When data is only in one place you only have to get it right/fix it once.

Vertical partitioning
Horizontal partitioning