Drug-Condition Graph Project

This example is for visualizing drug(s) and condition(s) its prescribed for using Neo4j + Spring Boot Integration. Provides following REST API -

• GET - /graph/neo4j/drugs returns the list of Drugs, Conditions and the "PRESCRIBED" relationship from the Neo4j Instance running as a Docker container

Technology Stack

Docker
Neo4j - Docker Container, Bolt Driver, Spring Boot Integration
Spring Boot
REST API

Cypher Queries for Neo4J

• Creation of Drug and Condition Graph Nodes:

CREATE (Asthma:Condition {name: 'Asthma', symptom: 'Shortness of Breath'})
CREATE (Diabetes:Condition {name: 'Diabetes', symptom: 'Fatigue'})
CREATE (Amevive:Drug {name: 'Amevive', therapeuticArea: 'Diabetes', activeIngredient: 'Pixie Dust'})
CREATE (Ketoconazole:Drug {name: 'Ketoconazole', therapeuticArea: 'Diabetes and COPD', activeIngredient: 'Benzoid Sulphur'})
CREATE (Tacrolimus:Drug {name: 'Tacrolimus', therapeuticArea: 'Asthma and Multiple Sclerosis', activeIngredient: 'Propylene glycol'})

• Creation of Relationships or Graph Edges:

MATCH (a:Drug),(b:Condition)
WHERE a.name = 'Amevive' AND b.name = 'Asthma'
CREATE (a)-[r:PRESCRIBED {dose: 2}]->(b)
RETURN type(r)

MATCH (a:Drug),(b:Condition)
WHERE a.name = 'Amevive' AND b.name = 'Diabetes'
CREATE (a)-[r:PRESCRIBED {dose: 3}]->(b)
RETURN type(r)

MATCH (a:Drug),(b:Condition)
WHERE a.name = 'Ketoconazole' AND b.name = 'Diabetes'
CREATE (a)-[r:PRESCRIBED {dose: 2}]->(b)
RETURN type(r)

MATCH (a:Drug),(b:Condition)
WHERE a.name = 'Ketoconazole' AND b.name = 'Asthma'
CREATE (a)-[r:PRESCRIBED {dose: 4}]->(b)
RETURN type(r)

MATCH (a:Drug),(b:Condition)
WHERE a.name = 'Tacrolimus' AND b.name = 'Asthma'
CREATE (a)-[r:PRESCRIBED {dose: 6}]->(b)
RETURN type(r)
;

Neo4J Docker Administration

• Startup

docker run --publish=7474:7474 --publish=7687:7687 neo4j:latest

Neo4J Browser Console

http://localhost:7474/browser

Drug Condition Graph REST Response