Paano ka ke tsara alaƙa a cikin MongoDB?

Question

Accepted Answer

MongoDB ke tsara alaƙa (daya-daya, daya-da-yawancin, yawanci-daya) ta hanyar **haɗawa** ko **nuni** — zaɓi ya dogara ne akan cardinality na alaƙa, yadda ake samun data, da kuma ko an raba ta. Ba kamar SQL na amfani da tsabar-tsabar foreign-key, MongoDB ke taɓa ɓaje-ɓaje ga kowane alaƙa.

## Daya-daya

```js
// usually EMBED (the related data belongs to the document)
{ _id: ObjectId("..."), name: "Ann", profile: { bio: "...", avatar: "..." } }
// → one query gets both; they're accessed together
```

## Daya-da-yawancin (mafi kusan - da kuma mafi ɓatalacciya)

```js
// ONE-TO-FEW → embed (bounded, accessed together)
{ _id: ObjectId("..."), name: "Ann", addresses: [ {...}, {...} ] }  // a few addresses

// ONE-TO-MANY → reference (the "many" side references the "one")
// authors collection: { _id: "a1", name: "Ann" }
// books collection:   { _id: "b1", authorId: "a1", title: "..." }  // each book references its author

// ONE-TO-SQUILLIONS (huge/unbounded) → ALWAYS reference (never embed unbounded data)
// e.g. a user with millions of log entries → separate collection, reference by userId
```

Mahaɗi na mahimmantan aiki: **daya-ga-kadan** (haɗa), **daya-da-yawancin** (nuni daga wajen yawanci), **daya-ga-miliyan** (koyaushe nuni — kada haɗa babu iyaka, saboda iyaka na sauti na 16MB da aiki).

## Yawanci-daya

```js
// reference with an array of ids (on one or both sides)
{ _id: "s1", name: "Student", courseIds: ["c1", "c2"] }     // student → courses
{ _id: "c1", name: "Course", studentIds: ["s1", "s2"] }     // course → students (optional)
// → query and $lookup to resolve; or a separate "enrollments" collection (junction-like)
```

Yawanci-daya yana amfani da jerin nunin ids (a gefe daya ko biyu), ko zaɓi daban-daban kamar jeri don bayanan alaƙa masu karfi.

## Warware nunin ($lookup)

```js
// join referenced data when needed
db.books.aggregate([
  { $lookup: { from: "authors", localField: "authorId", foreignField: "_id", as: "author" } }
]);
```

## Me ya sa ya maɓali

Tsara alaƙa ita ce tushe na nuni na bayanai, kuma hanyar MongoDB ta ɓaje-ɓaje, ta anda-anda buƙata, ta saba da uniform foreign keys na SQL, don haka fahimtar yadda ke tsara alaƙa a cikin MongoDB ita ce ya zama dole don tsara amsosai masu kyau.

Sanin da ya mahimma shi ne cewa MongoDB ke tsara alaƙa ta hanyar **haɗawa ko nuni** dangane da siffa ta alaƙa — da fahimtar **yadda cardinality ke tasira kan zaɓi** shine ƙwarewa mafi mahimmantan: **daya-daya** (yawancin lokacin haɗa — an taba aiki tare), **daya-da-yawancin** tare da mahimman sauye-sauye (**daya-ga-kadan** → haɗa don badarar aiki tare; **daya-da-yawancin** → nuni daga wajen yawanci; **daya-ga-miliyan** → koyaushe nuni, kada haɗa babu iyaka saboda iyaka na 16MB da aiki), da **yawanci-daya** (jerin nunin ids, ko zaɓi ɗin kamar jeri).

Wannan yanke-yanke mai cardinality (musamman ganewa lokacin da bayanai sun kasua/babu iyaka don haɗa) ya zama dole don guje wa kuskuri na gida kamar haɗawa jerin babu iyaka (taye-taye sauti, bugi iyaka) ko over-referencing bayanan ya kamata haɗa.

Fahimtar yadda ke **warware nunin** tare da `$lookup` lokacin da aka buƙa jeri ye kammala hoton.

Saboda alaƙa tsakanin entities suna cikin yawancin nuni, kuma saboda hanyar MongoDB ta ɓaje-ɓaje kowane-kowane alaƙa (haɗa daga gida cardinality da anda-anda) ita ce ta ƙetare kuma mafi ɓatalacciya fiye da uniform foreign keys na SQL, fahimtar yadda ke tsara alaƙa a cikin MongoDB — yanke-yanke cardinality-base haɗa/nuni (musamman sauye-sauye daya-ga-kadan/da-yawancin/miliyan) da warware nunin — ita ce dole, aiki-aiki da yawa ilimi don tsara amsosai masu kyau a MongoDB, gida kan tushen haɗa/nuni don jiya alaƙa kowa da tsarin aiki mai tsani, da muhimmin waje mai ware sane MongoDB modeling daga naive relational ports.