Flights Search Application GRANDstack Experimental Implementation

Solution structure

/cql

Cypher queries

/data

Original .csv files from openflights.org

/generator

Dotnet core C# console application to generate .csv files of nodes and relationships to import to flights.db

/grand-stack-app

/api (Apollo GraphQL API)

/ui (React App)

/neo4j (Not used Docker file for blank Neo4j)

/neo4j-apoc-algo-graphql

Docker Image with APOC, Algorithms and GraphQL plugins based on neo4j official image

neo4j.conf (Configuration file used for Neo4j)

/neo4j-flights

Docker Image neo4j-flights with flights.db based on neo4j-apoc-algo-graphql

import.sh (Extention script executed to import data create flights.db)

/import (Files .csv with flights.db ready to import Nodes and Relationships)

Domain

Project provides a set of tools to solve real world problem of flights search for all possible routes in between 2 locations such as cities/airports.

Database Schema

Project based on the original idea of Max De Marzi of graph database POC.

Architecture

Project is build with using GRANDstack framework and special Docker image with original flights database with predefined imported data.

Neo4j

Approach with neo4j-admin import tool used to prepare flights.db data.