# ElasticSearch relational data

**URL:** <https://discuss.elastic.co/t/elasticsearch-relational-data/288387>\
**Category:** Elasticsearch\
**Created:** [November 4, 2021, 7:31am UTC](https://discuss.elastic.co/t/elasticsearch-relational-data/288387 "2021-11-04T07:31:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![muhammadahmad](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@muhammadahmad](https://discuss.elastic.co/u/muhammadahmad)\
**Post date:** [November 4, 2021, 7:31am UTC](https://discuss.elastic.co/t/elasticsearch-relational-data/288387/1 "2021-11-04T07:31:11Z")

</div>

Hello ,  
I need some help in managing following data,  
for example , I have five entities A, B, C, D ,E  
A has one to many relation with B,  
B has one to many relation with C,  
C has One to many relation with D,  
D has One to many relation E,  
The requirement is to Search A with the B,C,D,E all properties of the entities  
If i am creating an index of entity A,  
the document of index A have will have mappings like  
document A : { id of A, [B properties], [C properties], [D properties], [E properties]}  
now if there is an Update in B, C, D, E in database  
then there will be bulk update in A, which will be expensive call at real time  
As the data is very denormalized here.  
Can someone plz guide me how to handle this scenario

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 2, 2021, 7:32am UTC](https://discuss.elastic.co/t/elasticsearch-relational-data/288387/2 "2021-12-02T07:32:06Z")

</div>

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