Hello everyone,
I am coming from RDBMS background and I want to know how to model my requirement and how effective the query will be in neo4j.
Requirement:
Relation 1: INTERACTIONS_COUNT
employee_name<-->employee_name
Relation 2: TEAM_OF
employee<-->team_name
Relation 3: ORGANASATION_OF
team_name<-->org_name
problem Statement : Give me most interacted employees(output employee should consist of searched name) of given employee in a particular team and in a particular org.
Eg: Give me most interacted employees of 'sam' whose name consists of 'jam' and whose team name consists of string 'mail' and whose organisation name is 'google'
Input:
So if 'sam' interactes with 'James cameron', 'Jamieson', 'sam Billings' and 'Andrew james' with teams 'google mail', 'google drive', 'google mail' and 'google mail' respectively in org 'google'.
Output:
My output should be 'James cameron' and 'Andrew james' in decreasing order of interaction count.
After seeing the documentation, I felt it is easier to enter my data. But I have no idea how the cypher query looks like since I need to search for sub string for employee name and team name!! Can someone help me with cypher query and will that query be effective in neo4j?
Thank you!