MongoDB集約フレームワーク(Aggregation Framework)の使い方その１

URL
date
Nov 1, 2023
slug
mongodb-aggregation-framework-basic-practices-1
status
Published
tags
MongoDB
Basic
Command
Aggregate
summary
MongoDB集約フレームワーク(Aggregation Framework)の使い方
type
Post

集計フレームワーク(Aggregation Framework)とは？

  • aggregation frameworkは、find() メソッドと同じ検索も可能だが変換や複雑なデータ操作のための柔軟なパイプライン(Pipeline)ベースを提供
  • 一連の操作 (Stage) を順次適用することで、データを変換、フィルタリング、グルーピング、ソーティングなどができます。
 

Aggregation Frameworkの基本

メソッドの定義

db.collection.aggregate()
.leafygreen-ui-zzkys8{font-size:16px;line-height:28px;font-family:'Euclid Circular A','Helvetica Neue',Helvetica,Arial,sans-serif;display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-text-decoration:none;text-decoration:none;cursor:pointer;line-height:13px;color:#016BF8;font-weight:400;-webkit-text-decoration:none!important;text-decoration:none!important;font-size:13px;}.leafygreen-ui-zzkys8:hover,.leafygreen-ui-zzkys8:focus,.leafygreen-ui-zzkys8:visited{-webkit-text-decoration:none;text-decoration:none;}.leafygreen-ui-zzkys8:focus{outline:none;}.leafygreen-ui-zzkys8:last-of-type{color:#1C2D38;}.leafygreen-ui-zzkys8:hover,.leafygreen-ui-zzkys8:focus{-webkit-text-decoration:none;text-decoration:none;}.leafygreen-ui-zzkys8:hover:not(:last-of-type),.leafygreen-ui-zzkys8:focus:not(:last-of-type){color:#1C2D38;}Docs Home.css-156usfp{cursor:default;}.css-156usfp:last-of-type{color:#1C2D38;} → .leafygreen-ui-i01tdw{font-size:13px;}.leafygreen-ui-i01tdw:last-of-type{color:#1C2D38;}.leafygreen-ui-i01tdw:hover,.leafygreen-ui-i01tdw:focus{-webkit-text-decoration:none;text-decoration:none;}.leafygreen-ui-i01tdw:hover:not(:last-of-type),.leafygreen-ui-i01tdw:focus:not(:last-of-type){color:#1C2D38;}MongoDB Manual
db.collection.aggregate()
https://www.mongodb.com/docs/manual/reference/method/db.collection.aggregate/#definition
db.collection.aggregate()
 
基本 Syntax
 
Aggregation Pipeline Stages
.leafygreen-ui-zzkys8{font-size:16px;line-height:28px;font-family:'Euclid Circular A','Helvetica Neue',Helvetica,Arial,sans-serif;display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-text-decoration:none;text-decoration:none;cursor:pointer;line-height:13px;color:#016BF8;font-weight:400;-webkit-text-decoration:none!important;text-decoration:none!important;font-size:13px;}.leafygreen-ui-zzkys8:hover,.leafygreen-ui-zzkys8:focus,.leafygreen-ui-zzkys8:visited{-webkit-text-decoration:none;text-decoration:none;}.leafygreen-ui-zzkys8:focus{outline:none;}.leafygreen-ui-zzkys8:last-of-type{color:#1C2D38;}.leafygreen-ui-zzkys8:hover,.leafygreen-ui-zzkys8:focus{-webkit-text-decoration:none;text-decoration:none;}.leafygreen-ui-zzkys8:hover:not(:last-of-type),.leafygreen-ui-zzkys8:focus:not(:last-of-type){color:#1C2D38;}Docs Home.css-156usfp{cursor:default;}.css-156usfp:last-of-type{color:#1C2D38;} → .leafygreen-ui-i01tdw{font-size:13px;}.leafygreen-ui-i01tdw:last-of-type{color:#1C2D38;}.leafygreen-ui-i01tdw:hover,.leafygreen-ui-i01tdw:focus{-webkit-text-decoration:none;text-decoration:none;}.leafygreen-ui-i01tdw:hover:not(:last-of-type),.leafygreen-ui-i01tdw:focus:not(:last-of-type){color:#1C2D38;}MongoDB Manual
Aggregation Pipeline Stages
https://www.mongodb.com/docs/manual/reference/operator/aggregation-pipeline/#stages
Aggregation Pipeline Stages
 
以下は、MongoDB サンプルデータです。
  • persons Collection サンプルデータ 5000件
raw.githubusercontent.com
https://raw.githubusercontent.com/EndlessDev2016/mongodb_json/master/persons.json
 
簡単に$aggregateStageと$match、$groupOperatorを用いて、データを集約してみる。
 

© EndlessDev2016 2021 - 2025