Elasticsearch | Relationship based Index

(Nikesh) #1

Hi,

I need to provide One-to-Many relationships in my index.
example: Team and its players.
Both of the above would contain similar fields.
There would be constant updations or inclusion on new players to existing team.
What is the most suitable method to store this type of data structure?
Please note, Players are part of Team. So any search matched in any of the players would be considered as a match in Team.

Elasticsearch | Relationships based index
Elasticsearch | Relationships based index
(David Pilato) #2

Elasticsearch is not a relation system although you can use the join feature.

But, let's talk about the use case first.
What are your users going to search for? Players? Teams? Both? Note that a team and a player are not identical objects.
What are the typical questions they want to ask to the system? Which attributes do they need to search for Players (or Teams)?

(Nikesh) #3

Users can search on either Players or Teams or on both.
Let's assume player and teams are identical objects

(David Pilato) #4

Users can search on either Players or Teams or on both.

Which means that users will see both results all merged, with sometimes players, sometimes teams mixed in the same page result.

You did not answer to this question though:

What are the typical questions they want to ask to the system? Which attributes do they need to search for Players (or Teams)?

(system) closed #5

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