NEO4J ESSENTIALS
Tuna VARGI
DOWNLOAD NEO4J
http://neo4j.com/download/
Why graphs?
What is graph ?
USE CASES
SOCIAL NETWORK
NETWORK ANALYSIS
ROUTE FINDING
RECOMMENDATIONS
SECURITY ANALYSIS
ETC
WHAT IS GRAPH ?
BLOCKS
- Nodes
- Relationships
- Properties
- Labels
RELATIONAL DB
GRAPH DB
CYPHER
a pattern-matching query language for graphs
DECLARATIVE
PATTERN MATCHING
EXPRESSIVE
CLAUSES
GENERAL CLAUSES
- RETURN
- ORDER BY
- LIMIT
READING CLAUSES
- MATCH
- OPTIONAL MATCH
- WHERE
- WITH
- AGGREGATION
WRITE CLAUSES
- CREATE
- MERGE
- SET
- DELETE
- REMOVE
QUERY STRUCTURE
MOVIES
PERSON
RELATIONSHIPS
- ACTED_IN
- DIRECTED
- FOLLOWS
- PRODUCED
- REVIEWED
- WROTE
QUERY EXAMPLES
MATCH (m:Movie)
WHERE m.released=1992
RETURN m
MATCH (m:Movie), (p: Person)
MATCH path=(m)<-[:ACTED_IN]-(p)
WHERE m.released=1992
return path
MATCH (m:Movie), (p: Person {name: "Tom Hanks"})
MATCH (p)-[:DIRECTED]->(m)
return m
MATCH (m:Movie)<-[:ACTED_IN]-(a:Person)
RETURN m.title as movie, collect(a.name) as cast
LIMIT 20
MATCH (p: Person {name: "Tom Hanks"})
MATCH (p)-[:DIRECTED]->(m:Movie)
WITH distinct m
return count(m)
CHROMA
WHAT WAS OUR PROBLEM ?
INFINITE CATEGORY TREE
PHOTOS ATTACHED TO CATEGORIES
GIVE ME THE LATEST PHOTO IN A CATEGORY TREE
MATCH (category:Category{id:'5294ecd1389a5e44303bd774'})
MATCH (category)-[:CHILD_OF*0..50]->(subcats: Category)<-[:PHOTO_OF]-(photo: Photo)
with photo
order by photo.created_at
return last(collect(photo.id)) as last_photo_id
WE NEED THE LATEST PHOTO IN A CATEGORY TREE BELONG TO PROVIDED USER
COMPLEX AGGREGATION
MATCH (cat_user:User {id:"51e52cfc389a5e35fa403436"}),
(category:Category)
WHERE category.parent_id='0'
MATCH (category)-[:CHILD_OF*0..50]->(subcats)
WITH distinct subcats as dsubcats, category, cat_user
MATCH (dsubcats)<-[:PHOTO_OF]-(photo:Photo)-[:OWNER]->(cat_user)
with photo, category, cat_user
order by photo.created_at
return distinct category.id, last(collect(photo.id)) as last_photo_id, count(distinct photo) as photo_count, category.name
GIVE ME THE PHOTOS CONNECTED TO PLACES NEAR LAT 22.7 LON 79.10
START place=node:geom('withinDistance:[22.7, 79.10, 100.0]')
where place.type='Place'
MATCH (place)-[:CHILD_OF*0..50]->(subplaces:Place)
with distinct subplaces, place
MATCH (subplaces)<-[:TAKEN_AT]-(photo:Photo)
return place.name, photo
GIVE ME THE COUNT OF PHOTOS IN NORTH AMERICA FOR WILD ANIMALS
MATCH (place: Place{id: '5571b6a691201b05075468f8'})
MATCH (category: Category{id: '529500b0389a5e442fd8fcad'})
MATCH (place)-[:CHILD_OF*0..10]->(subplaces)<-[:TAKEN_AT]-(photo:Photo)
MATCH (category)-[:CHILD_OF*0..10]->(subcategories: Category)<-[:PHOTO_OF]-(photo: Photo)
return count(distinct photo)
THANKS
NEO4J ESSENTIALS
By Tuna Vargı
NEO4J ESSENTIALS
- 2,681