1

Creating a Neo4j Example Graph with the Arrows Tool

Posted by Michael Hunger on Mar 21, 2017 in cypher, import

Some years ago my colleague Alistair Jones created a neat little tool in JavaScript to edit and render example graphs in a consistent way.

It is aptly named Arrows and you can find it here: http://www.apcjones.com/arrows

We mostly use it for presentations, but also to show data models for Neo4j GraphGists and Neo4j Browser Guides.
Because it also [...]

 
0

Academy Awards (Oscars) from Kaggle to Neo4j

Posted by Michael Hunger on Mar 9, 2017 in cypher, import, neo4j

pre {
font-style:normal;
font-size:75%;
line-height: normal;
}
table {
margin: 10px;
}
th, td {
border-bottom: 1px solid black;
}
th {
background-color: #ddd;
}
img {
max-width:100%;
}

Table of Contents

Install Neo4j
Find the data as CSV
Importing the Data
Some Fun Queries
Part 2: Full Import from Kaggle
More Queries

Most Oscars
Most different Awards
Which Countries got the most [...]

 
1

5 Tips & Tricks for Fast Batched Updates of Graph Structures with Neo4j and Cypher

Posted by Michael Hunger on Mar 2, 2017 in Uncategorized, cypher, import, neo4j

Inefficient Solutions
Better Approach

UNWIND to the Rescue
Overall Syntax Structure

Examples

Create node with properties
MERGE node with properties
Node lookup and MERGE/CREATE relationship between with properties
Lookup by id, or even list of ids

Faster, Better, Further: All the tricks

Update of existing nodes by id
Update of existing relationships by id

Conditional Data Creation
Utilizing APOC Procedures

Creating Nodes and Relationships dynamically
Batched Transactions
Creating / Updating Maps [...]

 
0

The Reddit Meme Graph with Neo4j

Posted by Michael Hunger on Feb 25, 2017 in cypher, import

pre {
font-style:normal;
font-size:75%;
line-height: normal;
}
img {
max-width:100%;
}

Saturday night after not enough drinks, I came across these tweets by @LeFloatingGhost.

This definitely looks like a meme graph.

We can do that too

Tags:

 
6

How To: Neo4j Data Import – Minimal Example

Posted by Michael Hunger on Apr 18, 2015 in import, neo4j

We want to import data into Neo4j, there are too many resources with a lot of information which makes it confusing.
Here is the minimal thing you need to know.

Imagine the data coming from the export of a relational or legacy system, just plain CSV files without headers (this time).

people.csv

1,”John”
10,”Jane”
234,”Fred”
4893,”Mark”
234943,”Anne”

friendships.csv

1,234
10,4893
234,1
4893,234943
234943,234
234943,1

Graph Model

Our graph Model would be very [...]

 
5

LOAD CSV with SUCCESS

Posted by Michael Hunger on Oct 18, 2014 in cypher, import, neo4j

pre { word-wrap: normal; white-space:pre; overflow-x:scroll; }

I have to admit that using our LOAD CSV facility is trickier than you and I would expect.
Several people ran into issues that they could not solve on their own.

My first blog post on LOAD CSV is still valid in it own right, and contains important aspects that I [...]

 
5

Flexible Neo4j Batch Import with Groovy

Posted by Michael Hunger on Oct 9, 2014 in import, neo4j

You might have data as CSV files to create nodes and relationships from in your Neo4j Graph Database.
It might be a lot of data, like many tens of million lines.
Too much for LOAD CSV to handle transactionally.

Usually you can just fire up my batch-importer and prepare node and relationship files that adhere to its input [...]

 
30

LOAD CSV into Neo4j quickly and successfully

Posted by Michael Hunger on Jun 25, 2014 in cypher, import

Note

You can also read an interactive and live version of this blog post as a Neo4j GraphGist.

Since version 2.1 Neo4j provides out-of-the box support for CSV ingestion. The LOAD CSV command that was added to the Cypher Query language is a versatile and powerful ETL tool.
It allows you to ingest CSV data from any URL [...]

Copyright © 2007-2017 Better Software Development All rights reserved.
Multi v1.4.5 a child of the Desk Mess Mirrored v1.4.6 theme from BuyNowShop.com.