Comparing MongoDB New Aggregation Framework and SQL
Francois Zaninotto:
MongoDB 2.1 introduced the aggregation framework, a faster alternative to Map/Reduce for common aggregation operations. If you took a look at the documentation and examples, you may have found the feature intimidating. Once you tame it, this new feature reveals itself as a very powerful beast. So read on to discover its true power through a series of examples.
The aggregation framework is indeed an interesting feature of MongoDB. And it’s definitely more useful compared to MongoDB’s MapReduce which came with quite a few limitations. Now MongoDB has 3 different languages: the object-based query language, the aggregation framework (still object-based but using different operators and execution model) and the Javascript-based MapReduce.
Original title and link: Comparing MongoDB New Aggregation Framework and SQL (©myNoSQL)
via: http://architects.dzone.com/articles/comparing-mongodb-new
