I'm still pretty novice in regards to Elasticsearch. Currently in our sql server database, we are creating "connections" between a certain entity. For example we have a person table, and we have another table called personConnection, which has 2 foreign keys to the person table. Each entry will "connect" the users together.
So my question is what is the best way to model this in Elasticsearch while minimizing complexity on updating records. Originally I was creating the person document that contained a list of connections which basically stored the id of the other person it was connected to (and some other metadata).
Doing this is it easily do-able to query the connections to see if i'm connected to a search of "joe" instead of the id of 5?
Let me know if this doesn't make sense,