Its been a couple of weeks since my last post, and I’ve been experimenting more with graph databases. One of the more common graph database examples explores the relationship between air traffic carriers, and their routes. The nodes are the various cities that carriers fly between, routes are the edges connecting the nodes, and the …
Here we are at the last part for this series. To recap, in the first 2.5 parts of this series (part 1, part 2, part 2.5) I focused on setting up a graph database in SQL Server, and querying the metadata to discover the nodes and edges that define the structure of the graph. In the …
The first 2.5 parts of this series (part 1, part 2, part 2.5) focused on setting up a graph database in SQL Server, and querying the metadata to discover the nodes and edges that define the structure of the graph. In this part, we shift over to R and imbed the SQL Server cursor script …
Quick post tonight. While working on some examples to test out the cursor I posted in Part 2, I realized that I had only coded the cursor to retrieve information for the dbo schema. So here I present the revised cursor which pulls from any schema. If a table is part of the dbo schema …
This is part two of a series about diagramming SQL Server graph databases in R. In the first part, I covered setting up a simple graph database in SQL Server, with just a handful of tables to use as a test bed for this series. The database had one edge (enrolledIn). I have revised the …
Welcome to the first of several articles covering generating diagrams in R of Microsoft SQL Server graph databases. A little theoretical background is in order before diving into the mechanics. In relational databases, tables typically connect or join based on a unique value in one table to another table where the same value may appear …