Document + Graph Databases

Question 1

How do document databases work?

Answer 1

• like a python dictionary with key-value pairs

Question 2

Why are document db used?

Answer 2

• they’re just texted so it can be parsed easily, human-readable
• sql adds overheard which you might not need (think about what a blog needs)

Question 3

What do vertices and edges represent in graph databases?

Answer 3

vertices:
- objects, things w/ attributes/properties (entities in ER model)

edges:
- relationships b/w
- directed, but searching can ignore direction

Question 4

In Neo4J, what’s the syntas to create something with 2 attributes?

Answer 4

CREATE (Name:Label {key:value, key2:value2})

Question 5

In Neo4J, create a Person Keanu reeves, with the name being just his first name and he’s born in 1964

Answer 5

CREATE (Keanu: Person {name:’Keanu Reeves’, born: 1964})

Question 6

In Neo4J, create the relationship ACTED_IN between Keanu and the matrix. the property should include their role

Answer 6

CREATE (Keanu)-:[:ACTED_IN {roles:[‘Neo’]}]->(TheMatrix)

Question 7

Describe how to represent a node and edge in Neo4J

Answer 7

() = node
[] = edge
- edges are always directional

Question 8

What does MATCH and RETURN do here:
MATCH (a)-[]-(b) RETURN a,b

Answer 8

MATCH - searches for relationships satisfying the pattern
RETURN - specifies what is the result set

Question 9

How to show everything about a movie?

Answer 9

MATCH (m:movie) RETURN m

Question 10

How to search for a person named tom Hanks?

Answer 10

MATCH (tom:Person {name:”Tom Hanks”}) return tom

Question 11

How to make a director and movie?

Answer 11

MATCH (p:Person)-[d:DIRECTED]->(m:Movie) RETURN p,d,m

Question 12

Show the query to find person, director, and movie that was released after 2010

Answer 12

MATCH (p:Person)-[d:Directed]-(m:Movie) WHERE m.released>2010 RETURN p,d,m