I am a newbie to elasticsearch. I am planning to use elasticsearch for just
search and leave oracle DB to hold the canonical data.
Requirement : To provide search functionality on the 'application forms'
submitted to our system. Our 'application forms' can have many 'items'
associated with it (one to many).
We have to provide 2 searches, one that fetches 'application form' level
data and the other fetches 'item' level data. Both will have similar search
I can create 2 indices with different json document structure. First index
will have the 'application form' as the parent and all 'items' as its child
(similar to its canonical structure), Second index will reverse the
hierarchy and have 'item' as the parent and all the 'application form'
attributes associated to it.
Data is duplicated in 2 indices.
Create one index similar to canonical structure and support both the search
*Cons : *
I have to write code to process and massage the data for returning the
results at 'item' level.
- Which option is preferable and why.
- Is there a better solution to handle this scenario.
- If I opt for option 1 - do I need to create 2 JDBC river component to
update data in both the elasticsearch indices.
should I write one JDBC river component and update both the indices.
Appreciate your inputs.
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to email@example.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/92702ef1-4fd1-45a6-a4b2-eb0cbd8c3aad%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.