MongoDB to neo4j - modelling

DistribuzioneGaussiana Published at Dev

DistribuzioneGaussiana

I have to convert this mongoDB document into a neo4j. This is an example of document:

{
    "_id" : "Atl.02",
    "official_name" : "Club Atletico de Madrid S.A.D.",
    "common_name" : "Atletico Madrid",
    "country" : "Spain",
    "started_by" : {
        "day" : 26,
        "month" : 4,
        "year" : 1903
    },
    "stadium" : {
        "name" : "Vicente Calderón",
        "capacity" : 54907
    },
    "palmarès" : {
        "La Liga" : 10,
        "Segunda Division" : 1,
        "Copa del Rey" : 10,
        "Supercopa de Espana" : 2,
        "UEFA Europa League" : 2,
        "UEFA Cup Winners Cup" : 1,
        "UEFA Super Cup" : 2,
        "FIFA Club World cup" : 1
    },
    "uniform" : "blue, white and red"
}

I create a team node:

CREATE (n:team {_id:"Atl.02", official_name:"Club Atletico de Madrid S.A.D.", 
common_name:"Atletico Madrid", country:"Spain", 
started_by_day: 26, started_by_month:4, started_by_year:1903, 
uniform:"blue, white and red"})

A stadium node:

CREATE (n:stadium {name:"Vicente Calderòn", capacity:54907})

The relationship between the team and the stadium:

MATCH (n:team), (n1:stadium) WHERE n._id="Atl.02" AND
n1.name="Vicente Calderòn" CREATE n-[r:PLAYS]->n1

Here is a picture:
enter image description here

The first thing is:
how to convert the information about palmarès?
I thought two possibilities:
1) put this information in team node
2) create a new node, called palmarès, and set the properties on the relationship
What do you think? And waht about started by information? Is it a good choice to put it in team node?

cybersam

I recommend that you represent the individual prizes as separate nodes, since the same prize can be won by multiple teams in different years. Also, the queries for specific prizes would be easier to write and run quicker.

For example:

(team:team {_id:"Atl.02"})-[:AWARDED {count: 10}]->(prize:Prize {name: "La Liga"})

I think putting "started_by" in the Team node is fine, but you might want to store the year/month/day as a single integer (e.g., an epoch date) to make it easier to do Cypher queries involving the date.

Or, if you have no convenient way to convert the year/month/day to an integer, you can combine them into an 8-character string (in year, month, and day order). Here is an example of how to do that:

WITH 1993 AS year, 01 AS month, 16 AS day
RETURN
  TOSTRING(year) +
  (CASE WHEN month < 10 THEN "0" + month ELSE month END) +
  (CASE WHEN day < 10 THEN "0" + day ELSE day END)
  AS date;

The resulting date would be: "19930116".

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-19

Comments

0 comments

From Dev

Related Related

Article

MongoDB to neo4j - modelling

MongoDB to neo4j - modelling

Neo4j modelling advice

Suggestions for data modelling in Neo4j

Modelling time-varying financial exposures in `Neo4j`

Data modelling in MongoDB

unable to connect mongoDB and neo4j

Neo4j graph modelling performance and querability, property to a node or as separate node plus relationship

Neo4j graph modelling performance and querability, property to a node or as separate node plus relationship

Modelling tree/hierarchy structure in Spring Data Neo4j 4.1

Celery with MongoDB result backend and Neo4j storage

MongoDB + Neo4J vs OrientDB vs ArangoDB

Is combining MongoDB with Neo4J a good practice?

Convert a MongoDB with two collections in a neo4j graph

Is combining MongoDB with Neo4J a good practice?

How to integrate Spring Data Neo4j and Mongodb in Grails 2.4.2 Project

MongoDB or Neo4J for users attending to Event M:M relationship

Neo4J with APOC and MongoDB Driver, limiting returned records from Mongo

Modelling a pendulum in Haskell using RK4

Modelling domain objects in ASP.NET MVC 4

UML for system modelling or for software modelling?

Neo4j - NOT IN query

Neo4j multitenancy

Dividing in Neo4j

Java with Neo4j

Neo4j Deadlocks

Neo4j and Hugepages

Neo4j - NOT IN query

Java with Neo4j

Querying the Neo4j

Substring in Neo4j