When you are importing data into a MongoDB database, a lot of work and frayed tempers can be saved by preparing data properly before you attempt to create a MongoDB collection. In this article, I’ll be demonstrating how some real data can be imported into MongoDB and then cleaned up using aggregation and regex to [...]
When you have a whale of a performance problem Before you get into dealing with the minutia of database performance, you have to stand back and ask the obvious questions like ‘do I actually need all this data?’. Even with the cleverest querying or aggregation, fine tuning indexes and studying execution plans, you are unlikely [...]
In this post, we're going to take a look at how to do MongoDB aggregation queries with the Aggregation Editor in Studio 3T (formerly MongoChef). We're going to build a query based on the freely available housing data from the City of Chicago Data Portal. Create the MongoDB Aggregation Query Identify the Question MongoDB Aggregation [...]
In this post, we will see how Studio 3T can make your life easy with writing, debugging, and running MongoDB Map-Reduce jobs using the amazing new Map-Reduce screen. In case you haven't yet, download our MongoDB GUI and let's go through a Map-Reduce example together. MongoDB Map-Reduce vs Aggregation Pipeline A Map-Reduce Example Filtering the [...]
MongoDB 3.4 has brought out a number of new, very useful aggregation operators for both recursive search ($graphLookup), and faceted search ($bucket, $bucketAuto, $facet, $sortByCount). See below for a brief explanation of each new operator. And of course, both IntelliShell and the Studio 3T aggregation builder fully support the new additions. OPERATOR DESCRIPTION $bucket Categorizes incoming [...]
With the release of MongoChef 4.1.1, we have made it super-easy to quickly disable stages temporarily in your MongoDB aggregation query. This often comes in very handy while debugging. To demonstrate this, let's consider the following simple aggregation query on the City of Chicago's publicly available housing database. Our aggregation pipeline consists of 4 stages: Limit the documents [...]