3 ms·
Yeah, we were doing that with intermediate nodes. So, Bob -worked_at-> Work node Work node -from-> date Work node -to-> date Work node -employer-> WB, Disney,
by mrjn 9y ago
Yeah, we were doing that with intermediate nodes. So,
Bob -worked_at-> Work node
Work node -from-> date
Work node -to-> date
Work node -employer-> WB, Disney, etc.
Then each instance of Bob working would be a node in the graph. Note that (and this might be counterintuitive) this is the same as how you'd represent marriage data as well.
These intermediate nodes are the only complexity that one has to think about in a graph model (even then it's not that complex compared to thinking through how 20 different tables are connected). Rest is easy peasy.
- pbowyer 9y agoThanks, going to have a go at re-sketching with intermediate nodes!