Plugins ~ database neo4j plugin tutorial
Neo4j is a powerful, award-wining graph database written in Java. It can store billions of nodes and relationships and allows very fast query/traversal. We release today a new version of the Neo4j Plugin supporting the latest 1.5 version of Neo4j. In Gephi, go to Tools > Plugins to install the plug-in.
The plugin let you visualize a graph stored in a Neo4j database and play with it. Features include full import, traversal, filter, export and lazy loading.
Neo4j Integration into Gephi from gephi on Vimeo.
The plug-in is officially supported by the Neo4j team and is open to contribution! The code is hosted on GitHub.
If you have suggestions please send them our way, we would love to hear your feedback! The forum is the best place for that.
Plugins ~ 0.8 architecture database gsoc neo4j scalability
During this summer, six students are working on Gephi with the Google Summer of Code. They contribute to Gephi by developing new features that will be integrated in the 0.8 version, released later this year.
My name is Martin Škurla and this summer I was working on GSoC project called “Adding support for Neo4j in Gephi”. In this article we will look at implemented features including these under the hood, pictures of dialogs, common use cases and future plans.
At first I want to make quick introduction into Gephi project. Gephi is Open Source Visualization Platform build on top of the NetBeans platform. It is written in Java so you can run it on various Operating Systems including Windows, Linux, Mac OS. It supports many interesting graph analysis capabilities including:
- Real-time visualization
- Dynamic network analysis
- Cartography clustering and hierarchical graphs
- Dynamic filtering
The story so far
The main idea of my project is to add support for Neo4j in Gephi. This means the ability to transform the Neo4j graph into Gephi graph. In fact, both graph models are different so the first task was to make mapping between Neo4j graph items and Gephi graph items and vice versa.
There was also a mismatch between types supported in Neo4j and these supported by Gephi. This mismatch was solved by adding new “List” types into Gephi, so now every type in Neo4j has its appropriate type in Gephi.
There were also some changes under the hood which are not visible to end user, but must be defined and implemented. The most interesting thing is adding “Delegating mechanism”. This mechanism is responsible for getting values from storing engine (Neo4j) as well as manipulation with data. In fact during the importing process, graph representation of Neo4j graph is created in Gephi, but all values are not stored directly, but they are queried using delegating mechanism.
Another minor tasks were to customize the open dialogs used for importing local Neo4j database and debugging the imported database. The open dialog for importing accepts only valid Neo4j database directories. I defined valid Neo4j database directory structure and every valid directory now includes picture of Neo4j in the open dialog. User is able to open only valid Neo4j directories in the process of importing. The open dialog for debugging accepts only Java class files that can be used for debugging process. This simply means they have to implement required interface and have public nonparam constructor. Every valid class file will have Neo4j picture and after selecting a valid debug file, Target and Visualization options will be automatically filled based on data from selected class file.
Open Neo4j directory dialog customization
Open Neo4j debug file dialog customization
All possible actions started in menu. As we can see, this is the entry point to import from, export to and debug the Neo4j graph. Both importing and exporting support local as well as remote Neo4j databases.
Whole graph import dialog
Importing process consist of 2 approaches:
- whole import
- traversal import
Whole graph import dialog is designed for importing whole graph. We can customize the rules responsible for returning nodes by defining filtering expressions. For example previous dialog can be used when we want to find all people working on project Gephi with maximum age 30 years. Only people with at least 5 years of experience and those which have driver licence types A, B and C will be included.
Let’s have a deeper look at the dialog:
- Property key is the name of property we want to filter
- Property value is the value which will be compared to actual Node property value using chosen operator. Values will be automatically converted into appropriate types and if the value cannot be converted, the node will not be included into graph. All types supported in Neo4j are supported in this dialog. We can also see the support for array types in the last filter expression.
- Operator will be applied on the final expression and if the expression is evaluated to true, node will be included
- Match case means the ability to compare String, char, String and char types with respect of the same case
- Restrict mode is used to restrict some nodes. Imagine we have people stored in database which have only subset of required property names used in filtering expressions. If the Restrict mode is on, only nodes which have all property names and all filtering expressions evaluated to true will be included. If the Restrict mode is off, every node which has any subset of required property names (even empty subset) will be included if all the filtering expressions applicable to the subset will be evaluated to true.
All the filtering expressions are combined together using AND and the list of current supported operators consist of: ==, !=, <, <=, >, >=.
In fact, usefulness of adding new operators as well as including OR and other useful import options is the main idea behind Questionnaire which is part of this article.
Traversal graph import dialog is designed for importing any subgraph using traversal capabilities of Neo4j v 1.1. Traversal import adds additional options:
- Start node can be set in two ways, either by its id or by its indexing key and value pair
- Order can be set to depth or breadth first algorithms
- Max depth can be set to concrete number or to end of graph
- Relationships can be restricted too. We can set any combination of Relationship types and directions which should traversal include. The list of Relationship types is dynamically filled from database with existing values.
Traversal graph import dialog
This was the quick summary of Gephi Neo4j importing capabilities implemented in the project. We focused on more features and one of them is the support for exporting. We can export any loaded graph into local or remote Neo4j database. The exporting process can be customized in similar way as importing.
Exporting means opposite process to importing. Previous dialog shows exporting options as well as validation. We can customize exporting process by setting:
- From column is used to set the RelationshipType to appropriate values from any of Gephi edge columns. During importing Neo4j graph, column with name “Neo4j Relationship Type” is automatically created.
- Default value is used in the case when processed Gephi edge does not have value in selected From column
- Export Node columns is the set of Gephi columns in node table which will be exported
- Export Edge columns is the set of Gephi columns in edge table which will be exported
The only difference between local and remote importing/exporting is the existence of Remote dialog, where we need to set following connection information:
- Remote database URL
All of them must be filled in order to successfully import/export remote graph.
Remote import/export dialog
Nodes values exploration (click on the image to enlarge)
As we can see from previous picture, we can very simply explore all the node and edge values. This is exactly the place where delegating mechanism is used. All values are in fact not stored directly in memory in some kind of Gephi data structure, but the storing engine (Neo4j) is requested for actual values every time we need them.
We can see debugging in action in previous picture. The dialog is initialized with data from chosen debug class file, but we can change all of them at the runtime too. Any change in options will automatically update graph visualization. We can change visibility of nodes and edges as well as colors for both nodes and edges. User proceeds to next step of debugging/traversal by clicking on the Next button.
That was the quick summary of all implemented features and now we can summarize common use cases every user can be interested in.
Visualizing Neo4j graphs
One of the main ideas of my project was to implement the ability to visualize Neo4j graphs, even big ones. As we saw from the dialog pictures, we have many options how to customize the importing process including filtering. After the import we can use all the rich graph analysis features Gephi provides.
Analyzing only part of the whole graphs
Quite common use case is to analyze only part of the graph, which is possible in Gephi too. We can take advantage of traversing where we can set starting node and other traversal options. After that we can visualize and analyze only part of the graph.
Export graph stored in text files/databases into Neo4j
Another use case could be exporting graphs stored in graph text files or relational databases into Neo4j. In fact, every graph loaded into Gephi can be easily exported to Neo4j database. Importing formats depends on Gephi abilities themselves, currently following formats are supported:
- Text formats: GEXF, GDF, GML, GraphML, Pajek NET, GraphViz DOT, CSV, UCINET DL, Tulip TPL, XGMML
- Relational databases: MySQL, PostgreSQL, SQL Server
There are more things which we want to implement, including:
- support for Gephi Toolkit, which is in general set of Gephi core libraries which you can use in your own Java projects for graph visualization and manipulation
- implementing proof of concept Web application using both Gephi Toolkit & Neo4j to manipulate with Neo4j database & show results (probably using GWT)
- more features, bug fixing, performance optimizations
One of the big advantages of Gephi is the fact that it is developed as Open Source project. We want to add additional features according to user requests and their opinions. That’s why we created questionnaire focusing on usefulness of proposed additions. We will be very happy if you fill the questionnaire because it is very valuable source of information and we can focus on features Neo4j users think useful. Please fill in the questionnaire.
I am very happy that I can be part of the Gephi developer community and introduce integration with Neo4j. During this summer I learned a lot and I am proud that I was chosen as GSoC student. The fact is that none of these features can be done without great help of my mentors, so big thank to both of them: Mathieu Bastian & Tobias Ivarsson.
If you are interested in and want to test the code, you can download source codes from my branch using
bzr branch lp:~bujacik/gephi/support-for-neo4j
All the pictures were made on data stored in testing Neo4j database which can be created using Java SE project and you can download it using:
bzr branch lp:~bujacik/+junk/testing-new-neo4j-traversal-api
Download this article in PDF.
Announcement Community ~ gsoc neo4j
Annoucement! Gephi is adding a new GsoC proposal: Adding support for Neo4j in Gephi
Neo4j is an open-source graph database that scales to billions of nodes and relationships. The stable 1.0 version has been released in February this year and is widely appreciated for variety of problems where relational databases are unqualified. Neo4j is therefore part of the growing NoSQL movement and is getting a lot of attention.
There is huge interest of visualizing Neo4j graphs and Gephi is suited for this task due to its performance and modularity. With graph data in Neo4j and a nice plug-in, Gephi could deal to larger graphs and overcome the traditionnal memory limit.
Students can start present themselves and apply for this proposal. Mentoring will be done by both Neo4j and Gephi team members. Deadline is April 9 so there is still enough time!
The Gephi team is excited about collaborating with Neo4j community!