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

Modeling airports and hotels

To be able to show only those hotels that are located at the airport through which the traveler is transiting, we need to model airports. Currently, airports are a part of the flight information, and this needs to change. We will extract airport information (that is, airport_code) into a separate node labeled :Airport, as shown in Figure 5.1. The property code will act as a unique identifier for an airport.

Figure 5.1: Airports and hotels

Hotels will be modeled with their name and the price. Since prices should be comparable, storing them as a number would be beneficial. Considering hotel chains have similar or same names for each class of hotel that that they own, it would be good to have an ID on the hotels.

Note

The currency in which the price is expressed should be a application concern and should not be spread across data and application. Ideally, a standard currency (for example, USD or EUR) would be used to express the price, and the conversion to local currency...

Search

Your notes and bookmarks