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.