Reactome Graph Database Batch Importer

What is the Reactome Graph Batch Importer project

The Graph Importer is a tool used for initial data conversion from the Reactome relational database to a graph database. To maximise import performance the Neo4j Graph Importer is utilised to directly create the Neo4j database file structure. This process is unsafe ignoring transactions, constraints or other safety features. Constraints will be checked once the import process has finished.

The Gatch Importer generates the graph database dynamically depending on the Model specified in the Reactome graph library. Depending on the POJOs specified in Domain model, data will be automatically fetched from corresponding Instances of the relational database. Annotations used in the model help to indicate properties and relationships that should be taken into account in the import process.

Project components used:

• Neo4j Community Edition - version: 3.2.2 or latest
• Reactome Graph Core

Data Import

Reactome data can be imported without the script using the Main.java entry point. Use: java -jar BatchImporter-exec.jar

⚠️CAUTION: In order for the import to succeed following steps must be ensured:

1. All permissions to the specified target folder must be granted to the executing users of the jar file
2. When using the new database, permissions must be given to neo4j in order to access the database.
3. Restart neo4j

Properties

When executing the jar file following properties have to be set.

Usage:
org.reactome.server.graph.Main [--help] [(-h|--host) <host>] [(-s|--port)
<port>] [(-d|--name) <name>] [(-u|--user) <user>] [(-p|--password) <password>]
[(-n|--neo4j) <neo4j>] [(-f|--intactFile) <intactFile>]
[(-i|--interactions)[:<interactions>]] [(-b|--bar)[:<bar>]]
Atoolforimportingreactomedataimporttotheneo4jgraphDb
[--help]
Printsthishelpmessage.
[(-h|--host) <host>]
Thedatabasehost (default: localhost)
[(-s|--port) <port>]
Thereactomeport (default: 3306)
[(-d|--name) <name>]
Thereactomedatabasenametoconnectto (default: reactome)
[(-u|--user) <user>]
Thedatabaseuser (default: reactome)
[(-p|--password) <password>]
Thepasswordtoconnecttothedatabase (default: reactome)
[(-n|--neo4j) <neo4j>]
Pathtotheneo4jdatabase (default: ./target/graph.db)
[(-f|--intactFile) <intactFile>]
Pathtotheinteractiondatafile
[(-i|--interactions)[:<interactions>]]
Includeinteractiondata. IftheintactFileisnotprovided, theinteractiondatawillbedownloaded

Example:

java -jar GraphImporter-exec.jar \ 
-h localhost \ 
-s 3306 \
-d reactome \ 
-u reactome_user \
-p not2share \ 
-n ./target/graph.db

Extras

• [1] Reactome Graph Database
• [2] Documentation
• [3] MySQL dump database