Here, a similarity between two players in a game is calculated by the number of times they have eaten the same food.
Query.
MATCH me-[r1:ATE]->food<-[r2:ATE]-you WHERE me.name = 'me' WITH me,count(DISTINCT r1) AS H1,count(DISTINCT r2) AS H2,you MATCH me-[r1:ATE]->food<-[r2:ATE]-you RETURN sum((1-ABS(r1.times/H1-r2.times/H2))*(r1.times+r2.times)/(H1+H2)) AS similarity
The two players and their similarity measure.
Copyright © 2013 Neo Technology