Graph data with Neo4J PHP & Neoxygen

Slide 1

Slide 1 text

GRAPH DATA AND PHP NEO4J and NEOXYGEN      For PHP Belfast - April 23rd 2015

Slide 2

Slide 2 text

TRADITIONAL DB ID NAME CITY 1 Albert London 2 Bernard New York 3 Charlotte Paris 4 Daniel London

Slide 3

Slide 3 text

GRAPH DB? 0 25 50 75 100 April May June July 0 25 50 75 100 April May June July

Slide 4

Slide 4 text

GRAPH DB? 0 25 50 75 100 April May June July 0 25 50 75 100 April May June July NO….

Slide 5

Slide 5 text

WHAT IS GRAPH DATA?

Slide 6

Slide 6 text

WHAT IS GRAPH DATA? Facebook Open Graph

Slide 7

Slide 7 text

WHAT IS GRAPH DATA? Facebook Open Graph Twitter Firehose

Slide 8

Slide 8 text

WHAT IS GRAPH DATA? Facebook Open Graph Twitter Firehose Big Data (buzzword alert!)

Slide 9

Slide 9 text

WHAT IS GRAPH DATA? Facebook Open Graph Twitter Firehose Big Data (buzzword alert!) Ideal for “Social” Media

Slide 10

Slide 10 text

WHAT IS GRAPH DATA? Facebook Open Graph Twitter Firehose Big Data (buzzword alert!) Ideal for “Social” Media NODES and RELATIONSHIPS

Slide 11

Slide 11 text

START WITH A NODE BATMAN

Slide 12

Slide 12 text

START WITH A NODE BATMAN (batman:Person)

Slide 13

Slide 13 text

START WITH A NODE BATMAN (batman:Person) (batman:Superhero)

Slide 14

Slide 14 text

START WITH A NODE BATMAN (batman:Person) (batman:Superhero) (batman:Person {name:’Batman’, realname:’Bruce Wayne’, superpower:’Money’})

Slide 15

Slide 15 text

ADD MORE NODES BATMAN JOKER ALFRED JIM   GORDON PENGUIN

Slide 16

Slide 16 text

ADD RELATIONSHIPS BATMAN JOKER ALFRED JIM   GORDON PENGUIN enemy enem y Friend Friend

Slide 17

Slide 17 text

ADD MORE NODES AND RELATIONSHIPS

Slide 18

Slide 18 text

NODES OF THE SAME TYPE CAN STORE DIFFERENT INFORMATION Batman Spiderman (batman:Superhero {  realname: Bruce Wayne  Lives: Gotham City  Net Worth: $100billion} ) ( spiderman: Superhero {  realname: Peter Parker meta_human: Yes climb_walls: Yes cape: No Hobbies: Photography} )

Slide 19

Slide 19 text

RELATIONSHIPS HAVE   METADATA TOO Batman (batman:Person) ( robin: Person) Robin [Friend_Of {role: ‘Sidekick’}]

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

Installation http://neo4j.com/download/

Slide 22

Slide 22 text

Java SDK 1.7+ reqd. http://www.oracle.com/technetwork/java/javase/downloads/

Slide 23

Slide 23 text

Java SDK 1.7+ reqd. Update your path to use the new Java SDK

Slide 24

Slide 24 text

Start the Neo4J Database

Slide 25

Slide 25 text

Test the web interface http://localhost:7474

Slide 26

Slide 26 text

SECURITY - CONNECTION ﬁle: conf/neo4j-server.properties # http port (for all data, administrative, and UI access) org.neo4j.server.webserver.port=7474 #let the webserver only listen on the specified IP. Default #is localhost (only accept local connections). Uncomment to allow #any connection. org.neo4j.server.webserver.address=0.0.0.0 http://neo4j.com/docs/stable/security-server.html Be Security Aware: Never switch off IP ﬁlter in production

Slide 27

Slide 27 text

SECURITY - AUTHORISATION ﬁle: data/dbms/auth neo4j:SHA-‐256,ABCDEFGH…… http://neo4j.com/docs/stable/security-server.html # Require (or disable the requirement of) auth to access Neo4j dbms.security.auth_enabled=false ﬁle: conf/neo4j-server.properties Be Security Aware: Never switch off auth in production

Slide 28

Slide 28 text

QUESTION TIME How do we Query an Neo4J Database?

Slide 29

Slide 29 text

CYPHER - THE NEO4J QUERY LANGUAGE

Slide 30

Slide 30 text

CYPHER - THE NEO4J QUERY LANGUAGE CREATE()…. A Node

Slide 31

Slide 31 text

CYPHER - THE NEO4J QUERY LANGUAGE CREATE()…. A Node CREATE(objname:ObjectType)

Slide 32

Slide 32 text

CYPHER - THE NEO4J QUERY LANGUAGE CREATE()…. A Node CREATE(objname:ObjectType) CREATE(bruce:Person)

Slide 33

Slide 33 text

CYPHER - THE NEO4J QUERY LANGUAGE

Slide 34

Slide 34 text

CREATE()…. A Node with extra properties CYPHER - THE NEO4J QUERY LANGUAGE

Slide 35

Slide 35 text

CREATE()…. A Node with extra properties CREATE(objname:ObjectType {propertyname: “Property Value”}) CYPHER - THE NEO4J QUERY LANGUAGE

Slide 36

Slide 36 text

CREATE()…. A Node with extra properties CREATE(objname:ObjectType {propertyname: “Property Value”}) CREATE(bruce:Person {realname:“Bruce Wayne”, alterego: “Batman”}) CYPHER - THE NEO4J QUERY LANGUAGE

Slide 37

Slide 37 text

CYPHER - THE NEO4J QUERY LANGUAGE

Slide 38

Slide 38 text

CYPHER - THE NEO4J QUERY LANGUAGE CREATE()…. A Relationship between nodes

Slide 39

Slide 39 text

CYPHER - THE NEO4J QUERY LANGUAGE CREATE()…. A Relationship between nodes CREATE(object1)-‐[:REL_TYPE {propertykey:PropertyVal}]-‐>(object2)

Slide 40

Slide 40 text

CYPHER - THE NEO4J QUERY LANGUAGE CREATE()…. A Relationship between nodes CREATE(object1)-‐[:REL_TYPE {propertykey:PropertyVal}]-‐>(object2) CREATE(joker)-‐[:DANCES {where: “In the pale moonlight”}]-‐>(the_devil)

Slide 41

Slide 41 text

CYPHER - THE NEO4J QUERY LANGUAGE

Slide 42

Slide 42 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find entities in the graph

Slide 43

Slide 43 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find entities in the graph MATCH(object1) RETURN object1

Slide 44

Slide 44 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find entities in the graph MATCH(object1) RETURN object1 Find everything

Slide 45

Slide 45 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find entities in the graph MATCH(object1) RETURN object1 MATCH(n) RETURN n Find everything

Slide 46

Slide 46 text

CYPHER - THE NEO4J QUERY LANGUAGE

Slide 47

Slide 47 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find with criteria

Slide 48

Slide 48 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find with criteria MATCH(object1:Label {criteria:Description} ) RETURN object1

Slide 49

Slide 49 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find with criteria MATCH(object1:Label {criteria:Description} ) RETURN object1 Find everything

Slide 50

Slide 50 text

CYPHER - THE NEO4J QUERY LANGUAGE MATCH()…. Find with criteria MATCH(object1:Label {criteria:Description} ) RETURN object1 MATCH(bruce:Person {realname:”Bruce Wayne”}) RETURN bruce Find everything

Slide 51

Slide 51 text

QUERY via PHP

Slide 52

Slide 52 text

NEOXYGEN composer.json 1 { 2 "require": { 3 "neoxygen/neoclient":"~2.1" 4 } 5 } https://github.com/neoxygen/neo4j-neoclient

Slide 53

Slide 53 text

use Neoxygen\NeoClient\ClientBuilder; $client = ClientBuilder::create() -‐>addConnection('default', 'http', 'localhost', 7474)  -‐>setAutoFormatResponse(true) -‐>build(); NEOXYGEN

Slide 54

Slide 54 text

// use the client to send a query $query = “MATCH(n) RETURN (n)”; $client-‐>sendCyperQuery($query); NEOXYGEN - BASICS // use the client to send a query & grab the result $query = “MATCH(n) RETURN (n)”; $result = $client-‐>sendCyperQuery($query)-‐>getResult();

Slide 55

Slide 55 text

// use the client to send a query $query = “MATCH(n) RETURN (n)”; $client-‐>sendCyperQuery($query)-‐>getResult(); // OR $client-‐>sendCyperQuery($query)-‐>getRows(); // OR $client-‐>sendCyperQuery($query); $client-‐>getResponse(); NEOXYGEN - RETURN OPTIONS

Slide 56

Slide 56 text

// return an array of nodes $query = “MATCH(p:Person) RETURN (p) LIMIT 10”; $result = $client-‐>sendCyperQuery($query)-‐>getResult(); $arrayOfNodes = $result-‐>getNodes(); foreach ($arrayOfNodes as $node ) { $nodeProperties = $node-‐>getProperties(); } NEOXYGEN - Get Nodes

Slide 57

Slide 57 text

// get relationships of a node $query = “MATCH(p:Person {type:‘Superhero’}) RETURN (p)”; $result = $client-‐>sendCyperQuery($query)-‐>getResult(); $heros = $result-‐>getNodes(); foreach ($heros as $hero ) { $enemies = $node-‐>getRelationships(‘ENEMY_OF’); } NEOXYGEN - Get Relationships

Slide 58

Slide 58 text

// use {parameter} notation $query = “MATCH(p:Person {name: { personname } type: { persontype } }) RETURN (p)”; $result = $client-‐>sendCyperQuery($query, array( ‘personname’=> ‘Bruce Wayne’, ‘persontype’ => ‘Superhero’ )) -‐>getResult(); NEOXYGEN - Using Parameters in Queries

Slide 59

Slide 59 text

Cypher - Delete Everything    Find all nodes and relationships  And delete them MATCH (n) OPTIONAL MATCH (n)-‐[r]-‐() DELETE n,r

Slide 60

Slide 60 text

RESOURCES http://gist.neo4j.org/?6029850 NEO4J Gists NEO4J Documentation http://neo4j.com/developer/get-started/ Localhost Examples http://localhost:7474 http://assets.neo4j.org/download/Neo4j_CheatSheet_v3.pdf Cypher Cheat Sheet

Slide 61

Slide 61 text

RESOURCES Free eBooks http://neo4j.com/books/