問題描述

我正在嘗試使用 Mongoose 在我的集合中的數組中計算字符串的出現次數.我的模式"如下所示:

I'm trying to count the number of occurrences of a string in an array in my collection using Mongoose. My "schema" looks like this:

var ThingSchema = new Schema({
  tokens: [ String ]
});

我的目標是獲取Thing"集合中的前 10 個令牌"，每個文檔可以包含多個值.例如:

My objective is to get the top 10 "tokens" in the "Thing" collection, which can contain multiple values per document. For example:

var documentOne = {
    _id: ObjectId('50ff1299a6177ef9160007fa')
  , tokens: [ 'foo' ]
}

var documentTwo = {
    _id: ObjectId('50ff1299a6177ef9160007fb')
  , tokens: [ 'foo', 'bar' ]
}

var documentThree = {
    _id: ObjectId('50ff1299a6177ef9160007fc')
  , tokens: [ 'foo', 'bar', 'baz' ]
}

var documentFour = {
    _id: ObjectId('50ff1299a6177ef9160007fd')
  , tokens: [ 'foo', 'baz' ]
}

...會給我數據結果:

...would give me data result:

[ foo: 4, bar: 2 baz: 2 ]

我正在考慮為此工具使用 MapReduce 和 Aggregate，但我不確定什么是最佳選擇.

I'm considering using MapReduce and Aggregate for this tool, but I'm not certain what is the best option.

推薦答案

啊哈，我找到了解決方案.MongoDB 的 aggregate 框架允許我們在集合上執行一系列任務.特別值得注意的是$unwind，它將文檔中的數組分解為唯一的文檔，因此它們可以被分組/計數en masse.

Aha, I've found the solution. MongoDB's aggregate framework allows us to execute a series of tasks on a collection. Of particular note is $unwind, which breaks an array in a document into unique documents, so they can be groups / counted en masse.

MongooseJS 在模型上非常容易地公開了這一點.使用上面的示例，如下所示:

MongooseJS exposes this very accessibly on a model. Using the example above, this looks as follows:

Thing.aggregate([
    { $match: { /* Query can go here, if you want to filter results. */ } } 
  , { $project: { tokens: 1 } } /* select the tokens field as something we want to "send" to the next command in the chain */
  , { $unwind: '$tokens' } /* this converts arrays into unique documents for counting */
  , { $group: { /* execute 'grouping' */
          _id: { token: '$tokens' } /* using the 'token' value as the _id */
        , count: { $sum: 1 } /* create a sum value */
      }
    }
], function(err, topTopics) {
  console.log(topTopics);
  // [ foo: 4, bar: 2 baz: 2 ]
});

在大約 200,000 條記錄的初步測試中，它明顯快于 MapReduce，因此擴展性可能更好，但這只是粗略的一瞥.YMMV.

It is noticeably faster than MapReduce in preliminary tests across ~200,000 records, and thus likely scales better, but this is only after a cursory glance. YMMV.

這篇關于Mongoose/MongoDB:計算數組中的元素的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！