Self Relationship - Add Update Delete

Hi i have a document type "artefact" (fields like name, type, author,usage etc.) this artefact can be referenced by other artefacts and also contain references of other artefacts.

What is the best way to depict such relationships. Should we just store the ids of the linked document or in denormalized form. What is the recommended strategy for such requirements in Elastic. Should there be separate collection to store such relationship Iike hashmap etc.)

For search queries that we receive from front-end application. We may need to pass extrainformation for the references such as (name,author etc.). Would we be required to execute multiple queries to handle this situation as well as delete operation. Please throw some light on this.

Just an after thought - should relations be stored separately in a table (relational or non-relational) for such use cases??

thanks,
Aakash

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