品牌建设网站特点,wordpress清理无用缩略图,电子商务网站建设与管理的背景,上海企业名录 企业黄页关系类型数量源数据目标数据属性ACTED_IN172演员电影roles#xff08;角色扮演#xff09;属性#xff0c;属性值为数组DIRECTED44导演电影无PRODUCED15制片商电影无WROTE10作家电影无FOLLOWS3影评人影评人无REVIEWED9影评人电影summary#xff08;影评摘要#xff09;和 …关系类型数量源数据目标数据属性ACTED_IN172演员电影roles角色扮演属性属性值为数组DIRECTED44导演电影无PRODUCED15制片商电影无WROTE10作家电影无FOLLOWS3影评人影评人无REVIEWED9影评人电影summary影评摘要和 rating评分属性
【先按照书本整理下等理解加深后再加对应注释】
序号查询目的脚本1查找所有相关电影、人物、关系MATCH (n) RETURN n2查找名为“Tom Hanks”的人物MATCH (person{name:Tom Hanks}) RETURN person3随机查找10个人物的人名MATCH (people:Person) RETURN people.name LIMIT 104随机查找10个人物MATCH (people:Person) RETURN people LIMIT 105查找1990-2000年之间发行的电影名称 MATCH (nineties:Movie) WHERE nineties.released1990 AND nineties.released2000 RETURN nineties.title,nineties.released ORDER BY nineties.released 6查找Tom Hanks参演过的电影名称 MATCH (people:Person{name:Tom Hanks})-[:ACTED_IN]-(actorMovies) RETURN people,actorMovies 7查找谁导演了电影“Cloud Atlas” MATCH (move {title:Cloud Atlas}) - [:DIRECTED] - (directors) RETURN directors.name 8查找与Tom Hanks一同出演过电影的人 MATCH (people:Person{name:Tom Hanks})-[:ACTED_IN]-(m)-[:ACTED_IN]-(acActors) RETURN acActors.name,m.title 9查找与电影Cloud Atlas相关的人 MATCH (people:Person) - [relatedTo] - (movie:Movie {title:Cloud Atlas}) RETURN people.name,Type(relatedTo),relatedTo,movie.title 10查找与演员Kevin Bacon存在4条及以内关系的任何演员和电影 MATCH (people:Person{name:Kevin Bacon}) - [*1..4] - (hollywood) RETURN DISTINCT hollywood 11查找与演员Kevin Bacon与Meg Ryan之间的最短关系路径 MATCH pshortestPath((people:Person{name:Kevin Bacon}) - [*] - (other:Person{name:Meg Ryan})) RETURN p 12查找没有与Tom Hanks合作过的演员 1、先找到Tom Hanks还没有合作过的演员但Tom Hanks的合作伙伴曾经与其合作过 2、找到一个可以向他的潜在合作者介绍Tom Hanks的人 MATCH (people:Person{name:Tom Hanks}) - [:ACTED_IN]-(m)-[:ACTED_IN]-(others), (others)-[:ACTED_IN]-(m2)-[:ACTED_IN]-(otherothers) WHERE NOT (people)- [:ACTED_IN]-(m2) RETURN otherothers.name AS Recommended,count(*) AS Strength ORDER BY Strength DESC 13找人将Tom Hanks介绍给Tom Cruise MATCH (tom:Person{name:Tom Hanks})-[:ACTED_IN]-(m)-[:ACTED_IN]-(others), (others)-[:ACTED_IN]-(m2)-[:ACTED_IN]-(cruise:Person{name:Tom Cruise}) RETURN tom,m,others,m2,cruise 14匹配某个电影相关的演员和导演等多种关系 MATCH (movie:Movie{title:The Matrix Reloaded})-[:ACTED_IN|DIRECTED]-(person) RETURN person.name 15单条最短路径shortestPath函数 MATCH (apeople:Person{name:Tom Hanks}),(bpeople:Person{name:Tom Cruise}), pshortestPath((apeople)-[*..4]-(bpeople)) RETURN p 16所有最短路径allshortestPaths函数 MATCH (apeople:Person{name:Tom Hanks}),(bpeople:Person{name:Tom Cruise}), pallshortestPaths((apeople)-[*..4]-(bpeople)) RETURN p
