DevOps Articles

Do We Need Data Normalization Anymore?

Folks with many different roles in information technology — including developers, database administrators, domain modelers, business stakeholders — routinely come into contact with data normalization. Yet as the database landscape becomes more diverse and hardware becomes more powerful, we might wonder whether the practice of data normalization is necessary anymore.

The process of data normalization optimizes data structures in a relational database to ensure data integrity and query efficiency.

At its core, data normalization helps avoid data anomalies that occur when creating new data (Insert), updating existing data (Update), or deleting data (Delete).

Worse yet, to avoid doing that, we would have to gather all the information on customer, products and receipt date/time.