Sample Header Ad - 728x90

Graph Database - data modelling - linking multiple pairs of nodes using the same edge?

-1 votes
2 answers
504 views
I am trying understand the concepts, which apply to data modeling using Graphs - specifically on SQL Server 2019. One thing I am unsure of is can the same edge be used to connect different pairs of nodes: - If I have three nodes PowerBI, SSAS, SQL Server - The in the pipeline i am trying to model there are two 'Connects To' relationships: Power BI -> SSAS -> SQL Server - Can I use a single edge 'Connects To' to store the relationship between Power BI -> SSAS and also the relationship between SSAS -> SQL Server or should these be two separate edges? Previously, have worked on both OLTP and OLAP databases. However, there seems to be a much smaller body of knowledge on best practices for developing data models using graphs.
Asked by Soap (11 rep)
Dec 6, 2019, 05:51 AM
Last activity: Nov 6, 2020, 07:23 AM