O'Reilly logo

Learning Neo4j 3.x - Second Edition by Rik Van Bruggen, Jérôme Baton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introducing complexity through join tables

Let's take the model, which was described previously, to the database administrator for an actual implementation. What happens then is that, in this implementation, the relational model inherently causes complexity. What you can see in the following diagram is that, for every relationship where we can have n-n combinations, we actually need to introduce something that links the two tables together.

This is what we call a join table, and this will be used by every query that requests a combination of the n-n entities:

 The database schema

In the previous example, we introduced the AppDatabase table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required