Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

editing subdocments N-N relationship in mongodb

I have an application where an article can be linked to multiple platforms.

Article contains a list of platforms and platforms also contains a list of articles.

For more detailed information please look at this stackoverflow question that I asked a few months ago.

https://stackoverflow.com/a/40377383/5770147

The question was on how to create an article and implement the N-N relationship between article and platform.

I have Creating article and Deleting the article setup so that the lists update in the platforms aswell.

How do I implement editing an article so I can update which platforms are linked to an article?

For creating and editing the linked platforms I use a dropdown menu in which multiple options can be selected. The necessary code can be found in the question previously linked.

like image 388
WebstraDev Avatar asked Feb 09 '17 14:02

WebstraDev


1 Answers

Based on the information that you provided, I would recommend two possible approaches, starting from the same foundation:

Use two collections (articles and platforms) and store only a reference to platform documents in an array defined on article documents

I would recommend this approach if:

  • You have a high cardinality of both article documents, as well as platforms
  • You want to be able to manage both entities independently, while also syncing references between them

    // articles collection schema
    {
    "_id": ...,
    "title": "I am an article",
    
    ...
    
    "platforms": [ "platform_1", "platform_2", "platform_3" ],
    ...
    }
    
    
    // platforms collection schema    
    {
    "_id": "platform_1",
    "name": "Platform 1",
    "url": "http://right/here",
    ...
    },
    
    {
    "_id": "platform_2",
    "name": "Platform 2",
    "url": "http://right/here",
    ...
    },
    
    {
    "_id": "platform_3",
    "name": "Platform 3",
    "url": "http://right/here",
    ...
    }
    

Even if this approach is quite flexible, it comes at a cost - if you require both article and platform data, you will have to fire more queries to your MongoDB instance, as the data is split in two different collections.

For example, when loading an article page, considering that you also want to display a list of platforms, you would have to fire a query to the articles collection, and then also trigger a search on the platforms collection to retrieve all the platform entities to which that article is published via the members of the platforms array on the article document.

However, if you only have a small subset of frequently accessed platform attributes that you need to have available when loading an article document, you might enhance the platforms array on the articles collection to store those attributes in addition to the _id reference to the platform documents:

// enhanced articles collection schema  
{
"_id": ...,
"title": "I am an article",

...

"platforms": [
    {platform_id: "platform_1", name: "Platform 1"},
    {platform_id: "platform_2", name: "Platform 2"},
    {platform_id: "platform_3", name: "Platform 3"}
],

...

}

This hybrid approach would be suitable if the platform data attributes that you frequently retrieve to display together with article specific data are not changing that often.

Otherwise, you will have to synchronize all the updates that are made to the platform document attributes in the platforms collection with the subset of attributes that you track as part of the platforms array for article documents.

Regarding the management of article lists for individual platforms, I wouldn't recommend storing N-to-N references in both collections, as the aforementioned mechanism already allows you to extract article lists by querying the articles collection using a find query with the _id value of the platform document:

Approach #1
db.articles.find({"platforms": "platform_1"});

Approach #2:
db.articles.find({"platforms.platform_id": "platform_1"});

Having presented two different approaches, what I would recommend now is for you to analyze the query patterns and performance thresholds of your application and make a calculated decision based on the scenarios that you encounter.

like image 183
vladzam Avatar answered Nov 09 '22 06:11

vladzam