8. Recommendations and Analysis of Historical Data | 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

Analysis of the historical data

We have explored how to use the data model to enable a traveler to find what they need. With this data and some clever querying, we can also discover some trends that can help the businesses. Given we have the year, month, and day of bookings and hotel stays, we can venture into analyzing data and behavior patterns of individuals, and how it affects the businesses (hotels and airlines).

Querying to discover patterns

Bookings are not spread across the year evenly. There will always be months when the number of bookings made far exceeds the number of bookings during other months. The following query gives the number of bookings made for each month:

neo4j-sh (?)$ MATCH (booking:Booking)
WITH COLLECT(booking) AS bookings, booking
RETURN DISTINCT booking.month AS month, COUNT(bookings) AS num_of_bookings 
ORDER BY num_of_bookings DESC;

The output of the preceding query is as follows:

+-------------------------+
| month | num_of_bookings |
+-------------------------...

Search

Your notes and bookmarks