Advanced MATCH queries

In this section, you will see the power of the MATCH clause in more detail. Queries will be issued in a SQL Server 2017 instance of the Internet Movie Database (IMDb). The entirety of IMDb's datasets are available in TSV format at https://datasets.imdbws.com. Here is a sample data model of this graph database:

Simplified data model of the IMDb graph database

For the purpose of this example, I have created three node and two edge tables. Here is the code to create tables and indexes:

CREATE SCHEMA graphGO--node table MovieCREATE TABLE graph.Movie(Id INT NOT NULL,Name NVARCHAR(300) NOT NULL,ReleaseYear INT NULL,CONSTRAINT ...

Get SQL Server 2017 Developer's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.