I am creating a database that maps relationships between entities. These relationships change over time.
For example, methane emissions are responsible for x% of greenhouse gas emissions in 2017 and y% of greenhouse gas emissions in 2018.
Without taking time into account, it could look something like this:
I do however, want to track changes over time. My preference would be to link a relationship to a node, but this is not possible. I have two ideas in my mind.
The first is to simply create multiple relationships between the two entities, one for each year that I'm tracking:
The other is to create a proper time tree and make a node for each year, like so:
I'm not really sure which one to pick (or whether there is another, more sensible alternative). I tend to like the latter option with the intermediate node a little bit better, but it also introduces complexity that the simpler solution avoids.
Most articles on this topic are about nodes that are connected to a time tree, in which case it's fairly straightforward. Here it's the relationship that should be connected to the time tree, but that's not possible.