What are the options for relational relationships between documents in different indexes?

Question

elasticsearch

For example, there is such a data structure (almost from a lantern, but reflects the essence):

Call

• Duration
  
• City
  
• Customer
  
• Company
  

Customer

• Good
  
• Bad
  

Company

• We are friends with her
  
• We are not friends with her.
  

Actually, you need to understand in what form it is stored in elastic.

Of course, the client and the company can change their properties and you need to either trigger and change objects in all calls (if you store a copy of the client / company in the form of an object for each call), or some kind of join (which seems to be only one allowed in mapping). Well, of course, you need to look for calls taking into account some properties of the client / company.

I ask for help, how to map such structures?

Answer 1

There is no relation (disclaimer: practically) in Elasticsearch, these are very costly operations and therefore lose all meaning, everything that was taught in relational subds (normalization) must be forgotten when working with NoSQL and work in a new way (denormalization and redundancy).