{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"slideshow": {
"slide_type": "slide"
}
},
"source": [
"###### Algorithms & Database for Graph Data\n",
"
\n",
"
SC 4125: Developing Data Products
\n", "Module-5: Network Science Toolkit
\n",
" \n",
" | \n",
"
\n",
" \n",
" | \n",
" \n",
" \n",
" | \n",
"
\n",
" \n",
" | \n",
" \n",
" \n",
" | \n",
"
\n",
" The following content on Neo4j and Cypher is (primarily) based on the book Graph Databases by Robinson et al. (specifically Chapter 3, where Cypher is discussed), and documentation resources on Neo4j website. Unless a different source is stated, the image snippets used in the following are from the stated book and Neo4j website. Neo4j provides for free this book as well as several other books on Graph DB, Algorithms and Data Science. Memgraph.com has a nice cheat sheet to get basic familiarity quickly with Cypher.\n", " \n", " \n", " \n", " | \n",
" \n",
" \n",
" | \n",
"
\n",
"\n",
"Flexibility\n",
"
| \n",
" \n",
" \n",
" | \n",
"
\n", " | NodeType | \n", "
---|---|
0 | \n", "[Movie] | \n", "
1 | \n", "[Person] | \n", "
\n", " | NodeType | \n", "Properties | \n", "
---|---|---|
0 | \n", "[Movie] | \n", "[tagline, title, released] | \n", "
1 | \n", "[Movie] | \n", "[title, released, tagline] | \n", "
2 | \n", "[Movie] | \n", "[released, tagline, title] | \n", "
3 | \n", "[Movie] | \n", "[title, released] | \n", "
4 | \n", "[Person] | \n", "[name, born] | \n", "
5 | \n", "[Person] | \n", "[name] | \n", "
\n", " | RelationType | \n", "Properties | \n", "
---|---|---|
0 | \n", "ACTED_IN | \n", "[roles] | \n", "
1 | \n", "PRODUCED | \n", "[] | \n", "
2 | \n", "DIRECTED | \n", "[] | \n", "
3 | \n", "WROTE | \n", "[] | \n", "
4 | \n", "REVIEWED | \n", "[summary, rating] | \n", "
5 | \n", "REVIEWED | \n", "[rating, summary] | \n", "
6 | \n", "FOLLOWS | \n", "[] | \n", "
\n", " | PersonName | \n", "MovieName | \n", "
---|---|---|
0 | \n", "Aaron Sorkin | \n", "A Few Good Men | \n", "
1 | \n", "Al Pacino | \n", "The Devil's Advocate | \n", "
2 | \n", "Annabella Sciorra | \n", "What Dreams May Come | \n", "
3 | \n", "Anthony Edwards | \n", "Top Gun | \n", "
4 | \n", "Audrey Tautou | \n", "The Da Vinci Code | \n", "
... | \n", "... | \n", "... | \n", "
167 | \n", "Victor Garber | \n", "Sleepless in Seattle | \n", "
168 | \n", "Werner Herzog | \n", "What Dreams May Come | \n", "
169 | \n", "Wil Wheaton | \n", "Stand By Me | \n", "
170 | \n", "Zach Grenier | \n", "RescueDawn | \n", "
171 | \n", "Zach Grenier | \n", "Twister | \n", "
172 rows × 2 columns
\n", "\n", " | PersonName | \n", "Colleague | \n", "
---|---|---|
0 | \n", "Kevin Bacon | \n", "Aaron Sorkin | \n", "
1 | \n", "Kevin Bacon | \n", "Bill Paxton | \n", "
2 | \n", "Kevin Bacon | \n", "Christopher Guest | \n", "
3 | \n", "Kevin Bacon | \n", "Cuba Gooding Jr. | \n", "
4 | \n", "Kevin Bacon | \n", "Demi Moore | \n", "
5 | \n", "Kevin Bacon | \n", "Ed Harris | \n", "
6 | \n", "Kevin Bacon | \n", "Frank Langella | \n", "
7 | \n", "Kevin Bacon | \n", "Gary Sinise | \n", "
8 | \n", "Kevin Bacon | \n", "J.T. Walsh | \n", "
9 | \n", "Kevin Bacon | \n", "Jack Nicholson | \n", "
10 | \n", "Kevin Bacon | \n", "James Marshall | \n", "
11 | \n", "Kevin Bacon | \n", "Kevin Pollak | \n", "
12 | \n", "Kevin Bacon | \n", "Kiefer Sutherland | \n", "
13 | \n", "Kevin Bacon | \n", "Michael Sheen | \n", "
14 | \n", "Kevin Bacon | \n", "Noah Wyle | \n", "
15 | \n", "Kevin Bacon | \n", "Oliver Platt | \n", "
16 | \n", "Kevin Bacon | \n", "Rob Reiner | \n", "
17 | \n", "Kevin Bacon | \n", "Ron Howard | \n", "
18 | \n", "Kevin Bacon | \n", "Sam Rockwell | \n", "
19 | \n", "Kevin Bacon | \n", "Tom Cruise | \n", "
20 | \n", "Kevin Bacon | \n", "Tom Hanks | \n", "
\n", " | PersonName | \n", "CoActor | \n", "
---|---|---|
0 | \n", "Kevin Bacon | \n", "Aaron Sorkin | \n", "
1 | \n", "Kevin Bacon | \n", "Bill Paxton | \n", "
2 | \n", "Kevin Bacon | \n", "Christopher Guest | \n", "
3 | \n", "Kevin Bacon | \n", "Cuba Gooding Jr. | \n", "
4 | \n", "Kevin Bacon | \n", "Demi Moore | \n", "
5 | \n", "Kevin Bacon | \n", "Ed Harris | \n", "
6 | \n", "Kevin Bacon | \n", "Frank Langella | \n", "
7 | \n", "Kevin Bacon | \n", "Gary Sinise | \n", "
8 | \n", "Kevin Bacon | \n", "J.T. Walsh | \n", "
9 | \n", "Kevin Bacon | \n", "Jack Nicholson | \n", "
10 | \n", "Kevin Bacon | \n", "James Marshall | \n", "
11 | \n", "Kevin Bacon | \n", "Kevin Pollak | \n", "
12 | \n", "Kevin Bacon | \n", "Kiefer Sutherland | \n", "
13 | \n", "Kevin Bacon | \n", "Michael Sheen | \n", "
14 | \n", "Kevin Bacon | \n", "Noah Wyle | \n", "
15 | \n", "Kevin Bacon | \n", "Oliver Platt | \n", "
16 | \n", "Kevin Bacon | \n", "Sam Rockwell | \n", "
17 | \n", "Kevin Bacon | \n", "Tom Cruise | \n", "
18 | \n", "Kevin Bacon | \n", "Tom Hanks | \n", "
\n", " | PersonName | \n", "Colleague | \n", "
---|---|---|
0 | \n", "Kevin Bacon | \n", "Rob Reiner | \n", "
1 | \n", "Kevin Bacon | \n", "Ron Howard | \n", "
\n", " | PersonName | \n", "Colleague | \n", "
---|---|---|
0 | \n", "Kevin Bacon | \n", "Rob Reiner | \n", "
1 | \n", "Kevin Bacon | \n", "Ron Howard | \n", "
\n", " | tagline | \n", "title | \n", "released | \n", "
---|---|---|---|
0 | \n", "In every life there comes a time when that thi... | \n", "That Thing You Do | \n", "1996 | \n", "
1 | \n", "Come as you are | \n", "The Birdcage | \n", "1996 | \n", "
2 | \n", "Break The Codes | \n", "The Da Vinci Code | \n", "2006 | \n", "
3 | \n", "Evil has its winning ways | \n", "The Devil's Advocate | \n", "1997 | \n", "
4 | \n", "Walk a mile you'll never forget. | \n", "The Green Mile | \n", "1999 | \n", "
5 | \n", "Welcome to the Real World | \n", "The Matrix | \n", "1999 | \n", "
6 | \n", "Free your mind | \n", "The Matrix Reloaded | \n", "2003 | \n", "
7 | \n", "Everything that has a beginning has an end | \n", "The Matrix Revolutions | \n", "2003 | \n", "
8 | \n", "This Holiday Season… Believe | \n", "The Polar Express | \n", "2004 | \n", "
9 | \n", "Pain heals, Chicks dig scars... Glory lasts fo... | \n", "The Replacements | \n", "2000 | \n", "
10 | \n", "I feel the need, the need for speed. | \n", "Top Gun | \n", "1986 | \n", "
11 | \n", "Don't Breathe. Don't Look Back. | \n", "Twister | \n", "1996 | \n", "