Chapter 11
SQL Graph
The SQL Graph feature provides an alternative way to model and query your data compared to traditional modeling and querying. It was introduced in SQL Server 2017 and later further enhanced. The modeling part involves using specialized node and edge tables to store the data, with the nodes representing the vertices of the graph and the edges connecting pairs of nodes. The querying part involves a specialized syntax in which you list the objects involved and use a MATCH clause to indicate how they connect.
If you are considering a graph-based design, I recommend reading this chapter very carefully. You need to understand the pros and cons compared to the traditional design, and make a decision whether the pros justify the ...
Get T-SQL Fundamentals, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.