Database Normalization

One of fundamental step when designing an application is how you represent your data. The structure of your database’s collections and documents is one of core factors affecting your application’s speed and latency. A poor designed data representation can slow performance down by forcing you to make unnecessary queries to get the data you need.

What is Normalization?

Normalization means break down a large piece of data into small pieces with references between those collections. Each piece of data will be in a collection, but multiple documents will reference it.

What are purposes of Normalization?

It reduces the data redundancy and complexity of data and improves the integrity of data.

This means, to change the data, you only need to update one document, because the data is only defined once. However in MongoDb, it doesn’t provides join facilities, like SQL does. Therefore several queries is needed to get data from several collections.