Neo4j官方示例练习、学习

Myth丶恋晨 2023-02-23 03:45 8阅读 0赞

## 写在前面 ##

主要包括以下几个个方面的学习，基于 docker服务部署

Docker 部署如下命令

1.  下载镜像：`docker pull neo4j:3.5.0`
2.  运行容器：`docker run -d -p 7474:7474 -p 7687:7687 --name neo4j-3.5.0 neo4j:3.5.0`
3.  停止容器：`docker stop neo4j-3.5.0`
4.  启动容器：`docker start neo4j-3.5.0`
5.  浏览器 http://192.168.1.74:7474/ 访问 neo4j 管理后台，初始账号/密码 neo4j/neo4j

两个基本问题

*  怎么用？
 *  什么时候用？

## 一、基本介绍 ##

Neo4j、TigerGraph、Amazon Neptune、JanusGraph、ArangoDB，是市场上最为知名的五大图数据库。

Neo4j是世界领先的图形数据库。 它的体系结构旨在优化管理，存储和遍历节点和关系。 该数据库采用一种属性图方法，这对于遍历性能和操作运行时都非常有利。 Neo4j提供专用的内存管理以及高效的内存操作。

它具有可伸缩性，可以部署为独立服务器，也可以在容错群集中的多台计算机上横向扩展以用于生产环境。 生产应用程序的其他功能包括热备份和广泛的监视。

目前只提供了 官方的驱动和 Java 客户端

服务端版本 包括社区版和商业版

## 二、Get start ##

几个概念  
Nodes - graph data records  
Relationships - connect nodes  
Properties - named data values  
Label - Nodes can be grouped together by applying a Label to each member

### 2.1、Cypher 基础 ###

相当于sql 管理数据库

create

CREATE (ee:Person {  name: "Emil", from: "Sweden", klout: 99 })
    
    注释
    CREATE clause to create data
    () parenthesis to indicate a node
    ee:Person a variable 'ee' and label 'Person' for the new node
    { } brackets to add properties to the node

MATCH

MATCH (ee:Person) WHERE ee.name = "Emil" RETURN ee;
    
    注释
    MATCH clause to specify a pattern of nodes and relationships
    (ee:Person) a single node pattern with label 'Person' which will assign matches to the variable 'ee'
    WHERE clause to constrain the results
    ee.name = "Emil" compares name property to the value "Emil"
    RETURN clause used to request particular results

关系

MATCH (ee:Person) WHERE ee.name = "Emil"
    CREATE (js:Person {  name: "Johan", from: "Sweden", learn: "surfing" }),
    (ir:Person {  name: "Ian", from: "England", title: "author" }),
    (rvb:Person {  name: "Rik", from: "Belgium", pet: "Orval" }),
    (ally:Person {  name: "Allison", from: "California", hobby: "surfing" }),
    (ee)-[:KNOWS { since: 2001}]->(js),(ee)-[:KNOWS { rating: 5}]->(ir),
    (js)-[:KNOWS]->(ir),(js)-[:KNOWS]->(rvb),
    (ir)-[:KNOWS]->(js),(ir)-[:KNOWS]->(ally),
    (rvb)-[:KNOWS]->(ally)

MATCH (ee:Person)-[:KNOWS]-(friends)
    WHERE ee.name = "Emil" RETURN ee, friends
    
    注释
    MATCHclause to describe the pattern from known Nodes to found Nodes
    (ee)starts the pattern with a Person (qualified by WHERE)
    -[:KNOWS]-matches "KNOWS" relationships (in either direction)
    (friends)will be bound to Emil's friends

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTA1NjI5_size_16_color_FFFFFF_t_70]

explain/PROFILE 执行计划

PROFILE MATCH (js:Person)-[:KNOWS]-()-[:KNOWS]-(surfer)
    WHERE js.name = "Johan" AND surfer.hobby = "surfing"
    RETURN DISTINCT surfer

## 三、样本数据测试 ##

### 3.1 、准备数据 ###

CREATE (TheMatrix:Movie { title:'The Matrix', released:1999, tagline:'Welcome to the Real World'})
    CREATE (Keanu:Person { name:'Keanu Reeves', born:1964})
    CREATE (Carrie:Person { name:'Carrie-Anne Moss', born:1967})
    CREATE (Laurence:Person { name:'Laurence Fishburne', born:1961})
    CREATE (Hugo:Person { name:'Hugo Weaving', born:1960})
    CREATE (LillyW:Person { name:'Lilly Wachowski', born:1967})
    CREATE (LanaW:Person { name:'Lana Wachowski', born:1965})
    CREATE (JoelS:Person { name:'Joel Silver', born:1952})
    CREATE
      (Keanu)-[:ACTED_IN { roles:['Neo']}]->(TheMatrix),
      (Carrie)-[:ACTED_IN { roles:['Trinity']}]->(TheMatrix),
      (Laurence)-[:ACTED_IN { roles:['Morpheus']}]->(TheMatrix),
      (Hugo)-[:ACTED_IN { roles:['Agent Smith']}]->(TheMatrix),
      (LillyW)-[:DIRECTED]->(TheMatrix),
      (LanaW)-[:DIRECTED]->(TheMatrix),
      (JoelS)-[:PRODUCED]->(TheMatrix)
    
    CREATE (Emil:Person { name:"Emil Eifrem", born:1978})
    CREATE (Emil)-[:ACTED_IN { roles:["Emil"]}]->(TheMatrix)
    
    CREATE (TheMatrixReloaded:Movie { title:'The Matrix Reloaded', released:2003, tagline:'Free your mind'})
    CREATE
      (Keanu)-[:ACTED_IN { roles:['Neo']}]->(TheMatrixReloaded),
      (Carrie)-[:ACTED_IN { roles:['Trinity']}]->(TheMatrixReloaded),
      (Laurence)-[:ACTED_IN { roles:['Morpheus']}]->(TheMatrixReloaded),
      (Hugo)-[:ACTED_IN { roles:['Agent Smith']}]->(TheMatrixReloaded),
      (LillyW)-[:DIRECTED]->(TheMatrixReloaded),
      (LanaW)-[:DIRECTED]->(TheMatrixReloaded),
      (JoelS)-[:PRODUCED]->(TheMatrixReloaded)
    
    CREATE (TheMatrixRevolutions:Movie { title:'The Matrix Revolutions', released:2003, tagline:'Everything that has a beginning has an end'})
    CREATE
      (Keanu)-[:ACTED_IN { roles:['Neo']}]->(TheMatrixRevolutions),
      (Carrie)-[:ACTED_IN { roles:['Trinity']}]->(TheMatrixRevolutions),
      (Laurence)-[:ACTED_IN { roles:['Morpheus']}]->(TheMatrixRevolutions),
      (Hugo)-[:ACTED_IN { roles:['Agent Smith']}]->(TheMatrixRevolutions),
      (LillyW)-[:DIRECTED]->(TheMatrixRevolutions),
      (LanaW)-[:DIRECTED]->(TheMatrixRevolutions),
      (JoelS)-[:PRODUCED]->(TheMatrixRevolutions)
    
    CREATE (TheDevilsAdvocate:Movie { title:"The Devil's Advocate", released:1997, tagline:'Evil has its winning ways'})
    CREATE (Charlize:Person { name:'Charlize Theron', born:1975})
    CREATE (Al:Person { name:'Al Pacino', born:1940})
    CREATE (Taylor:Person { name:'Taylor Hackford', born:1944})
    CREATE
      (Keanu)-[:ACTED_IN { roles:['Kevin Lomax']}]->(TheDevilsAdvocate),
      (Charlize)-[:ACTED_IN { roles:['Mary Ann Lomax']}]->(TheDevilsAdvocate),
      (Al)-[:ACTED_IN { roles:['John Milton']}]->(TheDevilsAdvocate),
      (Taylor)-[:DIRECTED]->(TheDevilsAdvocate)
    
    CREATE (AFewGoodMen:Movie { title:"A Few Good Men", released:1992, tagline:"In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth."})
    CREATE (TomC:Person { name:'Tom Cruise', born:1962})
    CREATE (JackN:Person { name:'Jack Nicholson', born:1937})
    CREATE (DemiM:Person { name:'Demi Moore', born:1962})
    CREATE (KevinB:Person { name:'Kevin Bacon', born:1958})
    CREATE (KieferS:Person { name:'Kiefer Sutherland', born:1966})
    CREATE (NoahW:Person { name:'Noah Wyle', born:1971})
    CREATE (CubaG:Person { name:'Cuba Gooding Jr.', born:1968})
    CREATE (KevinP:Person { name:'Kevin Pollak', born:1957})
    CREATE (JTW:Person { name:'J.T. Walsh', born:1943})
    CREATE (JamesM:Person { name:'James Marshall', born:1967})
    CREATE (ChristopherG:Person { name:'Christopher Guest', born:1948})
    CREATE (RobR:Person { name:'Rob Reiner', born:1947})
    CREATE (AaronS:Person { name:'Aaron Sorkin', born:1961})
    CREATE
      (TomC)-[:ACTED_IN { roles:['Lt. Daniel Kaffee']}]->(AFewGoodMen),
      (JackN)-[:ACTED_IN { roles:['Col. Nathan R. Jessup']}]->(AFewGoodMen),
      (DemiM)-[:ACTED_IN { roles:['Lt. Cdr. JoAnne Galloway']}]->(AFewGoodMen),
      (KevinB)-[:ACTED_IN { roles:['Capt. Jack Ross']}]->(AFewGoodMen),
      (KieferS)-[:ACTED_IN { roles:['Lt. Jonathan Kendrick']}]->(AFewGoodMen),
      (NoahW)-[:ACTED_IN { roles:['Cpl. Jeffrey Barnes']}]->(AFewGoodMen),
      (CubaG)-[:ACTED_IN { roles:['Cpl. Carl Hammaker']}]->(AFewGoodMen),
      (KevinP)-[:ACTED_IN { roles:['Lt. Sam Weinberg']}]->(AFewGoodMen),
      (JTW)-[:ACTED_IN { roles:['Lt. Col. Matthew Andrew Markinson']}]->(AFewGoodMen),
      (JamesM)-[:ACTED_IN { roles:['Pfc. Louden Downey']}]->(AFewGoodMen),
      (ChristopherG)-[:ACTED_IN { roles:['Dr. Stone']}]->(AFewGoodMen),
      (AaronS)-[:ACTED_IN { roles:['Man in Bar']}]->(AFewGoodMen),
      (RobR)-[:DIRECTED]->(AFewGoodMen),
      (AaronS)-[:WROTE]->(AFewGoodMen)
    
    CREATE (TopGun:Movie { title:"Top Gun", released:1986, tagline:'I feel the need, the need for speed.'})
    CREATE (KellyM:Person { name:'Kelly McGillis', born:1957})
    CREATE (ValK:Person { name:'Val Kilmer', born:1959})
    CREATE (AnthonyE:Person { name:'Anthony Edwards', born:1962})
    CREATE (TomS:Person { name:'Tom Skerritt', born:1933})
    CREATE (MegR:Person { name:'Meg Ryan', born:1961})
    CREATE (TonyS:Person { name:'Tony Scott', born:1944})
    CREATE (JimC:Person { name:'Jim Cash', born:1941})
    CREATE
      (TomC)-[:ACTED_IN { roles:['Maverick']}]->(TopGun),
      (KellyM)-[:ACTED_IN { roles:['Charlie']}]->(TopGun),
      (ValK)-[:ACTED_IN { roles:['Iceman']}]->(TopGun),
      (AnthonyE)-[:ACTED_IN { roles:['Goose']}]->(TopGun),
      (TomS)-[:ACTED_IN { roles:['Viper']}]->(TopGun),
      (MegR)-[:ACTED_IN { roles:['Carole']}]->(TopGun),
      (TonyS)-[:DIRECTED]->(TopGun),
      (JimC)-[:WROTE]->(TopGun)
    
    CREATE (JerryMaguire:Movie { title:'Jerry Maguire', released:2000, tagline:'The rest of his life begins now.'})
    CREATE (ReneeZ:Person { name:'Renee Zellweger', born:1969})
    CREATE (KellyP:Person { name:'Kelly Preston', born:1962})
    CREATE (JerryO:Person { name:"Jerry O'Connell", born:1974})
    CREATE (JayM:Person { name:'Jay Mohr', born:1970})
    CREATE (BonnieH:Person { name:'Bonnie Hunt', born:1961})
    CREATE (ReginaK:Person { name:'Regina King', born:1971})
    CREATE (JonathanL:Person { name:'Jonathan Lipnicki', born:1996})
    CREATE (CameronC:Person { name:'Cameron Crowe', born:1957})
    CREATE
      (TomC)-[:ACTED_IN { roles:['Jerry Maguire']}]->(JerryMaguire),
      (CubaG)-[:ACTED_IN { roles:['Rod Tidwell']}]->(JerryMaguire),
      (ReneeZ)-[:ACTED_IN { roles:['Dorothy Boyd']}]->(JerryMaguire),
      (KellyP)-[:ACTED_IN { roles:['Avery Bishop']}]->(JerryMaguire),
      (JerryO)-[:ACTED_IN { roles:['Frank Cushman']}]->(JerryMaguire),
      (JayM)-[:ACTED_IN { roles:['Bob Sugar']}]->(JerryMaguire),
      (BonnieH)-[:ACTED_IN { roles:['Laurel Boyd']}]->(JerryMaguire),
      (ReginaK)-[:ACTED_IN { roles:['Marcee Tidwell']}]->(JerryMaguire),
      (JonathanL)-[:ACTED_IN { roles:['Ray Boyd']}]->(JerryMaguire),
      (CameronC)-[:DIRECTED]->(JerryMaguire),
      (CameronC)-[:PRODUCED]->(JerryMaguire),
      (CameronC)-[:WROTE]->(JerryMaguire)
    
    CREATE (StandByMe:Movie { title:"Stand By Me", released:1986, tagline:"For some, it's the last real taste of innocence, and the first real taste of life. But for everyone, it's the time that memories are made of."})
    CREATE (RiverP:Person { name:'River Phoenix', born:1970})
    CREATE (CoreyF:Person { name:'Corey Feldman', born:1971})
    CREATE (WilW:Person { name:'Wil Wheaton', born:1972})
    CREATE (JohnC:Person { name:'John Cusack', born:1966})
    CREATE (MarshallB:Person { name:'Marshall Bell', born:1942})
    CREATE
      (WilW)-[:ACTED_IN { roles:['Gordie Lachance']}]->(StandByMe),
      (RiverP)-[:ACTED_IN { roles:['Chris Chambers']}]->(StandByMe),
      (JerryO)-[:ACTED_IN { roles:['Vern Tessio']}]->(StandByMe),
      (CoreyF)-[:ACTED_IN { roles:['Teddy Duchamp']}]->(StandByMe),
      (JohnC)-[:ACTED_IN { roles:['Denny Lachance']}]->(StandByMe),
      (KieferS)-[:ACTED_IN { roles:['Ace Merrill']}]->(StandByMe),
      (MarshallB)-[:ACTED_IN { roles:['Mr. Lachance']}]->(StandByMe),
      (RobR)-[:DIRECTED]->(StandByMe)
    
    CREATE (AsGoodAsItGets:Movie { title:'As Good as It Gets', released:1997, tagline:'A comedy from the heart that goes for the throat.'})
    CREATE (HelenH:Person { name:'Helen Hunt', born:1963})
    CREATE (GregK:Person { name:'Greg Kinnear', born:1963})
    CREATE (JamesB:Person { name:'James L. Brooks', born:1940})
    CREATE
      (JackN)-[:ACTED_IN { roles:['Melvin Udall']}]->(AsGoodAsItGets),
      (HelenH)-[:ACTED_IN { roles:['Carol Connelly']}]->(AsGoodAsItGets),
      (GregK)-[:ACTED_IN { roles:['Simon Bishop']}]->(AsGoodAsItGets),
      (CubaG)-[:ACTED_IN { roles:['Frank Sachs']}]->(AsGoodAsItGets),
      (JamesB)-[:DIRECTED]->(AsGoodAsItGets)
    
    CREATE (WhatDreamsMayCome:Movie { title:'What Dreams May Come', released:1998, tagline:'After life there is more. The end is just the beginning.'})
    CREATE (AnnabellaS:Person { name:'Annabella Sciorra', born:1960})
    CREATE (MaxS:Person { name:'Max von Sydow', born:1929})
    CREATE (WernerH:Person { name:'Werner Herzog', born:1942})
    CREATE (Robin:Person { name:'Robin Williams', born:1951})
    CREATE (VincentW:Person { name:'Vincent Ward', born:1956})
    CREATE
      (Robin)-[:ACTED_IN { roles:['Chris Nielsen']}]->(WhatDreamsMayCome),
      (CubaG)-[:ACTED_IN { roles:['Albert Lewis']}]->(WhatDreamsMayCome),
      (AnnabellaS)-[:ACTED_IN { roles:['Annie Collins-Nielsen']}]->(WhatDreamsMayCome),
      (MaxS)-[:ACTED_IN { roles:['The Tracker']}]->(WhatDreamsMayCome),
      (WernerH)-[:ACTED_IN { roles:['The Face']}]->(WhatDreamsMayCome),
      (VincentW)-[:DIRECTED]->(WhatDreamsMayCome)
    
    CREATE (SnowFallingonCedars:Movie { title:'Snow Falling on Cedars', released:1999, tagline:'First loves last. Forever.'})
    CREATE (EthanH:Person { name:'Ethan Hawke', born:1970})
    CREATE (RickY:Person { name:'Rick Yune', born:1971})
    CREATE (JamesC:Person { name:'James Cromwell', born:1940})
    CREATE (ScottH:Person { name:'Scott Hicks', born:1953})
    CREATE
      (EthanH)-[:ACTED_IN { roles:['Ishmael Chambers']}]->(SnowFallingonCedars),
      (RickY)-[:ACTED_IN { roles:['Kazuo Miyamoto']}]->(SnowFallingonCedars),
      (MaxS)-[:ACTED_IN { roles:['Nels Gudmundsson']}]->(SnowFallingonCedars),
      (JamesC)-[:ACTED_IN { roles:['Judge Fielding']}]->(SnowFallingonCedars),
      (ScottH)-[:DIRECTED]->(SnowFallingonCedars)
    
    CREATE (YouveGotMail:Movie { title:"You've Got Mail", released:1998, tagline:'At odds in life... in love on-line.'})
    CREATE (ParkerP:Person { name:'Parker Posey', born:1968})
    CREATE (DaveC:Person { name:'Dave Chappelle', born:1973})
    CREATE (SteveZ:Person { name:'Steve Zahn', born:1967})
    CREATE (TomH:Person { name:'Tom Hanks', born:1956})
    CREATE (NoraE:Person { name:'Nora Ephron', born:1941})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Joe Fox']}]->(YouveGotMail),
      (MegR)-[:ACTED_IN { roles:['Kathleen Kelly']}]->(YouveGotMail),
      (GregK)-[:ACTED_IN { roles:['Frank Navasky']}]->(YouveGotMail),
      (ParkerP)-[:ACTED_IN { roles:['Patricia Eden']}]->(YouveGotMail),
      (DaveC)-[:ACTED_IN { roles:['Kevin Jackson']}]->(YouveGotMail),
      (SteveZ)-[:ACTED_IN { roles:['George Pappas']}]->(YouveGotMail),
      (NoraE)-[:DIRECTED]->(YouveGotMail)
    
    CREATE (SleeplessInSeattle:Movie { title:'Sleepless in Seattle', released:1993, tagline:'What if someone you never met, someone you never saw, someone you never knew was the only someone for you?'})
    CREATE (RitaW:Person { name:'Rita Wilson', born:1956})
    CREATE (BillPull:Person { name:'Bill Pullman', born:1953})
    CREATE (VictorG:Person { name:'Victor Garber', born:1949})
    CREATE (RosieO:Person { name:"Rosie O'Donnell", born:1962})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Sam Baldwin']}]->(SleeplessInSeattle),
      (MegR)-[:ACTED_IN { roles:['Annie Reed']}]->(SleeplessInSeattle),
      (RitaW)-[:ACTED_IN { roles:['Suzy']}]->(SleeplessInSeattle),
      (BillPull)-[:ACTED_IN { roles:['Walter']}]->(SleeplessInSeattle),
      (VictorG)-[:ACTED_IN { roles:['Greg']}]->(SleeplessInSeattle),
      (RosieO)-[:ACTED_IN { roles:['Becky']}]->(SleeplessInSeattle),
      (NoraE)-[:DIRECTED]->(SleeplessInSeattle)
    
    CREATE (JoeVersustheVolcano:Movie { title:'Joe Versus the Volcano', released:1990, tagline:'A story of love, lava and burning desire.'})
    CREATE (JohnS:Person { name:'John Patrick Stanley', born:1950})
    CREATE (Nathan:Person { name:'Nathan Lane', born:1956})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Joe Banks']}]->(JoeVersustheVolcano),
      (MegR)-[:ACTED_IN { roles:['DeDe', 'Angelica Graynamore', 'Patricia Graynamore']}]->(JoeVersustheVolcano),
      (Nathan)-[:ACTED_IN { roles:['Baw']}]->(JoeVersustheVolcano),
      (JohnS)-[:DIRECTED]->(JoeVersustheVolcano)
    
    CREATE (WhenHarryMetSally:Movie { title:'When Harry Met Sally', released:1998, tagline:'At odds in life... in love on-line.'})
    CREATE (BillyC:Person { name:'Billy Crystal', born:1948})
    CREATE (CarrieF:Person { name:'Carrie Fisher', born:1956})
    CREATE (BrunoK:Person { name:'Bruno Kirby', born:1949})
    CREATE
      (BillyC)-[:ACTED_IN { roles:['Harry Burns']}]->(WhenHarryMetSally),
      (MegR)-[:ACTED_IN { roles:['Sally Albright']}]->(WhenHarryMetSally),
      (CarrieF)-[:ACTED_IN { roles:['Marie']}]->(WhenHarryMetSally),
      (BrunoK)-[:ACTED_IN { roles:['Jess']}]->(WhenHarryMetSally),
      (RobR)-[:DIRECTED]->(WhenHarryMetSally),
      (RobR)-[:PRODUCED]->(WhenHarryMetSally),
      (NoraE)-[:PRODUCED]->(WhenHarryMetSally),
      (NoraE)-[:WROTE]->(WhenHarryMetSally)
    
    CREATE (ThatThingYouDo:Movie { title:'That Thing You Do', released:1996, tagline:'In every life there comes a time when that thing you dream becomes that thing you do'})
    CREATE (LivT:Person { name:'Liv Tyler', born:1977})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Mr. White']}]->(ThatThingYouDo),
      (LivT)-[:ACTED_IN { roles:['Faye Dolan']}]->(ThatThingYouDo),
      (Charlize)-[:ACTED_IN { roles:['Tina']}]->(ThatThingYouDo),
      (TomH)-[:DIRECTED]->(ThatThingYouDo)
    
    CREATE (TheReplacements:Movie { title:'The Replacements', released:2000, tagline:'Pain heals, Chicks dig scars... Glory lasts forever'})
    CREATE (Brooke:Person { name:'Brooke Langton', born:1970})
    CREATE (Gene:Person { name:'Gene Hackman', born:1930})
    CREATE (Orlando:Person { name:'Orlando Jones', born:1968})
    CREATE (Howard:Person { name:'Howard Deutch', born:1950})
    CREATE
      (Keanu)-[:ACTED_IN { roles:['Shane Falco']}]->(TheReplacements),
      (Brooke)-[:ACTED_IN { roles:['Annabelle Farrell']}]->(TheReplacements),
      (Gene)-[:ACTED_IN { roles:['Jimmy McGinty']}]->(TheReplacements),
      (Orlando)-[:ACTED_IN { roles:['Clifford Franklin']}]->(TheReplacements),
      (Howard)-[:DIRECTED]->(TheReplacements)
    
    CREATE (RescueDawn:Movie { title:'RescueDawn', released:2006, tagline:"Based on the extraordinary true story of one man's fight for freedom"})
    CREATE (ChristianB:Person { name:'Christian Bale', born:1974})
    CREATE (ZachG:Person { name:'Zach Grenier', born:1954})
    CREATE
      (MarshallB)-[:ACTED_IN { roles:['Admiral']}]->(RescueDawn),
      (ChristianB)-[:ACTED_IN { roles:['Dieter Dengler']}]->(RescueDawn),
      (ZachG)-[:ACTED_IN { roles:['Squad Leader']}]->(RescueDawn),
      (SteveZ)-[:ACTED_IN { roles:['Duane']}]->(RescueDawn),
      (WernerH)-[:DIRECTED]->(RescueDawn)
    
    CREATE (TheBirdcage:Movie { title:'The Birdcage', released:1996, tagline:'Come as you are'})
    CREATE (MikeN:Person { name:'Mike Nichols', born:1931})
    CREATE
      (Robin)-[:ACTED_IN { roles:['Armand Goldman']}]->(TheBirdcage),
      (Nathan)-[:ACTED_IN { roles:['Albert Goldman']}]->(TheBirdcage),
      (Gene)-[:ACTED_IN { roles:['Sen. Kevin Keeley']}]->(TheBirdcage),
      (MikeN)-[:DIRECTED]->(TheBirdcage)
    
    CREATE (Unforgiven:Movie { title:'Unforgiven', released:1992, tagline:"It's a hell of a thing, killing a man"})
    CREATE (RichardH:Person { name:'Richard Harris', born:1930})
    CREATE (ClintE:Person { name:'Clint Eastwood', born:1930})
    CREATE
      (RichardH)-[:ACTED_IN { roles:['English Bob']}]->(Unforgiven),
      (ClintE)-[:ACTED_IN { roles:['Bill Munny']}]->(Unforgiven),
      (Gene)-[:ACTED_IN { roles:['Little Bill Daggett']}]->(Unforgiven),
      (ClintE)-[:DIRECTED]->(Unforgiven)
    
    CREATE (JohnnyMnemonic:Movie { title:'Johnny Mnemonic', released:1995, tagline:'The hottest data on earth. In the coolest head in town'})
    CREATE (Takeshi:Person { name:'Takeshi Kitano', born:1947})
    CREATE (Dina:Person { name:'Dina Meyer', born:1968})
    CREATE (IceT:Person { name:'Ice-T', born:1958})
    CREATE (RobertL:Person { name:'Robert Longo', born:1953})
    CREATE
      (Keanu)-[:ACTED_IN { roles:['Johnny Mnemonic']}]->(JohnnyMnemonic),
      (Takeshi)-[:ACTED_IN { roles:['Takahashi']}]->(JohnnyMnemonic),
      (Dina)-[:ACTED_IN { roles:['Jane']}]->(JohnnyMnemonic),
      (IceT)-[:ACTED_IN { roles:['J-Bone']}]->(JohnnyMnemonic),
      (RobertL)-[:DIRECTED]->(JohnnyMnemonic)
    
    CREATE (CloudAtlas:Movie { title:'Cloud Atlas', released:2012, tagline:'Everything is connected'})
    CREATE (HalleB:Person { name:'Halle Berry', born:1966})
    CREATE (JimB:Person { name:'Jim Broadbent', born:1949})
    CREATE (TomT:Person { name:'Tom Tykwer', born:1965})
    CREATE (DavidMitchell:Person { name:'David Mitchell', born:1969})
    CREATE (StefanArndt:Person { name:'Stefan Arndt', born:1961})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Zachry', 'Dr. Henry Goose', 'Isaac Sachs', 'Dermot Hoggins']}]->(CloudAtlas),
      (Hugo)-[:ACTED_IN { roles:['Bill Smoke', 'Haskell Moore', 'Tadeusz Kesselring', 'Nurse Noakes', 'Boardman Mephi', 'Old Georgie']}]->(CloudAtlas),
      (HalleB)-[:ACTED_IN { roles:['Luisa Rey', 'Jocasta Ayrs', 'Ovid', 'Meronym']}]->(CloudAtlas),
      (JimB)-[:ACTED_IN { roles:['Vyvyan Ayrs', 'Captain Molyneux', 'Timothy Cavendish']}]->(CloudAtlas),
      (TomT)-[:DIRECTED]->(CloudAtlas),
      (LillyW)-[:DIRECTED]->(CloudAtlas),
      (LanaW)-[:DIRECTED]->(CloudAtlas),
      (DavidMitchell)-[:WROTE]->(CloudAtlas),
      (StefanArndt)-[:PRODUCED]->(CloudAtlas)
    
    CREATE (TheDaVinciCode:Movie { title:'The Da Vinci Code', released:2006, tagline:'Break The Codes'})
    CREATE (IanM:Person { name:'Ian McKellen', born:1939})
    CREATE (AudreyT:Person { name:'Audrey Tautou', born:1976})
    CREATE (PaulB:Person { name:'Paul Bettany', born:1971})
    CREATE (RonH:Person { name:'Ron Howard', born:1954})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Dr. Robert Langdon']}]->(TheDaVinciCode),
      (IanM)-[:ACTED_IN { roles:['Sir Leight Teabing']}]->(TheDaVinciCode),
      (AudreyT)-[:ACTED_IN { roles:['Sophie Neveu']}]->(TheDaVinciCode),
      (PaulB)-[:ACTED_IN { roles:['Silas']}]->(TheDaVinciCode),
      (RonH)-[:DIRECTED]->(TheDaVinciCode)
    
    CREATE (VforVendetta:Movie { title:'V for Vendetta', released:2006, tagline:'Freedom! Forever!'})
    CREATE (NatalieP:Person { name:'Natalie Portman', born:1981})
    CREATE (StephenR:Person { name:'Stephen Rea', born:1946})
    CREATE (JohnH:Person { name:'John Hurt', born:1940})
    CREATE (BenM:Person { name: 'Ben Miles', born:1967})
    CREATE
      (Hugo)-[:ACTED_IN { roles:['V']}]->(VforVendetta),
      (NatalieP)-[:ACTED_IN { roles:['Evey Hammond']}]->(VforVendetta),
      (StephenR)-[:ACTED_IN { roles:['Eric Finch']}]->(VforVendetta),
      (JohnH)-[:ACTED_IN { roles:['High Chancellor Adam Sutler']}]->(VforVendetta),
      (BenM)-[:ACTED_IN { roles:['Dascomb']}]->(VforVendetta),
      (JamesM)-[:DIRECTED]->(VforVendetta),
      (LillyW)-[:PRODUCED]->(VforVendetta),
      (LanaW)-[:PRODUCED]->(VforVendetta),
      (JoelS)-[:PRODUCED]->(VforVendetta),
      (LillyW)-[:WROTE]->(VforVendetta),
      (LanaW)-[:WROTE]->(VforVendetta)
    
    CREATE (SpeedRacer:Movie { title:'Speed Racer', released:2008, tagline:'Speed has no limits'})
    CREATE (EmileH:Person { name:'Emile Hirsch', born:1985})
    CREATE (JohnG:Person { name:'John Goodman', born:1960})
    CREATE (SusanS:Person { name:'Susan Sarandon', born:1946})
    CREATE (MatthewF:Person { name:'Matthew Fox', born:1966})
    CREATE (ChristinaR:Person { name:'Christina Ricci', born:1980})
    CREATE (Rain:Person { name:'Rain', born:1982})
    CREATE
      (EmileH)-[:ACTED_IN { roles:['Speed Racer']}]->(SpeedRacer),
      (JohnG)-[:ACTED_IN { roles:['Pops']}]->(SpeedRacer),
      (SusanS)-[:ACTED_IN { roles:['Mom']}]->(SpeedRacer),
      (MatthewF)-[:ACTED_IN { roles:['Racer X']}]->(SpeedRacer),
      (ChristinaR)-[:ACTED_IN { roles:['Trixie']}]->(SpeedRacer),
      (Rain)-[:ACTED_IN { roles:['Taejo Togokahn']}]->(SpeedRacer),
      (BenM)-[:ACTED_IN { roles:['Cass Jones']}]->(SpeedRacer),
      (LillyW)-[:DIRECTED]->(SpeedRacer),
      (LanaW)-[:DIRECTED]->(SpeedRacer),
      (LillyW)-[:WROTE]->(SpeedRacer),
      (LanaW)-[:WROTE]->(SpeedRacer),
      (JoelS)-[:PRODUCED]->(SpeedRacer)
    
    CREATE (NinjaAssassin:Movie { title:'Ninja Assassin', released:2009, tagline:'Prepare to enter a secret world of assassins'})
    CREATE (NaomieH:Person { name:'Naomie Harris'})
    CREATE
      (Rain)-[:ACTED_IN { roles:['Raizo']}]->(NinjaAssassin),
      (NaomieH)-[:ACTED_IN { roles:['Mika Coretti']}]->(NinjaAssassin),
      (RickY)-[:ACTED_IN { roles:['Takeshi']}]->(NinjaAssassin),
      (BenM)-[:ACTED_IN { roles:['Ryan Maslow']}]->(NinjaAssassin),
      (JamesM)-[:DIRECTED]->(NinjaAssassin),
      (LillyW)-[:PRODUCED]->(NinjaAssassin),
      (LanaW)-[:PRODUCED]->(NinjaAssassin),
      (JoelS)-[:PRODUCED]->(NinjaAssassin)
    
    CREATE (TheGreenMile:Movie { title:'The Green Mile', released:1999, tagline:"Walk a mile you'll never forget."})
    CREATE (MichaelD:Person { name:'Michael Clarke Duncan', born:1957})
    CREATE (DavidM:Person { name:'David Morse', born:1953})
    CREATE (SamR:Person { name:'Sam Rockwell', born:1968})
    CREATE (GaryS:Person { name:'Gary Sinise', born:1955})
    CREATE (PatriciaC:Person { name:'Patricia Clarkson', born:1959})
    CREATE (FrankD:Person { name:'Frank Darabont', born:1959})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Paul Edgecomb']}]->(TheGreenMile),
      (MichaelD)-[:ACTED_IN { roles:['John Coffey']}]->(TheGreenMile),
      (DavidM)-[:ACTED_IN { roles:['Brutus "Brutal" Howell']}]->(TheGreenMile),
      (BonnieH)-[:ACTED_IN { roles:['Jan Edgecomb']}]->(TheGreenMile),
      (JamesC)-[:ACTED_IN { roles:['Warden Hal Moores']}]->(TheGreenMile),
      (SamR)-[:ACTED_IN { roles:['"Wild Bill" Wharton']}]->(TheGreenMile),
      (GaryS)-[:ACTED_IN { roles:['Burt Hammersmith']}]->(TheGreenMile),
      (PatriciaC)-[:ACTED_IN { roles:['Melinda Moores']}]->(TheGreenMile),
      (FrankD)-[:DIRECTED]->(TheGreenMile)
    
    CREATE (FrostNixon:Movie { title:'Frost/Nixon', released:2008, tagline:'400 million people were waiting for the truth.'})
    CREATE (FrankL:Person { name:'Frank Langella', born:1938})
    CREATE (MichaelS:Person { name:'Michael Sheen', born:1969})
    CREATE (OliverP:Person { name:'Oliver Platt', born:1960})
    CREATE
      (FrankL)-[:ACTED_IN { roles:['Richard Nixon']}]->(FrostNixon),
      (MichaelS)-[:ACTED_IN { roles:['David Frost']}]->(FrostNixon),
      (KevinB)-[:ACTED_IN { roles:['Jack Brennan']}]->(FrostNixon),
      (OliverP)-[:ACTED_IN { roles:['Bob Zelnick']}]->(FrostNixon),
      (SamR)-[:ACTED_IN { roles:['James Reston, Jr.']}]->(FrostNixon),
      (RonH)-[:DIRECTED]->(FrostNixon)
    
    CREATE (Hoffa:Movie { title:'Hoffa', released:1992, tagline:"He didn't want law. He wanted justice."})
    CREATE (DannyD:Person { name:'Danny DeVito', born:1944})
    CREATE (JohnR:Person { name:'John C. Reilly', born:1965})
    CREATE
      (JackN)-[:ACTED_IN { roles:['Hoffa']}]->(Hoffa),
      (DannyD)-[:ACTED_IN { roles:['Robert "Bobby" Ciaro']}]->(Hoffa),
      (JTW)-[:ACTED_IN { roles:['Frank Fitzsimmons']}]->(Hoffa),
      (JohnR)-[:ACTED_IN { roles:['Peter "Pete" Connelly']}]->(Hoffa),
      (DannyD)-[:DIRECTED]->(Hoffa)
    
    CREATE (Apollo13:Movie { title:'Apollo 13', released:1995, tagline:'Houston, we have a problem.'})
    CREATE (EdH:Person { name:'Ed Harris', born:1950})
    CREATE (BillPax:Person { name:'Bill Paxton', born:1955})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Jim Lovell']}]->(Apollo13),
      (KevinB)-[:ACTED_IN { roles:['Jack Swigert']}]->(Apollo13),
      (EdH)-[:ACTED_IN { roles:['Gene Kranz']}]->(Apollo13),
      (BillPax)-[:ACTED_IN { roles:['Fred Haise']}]->(Apollo13),
      (GaryS)-[:ACTED_IN { roles:['Ken Mattingly']}]->(Apollo13),
      (RonH)-[:DIRECTED]->(Apollo13)
    
    CREATE (Twister:Movie { title:'Twister', released:1996, tagline:"Don't Breathe. Don't Look Back."})
    CREATE (PhilipH:Person { name:'Philip Seymour Hoffman', born:1967})
    CREATE (JanB:Person { name:'Jan de Bont', born:1943})
    CREATE
      (BillPax)-[:ACTED_IN { roles:['Bill Harding']}]->(Twister),
      (HelenH)-[:ACTED_IN { roles:['Dr. Jo Harding']}]->(Twister),
      (ZachG)-[:ACTED_IN { roles:['Eddie']}]->(Twister),
      (PhilipH)-[:ACTED_IN { roles:['Dustin "Dusty" Davis']}]->(Twister),
      (JanB)-[:DIRECTED]->(Twister)
    
    CREATE (CastAway:Movie { title:'Cast Away', released:2000, tagline:'At the edge of the world, his journey begins.'})
    CREATE (RobertZ:Person { name:'Robert Zemeckis', born:1951})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Chuck Noland']}]->(CastAway),
      (HelenH)-[:ACTED_IN { roles:['Kelly Frears']}]->(CastAway),
      (RobertZ)-[:DIRECTED]->(CastAway)
    
    CREATE (OneFlewOvertheCuckoosNest:Movie { title:"One Flew Over the Cuckoo's Nest", released:1975, tagline:"If he's crazy, what does that make you?"})
    CREATE (MilosF:Person { name:'Milos Forman', born:1932})
    CREATE
      (JackN)-[:ACTED_IN { roles:['Randle McMurphy']}]->(OneFlewOvertheCuckoosNest),
      (DannyD)-[:ACTED_IN { roles:['Martini']}]->(OneFlewOvertheCuckoosNest),
      (MilosF)-[:DIRECTED]->(OneFlewOvertheCuckoosNest)
    
    CREATE (SomethingsGottaGive:Movie { title:"Something's Gotta Give", released:2003})
    CREATE (DianeK:Person { name:'Diane Keaton', born:1946})
    CREATE (NancyM:Person { name:'Nancy Meyers', born:1949})
    CREATE
      (JackN)-[:ACTED_IN { roles:['Harry Sanborn']}]->(SomethingsGottaGive),
      (DianeK)-[:ACTED_IN { roles:['Erica Barry']}]->(SomethingsGottaGive),
      (Keanu)-[:ACTED_IN { roles:['Julian Mercer']}]->(SomethingsGottaGive),
      (NancyM)-[:DIRECTED]->(SomethingsGottaGive),
      (NancyM)-[:PRODUCED]->(SomethingsGottaGive),
      (NancyM)-[:WROTE]->(SomethingsGottaGive)
    
    CREATE (BicentennialMan:Movie { title:'Bicentennial Man', released:1999, tagline:"One robot's 200 year journey to become an ordinary man."})
    CREATE (ChrisC:Person { name:'Chris Columbus', born:1958})
    CREATE
      (Robin)-[:ACTED_IN { roles:['Andrew Marin']}]->(BicentennialMan),
      (OliverP)-[:ACTED_IN { roles:['Rupert Burns']}]->(BicentennialMan),
      (ChrisC)-[:DIRECTED]->(BicentennialMan)
    
    CREATE (CharlieWilsonsWar:Movie { title:"Charlie Wilson's War", released:2007, tagline:"A stiff drink. A little mascara. A lot of nerve. Who said they couldn't bring down the Soviet empire."})
    CREATE (JuliaR:Person { name:'Julia Roberts', born:1967})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Rep. Charlie Wilson']}]->(CharlieWilsonsWar),
      (JuliaR)-[:ACTED_IN { roles:['Joanne Herring']}]->(CharlieWilsonsWar),
      (PhilipH)-[:ACTED_IN { roles:['Gust Avrakotos']}]->(CharlieWilsonsWar),
      (MikeN)-[:DIRECTED]->(CharlieWilsonsWar)
    
    CREATE (ThePolarExpress:Movie { title:'The Polar Express', released:2004, tagline:'This Holiday Season… Believe'})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Hero Boy', 'Father', 'Conductor', 'Hobo', 'Scrooge', 'Santa Claus']}]->(ThePolarExpress),
      (RobertZ)-[:DIRECTED]->(ThePolarExpress)
    
    CREATE (ALeagueofTheirOwn:Movie { title:'A League of Their Own', released:1992, tagline:'Once in a lifetime you get a chance to do something different.'})
    CREATE (Madonna:Person { name:'Madonna', born:1954})
    CREATE (GeenaD:Person { name:'Geena Davis', born:1956})
    CREATE (LoriP:Person { name:'Lori Petty', born:1963})
    CREATE (PennyM:Person { name:'Penny Marshall', born:1943})
    CREATE
      (TomH)-[:ACTED_IN { roles:['Jimmy Dugan']}]->(ALeagueofTheirOwn),
      (GeenaD)-[:ACTED_IN { roles:['Dottie Hinson']}]->(ALeagueofTheirOwn),
      (LoriP)-[:ACTED_IN { roles:['Kit Keller']}]->(ALeagueofTheirOwn),
      (RosieO)-[:ACTED_IN { roles:['Doris Murphy']}]->(ALeagueofTheirOwn),
      (Madonna)-[:ACTED_IN { roles:['"All the Way" Mae Mordabito']}]->(ALeagueofTheirOwn),
      (BillPax)-[:ACTED_IN { roles:['Bob Hinson']}]->(ALeagueofTheirOwn),
      (PennyM)-[:DIRECTED]->(ALeagueofTheirOwn)
    
    CREATE (PaulBlythe:Person { name:'Paul Blythe'})
    CREATE (AngelaScope:Person { name:'Angela Scope'})
    CREATE (JessicaThompson:Person { name:'Jessica Thompson'})
    CREATE (JamesThompson:Person { name:'James Thompson'})
    
    CREATE
      (JamesThompson)-[:FOLLOWS]->(JessicaThompson),
      (AngelaScope)-[:FOLLOWS]->(JessicaThompson),
      (PaulBlythe)-[:FOLLOWS]->(AngelaScope)
    
    CREATE
      (JessicaThompson)-[:REVIEWED { summary:'An amazing journey', rating:95}]->(CloudAtlas),
      (JessicaThompson)-[:REVIEWED { summary:'Silly, but fun', rating:65}]->(TheReplacements),
      (JamesThompson)-[:REVIEWED { summary:'The coolest football movie ever', rating:100}]->(TheReplacements),
      (AngelaScope)-[:REVIEWED { summary:'Pretty funny at times', rating:62}]->(TheReplacements),
      (JessicaThompson)-[:REVIEWED { summary:'Dark, but compelling', rating:85}]->(Unforgiven),
      (JessicaThompson)-[:REVIEWED { summary:"Slapstick redeemed only by the Robin Williams and Gene Hackman's stellar performances", rating:45}]->(TheBirdcage),
      (JessicaThompson)-[:REVIEWED { summary:'A solid romp', rating:68}]->(TheDaVinciCode),
      (JamesThompson)-[:REVIEWED { summary:'Fun, but a little far fetched', rating:65}]->(TheDaVinciCode),
      (JessicaThompson)-[:REVIEWED { summary:'You had me at Jerry', rating:92}]->(JerryMaguire)
    
    WITH TomH as a
    MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a,m,d LIMIT 10;

这里数据很多，如下关系图

[添加链接描述][Link 1]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTA1NjI5_size_16_color_FFFFFF_t_70 1]

### 3.2、Find ###

*  1、Find the actor named “Tom Hanks”…

MATCH (tom { name: "Tom Hanks"}) RETURN tom

*  3、Find the movie with title “Cloud Atlas”…

MATCH (cloudAtlas { title: "Cloud Atlas"}) RETURN cloudAtlas

*  4、Find 10 people…

MATCH (people:Person) RETURN people.name LIMIT 10

*  5、Find movies released in the 1990s…

MATCH (nineties:Movie) WHERE nineties.released >= 1990 AND nineties.released < 2000 RETURN nineties.title

### 3.3、query ###

*  List all Tom Hanks movies…

MATCH (tom:Person { name: "Tom Hanks"})-[:ACTED_IN]->(tomHanksMovies) RETURN tom,tomHanksMovies

*  Who directed “Cloud Atlas”?

MATCH (cloudAtlas { title: "Cloud Atlas"})<-[:DIRECTED]-(directors) RETURN directors.name

*  Tom Hanks’ co-actors…

MATCH (tom:Person { name:"Tom Hanks"})-[:ACTED_IN]->(m)<-[:ACTED_IN]-(coActors) RETURN coActors.name

*  How people are related to “Cloud Atlas”…

MATCH (people:Person)-[relatedTo]-(:Movie { title: "Cloud Atlas"}) RETURN people.name, Type(relatedTo), relatedTo

### 3.4、Solve ###

*  Movies and actors up to 4 “hops” away from Kevin Bacon

MATCH (bacon:Person { name:"Kevin Bacon"})-[*1..4]-(hollywood)
     RETURN DISTINCT hollywood

*  Bacon path, the shortest path of any relationships to Meg Ryan

MATCH p=shortestPath(
      (bacon:Person { name:"Kevin Bacon"})-[*]-(meg:Person { name:"Meg Ryan"})
    )
    RETURN p

Note you only need to compare property values like this when first creating relationships

### 3.5、delete ###

MATCH (n) DETACH DELETE n

### 3.6、load 加载CSV数据 ###

LOAD CSV WITH HEADERS FROM "http://data.neo4j.com/northwind/products.csv" AS row
    CREATE (n:Product)
    SET n = row,
      n.unitPrice = toFloat(row.unitPrice),
      n.unitsInStock = toInteger(row.unitsInStock), n.unitsOnOrder = toInteger(row.unitsOnOrder),
      n.reorderLevel = toInteger(row.reorderLevel), n.discontinued = (row.discontinued <> "0")

索引

CREATE INDEX ON :Product(productID)

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTA1NjI5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200705005642306.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTA1NjI5,size_16,color_FFFFFF,t_70
[Link 1]: https://kdocs.cn/l/cURYYgb8J%20%5B%E9%87%91%E5%B1%B1%E6%96%87%E6%A1%A3%5D%20graph.svg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTA1NjI5_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200705012912944.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTA1NjI5,size_16,color_FFFFFF,t_70