I’m looking for insight on the best way to solve a metadata-over-time problem.
Image a graph where you have VMs and Hosts. VMs run on a host… but over time, the VMs move between hosts.
We need to be able to show which host a VM was running on at a specific time. In my ideal world, I could put tuples of
[startTime, endTime] as a facet (edge attribute) on the relationship, however dgraph only supports scalar type facets.
As a workaround, we’ve tried adding multiple of the same relationships (with different facets) however it appears dgraph updates the existing relationship rather than make a new one.
Another idea we had was placing an intermediary node to act as a “relationship” that could hold more information, but that became pretty nasty to query against.
Are there any patterns for “temporally aware” graphs?