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
Last activity: Nov 6, 2020, 07:23 AM