I have 2 indices. These 2 indices are kind of related to one another.
For example, lets say, the 1st index contains all information pertaining to an e-book. Information like author, published date, title etc. will be indexed here.
And the 2nd index contains all paragraphs within a book. Information like book id, para content, page number, complex object information etc. will be indexed here.
When I want to query for paragraphs from the 2nd index based on the 1st index information like book title or published data, how do I do that?
- Is it advisable to store all the meta information of the 1st index inside the 2nd index to apply filters and query its documents. In this way I'll be needlessly bloating up the 2nd index with duplicate information which I already have in the 1st index.
- Is there a way I can form a relationship between these indices?
- Is it possible to maintain a single index for my case? Like storing all the paragraph related information in the 1st index itself as a list of objects. In this case, every document in the 1st index will be huge (lets say a list 10000 paragraphs indexed or more) and will it be efficient while performing the querying operation?
Or is there any other way I can solve this?
Any help, much appreciated.