GraphAcademy
Module 1

Filtering Queries

Module overview

There are many ways that you can query a subset or subgraph of the data in the graph.

In this module, you will:

  • Review basic query filtering.
  • Evaluate strings in your query filtering.
  • Retrieve data using Full definition for pattern (opens in a new tab)A graph structure written in Cypher, such as a node joined to another node by a relationship. in the graph.
  • Learn how to specify multiple or optional MATCH clauses.

Data model for this course

This course uses the movie dataset for all the queries you will be running and writing. This is the same dataset that will be used for the application development courses in GraphAcademy.

Here is the Full definition for data model (opens in a new tab)The labels, relationship types and properties chosen to represent a domain.:

Movie Data Model

You can view the data model in the sandbox to the right by executing this query:

cypher
CALL db.schema.visualization()

The Full definition for node (opens in a new tab)A vertex in a graph. In a property graph it can carry labels and properties. Full definition for label (opens in a new tab)A tag on a node that groups it with other nodes of the same kind. A node can carry more than one. for the graph include:

  • Person
  • Actor
  • Director
  • Movie
  • Genre
  • User

The Full definition for relationship (opens in a new tab)A named, directed connection between two nodes. Every relationship has a type, a start node and an end node. for the graph include:

Also notice that the nodes have a number of properties, along with the type of data that will be used for each property. It is important that you understand the property types defined in the data model.

You can view the property types for nodes in the graph by executing this query:

cypher
CALL db.schema.nodeTypeProperties()

You can view the property types for relationships in the graph by executing this query:

cypher
CALL db.schema.relTypeProperties()

Each node with a given label has a property that uniquely identifies the node. These nodes are indexed in the graph.

  • Movie nodes use movieId.
  • Person nodes use tmdbId.
  • User nodes use userId.
  • Genre nodes use name.

You can view the uniqueness Full definition for constraint (opens in a new tab)A rule the database enforces on every node or relationship with a given label or type, rejecting any write that breaks it. indexes in the graph by executing this query:

cypher
SHOW CONSTRAINTS

Resources

During this course, you can refer to:

Ready, let's go! →