This tutorial uses Northwind, a sample dataset widely used in RDBMS. It is true that the Northwind dataset is mostly used for examples of relational data, but it can be used as examples of graph data as well. This dataset contains sales data of a fictitious company called Northwind Traders, an importer/exporter of specialty foods from/to the global market.
The goal of this tutorial is to give users guidance in how to load sample data into AgensGraph, query the loaded data, and/or extract the desired information.
In order to load and use data as guided in this tutorial, AgensGraph should be installed first. You can install/use AgensBrowser, a visualization tool, as well, for easier and quicker analysis of the sample data.
In general, there are two ways to load data into AgensGraph:
- Import dataset files into AgensGraph.
- Execute queries on AgensGraph to generate the data
This tutorial describes how to import a dataset file (CSV) into AgensGraph. If you want more information on how to generate data using queries, please visit Bitnine's website and read Basic Cypher and Advanced Cypher white papers. We provide the full version of this tutorial on our homepage so if you are interested, please click the link below to meet our tutorial. Thank you.
Contents of tutorial:
- Dataset Overview
- What is, and How to Generate Graph Model
- Export Dataset from RDB to CSV
- Import CSV to AgensGraph
- Querying Graph Data
- Updating Graph Data
- Notes
Northwind Data Basic Information
AgensGraph Developer's Manual
AgensGraph Operator's Manual
Data Import and FDW How-To