Hi all. I'm fairly new to Neo4j, but am very much enjoying figuring it all out. I was hoping for a little guidance on my use case.
I'm storing the source of information as properties in relationships between nodes. Take the following relationship for example: "(company)-[EMPLOYS]->(person)." I would create a relationship property with the information source and a timestamp for when it was gathered. This all works well and is intuitive, at least to me, from a information design perspective.
The challenge is that if multiple information sources confirm the same thing, I would like to store those multiple information sources and their respective timestamps in the relationship properties. I suspect I could use an array of JSON to do this, but will it be possible to query/update that information? For example, I'd like to be able to return matches with multiple information sources and also to check/update the timestamps for specific information sources.
Is an array of JSON the best way to do this? If so, how might I go about using that in future queries/updates?
Any advice would be much appreciated!