The process of breaking down large tables into smaller, more manageable tables is known as ___________.

  • Denormalization
  • Normalization
  • Partitioning
  • Sharding
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves breaking down large tables into smaller, more manageable tables and defining relationships between them. Denormalization, on the other hand, involves combining tables to improve query performance but may lead to data redundancy. Partitioning and sharding are techniques used for distributing large databases across multiple servers. While both normalization and denormalization involve restructuring tables, normalization is specifically focused on reducing redundancy and improving data integrity, making it the correct choice.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *