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

Extracting airport information from flights

There are multiple steps involved in making the successful transition from airports being properties of flights to airports being an entity connected to the city they are located in.

To start with, let's create a constraint so that an airport can be uniquely identified by its code. The query is as follows:

neo4j-sh (?)$ CREATE CONSTRAINT ON (airport:Airport) ASSERT airport.code IS UNIQUE;

The output of the preceding query is as follows:

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

Breaking airports out as a node

The next step is to break out the source_airport_code and destination_airport_code properties into nodes. After this change, the :HAS_FLIGHT and :FLYING_TO relationships will connect :Flight and :Airport rather than :Flight and :City, as shown:

Figure 5.3: Airports and flights—current and future models

In Figure 5.3, the relationships depicted with the dotted line exist currently. Relationships shown with...

Search

Your notes and bookmarks