How to go about designing the schema for the following spec
Places are represented as Nodes with the relationship between each node being the path from one place to another. And the path has its properties like Name, number of nodes , Number of travelers etc.
Is it wise to store these relationships with their own properties as facets or create a separate node called as Path and map them to each Node.
My doubts are
- If the Path is stored as a facet wouldn’t make it repetitive to keep storing the properties for each Node->Node relation?
- If the Path is stored as separate node, then how to maintain the chain in order to be able to query all the nodes in the path in a serial order