当前位置：文江博客话题详情

Nosql多对多

发布于 2024-10-10 18:10:51 字数 32 浏览 1 评论 0原文

在文档数据库设计中处理多对多关系的公认模式是什么？

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

橘香 2024-10-17 18:10:51

您想要如何对多对多进行建模取决于您想要提出什么样的查询、您想要如何更新数据等等...假设我们有与多对多方式的 bar 相关的 foo。

您可以将 foo 建模为

{
   'bars': ['bar1', 'bar2', 'bar3']
}

并将 bar 建模为

{
   'foos': ['foo_x', 'foo_y', 'foo_z']
}

或者您可以将 foo 和 bar 之间的图表或关系建模为单独的文档本身

{
    from: 'foo1',
    to: 'bar1'
}

{
   from: 'foo1',
   to: 'bar2'
}

{  
   from: 'foo2',
   to: 'bar3
}

{
  from 'foo3',
  to: 'bar3'
}

还有很多其他方法。您想要如何做到这一点取决于您想要提出的问题、您想要支持的操作、您想要提高效率以及数据库中可用的索引。

How you want to model the many-to-many will depend on what kind of queries you want to ask, how you want to update the data, etc... Say we have foos related to bars in a many to many fashion.

You could model a foo as

{
   'bars': ['bar1', 'bar2', 'bar3']
}

and model a bar as

{
   'foos': ['foo_x', 'foo_y', 'foo_z']
}

Or you could model the graph or relations between foo and bar as individual documents themselves

{
    from: 'foo1',
    to: 'bar1'
}

{
   from: 'foo1',
   to: 'bar2'
}

{  
   from: 'foo2',
   to: 'bar3
}

{
  from 'foo3',
  to: 'bar3'
}

There are plenty of other ways too. How you want to do it will depend on the questions you want to ask, the operations you want to support, what you want to be efficient, and the indexing available in the database.

回复收藏 0 原文