Spring elasticsearch : create index for each user

Question

I am building an application using Spring boot and elasticsearch (& spring-data-elasticsearch).

I have an entity User that contains a list of regions (i.e each user is responsible for a set of regions).

I have another entity Report that is associated to region (i.e each report has a region)

I want to create indices of report for each user. So that each index contains only the reports of the regions that the user is responsible for.

In this way, when the user search for a report, the search is applied only in his index.

Besides, these indices has to be dynamic (i.e updates if the regions of the user are changed, or new reports are added).

How can I achieve this? Thank you for your help

Could you share which direction did you take? – Daniel Birowsky Popeski May 16 '20 at 12:29 — Daniel Birowsky Popeski, May 16 '20 at 12:29

score 0 · Answer 1 · answered Jun 07 '18 at 14:20

why don't you model user in such way such that user-related information is stored in a row(document), I think nested fields is a good idea, and they can be searched using the nested query so,

for example, each user is responsible for a set of regions so regions can be nested in user since regions are nested they will be stored as a separate document

@Field(type=FieldType.Nested)
private Set<Regions> regions;

secondly, I don't think building a new index every time is a good idea

Could you please elaborate why creating separate index for each user would be a bad idea? Thanx! — Daniel Birowsky Popeski, May 16 '20 at 12:30

Spring elasticsearch : create index for each user

1 Answers1