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.
Relation 1: INTERACTIONS_COUNT
Relation 2: TEAM_OF
Relation 3: ORGANASATION_OF
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'
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'.
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?