5. Refactoring the Data Model | Neo4j Graph Data Modelling

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Neo4j Graph Data Modelling

By : Mahesh K Lal

3 (1)

Neo4j Graph Data Modelling

3 (1)

By: Mahesh K Lal

Overview of this book

If you are a developer who wants to understand the fundamentals of modeling data in Neo4j and how it can be used to model full-fledged applications, then this book is for you. Some understanding of domain modeling may be advantageous but is not essential.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Graphs Are Everywhere

1. Graphs Are Everywhere

Graphs in mathematics

The property graph model

Storage – native graph storage versus non-native graph storage

Reasons to use graph databases

What to use a graph database for

Choosing Neo4j for exploring graph databases

The structure of the book

Summary

2. Modeling Flights and Cities

2. Modeling Flights and Cities

Graphs are more than social

Designing a system to get a travel itinerary

Introduction to modeling nodes and relationships

Using Cypher to operate on Neo4j

Creating cities in Neo4j

Indices

Adding flights to Neo4j

Traversing relationships

Summary

3. Formulating an Itinerary

3. Formulating an Itinerary

Creating an itinerary from flights and cities

Business logic should lie in code

Summary

4. Modeling Bookings and Users

4. Modeling Bookings and Users

Building a data model for booking flights

A simple model of the bookings ecosystem

Modeling bookings in an RDBMS

Creating bookings and users in Neo4j

Queries to find journeys and bookings

Queries to find the booking history of a user

Summary

5. Refactoring the Data Model

5. Refactoring the Data Model

Capturing information about hotels at airports

Modeling airports and hotels

Extracting airport information from flights

Reasons for not migrating using a single query

Adding hotels to airports

Fetching hotels

Summary

6. Modeling Communication Chains

6. Modeling Communication Chains

Capturing traveler reviews for hotels

A model for reviews and comments

Adding reviews to Neo4j

Adding comments to Neo4j

Summary

7. Modeling Access Control

7. Modeling Access Control

Controlling access for content change

Modeling hierarchies

Modeling access control groups and employees

Querying the data model to find what is accessible to an employee

Summary

8. Recommendations and Analysis of Historical Data

8. Recommendations and Analysis of Historical Data

Recommending cities to travelers

Recommending hotels to travelers

Analysis of the historical data

Summary

9. Wrapping Up

9. Wrapping Up

There is no correct model

Further reading and exploration

What to watch out for while using Neo4j

Index

Index

Customer Reviews

3 (1)

5 star

0

4 star

0

3 star

100%

2 star

0

1 star

0

Adding hotels to airports

Now that we have airports as nodes, we can add hotels to our data model. As discussed earlier, hotels have an ID, name, and average price.

Let's start by adding a constraint on the ID of the hotel, which is the _id property, as shown:

neo4j-sh (?)$ CREATE CONSTRAINT ON (hotel:Hotel) ASSERT hotel._id IS UNIQUE;

The output of the preceding query is as shown:

+-------------------+
| No data returned. |
+-------------------+
Constraints added: 1

We can add a hotel and connect it to the JFK airport using the following query:

neo4j-sh (?)$ CREATE (hotel:Hotel {_id:"6ad8ce6e-1c0e-11e5-8db1-6c40089a9424",  name:"Hilton", price: 180})
WITH hotel
MATCH (airport:Airport{code:"JFK"})
WITH airport, hotel
MERGE (airport)-[:HAS_HOTEL]->(hotel)
RETURN airport, hotel;

The output of the preceding query is as follows:

Figure 5.8: Airport hotels

Note

We can add more hotels from the hotels.cqy file that can be downloaded along with the code for this chapter.

Search

Your notes and bookmarks