Couchbase frente a MongoDB™: Comparación de rendimiento y escalabilidad

/* equivalente al ejemplo de Mongo */
SELECT SUM(valor * volumen) AS val, simbolo
FROM   db.acciones
WHERE  simbolo IN ( "AAPL", "GOOG" ) AND valor > 0
GROUP  BY simbolo
ORDER  BY val DESC, simbolo ASC

// equivalente al ejemplo de SQL++
db.stocks.aggregate([
     { "$match": {
          "$and": [
               {"symbol": {
	 	 	 	 "$in": [
                    "AAPL",
                    "GOOG"]}},
               { "value": {
	 	 	 "$gt": 0 }}]}},
     { "$group": {
          "_id": {
               "symbol": "$symbol" },
	 	 "sum(value * volume)": {
               "$sum": {
                    "$multiply": [
                         "$value",
	 	 	 	 	 "$volume"]}}}},
     { "$project": {
	 	 "_id": 0,
          "sum(value * volume)": "$sum(value * volume)",
          "symbol": "$_id.symbol"}}
	 { "$sort": {
          "sum(value * volume)": -1,
          "symbol": 1 }}]})