What Is Normalization?
The following are the objectives of normalization:
-
To represent facts about the real world in a way that can be understood
-
To reduce storing facts redundantly and to prevent anomalous or inconsistent data
-
To support integrity constraints
Notice that improving database performance is not on this list. Normalization will help you store data correctly and avoid getting into trouble when using SQL to query your data. Itâs practically inevitable that a database that is not normalized becomes a mess. You may have to develop a lot more code to clean up inconsistent or duplicate data. You will experience delays and expenses to the business from faulty data. If you include these scenarios, the benefits to performance from ...
Get SQL Antipatterns, Volume 1 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
