ALL COVERED TOPICS

NoSQL Benchmarks NoSQL use cases NoSQL Videos NoSQL Hybrid Solutions NoSQL Presentations Big Data Hadoop MapReduce Pig Hive Flume Oozie Sqoop HDFS ZooKeeper Cascading Cascalog BigTable Cassandra HBase Hypertable Couchbase CouchDB MongoDB OrientDB RavenDB Jackrabbit Terrastore Amazon DynamoDB Redis Riak Project Voldemort Tokyo Cabinet Kyoto Cabinet memcached Amazon SimpleDB Datomic MemcacheDB M/DB GT.M Amazon Dynamo Dynomite Mnesia Yahoo! PNUTS/Sherpa Neo4j InfoGrid Sones GraphDB InfiniteGraph AllegroGraph MarkLogic Clustrix CouchDB Case Studies MongoDB Case Studies NoSQL at Adobe NoSQL at Facebook NoSQL at Twitter

NAVIGATE MAIN CATEGORIES

Close

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 (NoSQL database©myNoSQL)

via: http://architects.dzone.com/articles/comparing-mongodb-new