スコアを正規化する

1
db.movies.aggregate([{
2
  "$search": {
3
    "text": {
4
      "query": "Helsinki",
5
      "path": "plot"
6
    }
7
  }
8
},
9
{
10
  "$limit": 5
11
},
12
{
13
  "$project": {
14
    "_id": 0,
15
    "title": 1,
16
    "score": 1,
17
    "maxScore": 1,
18
    "normalizedScore": 1
19
  }
20
},
21
{
22
  "$addFields": {
23
    "score": {
24
      "$meta": "searchScore"
25
    }
26
  }
27
},
28
{
29
  "$setWindowFields": {
30
    "output": {
31
      "maxScore": {
32
        "$max": "$score"
33
      }
34
    }
35
  }
36
},
37
{
38
  "$addFields": {
39
    "normalizedScore": {
40
      "$divide": [
41
        "$score", "$maxScore"
42
      ]
43
    }
44
  }
45
}])

1
db.movies.aggregate([{
2
  "$search": {
3
    "text": {
4
      "path": "title",
5
      "query": "men",
6
      "score": {
7
        "function":{
8
          "multiply":[
9
            {
10
              "path": {
11
                "value": "imdb.rating",
12
                "undefined": 2
13
              }
14
            },
15
            {
16
              "score": "relevance"
17
            }
18
          ]
19
        }
20
      }
21
    }
22
  }
23
},
24
{
25
  "$limit": 5
26
},
27
{
28
  "$addFields": {
29
    "score": {
30
      "$meta": "searchScore"
31
    }
32
  }
33
},
34
{
35
  "$setWindowFields": {
36
    "output": {
37
      "maxScore": {
38
        "$max": "$score"
39
      }
40
    }
41
  }
42
},
43
{
44
  "$addFields": {
45
    "normalizedScore": {
46
      "$divide": [
47
        "$score", "$maxScore"
48
      ]
49
    }
50
  }
51
},
52
{
53
  "$project": {
54
    "_id": 0,
55
    "title": 1,
56
    "score": 1,
57
    "maxScore": 1,
58
    "normalizedScore": 1
59
  }
60
}])

1
db.movies.aggregate([{
2
  "$search": {
3
    "text": {
4
      "path": "title",
5
      "query": "shop",
6
      "score": {
7
        "function":{
8
          "gauss": {
9
            "path": {
10
              "value": "imdb.rating",
11
              "undefined": 4.6
12
            },
13
            "origin": 9.5,
14
            "scale": 5,
15
            "offset": 0,
16
            "decay": 0.5
17
          }
18
        }
19
      }
20
    }
21
  }
22
},
23
{
24
  "$limit": 5
25
},
26
{
27
  "$addFields": {
28
    "score": {
29
      "$meta": "searchScore"
30
    }
31
  }
32
},
33
{
34
  "$setWindowFields": {
35
    "output": {
36
      "maxScore": {
37
        "$max": "$score"
38
      }
39
    }
40
  }
41
},
42
{
43
  "$addFields": {
44
    "normalizedScore": {
45
      "$divide": [
46
        "$score", "$maxScore"
47
      ]
48
    }
49
  }
50
},
51
{
52
  "$project": {
53
    "_id": 0,
54
    "title": 1,
55
    "score": 1,
56
    "maxScore": 1,
57
    "normalizedScore": 1
58
  }
59
}])

1
db.movies.aggregate([{
2
  "$search": {
3
    "text": {
4
      "path": "title",
5
      "query": "men",
6
      "score": {
7
        "function":{
8
          "path": {
9
            "value": "imdb.rating",
10
            "undefined": 4.6
11
          }
12
        }
13
      }
14
    }
15
  }
16
},
17
{
18
  "$limit": 5
19
},
20
{
21
  "$addFields": {
22
    "score": {
23
      "$meta": "searchScore"
24
    }
25
  }
26
},
27
{
28
  "$setWindowFields": {
29
    "output": {
30
      "maxScore": {
31
        "$max": "$score"
32
      }
33
    }
34
  }
35
},
36
{
37
  "$addFields": {
38
    "normalizedScore": {
39
      "$divide": [
40
        "$score", "$maxScore"
41
      ]
42
    }
43
  }
44
},
45
{
46
  "$project": {
47
    "_id": 0,
48
    "title": 1,
49
    "score": 1,
50
    "maxScore": 1,
51
    "normalizedScore": 1
52
  }
53
}])

1
db.movies.aggregate([{
2
  "$search": {
3
    "text": {
4
      "path": "title",
5
      "query": "men",
6
      "score": {
7
        "function": {
8
          "log": {
9
            "path": {
10
              "value": "imdb.rating",
11
              "undefined": 10
12
            }
13
          }
14
        }
15
      }
16
    }
17
  }
18
},
19
{
20
  "$limit": 5
21
},
22
{
23
  "$addFields": {
24
    "score": {
25
      "$meta": "searchScore"
26
    }
27
  }
28
},
29
{
30
  "$setWindowFields": {
31
    "output": {
32
      "maxScore": {
33
        "$max": "$score"
34
      }
35
    }
36
  }
37
},
38
{
39
  "$addFields": {
40
    "normalizedScore": {
41
      "$divide": [
42
        "$score", "$maxScore"
43
      ]
44
    }
45
  }
46
},
47
{
48
  "$project": {
49
    "_id": 0,
50
    "title": 1,
51
    "score": 1,
52
    "maxScore": 1,
53
    "normalizedScore": 1
54
  }
55
}])