Academy of Science and Literature | Digital Academy

Graphtechnologies in the Digital Humanities

First steps in the Graphworld

Andreas Kuczera | https://studiengang-digitale-methodik.pages.gitlab.rlp.net/modul-5/5c/slides/graphentechnologien-en/
Example projects (german): NeG | RI | DTA
CC-BY 4.0

structure

1. example graph
2. neo4j
3. my first node
4. relation and evaluation
5. import data from google-drive

01b

explanations

• The examplegraph shows above a node of the Person type with the Name property. This has the value "Charlemagne"..
• Below left is another node of type person by the name of Einhard.
• Below right is a node of the type book and the title "Vita Karoli Magni".
• The Edges indicate that Charlemagne knew Einhart, that Einhard wrote the book "Vita Karoli Magni" ca. 828-830 and Charlemagne is mentioned in the book.

02

Neo4j

• Download of Neo4j: https://neo4j.com/download/
• Or use a Sandbox
  
• Start Neo4j-Desktop or use browser inteface aufrufen
  (http://localhost:7474)
• At the top left is information about the structure of the database and sample commands. The third tab contains the documentation
• The input field for the commands is located in the right area and the result window below
• First login with neo4j/neo4j. Then assign your own password. Remember !

03a

My first node

• Link to the common work database

  Login: neo4j

  Passwort: |Rpmx18YvM6Zn-

• Empty database:

  MATCH (n) DETACH DELETE n;
  

03b

My first node

• Create a node - You have to specify a name when creating a node so that something can be returned afterwards:

  CREATE (n) RETURN *;
  

• Creates a node with the label Person and returns the result:

  CREATE (n:Person) RETURN n;
  

03c

My first node

• Creates a node with a label and a property (also multiple times):

  CREATE (n:Person {surname:'Kuczera'})
  RETURN n;
  

• How to delete a node:

  MATCH (n:Person {surname:'Kuczera'})
  DELETE n;
  

• A node with a label and a property, if it does not already exist:

  MERGE (n:Person {surname:'Kuczera'})
  RETURN n;
  

03d

My first node

• Adds the birthplace property to the person node:

  MATCH (n:Person {surname:'Kuczera'})
  SET n.birthplace = 'Giessen'
  RETURN n;
  

• Show me all people who have the letter 'r' in their last name property:

  MATCH (n:Person)
  WHERE n.surname =~ '.*r.*'
  RETURN n;
  

04

Linking and evaluation

• Adds another person:

  MERGE (n:Person {surname:'Schrade'}) RETURN *;
  

• Adds a connection between two persons

  MATCH (n1:Person {surname:'Kuczera'})
  MATCH (n2:Person {surname:'Schrade'})
  MERGE (n1)-[:MY_LEFT_NEIGHBOUR]->(n2)
  RETURN *;
  

• Show me all the people connected to Mr. Kuczera:

  MATCH (n:Person {surname:'Kuczera'})-[:MY_LEFT_NEIGHBOUR]-(m:Person)
  RETURN *;
  

05

LOAD CSV from Google Docs

• https://docs.google.com/spreadsheets/d/1jQ0nZTlhO4IrZOGROz0BUT5EXvAZNcxjGjEL9gvUbxs/edit?usp=sharing
  

• LOAD CSV WITH HEADERS FROM
  "https://docs.google.com/spreadsheets/d/1jQ0nZTlhO4IrZOGROz0BUT5EXvAZNcxjGjEL9gvUbxs/export?format=csv&id=1jQ0nZTlhO4IrZOGROz0BUT5EXvAZNcxjGjEL9gvUbxs&gid=0"
  AS line FIELDTERMINATOR ','
  CREATE (p1:Person {pid:line.number, surname:line.surname,
  forename:line.forename, placeOfBirth:line.birthplace, yearOfBirth:line.yearOfirth})
  RETURN *;

• LOAD CSV WITH HEADERS FROM
  "https://docs.google.com/spreadsheets/d/1jQ0nZTlhO4IrZOGROz0BUT5EXvAZNcxjGjEL9gvUbxs/export?format=csv&id=1jQ0nZTlhO4IrZOGROz0BUT5EXvAZNcxjGjEL9gvUbxs&gid=0"
  AS line FIELDTERMINATOR ','
  MATCH (p1:Person {pid:line.number})
  MATCH (p2:Person {pid:line.leftNeighbour})
  CREATE (p1)-[:MY_LEFT_NEIGHBOUR]->(p2)
  WITH line, p1
  MATCH (p3:Person {pid:line.knows})
  CREATE (p1)-[:KNOWS]->(p3)
  RETURN *;

06

Queries and exercises

• In which place are most people born ?

  MATCH (n:Person)
  RETURN n.birthplace, count(*) as count, collect(n.surname) as surname
  ORDER BY count DESC;
  

• In which year were the most seminar participants born ?

  MATCH (n:Person)
  RETURN n.yearOfBirth, count(*) as count, collect(n.surname) as surname
  ORDER BY count DESC;
  

06

Queries and exercises

• Is there a connection between two people ?

  // shortest_path
  MATCH
  (p1:Person { surname:'Kuczera' }),
  (p2:Person { surname:'Schrade' }),
  p = shortestPath((p1)-[*..25]-(p2))
  RETURN p;
  

• Paths between people born in 1993 and 1995 ?

  MATCH
  (p1:Person),
  (p2:Person),
  p = shortestPath((p1)-[*..25]-(p2))
  WHERE p1.geburtsjahr = '1992'
  AND p2.geburtsjahr = '1995'
  AND p1 <> p2
  RETURN p;
  

Academy of Science and Literature | Digital Academy

Thanks for your attention

Andreas Kuczera | https://studiengang-digitale-methodik.pages.gitlab.rlp.net/modul-5/5c/slides/graphentechnologien-en/
Example projects (german): NeG | RI | DTA
CC-BY 4.0