Slide 1
Slide 1 text
Graph Databases and Laravel
DOTS
the
CONNECTING
LARACON US 2019
KEITH DAMIANI
Slide 2
Slide 2 text
Graph Databases and Laravel
KEITH DAMIANI
DOTS
the
CONNECTING
LARACON US 2019
Slide 3
Slide 3 text
No content
Slide 4
Slide 4 text
No content
Slide 5
Slide 5 text
No content
Slide 6
Slide 6 text
Graph Databases and Laravel
KEITH DAMIANI
DOTS
the
CONNECTING
LARACON US 2019
Slide 7
Slide 7 text
No content
Slide 8
Slide 8 text
KEITH DAMIANI
PRINCIPAL PROGRAMMER
!
Slide 9
Slide 9 text
No content
Slide 10
Slide 10 text
No content
Slide 11
Slide 11 text
No content
Slide 12
Slide 12 text
No content
Slide 13
Slide 13 text
No content
Slide 14
Slide 14 text
No content
Slide 15
Slide 15 text
No content
Slide 16
Slide 16 text
No content
Slide 17
Slide 17 text
"
Slide 18
Slide 18 text
What is a graph database?
CONNECTING THE DOTS
Slide 19
Slide 19 text
What is a graph database?
CONNECTING THE DOTS
Slide 20
Slide 20 text
What is a graph database?
CONNECTING THE DOTS
Slide 21
Slide 21 text
What is a graph database?
CONNECTING THE DOTS
Slide 22
Slide 22 text
What is a graph database?
CONNECTING THE DOTS
Graph DBs vs. relational DBs
Use cases
Writing queries
Laravel graph DBs
Slide 23
Slide 23 text
What is a graph database?
CONNECTING THE DOTS
Slide 24
Slide 24 text
What is a graph database?
CONNECTING THE DOTS
© JACK MCDADE
Slide 25
Slide 25 text
© JACK MCDADE
Slide 26
Slide 26 text
No content
Slide 27
Slide 27 text
No content
Slide 28
Slide 28 text
Nodes
"VERTICES"
Slide 29
Slide 29 text
Nodes
"VERTICES"
"EDGES"
Relationships
Slide 30
Slide 30 text
Nodes
"VERTICES"
"EDGES"
Relationships
Slide 31
Slide 31 text
Keith's
Family
Tree
Slide 32
Slide 32 text
Keith's
Family
Tree
Keith
Slide 33
Slide 33 text
WAIT A MINUTE
Slide 34
Slide 34 text
WAIT A MINUTE
RELATIONAL DATABASES
Slide 35
Slide 35 text
WAIT A MINUTE
RELATIONAL DATABASES
“ ”
Slide 36
Slide 36 text
L
14th St./8th Ave. Union Square
6th Ave.
Washington Square
Houston St.
1st Ave.
L L
K
B
B
K
B
B
Slide 37
Slide 37 text
stations
id name
1 14th St./8th Ave.
2 6th Ave.
3 Union Square
4 1st Ave.
5 Washington Square
6 Houston St.
lines
id name
1 3
2 4
3 5
4 L
5 B
6 K
line_station
id station_id line_id connected_to
1 3 4 2
2 4 4 7
3 5 5 4
4 5 6 8
5 6 5 6
6 6 6 9
Slide 38
Slide 38 text
stations
id name
1 14th St./8th Ave.
2 6th Ave.
3 Union Square
4 1st Ave.
5 Washington Square
6 Houston St.
lines
id name
1 3
2 4
3 5
4 L
5 B
6 K
line_station
id station_id line_id connected_to
1 3 4 2
2 4 4 7
3 5 5 4
4 5 6 8
5 6 5 6
6 6 6 9
Slide 39
Slide 39 text
L
14th St./8th Ave. Union Square
6th Ave.
Washington Square
Houston St.
1st Ave.
L L
K
B
B
K
B
B
Slide 40
Slide 40 text
1735
KALININGRAD
Slide 41
Slide 41 text
KÖNIGSBERG
Slide 42
Slide 42 text
© HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI
Slide 43
Slide 43 text
© HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI
Slide 44
Slide 44 text
© HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI
No sweat,
I got this.
Slide 45
Slide 45 text
© HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI
No sweat,
I got this.
e
2.718281828459045
Slide 46
Slide 46 text
© HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI
Slide 47
Slide 47 text
No content
Slide 48
Slide 48 text
No content
Slide 49
Slide 49 text
JOINS
Slide 50
Slide 50 text
JOINS
Slide 51
Slide 51 text
L
14th St./8th Ave. Union Square
6th Ave.
Washington Square
Houston St.
1st Ave.
L L
K
B
B
K
B
B
Slide 52
Slide 52 text
No content
Slide 53
Slide 53 text
What is a graph database?
CONNECTING THE DOTS
Graph DBs vs. relational DBs
Use cases
Slide 54
Slide 54 text
Highly-connected data
THE NATURE OF YOUR DATA
Hierarchical/tree-shaped
Slide 55
Slide 55 text
FRIEND-OF-A-FRIEND QUERY
Depth Relational DB Neo4j Graph DB Records
2 0.02 0.01 2500
3 30 0.17 110,000
4 1,544 1.36 600,000
5 Unfinished 2.13 800,000
PERFORMANCE, IN SECONDS
Slide 56
Slide 56 text
Highly-connected data
THE NATURE OF YOUR DATA
Hierarchical/tree-shaped
Many-to-many and/or polymorphic
Schema-less
Slide 57
Slide 57 text
Social networks
COMMON USE CASES
Real-time product recommendations
Social + Recommendation
Slide 58
Slide 58 text
Social networks
COMMON USE CASES
Real-time product recommendations
Would you like to
Join my Professional
Network?
Social + Recommendation
Slide 59
Slide 59 text
Social networks
COMMON USE CASES
Real-time product recommendations
Social + Recommendation
Geospatial
Geospatial + Recommendation
Slide 60
Slide 60 text
Digital asset management
COMMON USE CASES (MORE!)
Textual analysis / search
PageRank search
Financial / fraud detection
Public policy / journalism
Slide 61
Slide 61 text
No content
Slide 62
Slide 62 text
Disconnected data
BAD FITS
Bulk data scans
Aggregating across nodes
When write speed is paramount
BLOBs / large amounts of text
Slide 63
Slide 63 text
No content
Slide 64
Slide 64 text
NEO4J.COM
Slide 65
Slide 65 text
OrientDB
Apache TinkerPop
Amazon Neptune
JanusGraph
ArangoDB
Slide 66
Slide 66 text
CYPHER
Slide 67
Slide 67 text
CYPHER
( )-[ ]->( )
Slide 68
Slide 68 text
CYPHER
( )-[ ]->( )
MATCH RETURN
Slide 69
Slide 69 text
CYPHER
MATCH (me:User {name: 'Me'})
Slide 70
Slide 70 text
(DEMO TIME!)
Slide 71
Slide 71 text
What is a graph database?
CONNECTING THE DOTS
Graph DBs vs. relational DBs
Use cases
Writing queries
Laravel graph DBs
Slide 72
Slide 72 text
NeoEloquent
THREE OPTIONS FOR LARAVEL
Slide 73
Slide 73 text
NeoEloquent
THREE OPTIONS FOR LARAVEL
Slide 74
Slide 74 text
NeoEloquent
THREE OPTIONS FOR LARAVEL
GraphAware neo4j-php-client
Slide 75
Slide 75 text
NeoEloquent
THREE OPTIONS FOR LARAVEL
GraphAware neo4j-php-client
Slide 76
Slide 76 text
NeoEloquent
THREE OPTIONS FOR LARAVEL
GraphAware neo4j-php-client
¯\_(ツ)_/¯
Slide 77
Slide 77 text
Vapor
Laravel
Slide 78
Slide 78 text
Neo4Laravel
Slide 79
Slide 79 text
Larapals.com
Slide 80
Slide 80 text
! @keithdamiani
keithdamiani.com