Analyzing MongoDB data consistency

Analyzing data consistency

Nosql (non-relational) database systems have a huge advantage and disadvantage in their loose data structure. On one hand, this allows for much faster development and agility as your project grows. On the other hand, this also increases the chances of data inconsistency.

Of course, we are all great developers using all measures to prevent data inconsistencies. Nonetheless, as if by magic, there are always outliers in our data and we just can’t handle them properly.

Well, Mingo’s “Schema analyzer” helps with debugging such cases.

Getting to know your issues

First step is to find out whether you have any issue with your data. Using Mingo’s “Schema analyzer”, you’ll get a quick glance at the state of your data.

Data analyzer

You may restrict the analysis using a query selector and limit the number of documents analyzed. Setting the limit to a negative number will analyze the last X documents matching the query.

Dealing with the known data inconsistencies

Once you see the results, you have several ways to act.

Data analyzer

First, you can view documents with specific type of data. For example, you can view all documents where a field is a boolean with TRUE value. Or where a field is number.

You may also pull sample values for each value type. For example, show string value samples of a field.

A great feature is “Group by and count” on a field to show value distribution.

Data analyzer

Renaming and deleting fields in all documents

If you find that a field is old, useless or an accident, you can delete it from each document with one click. Sometimes, you may find a typo in a field name. In such case, renaming all such fields in each document can be done by a few clicks in Mingo.

Data analyzer

PS: We recommend performing analysis on your local server / computer. Analyzing requires downloading all the data to Mingo, therefore processing time will depend on your connection speed.

Download Mingo now

Mingo is free for personal use.

More articles

Hidden features

7 hidden features that make Mingo so addictive

Read more
Aggregation builder

Aggregation: simplified and visualized

Read more
Compare & Sync

Compare and sync entire MongoDB databases

Read more

Creating indexes with a breeze

Read more
Deep links

Deep linking from other apps or websites

Read more
Schema Analyzer

Analyze data structure

Read more
Human-readable dates

Querying by dates - the human way

Read more