Which is the best way to index the data from relational database table of One to many relationship
Clash Royale CLAN TAG #URR8PPP Which is the best way to index the data from relational database table of One to many relationship Can you please let me know which is the best way to index the records in elastic search for my scenario. My Scenario is : 1) Need to index around 40 million records from oracle table which has entries having one to many relationship records. And the uniqueness of the records is based on the composite key with 4 columns 2) After indexing , Search should support "full text search" on all the fields 3) Filters and sorting on selected fields needs to be supported. After going through the official documentation i found couple of options , but want to know which approach would be most useful among below 1) For each record in table create a entry in the elastic index 2) Create a nested json object based on the composite key and then add this elastic index 3)Parent child Relationship mechanism and application side joins are not suitable for my scenario Tha...