Skip to content

neo4j-graph-examples/northwind

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

52 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

northwind logo

Northwind Graph Example

Description: From RDBMS to Graph, using a classic retail dataset

model
Figure 1. Model
example
Figure 2. Example
Example Query:
MATCH (p:Product)-[:PART_OF]->(:Category)-[:PARENT*0..]->
(:Category {categoryName:$category})
 RETURN p.productName as product

Setup

This is for Neo4j version: 3.5,4.0

The database is also available on https://demo.neo4jlabs.com:7473

Username "northwind", password: "northwind", database: "northwind"

Rendered guide available via: :play https://guides.neo4j.com/northwind/index.html

Load graph data via the following:

Data files: import/*.csv

Import flat files (csv, json, etc) using Cypher’s LOAD CSV, APOC library, or other methods.

Dump file: data/northwind-40.dump

  • Drop the file into the Files section of a project in Neo4j Desktop. Then choose the option to Create new DBMS from dump option from the file options.

  • Use the neo4j-admin tool to load data from the command line with the command below.

bin/neo4j-admin load --from data/northwind-40.dump [--database "database"]

Data load script: scripts/northwind.cypher

bin/cypher-shell -u neo4j -p "password" -f scripts/northwind.cypher [-d "database"]

Or import in Neo4j Browser by dragging or pasting the content of scripts/northwind.cypher.

Code Examples

Feedback

Feel free to submit issues or pull requests for improvement on this repository.