Graph Database In SQL Server

Kevin Feasel



Niko Neugebauer has started a new series, this time on graph database functionality in SQL Server 2017:

Graph databases are based on graph theory, and employ nodes, edges, and properties. The graph theory is the study of the graphs that are mathematical structures used to model pairwise relations between objects. A graph in this context is made up of nodes, edges which are connected by edges, arcs, or lines.
A graph can be directed or undirected (uni or bi-directional) that might point the direction of the relationship between the edges.
Graph databases can be compared to the Network Model Databases, that were focusing on solving the same problem the interconnected world.

The most popular graph database in the world currently is NEO4J, which is implemented in Java and is using CQL (Cypher Query Language), a language that has definitely inspired the SQL Graph T-SQL language extension.

Niko notes that this is not a fully mature product yet, but it’s an interesting start.

Related Posts

Plotting Graph Data In R

Sifiso Ndlovu shows how to take graph data from SQL Server and plot it in R using Machine Learning Services: However, with recent focus on big data for many of my clients, we have experienced an increase in different business requests that requires for many-to-many data modelling. Consequently, as a Microsoft shop we’ve had to […]

Read More

Naming Graph Edges

Greg Low is trying to find a common nomenclature for edges in graphs: Positive (Forward) Direction I’d also like to see the tables use a forward direction naming rather than reverse (like “Written By”). So perhaps: ($from_id) the member Wrote the post ($to_id) ($from_id) who Likes who/what ($to_id) ($from_id) the reply to the main post RepliesTo the main post ($to_id) Avoid […]

Read More


June 2017
« May Jul »