Indexing a document

Elastic Stack Elasticsearch
1

Hi

I am new to Elasticsearch.

We are planning to a database that has the following columns.

[USER-ID USER-NAME GROUP PARENT-GROUP GROUP-JOIN-DATE]

The database would have billions of entries. An user belonging to a particular group may have multiple parent group. A parent group decides which specific group a user could be part of. For example A user needs to be part of either Student or Employee group to be part CanteenAccount group.

Is there any way we can do the following?

  • Index the document using different fields
    For example, To query all groups a user belongs to, To query all group hierarchy of an user, To retrieve
    all users joining after a date

    Could we rearrange the documents to satisfy my queries such as arrange in the order of USER-NAME
    so that "To query all groups a user belongs to" could be retrieved quickly. Similarly arrange in the order
    of GROUP and PARENT-GROUP to satisfy "To query all group hierarchy of an user" quickly.

Thanks

2

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