Software to build networks visualization using relational tables

Question

I've an table in SQL Server with the following schema:

 - Partner_ID
 - Child_ID
 - Relationship_Name

Example of my data:

Partner_ID  Child_ID    Relationship_Name
A             A1            Normal
B             B1            Custom
B             B2            Custom
A1           AAA            Custom
B1           B1.1           Normal
B2            BBB           Normal

I want to draw a network visualization (like the charts that we can do using Gephi) using the table as input.

There exists any open source tool that allows me to make this implementation?

Many thanks!!!

Answer 1

You could do this in R:

# some newer libraries for dealing with networks
library(ggraph)
library(tidygraph)
theme_set(theme_void())

#read in data
txt <- read.table(text = "
Partner_ID Child_ID Relationship_Name
A A1 Normal
B B1 Custom
B B2 Custom
A1 AAA Custom
B1 B1.1 Normal
B2 BBB Normal", 
header=TRUE, sep=" ", stringsAsFactors = FALSE)

# table (data frame) to graph object
gr <- as_tbl_graph(txt)


#plot it
ggraph(gr,layout="nicely")+
        geom_edge_link(colour="blue",alpha=0.3)+
        geom_node_point()+
        geom_node_text(aes(label=name),size=4,repel=T)

Result: