Create AT&T Network Hierarchy Diagrams using SQL Server Data

Question

Post reply

Create AT&T Network Hierarchy Diagrams using SQL Server Data

Paul Brewer

SSCrazy

Points: 2955
More actions
September 3, 2018 at 11:46 pm

#367708

Comments posted to this topic are about the item Create AT&T Network Hierarchy Diagrams using SQL Server Data

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ildjarn.is.dead Ten Centuries Points: 1167 More actions · Answer 1

Gnome mapping in wet lab environments

I assume genomes were mapped, not gnomes...

Paul Brewer SSCrazy Points: 2955 More actions · Answer 2

Is that how you spell it? I've no idea about chemistry but love some of the R packages their community are developing!

Paulo A. Nascimento SSCommitted Points: 1717 More actions · Answer 3

Hi there,

In your opinion what would be the advantage of this R approach compared to, say, direct graph visualization with GraphViz dot command, example:
digraph STG
{
   "Kirk" -> "Scotty"
   "Scotty" -> "Spock"
   "Spock" -> "Kirk"
}

Paul Brewer SSCrazy Points: 2955 More actions · Answer 4

I think the advantage is in situations where nodes have multiple edges. In the article there is a CTE that generates a network hierarchy, each node has three edges to other nodes. I suspect GraphViz can manage this too but many applications and packages can’t.

Paulo A. Nascimento SSCommitted Points: 1717 More actions · Answer 5

Paulo A. Nascimento

SSCommitted

Points: 1717

September 4, 2018 at 8:04 am

#2004352

Thanks for your comment Paul.

suparSteve SSC Enthusiast Points: 193 More actions · Answer 6

Had some trouble getting this to work in RStudio, wouldn't install the packages as in the commented section. This worked though:

source("https://bioconductor.org/biocLite.R")
biocLite()
biocLite("graph")
#biocLite("graphNEL") <- didn't work, fails but apparently wasn't needed, code runs w/out it
biocLite("Rgraphviz")

Nice post, thanks for the tips on graph viz tools.

Paul Brewer SSCrazy Points: 2955 More actions · Answer 7

Thanks for the feedback, I’ll update the comments section in the next release with this.

Create AT&T Network Hierarchy Diagrams using SQL Server Data

Cookies on SQLServerCentral