I have a use case where I want to make search within the billions of records. I wanted to display that data on my UI. I know I can do with pagination, but the thing is the data is huge and we don't want to create any performance issue.
I am planning to use Elasticsearch with Java API but not sure how I can design. Please let me know if following solution will work
Read the data from Oracle database and provide to Elasticsearch engine using Java API. I don't want manually to start elastic engine. Is there any way where I can embedded that server in my project?
Write Elasticsearch client in Java code and make request for search. So search will happen on Elastic engine side and not the actual database.
Not sure how to implement this. Can someone guide me here? I did some research and I found the client code to make search request not the actual one which will make database hit and store in Elasticsearch engine in Java.