4. Modeling Bookings and Users | 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

Modeling bookings in an RDBMS

To model data shown in Figure 4.1 in an RDBMS, we will have to create tables for bookings, journeys, passengers, and users. In the previous model, we have intentionally added booking_id to Journeys and user_id to Bookings. In an RDBMS, these will be used as foreign keys.

We also need an additional table Bookings_Passengers_Relationships so that we can depict the many relationships between Bookings and Passengers. The multiple relationships between Bookings and Passengers help us to ensure that we capture passenger details for two purposes. The first is that a user can have a master list of travelers they have travelled with and the second use is to ensure that all the journeys taken by a person can be fetched when the passenger logs into their account or creates an account in the future.

Note

We are naming the foreign key references with a prefix fk_ in adherence to the popular convention.

Figure 4.2: Modeling bookings in an RDBMS

In an RDBMS, every record is a representation...

Search

Your notes and bookmarks