Neo4j

vnjogani · 12-20-2021

I am new to Cypher and trying to figure out how one would achieve some kinds of queries that are relatively straightforward in SQL. One that comes to mind is computing Jaccard Similarity. I know there is a special procedure that does that, but say I ...

vnjogani · 12-23-2021

This also worked, and it makes sense -- albeit it's a bit counterintuitive coming from SQL. Readability-wise, the below solution looks a bit better to me but do you know which would be more efficient?

vnjogani · 12-23-2021

martin3: MATCH (m2:Movie)<-[:ACTED_IN]-(i:Person)-[:ACTED_IN]->(m1:Movie) WITH m1, m2 MATCH (u:Person)-[:ACTED_IN]->(m:Movie) WHERE ID(m) = ID(m1) OR ID(m) = ID(m2) This worked! Thank you 

vnjogani · 12-21-2021

I tried something like this: MATCH (m2:Movie)<-[:ACTED_IN]-(i:Person)-[:ACTED_IN]->(m1:Movie) WHERE id(m1) = 9 AND id(m2) = 10 WITH m1, m2, count(distinct i) AS Intersection MATCH (m3:Movie)<-[:ACTED_IN]-(i:Person) WITH m3, COUNT(distinct i) as count...

vnjogani · 12-21-2021

This is not quite what I had in mind -- For each pair of movies (m1, m2) I want to compute the Jaccard Similarity of their actors (sorry I should've clarified this earlier). For example, Matrix 1 and Matrix 2 might share 80% of the actors (intersecti...

Neo4j

User Statistics

User Activity

Complex SQL-like queries in Cypher

Re: Complex SQL-like queries in Cypher

Re: Complex SQL-like queries in Cypher

Re: Complex SQL-like queries in Cypher

Re: Complex SQL-like queries in Cypher