Fitur agregasi lanjutan apa yang ditawarkan MongoDB?

Question

Accepted Answer

Selain tahap dasar, kerangka kerja agregasi MongoDB menawarkan fitur lanjutan yang powerful — `$facet` (multiple pipelines sekaligus), `$bucket` (pengelompokan ke dalam range), window functions (`$setWindowFields`), `$graphLookup` (recursive/graph queries), dan lainnya — untuk analytics dan data processing yang sophisticated.

## $facet — multiple pipelines dalam satu query

```js
// run MULTIPLE aggregations on the same data in one pass
db.products.aggregate([
  { $facet: {
      byCategory: [{ $group: { _id: "$category", count: { $sum: 1 } } }],
      priceStats: [{ $group: { _id: null, avg: { $avg: "$price" } } }],
      topRated:   [{ $sort: { rating: -1 } }, { $limit: 5 }]
  }}
]);
// → one query returns all three results (great for dashboards/faceted search)
```

`$facet` menghitung multiple aggregations dalam satu pass — ideal untuk dashboards dan faceted search (mis. filter counts + results + stats bersama-sama).

## $bucket / $bucketAuto — group ke dalam ranges

```js
// group documents into buckets by ranges (like a histogram)
db.products.aggregate([
  { $bucket: {
      groupBy: "$price",
      boundaries: [0, 50, 100, 500, 1000],   // price ranges
      default: "1000+",
      output: { count: { $sum: 1 } }
  }}
]);
```

## Window functions ($setWindowFields)

```js
// running totals, moving averages, rankings (like SQL window functions)
db.sales.aggregate([
  { $setWindowFields: {
      partitionBy: "$region",
      sortBy: { date: 1 },
      output: { runningTotal: { $sum: "$amount", window: { documents: ["unbounded", "current"] } } }
  }}
]);
```

`$setWindowFields` menyediakan window-function capabilities (running totals, moving averages, rankings) — equivalent MongoDB dari SQL window functions.

## $graphLookup — recursive/graph traversal

```js
// traverse hierarchical/graph relationships (e.g. an org chart, category tree)
db.employees.aggregate([
  { $graphLookup: {
      from: "employees", startWith: "$reportsTo",
      connectFromField: "reportsTo", connectToField: "_id",
      as: "managementChain"
  }}
]);
```

`$graphLookup` secara recursive traverses relationships — untuk hierarchies dan graph-like data (similar to recursive CTEs di SQL).

## Mengapa ini penting

Memahami fitur agregasi lanjutan MongoDB adalah valuable senior-level knowledge untuk **sophisticated data analysis dan processing**, building on basic aggregation pipeline.

Sementara basic stages menangani common analytics, fitur lanjutan enable powerful capabilities yang genuinely useful: **`$facet`** (menjalankan multiple aggregations dalam satu pass — ideal untuk dashboards dan faceted search, di mana Anda memerlukan filter counts, results, dan statistics bersama-sama secara efficient, common real need), **`$bucket`/`$bucketAuto`** (pengelompokan ke ranges/histograms — useful untuk distributions dan analytics), **window functions (`$setWindowFields`)** (running totals, moving averages, rankings — equivalent MongoDB dari SQL window functions, enabling time-series dan comparative analytics yang simple grouping tidak bisa), dan **`$graphLookup`** (recursive traversal dari hierarchical/graph relationships — seperti org charts atau category trees, similar ke recursive CTEs di SQL).

Fitur ini memungkinkan MongoDB menangani complex analytical dan data-processing requirements yang sebaliknya memerlukan pulling data ke application code atau separate analytics system.

Memahami fitur ini reflects advanced MongoDB capability dan lets Anda leverage aggregation framework untuk sophisticated needs (dashboards, faceted search, time-series analytics, hierarchical data) langsung di database.

Karena complex analytics dan data processing adalah valuable uses MongoDB, dan karena fitur agregasi lanjutan ($facet, $bucket, window functions, $graphLookup) menyediakan powerful, efficient ways untuk menangani sophisticated requirements (faceted dashboards, distributions, running calculations, graph traversal), memahami advanced aggregation adalah valuable senior-level knowledge yang elevates MongoDB usage dari basic queries ke powerful in-database analytics, hallmark dari advanced MongoDB skill dan topic relevant untuk data-intensive applications yang memerlukan sophisticated analysis langsung di MongoDB.