NEO4J example script
This excercise was created from FIAP - MBA - Solution Architect
#####Create Social Network Node##### CREATE (Facebook:SocialNetwork { name:'Facebook'}) CREATE (Twitter:SocialNetwork { name:'Twitter'})
= SQL --> Neo4j | |
The main goal is to be able to import data from SQL (or similar RDBMS) into Neo4j, while maintaining Foreign Keys as relationships, using Cypher. The reason behind using cypher vs. the batch importer is because I want to build a system that allows for multiple imports and updates without having to batch process it. | |
//console | |
= Table Structure Requirements: | |
1. Primary Key column names should use the pattern [TableName]+Id, so for a Contact table, the primary key field should be names ContactId. This is to prevent overlap of Node Labels. |
For the past couple of years, I have been preaching the Neo4j gospel in many different places, meetups, conferences, and what have you. For the most part, I have been using a very specific demo that has been super well-received: The Belgian Beer Graph. It started out as a learning experience for me personally back in the day when Neo4j did not have any proper data import functionality - and I had to load the graph by jumping through all kinds of hoops.
And now: we can play this demo straight into the Neo4j browser. Such JOY!