Neo4j Cipher via Neo4j-shell

MATCH (a)-[r:ACTED_IN]->(m)
RETURN a.name,r.roles, m.title

:play movies

MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, m.title

Number of movies : $match (n:Movie) return count(n)
match (n:Movie) return count(n)

match (n) return count(n)

// Creating Movies

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 (AndyW:Person {name:’Andy 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), (AndyW)-[: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), (AndyW)-[: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), (AndyW)-[: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 (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), (AndyW)-[:DIRECTED]->(CloudAtlas), (LanaW)-[:DIRECTED]->(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), (AndyW)-[:PRODUCED]->(VforVendetta), (LanaW)-[:PRODUCED]->(VforVendetta), (JoelS)-[:PRODUCED]->(VforVendetta), (AndyW)-[: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), (AndyW)-[:DIRECTED]->(SpeedRacer), (LanaW)-[:DIRECTED]->(SpeedRacer), (AndyW)-[: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), (AndyW)-[: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) WITH TomH as a MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a,m,d LIMIT 10 ;

#pwd
/home/srinivas
#
#
#
#
#cd neo4j-community-2.3.0
#
#
#
#
#
#
#
#ll -lhtr
total 320K
-rw-r–r– 1 rtkit nogroup 1.6K Oct 17 02:50 README.txt
-rw-r–r– 1 rtkit nogroup 5.9K Oct 17 02:50 NOTICE.txt
-rw-r–r– 1 rtkit nogroup 36K Oct 17 02:50 LICENSE.txt
-rw-r–r– 1 rtkit nogroup 123K Oct 17 02:50 LICENSES.txt
-rw-r–r– 1 rtkit nogroup 92K Oct 17 02:50 CHANGES.txt
drwxr-xr-x 8 rtkit nogroup 4.0K Oct 17 02:50 ./
-rw-r–r– 1 rtkit nogroup 4.3K Oct 17 04:51 UPGRADE.txt
drwxr-xr-x 4 rtkit nogroup 4.0K Oct 30 22:39 system/
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 30 22:39 plugins/
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 22:39 bin/
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 30 22:39 lib/
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 23:49 conf/
drwxr-xr-x 6 rtkit nogroup 4.0K Oct 30 23:49 data/
drwxr-xr-x 16 srinivas srinivas 20K Oct 31 00:27 ../
#
#
#cd bin/
#
#
#ll -lhtr
total 56K
-rwxr-xr-x 1 rtkit nogroup 11K Oct 17 02:50 utils*
-rw-r–r– 1 rtkit nogroup 136 Oct 17 02:50 README.txt
-rwxr-xr-x 1 rtkit nogroup 3.4K Oct 17 02:50 neo4j-shell*
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 17 02:50 Neo4j-Management/
-rwxr-xr-x 1 rtkit nogroup 4.4K Oct 17 02:50 neo4j-installer*
-rwxr-xr-x 1 rtkit nogroup 3.5K Oct 17 02:50 neo4j-import*
-rwxr-xr-x 1 rtkit nogroup 11K Oct 17 02:50 neo4j*
drwxr-xr-x 8 rtkit nogroup 4.0K Oct 17 02:50 ../
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 22:39 ./
#
#
#cd ..
#
#
#
#bin/neo4j start
WARNING: Max 1024 open files allowed, minimum of 40 000 recommended. See the Neo4j manual.
Starting Neo4j Server…process [2736]… waiting for server to be ready………………… OK.
http://localhost:7474/ is ready.
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#./neo4j-shell
Welcome to the Neo4j Shell! Enter ‘help’ for a list of commands
NOTE: Remote Neo4j graph database service ‘shell’ at port 1337

neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH ()-[r:ACTED_IN]->() RETURN r LIMIT 25
> ;
+————————————————————+
| r |
+————————————————————+
| :ACTED_IN[7]{roles:[“Emil”]} |
| :ACTED_IN[3]{roles:[“Agent Smith”]} |
| :ACTED_IN[2]{roles:[“Morpheus”]} |
| :ACTED_IN[1]{roles:[“Trinity”]} |
| :ACTED_IN[0]{roles:[“Neo”]} |
| :ACTED_IN[11]{roles:[“Agent Smith”]} |
| :ACTED_IN[10]{roles:[“Morpheus”]} |
| :ACTED_IN[9]{roles:[“Trinity”]} |
| :ACTED_IN[8]{roles:[“Neo”]} |
| :ACTED_IN[18]{roles:[“Agent Smith”]} |
| :ACTED_IN[16]{roles:[“Trinity”]} |
| :ACTED_IN[17]{roles:[“Morpheus”]} |
| :ACTED_IN[15]{roles:[“Neo”]} |
| :ACTED_IN[24]{roles:[“John Milton”]} |
| :ACTED_IN[22]{roles:[“Kevin Lomax”]} |
| :ACTED_IN[23]{roles:[“Mary Ann Lomax”]} |
| :ACTED_IN[37]{roles:[“Man in Bar”]} |
| :ACTED_IN[36]{roles:[“Dr. Stone”]} |
| :ACTED_IN[33]{roles:[“Lt. Sam Weinberg”]} |
| :ACTED_IN[32]{roles:[“Cpl. Carl Hammaker”]} |
| :ACTED_IN[35]{roles:[“Pfc. Louden Downey”]} |
| :ACTED_IN[34]{roles:[“Lt. Col. Matthew Andrew Markinson”]} |
| :ACTED_IN[30]{roles:[“Lt. Jonathan Kendrick”]} |
| :ACTED_IN[31]{roles:[“Cpl. Jeffrey Barnes”]} |
| :ACTED_IN[28]{roles:[“Lt. Cdr. JoAnne Galloway”]} |
+————————————————————+
25 rows
119 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (n:Movie) RETURN n LIMIT 25;
+—————————————————————————————————————————————————————————————————————————————-+
| n |
+—————————————————————————————————————————————————————————————————————————————-+
| Node[1]{tagline:”Welcome to the Real World”,title:”The Matrix”,released:1999} |
+—————————————————————————————————————————————————————————————————————————————-+
25 rows
65 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH ()-[r:ACTED_IN]->() RETURN r LIMIT 1;
+——————————+
| r |
+——————————+
| :ACTED_IN[7]{roles:[“Emil”]} |
+——————————+
1 row
32 ms
neo4j-sh (?)$ MATCH ()-[r:ACTED_IN]->() RETURN r LIMIT 6;
+————————————–+
| r |
+————————————–+
| :ACTED_IN[7]{roles:[“Emil”]} |
| :ACTED_IN[3]{roles:[“Agent Smith”]} |
| :ACTED_IN[2]{roles:[“Morpheus”]} |
| :ACTED_IN[1]{roles:[“Trinity”]} |
| :ACTED_IN[0]{roles:[“Neo”]} |
| :ACTED_IN[11]{roles:[“Agent Smith”]} |
+————————————–+
6 rows
37 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)
> RETURN a.name, m.title limit 10;
+———————————————–+
| a.name | m.title |
+———————————————–+
| “Keanu Reeves” | “Something’s Gotta Give” |
| “Keanu Reeves” | “Johnny Mnemonic” |
| “Keanu Reeves” | “The Replacements” |
| “Keanu Reeves” | “The Devil’s Advocate” |
| “Keanu Reeves” | “The Matrix Revolutions” |
| “Keanu Reeves” | “The Matrix Reloaded” |
| “Keanu Reeves” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix” |
+———————————————–+
10 rows
49 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a.name, m.title;
+————————————————————–+
| a.name | m.title |
+————————————————————–+
| “Christina Ricci” | “Speed Racer” |
| “Rain” | “Speed Racer” |
| “Ben Miles” | “Speed Racer” |
| “Emile Hirsch” | “Speed Racer” |
| “John Goodman” | “Speed Racer” |
| “Susan Sarandon” | “Speed Racer” |
| “Matthew Fox” | “Speed Racer” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
| “Tom Hanks” | “Cloud Atlas” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Keanu Reeves” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Keanu Reeves” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Keanu Reeves” | “The Matrix” |
| “Christina Ricci” | “Speed Racer” |
| “Rain” | “Speed Racer” |
| “Ben Miles” | “Speed Racer” |
| “Emile Hirsch” | “Speed Racer” |
| “John Goodman” | “Speed Racer” |
| “Susan Sarandon” | “Speed Racer” |
| “Matthew Fox” | “Speed Racer” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
| “Tom Hanks” | “Cloud Atlas” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Keanu Reeves” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Keanu Reeves” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Keanu Reeves” | “The Matrix” |
| “Al Pacino” | “The Devil’s Advocate” |
| “Keanu Reeves” | “The Devil’s Advocate” |
| “Charlize Theron” | “The Devil’s Advocate” |
| “Rain” | “Ninja Assassin” |
| “Naomie Harris” | “Ninja Assassin” |
| “Rick Yune” | “Ninja Assassin” |
| “Ben Miles” | “Ninja Assassin” |
| “Stephen Rea” | “V for Vendetta” |
| “Natalie Portman” | “V for Vendetta” |
| “Hugo Weaving” | “V for Vendetta” |
| “Ben Miles” | “V for Vendetta” |
| “John Hurt” | “V for Vendetta” |
| “Bruno Kirby” | “When Harry Met Sally” |
| “Carrie Fisher” | “When Harry Met Sally” |
| “Meg Ryan” | “When Harry Met Sally” |
| “Billy Crystal” | “When Harry Met Sally” |
| “Marshall Bell” | “Stand By Me” |
| “Kiefer Sutherland” | “Stand By Me” |
| “John Cusack” | “Stand By Me” |
| “Wil Wheaton” | “Stand By Me” |
| “River Phoenix” | “Stand By Me” |
| “Jerry O’Connell” | “Stand By Me” |
| “Corey Feldman” | “Stand By Me” |
| “Aaron Sorkin” | “A Few Good Men” |
| “Christopher Guest” | “A Few Good Men” |
| “Kevin Pollak” | “A Few Good Men” |
| “Cuba Gooding Jr.” | “A Few Good Men” |
| “James Marshall” | “A Few Good Men” |
| “J.T. Walsh” | “A Few Good Men” |
| “Kiefer Sutherland” | “A Few Good Men” |
| “Noah Wyle” | “A Few Good Men” |
| “Demi Moore” | “A Few Good Men” |
| “Kevin Bacon” | “A Few Good Men” |
| “Tom Cruise” | “A Few Good Men” |
| “Jack Nicholson” | “A Few Good Men” |
| “Meg Ryan” | “Top Gun” |
| “Tom Skerritt” | “Top Gun” |
| “Kelly McGillis” | “Top Gun” |
| “Tom Cruise” | “Top Gun” |
| “Anthony Edwards” | “Top Gun” |
| “Val Kilmer” | “Top Gun” |
| “Jonathan Lipnicki” | “Jerry Maguire” |
| “Jerry O’Connell” | “Jerry Maguire” |
| “Jay Mohr” | “Jerry Maguire” |
| “Bonnie Hunt” | “Jerry Maguire” |
| “Regina King” | “Jerry Maguire” |
| “Tom Cruise” | “Jerry Maguire” |
| “Cuba Gooding Jr.” | “Jerry Maguire” |
| “Renee Zellweger” | “Jerry Maguire” |
| “Kelly Preston” | “Jerry Maguire” |
| “Cuba Gooding Jr.” | “As Good as It Gets” |
| “Greg Kinnear” | “As Good as It Gets” |
| “Helen Hunt” | “As Good as It Gets” |
| “Jack Nicholson” | “As Good as It Gets” |
| “Christian Bale” | “RescueDawn” |
| “Zach Grenier” | “RescueDawn” |
| “Steve Zahn” | “RescueDawn” |
| “Marshall Bell” | “RescueDawn” |
| “Annabella Sciorra” | “What Dreams May Come” |
| “Cuba Gooding Jr.” | “What Dreams May Come” |
| “Robin Williams” | “What Dreams May Come” |
| “Werner Herzog” | “What Dreams May Come” |
| “Max von Sydow” | “What Dreams May Come” |
| “James Cromwell” | “Snow Falling on Cedars” |
| “Rick Yune” | “Snow Falling on Cedars” |
| “Max von Sydow” | “Snow Falling on Cedars” |
| “Ethan Hawke” | “Snow Falling on Cedars” |
| “Charlize Theron” | “That Thing You Do” |
| “Liv Tyler” | “That Thing You Do” |
| “Tom Hanks” | “That Thing You Do” |
| “Rosie O’Donnell” | “Sleepless in Seattle” |
| “Tom Hanks” | “Sleepless in Seattle” |
| “Bill Pullman” | “Sleepless in Seattle” |
| “Victor Garber” | “Sleepless in Seattle” |
| “Meg Ryan” | “Sleepless in Seattle” |
| “Rita Wilson” | “Sleepless in Seattle” |
| “Dave Chappelle” | “You’ve Got Mail” |
| “Steve Zahn” | “You’ve Got Mail” |
| “Greg Kinnear” | “You’ve Got Mail” |
| “Parker Posey” | “You’ve Got Mail” |
| “Tom Hanks” | “You’ve Got Mail” |
| “Meg Ryan” | “You’ve Got Mail” |
| “Meg Ryan” | “Joe Versus the Volcano” |
| “Tom Hanks” | “Joe Versus the Volcano” |
| “Nathan Lane” | “Joe Versus the Volcano” |
| “Keanu Reeves” | “The Replacements” |
| “Brooke Langton” | “The Replacements” |
| “Gene Hackman” | “The Replacements” |
| “Orlando Jones” | “The Replacements” |
| “Tom Hanks” | “Charlie Wilson’s War” |
| “Julia Roberts” | “Charlie Wilson’s War” |
| “Philip Seymour Hoffman” | “Charlie Wilson’s War” |
| “Robin Williams” | “The Birdcage” |
| “Nathan Lane” | “The Birdcage” |
| “Gene Hackman” | “The Birdcage” |
| “Gene Hackman” | “Unforgiven” |
| “Richard Harris” | “Unforgiven” |
| “Clint Eastwood” | “Unforgiven” |
| “Dina Meyer” | “Johnny Mnemonic” |
| “Ice-T” | “Johnny Mnemonic” |
| “Keanu Reeves” | “Johnny Mnemonic” |
| “Takeshi Kitano” | “Johnny Mnemonic” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
| “Tom Hanks” | “Cloud Atlas” |
| “Oliver Platt” | “Frost/Nixon” |
| “Sam Rockwell” | “Frost/Nixon” |
| “Frank Langella” | “Frost/Nixon” |
| “Kevin Bacon” | “Frost/Nixon” |
| “Michael Sheen” | “Frost/Nixon” |
| “Ed Harris” | “Apollo 13” |
| “Bill Paxton” | “Apollo 13” |
| “Tom Hanks” | “Apollo 13” |
| “Kevin Bacon” | “Apollo 13” |
| “Gary Sinise” | “Apollo 13” |
| “Paul Bettany” | “The Da Vinci Code” |
| “Audrey Tautou” | “The Da Vinci Code” |
| “Ian McKellen” | “The Da Vinci Code” |
| “Tom Hanks” | “The Da Vinci Code” |
| “Michael Clarke Duncan” | “The Green Mile” |
| “Tom Hanks” | “The Green Mile” |
| “Bonnie Hunt” | “The Green Mile” |
| “David Morse” | “The Green Mile” |
| “Sam Rockwell” | “The Green Mile” |
| “James Cromwell” | “The Green Mile” |
| “Patricia Clarkson” | “The Green Mile” |
| “Gary Sinise” | “The Green Mile” |
| “Jack Nicholson” | “Hoffa” |
| “John C. Reilly” | “Hoffa” |
| “Danny DeVito” | “Hoffa” |
| “J.T. Walsh” | “Hoffa” |
| “Philip Seymour Hoffman” | “Twister” |
| “Zach Grenier” | “Twister” |
| “Bill Paxton” | “Twister” |
| “Helen Hunt” | “Twister” |
| “Tom Hanks” | “The Polar Express” |
| “Tom Hanks” | “Cast Away” |
| “Helen Hunt” | “Cast Away” |
| “Danny DeVito” | “One Flew Over the Cuckoo’s Nest” |
| “Jack Nicholson” | “One Flew Over the Cuckoo’s Nest” |
| “Keanu Reeves” | “Something’s Gotta Give” |
| “Diane Keaton” | “Something’s Gotta Give” |
| “Jack Nicholson” | “Something’s Gotta Give” |
| “Oliver Platt” | “Bicentennial Man” |
| “Robin Williams” | “Bicentennial Man” |
| “Tom Hanks” | “A League of Their Own” |
| “Geena Davis” | “A League of Their Own” |
| “Lori Petty” | “A League of Their Own” |
| “Rosie O’Donnell” | “A League of Their Own” |
| “Madonna” | “A League of Their Own” |
| “Bill Paxton” | “A League of Their Own” |
+————————————————————–+
200 rows
366 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a.name, m.title limit 10;
+———————————–+
| a.name | m.title |
+———————————–+
| “Christina Ricci” | “Speed Racer” |
| “Rain” | “Speed Racer” |
| “Ben Miles” | “Speed Racer” |
| “Emile Hirsch” | “Speed Racer” |
| “John Goodman” | “Speed Racer” |
| “Susan Sarandon” | “Speed Racer” |
| “Matthew Fox” | “Speed Racer” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
+———————————–+
10 rows
59 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a.name,d.name,m.title limit 10;
+——————————————————+
| a.name | d.name | m.title |
+——————————————————+
| “Christina Ricci” | “Andy Wachowski” | “Speed Racer” |
| “Rain” | “Andy Wachowski” | “Speed Racer” |
| “Ben Miles” | “Andy Wachowski” | “Speed Racer” |
| “Emile Hirsch” | “Andy Wachowski” | “Speed Racer” |
| “John Goodman” | “Andy Wachowski” | “Speed Racer” |
| “Susan Sarandon” | “Andy Wachowski” | “Speed Racer” |
| “Matthew Fox” | “Andy Wachowski” | “Speed Racer” |
| “Jim Broadbent” | “Andy Wachowski” | “Cloud Atlas” |
| “Hugo Weaving” | “Andy Wachowski” | “Cloud Atlas” |
| “Halle Berry” | “Andy Wachowski” | “Cloud Atlas” |
+——————————————————+
10 rows
58 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (keanu:Person)-[r:ACTED_IN]->(movie),(movie)<-[r:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” AND ANY (x IN r.name WHERE x!=”Keanu Reeves”) RETURN distinct coact.name limit 10;
[ERROR] Could not expand event
java.lang.IllegalArgumentException: !=”Keanu Reeves”) RETURN distinct coact.name limit 10;: event not found
at jline.console.ConsoleReader.expandEvents(ConsoleReader.java:779)
at jline.console.ConsoleReader.finishBuffer(ConsoleReader.java:631)
at jline.console.ConsoleReader.accept(ConsoleReader.java:2019)
at jline.console.ConsoleReader.readLine(ConsoleReader.java:2666)
at jline.console.ConsoleReader.readLine(ConsoleReader.java:2269)
at jline.console.ConsoleReader.readLine(ConsoleReader.java:2257)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.neo4j.shell.impl.JLineConsole.readLine(JLineConsole.java:98)
at org.neo4j.shell.impl.AbstractClient.readLine(AbstractClient.java:268)
at org.neo4j.shell.impl.AbstractClient.grabPrompt(AbstractClient.java:96)
at org.neo4j.shell.StartClient.grabPromptOrJustExecuteCommand(StartClient.java:383)
at org.neo4j.shell.StartClient.startRemote(StartClient.java:330)
at org.neo4j.shell.StartClient.start(StartClient.java:196)
at org.neo4j.shell.StartClient.main(StartClient.java:135)

neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (keanu:Person)-[r:ACTED_IN]->(movie),(movie)<-[r:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” AND ANY (x IN r.name WHERE x.name =”Keanu Reeves”) RETURN distinct coact.name limit 10;
10 ms

WARNING: Cannot use the same relationship identifier ‘r’ for multiple patterns (line 1, column 23 (offset: 22))
“MATCH (keanu:Person)-[r:ACTED_IN]->(movie),(movie)<-[r:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” AND ANY (x IN r.name WHERE x.name =”Keanu Reeves”) RETURN distinct coact.name limit 10″
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (keanu:Person)-[r:ACTED_IN]->(movie),(movie)<-[r:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” AND ANY (x IN r.name WHERE x.name =”Keanu Reeves”) RETURN distinct coact.name limit 10;
6 ms

WARNING: Cannot use the same relationship identifier ‘r’ for multiple patterns (line 1, column 23 (offset: 22))
“MATCH (keanu:Person)-[r:ACTED_IN]->(movie),(movie)<-[r:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” AND ANY (x IN r.name WHERE x.name =”Keanu Reeves”) RETURN distinct coact.name limit 10″
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ maatch (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” RETURN distinct coact.name limit 10;
Unknown command ‘maatch’
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” RETURN distinct coact.name limit 10;
6 ms

WARNING: coact not defined (line 1, column 136 (offset: 135))
“match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” RETURN distinct coact.name limit 10″
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k WITH coc,m optional mactch RETURN coc.name,m.name ;
13 ms

WARNING: Invalid input ‘c’: expected ‘t/T’ (line 1, column 153 (offset: 152))
“match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k WITH coc,m optional mactch RETURN coc.name,m.name “
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k WITH coc,m optional match RETURN coc.name,m.name ;
7 ms

WARNING: Invalid input ‘o’: expected ‘r/R’ (line 1, column 166 (offset: 165))
“match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k WITH coc,m optional match RETURN coc.name,m.name “
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k WITH coc,m optional match (coc)-[r:ACTED_IN]->(m) RETURN coc.name,m.title ;
+————————————————-+
| coc.name | m.title |
+————————————————-+
| “Danny DeVito” | “Something’s Gotta Give” |
| “John C. Reilly” | “Something’s Gotta Give” |
| “Danny DeVito” | “Something’s Gotta Give” |
| “J.T. Walsh” | “Something’s Gotta Give” |
| “Cuba Gooding Jr.” | “Something’s Gotta Give” |
| “Greg Kinnear” | “Something’s Gotta Give” |
| “Helen Hunt” | “Something’s Gotta Give” |
| “Aaron Sorkin” | “Something’s Gotta Give” |
| “Christopher Guest” | “Something’s Gotta Give” |
| “Kevin Pollak” | “Something’s Gotta Give” |
| “Cuba Gooding Jr.” | “Something’s Gotta Give” |
| “James Marshall” | “Something’s Gotta Give” |
| “J.T. Walsh” | “Something’s Gotta Give” |
| “Kiefer Sutherland” | “Something’s Gotta Give” |
| “Noah Wyle” | “Something’s Gotta Give” |
| “Demi Moore” | “Something’s Gotta Give” |
| “Kevin Bacon” | “Something’s Gotta Give” |
| “Tom Cruise” | “Something’s Gotta Give” |
| “Richard Harris” | “The Replacements” |
| “Clint Eastwood” | “The Replacements” |
| “Robin Williams” | “The Replacements” |
| “Nathan Lane” | “The Replacements” |
| “Liv Tyler” | “The Devil’s Advocate” |
| “Tom Hanks” | “The Devil’s Advocate” |
| “Stephen Rea” | “The Matrix Revolutions” |
| “Natalie Portman” | “The Matrix Revolutions” |
| “Ben Miles” | “The Matrix Revolutions” |
| “John Hurt” | “The Matrix Revolutions” |
| “Jim Broadbent” | “The Matrix Revolutions” |
| “Halle Berry” | “The Matrix Revolutions” |
| “Tom Hanks” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Emil Eifrem” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Emil Eifrem” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Emil Eifrem” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Stephen Rea” | “The Matrix Reloaded” |
| “Natalie Portman” | “The Matrix Reloaded” |
| “Ben Miles” | “The Matrix Reloaded” |
| “John Hurt” | “The Matrix Reloaded” |
| “Jim Broadbent” | “The Matrix Reloaded” |
| “Halle Berry” | “The Matrix Reloaded” |
| “Tom Hanks” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Stephen Rea” | “The Matrix” |
| “Natalie Portman” | “The Matrix” |
| “Ben Miles” | “The Matrix” |
| “John Hurt” | “The Matrix” |
| “Jim Broadbent” | “The Matrix” |
| “Halle Berry” | “The Matrix” |
| “Tom Hanks” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |

| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
+————————————————-+
87 rows
388 ms
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k AND NOT ((k)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc)) RETURN coc.name,count(coc) ORDER BY count(coc) DESC LIMIT 3;
+—————————-+
| coc.name | count(coc) |
+—————————-+
| “Tom Hanks” | 4 |
| “Stephen Rea” | 3 |
| “Ben Miles” | 3 |
+—————————-+
3 rows
443 ms
neo4j-sh (?)$
neo4j-sh (?)$
srinivas@srinivas-HP-G62-Notebook-PC:~$
srinivas@srinivas-HP-G62-Notebook-PC:~$
srinivas@srinivas-HP-G62-Notebook-PC:~$
srinivas@srinivas-HP-G62-Notebook-PC:~$
srinivas@srinivas-HP-G62-Notebook-PC:~$ sudo su
[sudo] password for srinivas:
#
#
#
#
#
#
#
#
#
#pwd
/home/srinivas
#
#ll -lhtr
total 47M
drwxr-xr-x 3 root root 4.0K Aug 28 19:47 ../
-rw-r–r– 1 srinivas srinivas 675 Aug 28 19:47 .profile
-rw-r–r– 1 srinivas srinivas 220 Aug 28 19:47 .bash_logout
-rw-r–r– 1 srinivas srinivas 8.8K Aug 28 19:47 examples.desktop
-rw-r–r– 1 srinivas srinivas 3.6K Aug 28 19:47 .bashrc
drwxr-xr-x 2 srinivas srinivas 4.0K Aug 28 20:12 Videos/
drwxr-xr-x 2 srinivas srinivas 4.0K Aug 28 20:12 Templates/
drwxr-xr-x 2 srinivas srinivas 4.0K Aug 28 20:12 Public/
drwxr-xr-x 2 srinivas srinivas 4.0K Aug 28 20:12 Pictures/
drwxr-xr-x 2 srinivas srinivas 4.0K Aug 28 20:12 Music/
drwxr-xr-x 2 srinivas srinivas 4.0K Aug 28 20:12 Documents/
drwx—— 3 srinivas srinivas 4.0K Aug 28 20:12 .local/
drwxrwxr-x 2 srinivas srinivas 4.0K Aug 28 20:36 test/
drwx—— 3 srinivas srinivas 4.0K Aug 28 22:12 .compiz/
drwx—— 4 srinivas srinivas 4.0K Aug 28 23:23 .mozilla/
drwx—— 4 srinivas srinivas 4.0K Aug 30 03:11 .thunderbird/
-rw-rw-r– 1 srinivas srinivas 998K Aug 30 23:38 epp231_en.exe
drwxrwxr-x 15 srinivas srinivas 4.0K Sep 1 23:14 New_Movies/
-rw-rw-r– 1 srinivas srinivas 0 Sep 3 11:07 email ids funNfun
drwx—— 3 srinivas srinivas 4.0K Sep 10 15:02 .dbus/
drwx—— 7 srinivas srinivas 4.0K Sep 23 07:24 .Skype/
drwx—— 3 srinivas srinivas 4.0K Sep 29 02:10 .adobe/
drwx—— 3 srinivas srinivas 4.0K Sep 29 02:10 .macromedia/
drwx—— 2 srinivas srinivas 12K Sep 29 11:03 all songs/
drwxrwxr-x 2 srinivas srinivas 20K Oct 5 11:28 Trip/
-rw-rw-r– 1 srinivas srinivas 39K Oct 5 13:37 12039217_892880520793537_6285703555469422163_n.jpg
drwxrwxr-x 3 srinivas srinivas 16K Oct 5 15:31 Trip (copy)/
drwxrwxr-x 2 srinivas srinivas 4.0K Oct 17 13:50 .mplayer/
drwxrwxr-x 2 srinivas srinivas 20K Oct 20 23:13 Mahabaleswar_pics/
drwx—— 3 srinivas srinivas 4.0K Oct 22 22:07 .thumbnails/
-rw-rw-r– 1 srinivas srinivas 46M Oct 23 00:09 google-chrome-stable_current_amd64.deb
drwx—— 3 srinivas srinivas 4.0K Oct 27 00:02 .pki/
drwx—— 30 srinivas srinivas 4.0K Oct 27 00:02 .cache/
drwx—— 32 srinivas srinivas 4.0K Oct 27 00:02 .config/
drwx—— 3 srinivas srinivas 4.0K Oct 27 00:02 .gnome/
-rw——- 1 srinivas srinivas 4.4K Oct 31 00:01 .bash_history
drwxr-xr-x 16 srinivas srinivas 20K Oct 31 00:27 Downloads/
drwxr-xr-x 24 srinivas srinivas 4.0K Oct 31 00:27 .gimp-2.8/
drwxr-xr-x 2 srinivas srinivas 4.0K Oct 31 00:33 Desktop/
-rw——- 1 srinivas srinivas 1.2K Oct 31 01:13 .xsession-errors.old
-rw——- 1 srinivas srinivas 72 Oct 31 08:58 .Xauthority
-rw——- 1 srinivas srinivas 25K Oct 31 08:58 .ICEauthority
drwxr-xr-x 32 srinivas srinivas 4.0K Oct 31 08:58 ./
drwx—— 4 srinivas srinivas 4.0K Oct 31 08:58 .gconf/
-rw——- 1 srinivas srinivas 486 Oct 31 08:58 .xsession-errors
#
#
#
#
#
#
#cd Do
Documents/ Downloads/
#cd Do
Documents/ Downloads/
#cd Downloads/
#
#
#
#
#
#
#
#
#
#ll -ltr
total 111160
drwxrwxr-x 6 501 501 4096 Aug 8 02:03 usr/
drwxrwxr-x 2 501 501 4096 Aug 8 02:03 LGPL/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 14 13:08 Ted 2/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 14 13:09 The intern/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 14 15:43 all_subtitles/
drwxr-xr-x 8 rtkit nogroup 4096 Oct 17 02:50 neo4j-community-2.3.0/
-rw——- 1 srinivas srinivas 52847804 Oct 18 00:43 PCMLinux_GPL_sources.zip.part
-rw-rw-r– 1 srinivas srinivas 13038 Oct 20 22:36 Devil.2010.1080p.BrRip.x264.YIFY.torrent
-rw-rw-r– 1 srinivas srinivas 26219 Oct 20 23:25 devil_english-995081.zip
-rw-rw-r– 1 srinivas srinivas 20998 Oct 25 02:03 Cast.Away.2000.720p.BrRip.x264.950.41.MB.YIFY.torrent
drwxrwxr-x 2 srinivas srinivas 4096 Oct 25 02:04 Journey 1/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 25 02:04 Devil (2010) [1080p]/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 25 02:04 The Judge (2014) [1080p]/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 25 02:04 Frozen.Fever.2015.720p.Bluray.X264.DTS-EVO/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 25 02:04 Into the Woods (2014) [1080p]/
drwxrwxr-x 2 srinivas srinivas 4096 Oct 25 02:26 Cast Away (2000)/
-rw-rw-r– 1 srinivas srinivas 17912 Oct 25 22:21 Into.the.Wild.2007.720p.BrRip.x264.850MB.YIFY.torrent
-rw-rw-r– 1 srinivas srinivas 67770 Oct 26 23:27 Interstellar.2014.1080p.BluRay.H264.AAC.RARBG.torrent
drwxrwxr-x 2 srinivas srinivas 4096 Oct 26 23:28 Into The Wild (2007)/
drwxrwxr-x 3 srinivas srinivas 4096 Oct 27 01:55 Interstellar.2014.1080p.BluRay.H264.AAC-RARBG/
-rw-r—– 1 srinivas srinivas 60735 Oct 30 22:34 Neo4jFundamentalsCourse-SetupInstructions.pdf
-rw-r—– 1 srinivas srinivas 58590471 Oct 30 22:36 neo4j-community-2.3.0-unix.tar.gz
-rw-r—– 1 srinivas srinivas 2057063 Oct 31 00:27 newdbfry123.xcf
drwxr-xr-x 16 srinivas srinivas 20480 Oct 31 00:27 ./
drwxr-xr-x 32 srinivas srinivas 4096 Oct 31 08:58 ../
#
#cd neo4j-community-2.3.0
#
#
#
#
#
#
#
#ll -lhtr
total 320K
-rw-r–r– 1 rtkit nogroup 1.6K Oct 17 02:50 README.txt
-rw-r–r– 1 rtkit nogroup 5.9K Oct 17 02:50 NOTICE.txt
-rw-r–r– 1 rtkit nogroup 36K Oct 17 02:50 LICENSE.txt
-rw-r–r– 1 rtkit nogroup 123K Oct 17 02:50 LICENSES.txt
-rw-r–r– 1 rtkit nogroup 92K Oct 17 02:50 CHANGES.txt
drwxr-xr-x 8 rtkit nogroup 4.0K Oct 17 02:50 ./
-rw-r–r– 1 rtkit nogroup 4.3K Oct 17 04:51 UPGRADE.txt
drwxr-xr-x 4 rtkit nogroup 4.0K Oct 30 22:39 system/
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 30 22:39 plugins/
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 22:39 bin/
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 30 22:39 lib/
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 23:49 conf/
drwxr-xr-x 6 rtkit nogroup 4.0K Oct 30 23:49 data/
drwxr-xr-x 16 srinivas srinivas 20K Oct 31 00:27 ../
#
#
#cd bin/
#
#
#ll -lhtr
total 56K
-rwxr-xr-x 1 rtkit nogroup 11K Oct 17 02:50 utils*
-rw-r–r– 1 rtkit nogroup 136 Oct 17 02:50 README.txt
-rwxr-xr-x 1 rtkit nogroup 3.4K Oct 17 02:50 neo4j-shell*
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 17 02:50 Neo4j-Management/
-rwxr-xr-x 1 rtkit nogroup 4.4K Oct 17 02:50 neo4j-installer*
-rwxr-xr-x 1 rtkit nogroup 3.5K Oct 17 02:50 neo4j-import*
-rwxr-xr-x 1 rtkit nogroup 11K Oct 17 02:50 neo4j*
drwxr-xr-x 8 rtkit nogroup 4.0K Oct 17 02:50 ../
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 22:39 ./
#
#
#cd ..
#
#
#
#bin/neo4j start
WARNING: Max 1024 open files allowed, minimum of 40 000 recommended. See the Neo4j manual.
Starting Neo4j Server…process [2736]… waiting for server to be ready………………… OK.
http://localhost:7474/ is ready.
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#
#ll -lhtr
total 320K
-rw-r–r– 1 rtkit nogroup 1.6K Oct 17 02:50 README.txt
-rw-r–r– 1 rtkit nogroup 5.9K Oct 17 02:50 NOTICE.txt
-rw-r–r– 1 rtkit nogroup 36K Oct 17 02:50 LICENSE.txt
-rw-r–r– 1 rtkit nogroup 123K Oct 17 02:50 LICENSES.txt
-rw-r–r– 1 rtkit nogroup 92K Oct 17 02:50 CHANGES.txt
drwxr-xr-x 8 rtkit nogroup 4.0K Oct 17 02:50 ./
-rw-r–r– 1 rtkit nogroup 4.3K Oct 17 04:51 UPGRADE.txt
drwxr-xr-x 4 rtkit nogroup 4.0K Oct 30 22:39 system/
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 30 22:39 plugins/
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 22:39 bin/
drwxr-xr-x 2 rtkit nogroup 4.0K Oct 30 22:39 lib/
drwxr-xr-x 3 rtkit nogroup 4.0K Oct 30 23:49 conf/
drwxr-xr-x 6 rtkit nogroup 4.0K Oct 30 23:49 data/
drwxr-xr-x 16 srinivas srinivas 20K Oct 31 00:27 ../
#
#
#
#
#cd bi
bash: cd: bi: No such file or directory
#
#cd bin
#
#
#ll -ltr
total 56
-rwxr-xr-x 1 rtkit nogroup 10484 Oct 17 02:50 utils*
-rw-r–r– 1 rtkit nogroup 136 Oct 17 02:50 README.txt
-rwxr-xr-x 1 rtkit nogroup 3444 Oct 17 02:50 neo4j-shell*
drwxr-xr-x 2 rtkit nogroup 4096 Oct 17 02:50 Neo4j-Management/
-rwxr-xr-x 1 rtkit nogroup 4445 Oct 17 02:50 neo4j-installer*
-rwxr-xr-x 1 rtkit nogroup 3576 Oct 17 02:50 neo4j-import*
-rwxr-xr-x 1 rtkit nogroup 10397 Oct 17 02:50 neo4j*
drwxr-xr-x 8 rtkit nogroup 4096 Oct 17 02:50 ../
drwxr-xr-x 3 rtkit nogroup 4096 Oct 30 22:39 ./
#
#./neo4j-shell
Welcome to the Neo4j Shell! Enter ‘help’ for a list of commands
NOTE: Remote Neo4j graph database service ‘shell’ at port 1337

neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH ()-[r:ACTED_IN]->() RETURN r LIMIT 25
> ;
+————————————————————+
| r |
+————————————————————+
| :ACTED_IN[7]{roles:[“Emil”]} |
| :ACTED_IN[3]{roles:[“Agent Smith”]} |
| :ACTED_IN[2]{roles:[“Morpheus”]} |
| :ACTED_IN[1]{roles:[“Trinity”]} |
| :ACTED_IN[0]{roles:[“Neo”]} |
| :ACTED_IN[11]{roles:[“Agent Smith”]} |
| :ACTED_IN[10]{roles:[“Morpheus”]} |
| :ACTED_IN[9]{roles:[“Trinity”]} |
| :ACTED_IN[8]{roles:[“Neo”]} |
| :ACTED_IN[18]{roles:[“Agent Smith”]} |
| :ACTED_IN[16]{roles:[“Trinity”]} |
| :ACTED_IN[17]{roles:[“Morpheus”]} |
| :ACTED_IN[15]{roles:[“Neo”]} |
| :ACTED_IN[24]{roles:[“John Milton”]} |
| :ACTED_IN[22]{roles:[“Kevin Lomax”]} |
| :ACTED_IN[23]{roles:[“Mary Ann Lomax”]} |
| :ACTED_IN[37]{roles:[“Man in Bar”]} |
| :ACTED_IN[36]{roles:[“Dr. Stone”]} |
| :ACTED_IN[33]{roles:[“Lt. Sam Weinberg”]} |
| :ACTED_IN[32]{roles:[“Cpl. Carl Hammaker”]} |
| :ACTED_IN[35]{roles:[“Pfc. Louden Downey”]} |
| :ACTED_IN[34]{roles:[“Lt. Col. Matthew Andrew Markinson”]} |
| :ACTED_IN[30]{roles:[“Lt. Jonathan Kendrick”]} |
| :ACTED_IN[31]{roles:[“Cpl. Jeffrey Barnes”]} |
| :ACTED_IN[28]{roles:[“Lt. Cdr. JoAnne Galloway”]} |
+————————————————————+
25 rows
119 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (n:Movie) RETURN n LIMIT 25;
+—————————————————————————————————————————————————————————————————————————————-+
| n |
+—————————————————————————————————————————————————————————————————————————————-+
| Node[1]{tagline:”Welcome to the Real World”,title:”The Matrix”,released:1999} |
| Node[10]{tagline:”Free your mind”,title:”The Matrix Reloaded”,released:2003} |
| Node[11]{tagline:”Everything that has a beginning has an end”,title:”The Matrix Revolutions”,released:2003} |
| Node[12]{tagline:”Evil has its winning ways”,title:”The Devil’s Advocate”,released:1997} |
| Node[16]{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.”} |
| Node[30]{tagline:”I feel the need, the need for speed.”,title:”Top Gun”,released:1986} |
| Node[38]{tagline:”The rest of his life begins now.”,title:”Jerry Maguire”,released:2000} |
| Node[47]{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.”} |
| Node[53]{tagline:”A comedy from the heart that goes for the throat.”,title:”As Good as It Gets”,released:1997} |
| Node[57]{tagline:”After life there is more. The end is just the beginning.”,title:”What Dreams May Come”,released:1998} |
| Node[63]{tagline:”First loves last. Forever.”,title:”Snow Falling on Cedars”,released:1999} |
| Node[68]{tagline:”At odds in life… in love on-line.”,title:”You’ve Got Mail”,released:1998} |
| Node[74]{tagline:”What if someone you never met, someone you never saw, someone you never knew was the only someone for you?”,title:”Sleepless in Seattle”,released:1993} |
| Node[79]{tagline:”A story of love, lava and burning desire.”,title:”Joe Versus the Volcano”,released:1990} |
| Node[82]{tagline:”At odds in life… in love on-line.”,title:”When Harry Met Sally”,released:1998} |
| Node[86]{tagline:”In every life there comes a time when that thing you dream becomes that thing you do”,title:”That Thing You Do”,released:1996} |
| Node[88]{tagline:”Pain heals, Chicks dig scars… Glory lasts forever”,title:”The Replacements”,released:2000} |
| Node[93]{title:”RescueDawn”,released:2006,tagline:”Based on the extraordinary true story of one man’s fight for freedom”} |
| Node[96]{tagline:”Come as you are”,title:”The Birdcage”,released:1996} |
| Node[98]{title:”Unforgiven”,released:1992,tagline:”It’s a hell of a thing, killing a man”} |
| Node[101]{tagline:”The hottest data on earth. In the coolest head in town”,title:”Johnny Mnemonic”,released:1995} |
| Node[106]{tagline:”Everything is connected”,title:”Cloud Atlas”,released:2012} |
| Node[110]{tagline:”Break The Codes”,title:”The Da Vinci Code”,released:2006} |
| Node[115]{tagline:”Freedom! Forever!”,title:”V for Vendetta”,released:2006} |
| Node[120]{tagline:”Speed has no limits”,title:”Speed Racer”,released:2008} |
+—————————————————————————————————————————————————————————————————————————————-+
25 rows
65 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH ()-[r:ACTED_IN]->() RETURN r LIMIT 1;
+——————————+
| r |
+——————————+
| :ACTED_IN[7]{roles:[“Emil”]} |
+——————————+
1 row
32 ms
neo4j-sh (?)$ MATCH ()-[r:ACTED_IN]->() RETURN r LIMIT 6;
+————————————–+
| r |
+————————————–+
| :ACTED_IN[7]{roles:[“Emil”]} |
| :ACTED_IN[3]{roles:[“Agent Smith”]} |
| :ACTED_IN[2]{roles:[“Morpheus”]} |
| :ACTED_IN[1]{roles:[“Trinity”]} |
| :ACTED_IN[0]{roles:[“Neo”]} |
| :ACTED_IN[11]{roles:[“Agent Smith”]} |
+————————————–+
6 rows
37 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)
> RETURN a.name, m.title limit 10;
+———————————————–+
| a.name | m.title |
+———————————————–+
| “Keanu Reeves” | “Something’s Gotta Give” |
| “Keanu Reeves” | “Johnny Mnemonic” |
| “Keanu Reeves” | “The Replacements” |
| “Keanu Reeves” | “The Devil’s Advocate” |
| “Keanu Reeves” | “The Matrix Revolutions” |
| “Keanu Reeves” | “The Matrix Reloaded” |
| “Keanu Reeves” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix” |
+———————————————–+
10 rows
49 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)
> ;
5 ms

WARNING: Query cannot conclude with MATCH (must be RETURN or an update clause) (line 1, column 1 (offset: 0))
“MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)”
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d);
3 ms

WARNING: Query cannot conclude with MATCH (must be RETURN or an update clause) (line 1, column 1 (offset: 0))
“MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)”
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a.name, m.title;
+————————————————————–+
| a.name | m.title |
+————————————————————–+
| “Christina Ricci” | “Speed Racer” |
| “Rain” | “Speed Racer” |
| “Ben Miles” | “Speed Racer” |
| “Emile Hirsch” | “Speed Racer” |
| “John Goodman” | “Speed Racer” |
| “Susan Sarandon” | “Speed Racer” |
| “Matthew Fox” | “Speed Racer” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
| “Tom Hanks” | “Cloud Atlas” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Keanu Reeves” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Keanu Reeves” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Keanu Reeves” | “The Matrix” |
| “Christina Ricci” | “Speed Racer” |
| “Rain” | “Speed Racer” |
| “Ben Miles” | “Speed Racer” |
| “Emile Hirsch” | “Speed Racer” |
| “John Goodman” | “Speed Racer” |
| “Susan Sarandon” | “Speed Racer” |
| “Matthew Fox” | “Speed Racer” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
| “Tom Hanks” | “Cloud Atlas” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Keanu Reeves” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Keanu Reeves” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Keanu Reeves” | “The Matrix” |
| “Al Pacino” | “The Devil’s Advocate” |
| “Keanu Reeves” | “The Devil’s Advocate” |
| “Charlize Theron” | “The Devil’s Advocate” |
| “Rain” | “Ninja Assassin” |
| “Naomie Harris” | “Ninja Assassin” |
| “Rick Yune” | “Ninja Assassin” |
| “Ben Miles” | “Ninja Assassin” |
| “Stephen Rea” | “V for Vendetta” |
| “Natalie Portman” | “V for Vendetta” |
| “Hugo Weaving” | “V for Vendetta” |
| “Ben Miles” | “V for Vendetta” |
| “John Hurt” | “V for Vendetta” |
| “Bruno Kirby” | “When Harry Met Sally” |
| “Carrie Fisher” | “When Harry Met Sally” |
| “Meg Ryan” | “When Harry Met Sally” |
| “Billy Crystal” | “When Harry Met Sally” |
| “Marshall Bell” | “Stand By Me” |
| “Kiefer Sutherland” | “Stand By Me” |
| “John Cusack” | “Stand By Me” |
| “Wil Wheaton” | “Stand By Me” |
| “River Phoenix” | “Stand By Me” |
| “Jerry O’Connell” | “Stand By Me” |
| “Corey Feldman” | “Stand By Me” |
| “Aaron Sorkin” | “A Few Good Men” |
| “Christopher Guest” | “A Few Good Men” |
| “Kevin Pollak” | “A Few Good Men” |
| “Cuba Gooding Jr.” | “A Few Good Men” |
| “James Marshall” | “A Few Good Men” |
| “J.T. Walsh” | “A Few Good Men” |
| “Kiefer Sutherland” | “A Few Good Men” |
| “Noah Wyle” | “A Few Good Men” |
| “Demi Moore” | “A Few Good Men” |
| “Kevin Bacon” | “A Few Good Men” |
| “Tom Cruise” | “A Few Good Men” |
| “Jack Nicholson” | “A Few Good Men” |
| “Meg Ryan” | “Top Gun” |
| “Tom Skerritt” | “Top Gun” |
| “Kelly McGillis” | “Top Gun” |
| “Tom Cruise” | “Top Gun” |
| “Anthony Edwards” | “Top Gun” |
| “Val Kilmer” | “Top Gun” |
| “Jonathan Lipnicki” | “Jerry Maguire” |
| “Jerry O’Connell” | “Jerry Maguire” |
| “Jay Mohr” | “Jerry Maguire” |
| “Bonnie Hunt” | “Jerry Maguire” |
| “Regina King” | “Jerry Maguire” |
| “Tom Cruise” | “Jerry Maguire” |
| “Cuba Gooding Jr.” | “Jerry Maguire” |
| “Renee Zellweger” | “Jerry Maguire” |
| “Kelly Preston” | “Jerry Maguire” |
| “Cuba Gooding Jr.” | “As Good as It Gets” |
| “Greg Kinnear” | “As Good as It Gets” |
| “Helen Hunt” | “As Good as It Gets” |
| “Jack Nicholson” | “As Good as It Gets” |
| “Christian Bale” | “RescueDawn” |
| “Zach Grenier” | “RescueDawn” |
| “Steve Zahn” | “RescueDawn” |
| “Marshall Bell” | “RescueDawn” |
| “Annabella Sciorra” | “What Dreams May Come” |
| “Cuba Gooding Jr.” | “What Dreams May Come” |
| “Robin Williams” | “What Dreams May Come” |
| “Werner Herzog” | “What Dreams May Come” |
| “Max von Sydow” | “What Dreams May Come” |
| “James Cromwell” | “Snow Falling on Cedars” |
| “Rick Yune” | “Snow Falling on Cedars” |
| “Max von Sydow” | “Snow Falling on Cedars” |
| “Ethan Hawke” | “Snow Falling on Cedars” |
| “Charlize Theron” | “That Thing You Do” |
| “Liv Tyler” | “That Thing You Do” |
| “Tom Hanks” | “That Thing You Do” |
| “Rosie O’Donnell” | “Sleepless in Seattle” |
| “Tom Hanks” | “Sleepless in Seattle” |
| “Bill Pullman” | “Sleepless in Seattle” |
| “Victor Garber” | “Sleepless in Seattle” |
| “Meg Ryan” | “Sleepless in Seattle” |
| “Rita Wilson” | “Sleepless in Seattle” |
| “Dave Chappelle” | “You’ve Got Mail” |
| “Steve Zahn” | “You’ve Got Mail” |
| “Greg Kinnear” | “You’ve Got Mail” |
| “Parker Posey” | “You’ve Got Mail” |
| “Tom Hanks” | “You’ve Got Mail” |
| “Meg Ryan” | “You’ve Got Mail” |
| “Meg Ryan” | “Joe Versus the Volcano” |
| “Tom Hanks” | “Joe Versus the Volcano” |
| “Nathan Lane” | “Joe Versus the Volcano” |
| “Keanu Reeves” | “The Replacements” |
| “Brooke Langton” | “The Replacements” |
| “Gene Hackman” | “The Replacements” |
| “Orlando Jones” | “The Replacements” |
| “Tom Hanks” | “Charlie Wilson’s War” |
| “Julia Roberts” | “Charlie Wilson’s War” |
| “Philip Seymour Hoffman” | “Charlie Wilson’s War” |
| “Robin Williams” | “The Birdcage” |
| “Nathan Lane” | “The Birdcage” |
| “Gene Hackman” | “The Birdcage” |
| “Gene Hackman” | “Unforgiven” |
| “Richard Harris” | “Unforgiven” |
| “Clint Eastwood” | “Unforgiven” |
| “Dina Meyer” | “Johnny Mnemonic” |
| “Ice-T” | “Johnny Mnemonic” |
| “Keanu Reeves” | “Johnny Mnemonic” |
| “Takeshi Kitano” | “Johnny Mnemonic” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
| “Tom Hanks” | “Cloud Atlas” |
| “Oliver Platt” | “Frost/Nixon” |
| “Sam Rockwell” | “Frost/Nixon” |
| “Frank Langella” | “Frost/Nixon” |
| “Kevin Bacon” | “Frost/Nixon” |
| “Michael Sheen” | “Frost/Nixon” |
| “Ed Harris” | “Apollo 13” |
| “Bill Paxton” | “Apollo 13” |
| “Tom Hanks” | “Apollo 13” |
| “Kevin Bacon” | “Apollo 13” |
| “Gary Sinise” | “Apollo 13” |
| “Paul Bettany” | “The Da Vinci Code” |
| “Audrey Tautou” | “The Da Vinci Code” |
| “Ian McKellen” | “The Da Vinci Code” |
| “Tom Hanks” | “The Da Vinci Code” |
| “Michael Clarke Duncan” | “The Green Mile” |
| “Tom Hanks” | “The Green Mile” |
| “Bonnie Hunt” | “The Green Mile” |
| “David Morse” | “The Green Mile” |
| “Sam Rockwell” | “The Green Mile” |
| “James Cromwell” | “The Green Mile” |
| “Patricia Clarkson” | “The Green Mile” |
| “Gary Sinise” | “The Green Mile” |
| “Jack Nicholson” | “Hoffa” |
| “John C. Reilly” | “Hoffa” |
| “Danny DeVito” | “Hoffa” |
| “J.T. Walsh” | “Hoffa” |
| “Philip Seymour Hoffman” | “Twister” |
| “Zach Grenier” | “Twister” |
| “Bill Paxton” | “Twister” |
| “Helen Hunt” | “Twister” |
| “Tom Hanks” | “The Polar Express” |
| “Tom Hanks” | “Cast Away” |
| “Helen Hunt” | “Cast Away” |
| “Danny DeVito” | “One Flew Over the Cuckoo’s Nest” |
| “Jack Nicholson” | “One Flew Over the Cuckoo’s Nest” |
| “Keanu Reeves” | “Something’s Gotta Give” |
| “Diane Keaton” | “Something’s Gotta Give” |
| “Jack Nicholson” | “Something’s Gotta Give” |
| “Oliver Platt” | “Bicentennial Man” |
| “Robin Williams” | “Bicentennial Man” |
| “Tom Hanks” | “A League of Their Own” |
| “Geena Davis” | “A League of Their Own” |
| “Lori Petty” | “A League of Their Own” |
| “Rosie O’Donnell” | “A League of Their Own” |
| “Madonna” | “A League of Their Own” |
| “Bill Paxton” | “A League of Their Own” |
+————————————————————–+
200 rows
366 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a.name, m.title limit 10;
+———————————–+
| a.name | m.title |
+———————————–+
| “Christina Ricci” | “Speed Racer” |
| “Rain” | “Speed Racer” |
| “Ben Miles” | “Speed Racer” |
| “Emile Hirsch” | “Speed Racer” |
| “John Goodman” | “Speed Racer” |
| “Susan Sarandon” | “Speed Racer” |
| “Matthew Fox” | “Speed Racer” |
| “Jim Broadbent” | “Cloud Atlas” |
| “Hugo Weaving” | “Cloud Atlas” |
| “Halle Berry” | “Cloud Atlas” |
+———————————–+
10 rows
59 ms
neo4j-sh (?)$

neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d) RETURN a.name,d.name,m.title limit 10;
+——————————————————+
| a.name | d.name | m.title |
+——————————————————+
| “Christina Ricci” | “Andy Wachowski” | “Speed Racer” |
| “Rain” | “Andy Wachowski” | “Speed Racer” |
| “Ben Miles” | “Andy Wachowski” | “Speed Racer” |
| “Emile Hirsch” | “Andy Wachowski” | “Speed Racer” |
| “John Goodman” | “Andy Wachowski” | “Speed Racer” |
| “Susan Sarandon” | “Andy Wachowski” | “Speed Racer” |
| “Matthew Fox” | “Andy Wachowski” | “Speed Racer” |
| “Jim Broadbent” | “Andy Wachowski” | “Cloud Atlas” |
| “Hugo Weaving” | “Andy Wachowski” | “Cloud Atlas” |
| “Halle Berry” | “Andy Wachowski” | “Cloud Atlas” |
+——————————————————+
10 rows
58 ms
neo4j-sh (?)$
neo4j-sh (?)$

neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(a) RETURN a.name,m.title limit 10;
+—————————————-+
| a.name | m.title |
+—————————————-+
| “Tom Hanks” | “That Thing You Do” |
| “Clint Eastwood” | “Unforgiven” |
| “Danny DeVito” | “Hoffa” |
+—————————————-+
3 rows
64 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m), (m)<-[:DIRECTED]-(a) RETURN a.name,m.title limit 10;
+—————————————-+
| a.name | m.title |
+—————————————-+
| “Tom Hanks” | “That Thing You Do” |
| “Clint Eastwood” | “Unforgiven” |
| “Danny DeVito” | “Hoffa” |
+—————————————-+
3 rows
54 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m), (m)<-[:DIRECTED]-(a) RETURN a.name,m.title limit 10;
+—————————————-+
| a.name | m.title |
+—————————————-+
| “Tom Hanks” | “That Thing You Do” |
| “Clint Eastwood” | “Unforgiven” |
| “Danny DeVito” | “Hoffa” |
+—————————————-+
3 rows
34 ms
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(a) RETURN a.name,m.title limit 10;
+—————————————-+
| a.name | m.title |
+—————————————-+
| “Tom Hanks” | “That Thing You Do” |
| “Clint Eastwood” | “Unforgiven” |
| “Danny DeVito” | “Hoffa” |
+—————————————-+
3 rows
23 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (n) RETURN n limit 10;
+——————————————————————————-+
| n |
+——————————————————————————-+
| Node[0]{name:”World”} |
| Node[1]{tagline:”Welcome to the Real World”,title:”The Matrix”,released:1999} |
| Node[2]{name:”Keanu Reeves”,born:1964} |
| Node[3]{name:”Carrie-Anne Moss”,born:1967} |
| Node[4]{name:”Laurence Fishburne”,born:1961} |
| Node[5]{name:”Hugo Weaving”,born:1960} |
| Node[6]{name:”Andy Wachowski”,born:1967} |
| Node[7]{name:”Lana Wachowski”,born:1965} |
| Node[8]{name:”Joel Silver”,born:1952} |
| Node[9]{name:”Emil Eifrem”,born:1978} |
+——————————————————————————-+
10 rows
35 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (n) WHERE n.name=”Hugo Weaving” RETURN n limit 10;
+—————————————-+
| n |
+—————————————-+
| Node[5]{name:”Hugo Weaving”,born:1960} |
+—————————————-+
1 row
47 ms
neo4j-sh (?)$
neo4j-sh (?)$

neo4j-sh (?)$
neo4j-sh (?)$ MATCH (x)-[:ACTED_IN]->(z)<-[:ACTED_IN]-(w) RETURN x.name,z.title limit 10;
+———————————————-+
| x.name | z.title |
+———————————————-+
| “Diane Keaton” | “Something’s Gotta Give” |
| “Jack Nicholson” | “Something’s Gotta Give” |
| “Dina Meyer” | “Johnny Mnemonic” |
| “Ice-T” | “Johnny Mnemonic” |
| “Takeshi Kitano” | “Johnny Mnemonic” |
| “Brooke Langton” | “The Replacements” |
| “Gene Hackman” | “The Replacements” |
| “Orlando Jones” | “The Replacements” |
| “Al Pacino” | “The Devil’s Advocate” |
| “Charlize Theron” | “The Devil’s Advocate” |
+———————————————-+
10 rows
96 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ create index on :Person(name)
> ;
+——————-+
| No data returned. |
+——————-+
Indexes added: 1
22 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ create index on :Person(name);
+——————————————–+
| No data returned, and nothing was changed. |
+——————————————–+
13 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ create index on :Movie(title);
+——————-+
| No data returned. |
+——————-+
Indexes added: 1
9 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ // no propery null node
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (tom:Person)-[:ACTED_IN]->(movie),(kevin:Person)-[:ACTED_IN]->(movie) WHERE tom.name=”Tom Hannks” AND kevin.name=”Kevin Bacon” RETURN movie.title;
+————-+
| movie.title |
+————-+
+————-+
0 row
160 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$

neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, COUNT(m.title) GROUP BY a.name limit 6;

neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, COUNT(m.title) limit 6;
+————————————–+
| a.name | COUNT(m.title) |
+————————————–+
| “Charlize Theron” | 2 |
| “Orlando Jones” | 1 |
| “Patricia Clarkson” | 1 |
| “Tom Skerritt” | 1 |
| “Helen Hunt” | 3 |
| “Victor Garber” | 1 |
+————————————–+
6 rows
87 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, COUNT(m.title) as No_movies limit 6;
+———————————+
| a.name | No_movies |
+———————————+
| “Charlize Theron” | 2 |
| “Orlando Jones” | 1 |
| “Patricia Clarkson” | 1 |
| “Tom Skerritt” | 1 |
| “Helen Hunt” | 3 |
| “Victor Garber” | 1 |
+———————————+
6 rows
87 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, COUNT(m.title) as No_movies GROUP BY No_movies DESC limit 6;
5 ms

WARNING: Invalid input ‘G’: expected whitespace, comment, ‘,’, ORDER, SKIP, LIMIT, LOAD CSV, START, MATCH, UNWIND, MERGE, CREATE, SET, DELETE, REMOVE, FOREACH, WITH, RETURN, UNION, ‘;’ or end of input (line 1, column 71 (offset: 70))
“MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, COUNT(m.title) as No_movies GROUP BY No_movies DESC limit 6”
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, COUNT(m.title) as No_movies ORDER BY No_movies DESC limit 6;
+——————————–+
| a.name | No_movies |
+——————————–+
| “Tom Hanks” | 12 |
| “Keanu Reeves” | 7 |
| “Hugo Weaving” | 5 |
| “Jack Nicholson” | 5 |
| “Meg Ryan” | 5 |
| “Cuba Gooding Jr.” | 4 |
+——————————–+
6 rows
126 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name as Actor, COUNT(m.title) as No_movies ORDER BY No_movies DESC limit 6;
+——————————–+
| Actor | No_movies |
+——————————–+
| “Tom Hanks” | 12 |
| “Keanu Reeves” | 7 |
| “Hugo Weaving” | 5 |
| “Jack Nicholson” | 5 |
| “Meg Ryan” | 5 |
| “Cuba Gooding Jr.” | 4 |
+——————————–+
6 rows
156 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name as Actor, COUNT(m.title) as No_movies ORDER BY No_movies DESC limit 5;
+——————————+
| Actor | No_movies |
+——————————+
| “Tom Hanks” | 12 |
| “Keanu Reeves” | 7 |
| “Hugo Weaving” | 5 |
| “Jack Nicholson” | 5 |
| “Meg Ryan” | 5 |
+——————————+
5 rows
93 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) RETURN a.name as Actor, COUNT(m.title) as No_movies ORDER BY No_movies DESC limit 5;
+——————————+
| Actor | No_movies |
+——————————+
| “Tom Hanks” | 12 |
| “Keanu Reeves” | 7 |
| “Hugo Weaving” | 5 |
| “Jack Nicholson” | 5 |
| “Meg Ryan” | 5 |
+——————————+
5 rows
58 ms
neo4j-sh (?)$

neo4j-sh (?)$ match (a)-[:ACTED_IN]->(m) return a.name as Actor, COUNT(m.title) as No_movies order by No_movies DESC limit 5;
+——————————+
| Actor | No_movies |
+——————————+
| “Tom Hanks” | 12 |
| “Keanu Reeves” | 7 |
| “Hugo Weaving” | 5 |
| “Jack Nicholson” | 5 |
| “Meg Ryan” | 5 |
+——————————+
5 rows
60 ms
neo4j-sh (?)$

neo4j-sh (?)$
neo4j-sh (?)$ match (a)-[:ACTED_IN]->(m) return a.name as Actor, COUNT(m.title) as No_movies order by No_movies DESC limit 5;
+——————————+
| Actor | No_movies |
+——————————+
| “Tom Hanks” | 12 |
| “Keanu Reeves” | 7 |
| “Hugo Weaving” | 5 |
| “Jack Nicholson” | 5 |
| “Meg Ryan” | 5 |
+——————————+
5 rows
45 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ match (a)-[:ACTED_IN]->(m) return a.name as Actor, COUNT(m.title) as No_movies order by No_movies DESC limit 5;
+——————————+
| Actor | No_movies |
+——————————+
| “Tom Hanks” | 12 |
| “Keanu Reeves” | 7 |
| “Hugo Weaving” | 5 |
| “Jack Nicholson” | 5 |
| “Meg Ryan” | 5 |
+——————————+
5 rows
52 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k.Person)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN k.name as Actor limit 5;
4 ms

WARNING: Invalid input ‘.’: expected an identifier character, node labels, a property map, ‘)’ or a relationship pattern (line 1, column 9 (offset: 8))
“MATCH (k.Person)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN k.name as Actor limit 5″
^
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN k.name as Actor limit 5;
+—————-+
| Actor |
+—————-+
| “Keanu Reeves” |
| “Keanu Reeves” |
| “Keanu Reeves” |
| “Keanu Reeves” |
| “Keanu Reeves” |
+—————-+
5 rows
43 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN k.name,m.title as Actor limit 5;
+——————————————-+
| k.name | Actor |
+——————————————-+
| “Keanu Reeves” | “Something’s Gotta Give” |
| “Keanu Reeves” | “Johnny Mnemonic” |
| “Keanu Reeves” | “The Replacements” |
| “Keanu Reeves” | “The Devil’s Advocate” |
| “Keanu Reeves” | “The Matrix Revolutions” |
+——————————————-+
5 rows
50 ms
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN k.name,m.title as Actor limit 10;
+——————————————-+
| k.name | Actor |
+——————————————-+
| “Keanu Reeves” | “Something’s Gotta Give” |
| “Keanu Reeves” | “Johnny Mnemonic” |
| “Keanu Reeves” | “The Replacements” |
| “Keanu Reeves” | “The Devil’s Advocate” |
| “Keanu Reeves” | “The Matrix Revolutions” |
| “Keanu Reeves” | “The Matrix Reloaded” |
| “Keanu Reeves” | “The Matrix” |
+——————————————-+
7 rows
61 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN m.title as Actor limit 10;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix” |
+————————–+
7 rows
48 ms
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN m.title as Actor;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix” |
+————————–+
7 rows
45 ms

neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN m.title as Actor;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix” |
+————————–+
7 rows
28 ms
neo4j-sh (?)$

neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN m.title as Actor;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix” |
+————————–+
7 rows
30 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (a)-[:ACTED_IN]->(m) WHERE NOT m.title IN [“Something’s Gotta Give”,”Johnny Mnemonic”,”The Replacements”,”The Devil’s Advocate”,”The Matrix Revolutions”,”The Matrix Reloaded”,”The Matrix”] RETURN a.name limit 10;
+———————+
| a.name |
+———————+
| “Aaron Sorkin” |
| “Christopher Guest” |
| “Kevin Pollak” |
| “Cuba Gooding Jr.” |
| “James Marshall” |
| “J.T. Walsh” |
| “Kiefer Sutherland” |
| “Noah Wyle” |
| “Demi Moore” |
| “Kevin Bacon” |
+———————+
10 rows
55 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN m.title as Actor;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix” |
+————————–+
7 rows
27 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN m.title as Actor;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix” |
+————————–+
7 rows
25 ms
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m),(m)<-[:ACTED_IN]-() WHERE k.name=”Keanu Reeves” RETURN m.title as Actor;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “Johnny Mnemonic” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Replacements” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Revolutions” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix Reloaded” |
| “The Matrix Reloaded” |
| “The Matrix” |
| “The Matrix” |
| “The Matrix” |
| “The Matrix” |
+————————–+
20 rows
82 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m),(m)<-[:ACTED_IN]-(x) WHERE k.name=”Keanu Reeves” RETURN x.name,m.title as Actor;
+————————————————-+
| x.name | Actor |
+————————————————-+
| “Diane Keaton” | “Something’s Gotta Give” |
| “Jack Nicholson” | “Something’s Gotta Give” |
| “Dina Meyer” | “Johnny Mnemonic” |
| “Ice-T” | “Johnny Mnemonic” |
| “Takeshi Kitano” | “Johnny Mnemonic” |
| “Brooke Langton” | “The Replacements” |
| “Gene Hackman” | “The Replacements” |
| “Orlando Jones” | “The Replacements” |
| “Al Pacino” | “The Devil’s Advocate” |
| “Charlize Theron” | “The Devil’s Advocate” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
+————————————————-+
20 rows
78 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m) WHERE k.name=”Keanu Reeves” RETURN m.title as Actor;
+————————–+
| Actor |
+————————–+
| “Something’s Gotta Give” |
| “Johnny Mnemonic” |
| “The Replacements” |
| “The Devil’s Advocate” |
| “The Matrix Revolutions” |
| “The Matrix Reloaded” |
| “The Matrix” |
+————————–+
7 rows
22 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m),(m)<-[:ACTED_IN]-(x) WHERE k.name=”Keanu Reeves” RETURN x.name,m.title as Actor;
+————————————————-+
| x.name | Actor |
+————————————————-+
| “Diane Keaton” | “Something’s Gotta Give” |
| “Jack Nicholson” | “Something’s Gotta Give” |
| “Dina Meyer” | “Johnny Mnemonic” |
| “Ice-T” | “Johnny Mnemonic” |
| “Takeshi Kitano” | “Johnny Mnemonic” |
| “Brooke Langton” | “The Replacements” |
| “Gene Hackman” | “The Replacements” |
| “Orlando Jones” | “The Replacements” |
| “Al Pacino” | “The Devil’s Advocate” |
| “Charlize Theron” | “The Devil’s Advocate” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
+————————————————-+
20 rows
57 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m),(m)<-[:ACTED_IN]-(x) WHERE k.name=”Keanu Reeves” RETURN x.name as Actor;
+———————-+
| Actor |
+———————-+
| “Diane Keaton” |
| “Jack Nicholson” |
| “Dina Meyer” |
| “Ice-T” |
| “Takeshi Kitano” |
| “Brooke Langton” |
| “Gene Hackman” |
| “Orlando Jones” |
| “Al Pacino” |
| “Charlize Theron” |
| “Hugo Weaving” |
| “Carrie-Anne Moss” |
| “Laurence Fishburne” |
| “Hugo Weaving” |
| “Laurence Fishburne” |
| “Carrie-Anne Moss” |
| “Emil Eifrem” |
| “Hugo Weaving” |
| “Laurence Fishburne” |
| “Carrie-Anne Moss” |
+———————-+
20 rows
46 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (k)-[:ACTED_IN]->(m),(m)<-[:ACTED_IN]-(x) WHERE k.name=”Keanu Reeves” RETURN DISTINCT x.name as Actor;
+———————-+
| Actor |
+———————-+
| “Diane Keaton” |
| “Jack Nicholson” |
| “Dina Meyer” |
| “Ice-T” |
| “Takeshi Kitano” |
| “Brooke Langton” |
| “Gene Hackman” |
| “Orlando Jones” |
| “Al Pacino” |
| “Charlize Theron” |
| “Hugo Weaving” |
| “Carrie-Anne Moss” |
| “Laurence Fishburne” |
| “Emil Eifrem” |
+———————-+
14 rows
28 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (keanu:Person)-[:ACTED_IN]->(movie),(movie)<-[:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” RETURN coact.name;

neo4j-sh (?)$ MATCH (keanu:Person)-[:ACTED_IN]->(movie),(movie)<-[:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” RETURN coact.name limit 10;
+—————-+
| coact.name |
+—————-+
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
| “Diane Keaton” |
+—————-+
10 rows
77 ms
neo4j-sh (?)$
neo4j-sh (?)$ MATCH (keanu:Person)-[:ACTED_IN]->(movie),(movie)<-[:ACTED_IN]-(coact),(subco:Person) WHERE keanu.name=”Keanu Reeves” RETURN distinct coact.name limit 10;
+——————-+
| coact.name |
+——————-+
| “Diane Keaton” |
| “Jack Nicholson” |
| “Dina Meyer” |
| “Ice-T” |
| “Takeshi Kitano” |
| “Brooke Langton” |
| “Gene Hackman” |
| “Orlando Jones” |
| “Al Pacino” |
| “Charlize Theron” |
+——————-+
10 rows
217 ms
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k WITH coc,m optional match (coc)-[r:ACTED_IN]->(m) RETURN coc.name,m.title ;
+————————————————-+
| coc.name | m.title |
+————————————————-+
| “Danny DeVito” | “Something’s Gotta Give” |
| “John C. Reilly” | “Something’s Gotta Give” |
| “Danny DeVito” | “Something’s Gotta Give” |
| “J.T. Walsh” | “Something’s Gotta Give” |
| “Cuba Gooding Jr.” | “Something’s Gotta Give” |
| “Greg Kinnear” | “Something’s Gotta Give” |
| “Helen Hunt” | “Something’s Gotta Give” |
| “Aaron Sorkin” | “Something’s Gotta Give” |
| “Christopher Guest” | “Something’s Gotta Give” |
| “Kevin Pollak” | “Something’s Gotta Give” |
| “Cuba Gooding Jr.” | “Something’s Gotta Give” |
| “James Marshall” | “Something’s Gotta Give” |
| “J.T. Walsh” | “Something’s Gotta Give” |
| “Kiefer Sutherland” | “Something’s Gotta Give” |
| “Noah Wyle” | “Something’s Gotta Give” |
| “Demi Moore” | “Something’s Gotta Give” |
| “Kevin Bacon” | “Something’s Gotta Give” |
| “Tom Cruise” | “Something’s Gotta Give” |
| “Richard Harris” | “The Replacements” |
| “Clint Eastwood” | “The Replacements” |
| “Robin Williams” | “The Replacements” |
| “Nathan Lane” | “The Replacements” |
| “Liv Tyler” | “The Devil’s Advocate” |
| “Tom Hanks” | “The Devil’s Advocate” |
| “Stephen Rea” | “The Matrix Revolutions” |
| “Natalie Portman” | “The Matrix Revolutions” |
| “Ben Miles” | “The Matrix Revolutions” |
| “John Hurt” | “The Matrix Revolutions” |
| “Jim Broadbent” | “The Matrix Revolutions” |
| “Halle Berry” | “The Matrix Revolutions” |
| “Tom Hanks” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Emil Eifrem” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Emil Eifrem” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Laurence Fishburne” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Emil Eifrem” | “The Matrix Revolutions” |
| “Hugo Weaving” | “The Matrix Revolutions” |
| “Carrie-Anne Moss” | “The Matrix Revolutions” |
| “Stephen Rea” | “The Matrix Reloaded” |
| “Natalie Portman” | “The Matrix Reloaded” |
| “Ben Miles” | “The Matrix Reloaded” |
| “John Hurt” | “The Matrix Reloaded” |
| “Jim Broadbent” | “The Matrix Reloaded” |
| “Halle Berry” | “The Matrix Reloaded” |
| “Tom Hanks” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Carrie-Anne Moss” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Emil Eifrem” | “The Matrix Reloaded” |
| “Hugo Weaving” | “The Matrix Reloaded” |
| “Laurence Fishburne” | “The Matrix Reloaded” |
| “Stephen Rea” | “The Matrix” |
| “Natalie Portman” | “The Matrix” |
| “Ben Miles” | “The Matrix” |
| “John Hurt” | “The Matrix” |
| “Jim Broadbent” | “The Matrix” |
| “Halle Berry” | “The Matrix” |
| “Tom Hanks” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Carrie-Anne Moss” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
| “Hugo Weaving” | “The Matrix” |
| “Laurence Fishburne” | “The Matrix” |
+————————————————-+
87 rows
388 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k AND NOT ((k)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc)) RETURN coc.name,count(coc) ORDER BY count(coc) DESC ;
+———————————-+
| coc.name | count(coc) |
+———————————-+
| “Tom Hanks” | 4 |
| “Stephen Rea” | 3 |
| “Ben Miles” | 3 |
| “Natalie Portman” | 3 |
| “Halle Berry” | 3 |
| “Jim Broadbent” | 3 |
| “John Hurt” | 3 |
| “Danny DeVito” | 2 |
| “J.T. Walsh” | 2 |
| “Cuba Gooding Jr.” | 2 |
| “Helen Hunt” | 1 |
| “Tom Cruise” | 1 |
| “Richard Harris” | 1 |
| “Kevin Pollak” | 1 |
| “Clint Eastwood” | 1 |
| “John C. Reilly” | 1 |
| “Liv Tyler” | 1 |
| “Christopher Guest” | 1 |
| “Demi Moore” | 1 |
| “James Marshall” | 1 |
| “Greg Kinnear” | 1 |
| “Kevin Bacon” | 1 |
| “Noah Wyle” | 1 |
| “Nathan Lane” | 1 |
| “Kiefer Sutherland” | 1 |
| “Aaron Sorkin” | 1 |
| “Robin Williams” | 1 |
+———————————-+
27 rows
688 ms
neo4j-sh (?)$
neo4j-sh (?)$ match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k AND NOT ((k)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc)) RETURN coc.name,count(coc) ORDER BY count(coc) DESC LIMIT 3;
+—————————-+
| coc.name | count(coc) |
+—————————-+
| “Tom Hanks” | 4 |
| “Stephen Rea” | 3 |
| “Ben Miles” | 3 |
+—————————-+
3 rows
443 ms
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$
neo4j-sh (?)$ profile match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c), (c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc) where k.name=”Keanu Reeves” AND coc<>k AND NOT ((k)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc)) RETURN coc.name,count(coc) ORDER BY count(coc) DESC LIMIT 3;
+—————————-+
| coc.name | count(coc) |
+—————————-+
| “Tom Hanks” | 4 |
| “Stephen Rea” | 3 |
| “Ben Miles” | 3 |
+—————————-+
3 rows
44 ms

Compiler CYPHER 2.3

Planner COST

Runtime INTERPRETED

+——————-+—————-+——+———+—————————————————————————+————————————————————————————————————————+
| Operator | Estimated Rows | Rows | DB Hits | Identifiers | Other |
+——————-+—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +ProduceResults | 1 | 3 | 0 | coc.name, count(coc) | coc.name, count(coc) |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Projection | 1 | 3 | 0 | anon[190], anon[195], coc.name, count(coc) | anon[190]; anon[195] |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Top | 1 | 3 | 0 | anon[190], anon[195] | Literal(3); |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +EagerAggregation | 0 | 27 | 0 | anon[190], anon[195] | anon[190] |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Projection | 0 | 45 | 45 | anon[190], anon[17], anon[34], anon[56], anon[70], anon[72], c, coc, k, m | coc.name; coc |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +AntiSemiApply | 0 | 45 | 0 | anon[17], anon[34], anon[56], anon[70], anon[72], c, coc, k, m | |
| |\ +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| | +Filter | 0 | 0 | 0 | anon[143], anon[157], anon[159], coc, k | NOT(anon[143] == anon[159]) |
| | | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| | +Expand(Into) | 0 | 42 | 1570 | anon[143], anon[157], anon[159], coc, k | (k)-[:ACTED_IN]->() |
| | | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| | +Expand(All) | 1 | 182 | 269 | anon[157], anon[159], coc, k | (coc)-[:ACTED_IN]->() |
| | | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| | +Argument | 1 | 87 | 0 | coc, k | |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Filter | 1 | 87 | 0 | anon[17], anon[34], anon[56], anon[70], anon[72], c, coc, k, m | Ands(Fby(NOT(coc == k),Fby(NOT(anon[34] == anon[72]),Fby(NOT(anon[56] == anon[72]),Last(NOT(anon[17] == anon[72])))))) |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Expand(All) | 1 | 136 | 167 | anon[17], anon[34], anon[56], anon[70], anon[72], c, coc, k, m | ()<-[:ACTED_IN]-(coc) |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Filter | 1 | 31 | 0 | anon[17], anon[34], anon[56], anon[70], c, k, m | Ands(Fby(NOT(anon[34] == anon[56]),Last(NOT(anon[17] == anon[56])))) |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Expand(All) | 1 | 51 | 71 | anon[17], anon[34], anon[56], anon[70], c, k, m | (c)-[:ACTED_IN]->() |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Filter | 1 | 20 | 0 | anon[17], anon[34], c, k, m | NOT(anon[17] == anon[34]) |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Expand(All) | 1 | 27 | 34 | anon[17], anon[34], c, k, m | (m)<-[:ACTED_IN]-(c) |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +Expand(All) | 1 | 7 | 8 | anon[17], k, m | (k)-[:ACTED_IN]->(m) |
| | +—————-+——+———+—————————————————————————+————————————————————————————————————————+
| +NodeIndexSeek | 1 | 1 | 2 | k | :Person(name) |
+——————-+—————-+——+———+—————————————————————————+————————————————————————————————————————+

Total database accesses: 2166
neo4j-sh (?)$
match (k:Person)-[:ACTED_IN]->(m)<-[:ACTED_IN]-(c),
(c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc)

where

k.name=”Keanu Reeves” AND
coc<>k AND
NOT ((k)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc))
RETURN

coc.name,count(coc)

ORDER BY count(coc) DESC
LIMIT 3;

+—————————-+
| coc.name | count(coc) |
+—————————-+
| “Tom Hanks” | 4 |
| “Stephen Rea” | 3 |
| “Ben Miles” | 3 |
+—————————-+
3 rows
443 ms
neo4j-sh (?)$
neo4j-sh (?)$
[identifier : relation_type * lower .. upper ]

Useful references

www.maxdemarzi.com
www.jexp.de
www.neo4j-users.slack.com
www.graphgist.neo4j.com – finance

Clients & thier Use-cases
cisco – Access control management
KB recommendations
Master data Mgt of Cisco – sales compensation
Accenture : Real time routing : ( breadth first)
Truck route mgt
Adobe : User control
Glassdoor
Seven Bridges
SFR – Communications n/w
Teachscape
Duetsche Tekekom – content
Telenor – Communication
Thresholds :
32 billian nodes, relations, 64 Billians of properties

  • Ask Question