Pros and Cons of Database Normalization
When using a relational database, normalization can help keep the data free of errors and can also help ensure that the size of the database doesn’t grow large with duplicated data. At the same time, some types of operations can be slower in a normalized environment. So, when should you normalize and when is it better to proceed without normalization?
What Is Normalization?
Database normalization is the process of organizing data within a database in the most efficient manner possible. For example, you likely do not want a username stored in several different tables within your database when you could store it in a single location and point to that user via an ID instead.
via DZone.com Feed https://dzone.com
May 29, 2017 at 07:09AM