I am building an application which has to show data from the legal industry (e.g. laws, verdicts etc). The data is characterized by having many relations/links. E.g., paragraphs x in law y refers to other paragraph z in law w etc.
My first idea was to combine a relational database (RD)(postresql) with elasticsearch. The RD is then supposed to be the primary data source and elasticsearch is used for text search. The RD data is denormalized and migrated to elasticsearch. From the Elastic search results I retrieve the lnked data from the RD and pass that to the frontend. The reason for this design is that I find it a bit cumbersome to handle the relations in elastic (parent/child).
My questions are (I am a newbie):
- Is my current design (combination of RD and elastic) a common/clever approach?
- If I was to do it in Elastic only would parent child be the way to go ?