Storing a graph of data in an index


(Matthew Hartz) #1

Hi,

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,

Thanks!


(Mark Walkom) #2

You can do this sort of structure then build the graph with our Graph plugin :slight_smile:


(Matthew Hartz) #3

:slight_smile: Unfortunately I'm running on the free license atm and the trial expired. For this type of structure do i need to make sure i'm using parent_child mappings?

Thanks!


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.