Method and system for scalable search using microservice and cloud based search with records indexes

A system for searching for information maintained in a relational database platform, the system comprising:

• a relational database platform configured to store a plurality of records containing a plurality of attributes;
• a cloud-based non-relational database platform configured to store a plurality of index instances, each of the plurality of index instances corresponding to one of the plurality of records and containing a subset of attributes from a total number of attributes for each of the plurality of record, wherein the subset of attributes includes a plurality of search attributes and a plurality of search summary attributes;
• a backend processor configured to extract the subset of attributes from each record in the relational database;
• and
• a microservice residing in the cloud configured to create in the cloud-based non-relational database platform the plurality of index instances;
• wherein in response to receiving a search request that includes one or more search attributes, the backend processor causes the microservice to search the index instances in the cloud-based non-relational database platform for corresponding records in the relational database;
• and
• the microservice provides search results that include information from corresponding records in the relational database, wherein the information is associated with the plurality of search summary attributes.

A method for searching for information maintained in a relational database, the method comprising:

• creating in a non-relational database in a cloud-based search platform an index instance corresponding to each record in the relational database, wherein each index instance in the non-relational database includes a subset of identified attributes from attributes for each record, each index instance indexed to a corresponding record in the relational database;
• receiving a search request for the relational database, the search request including one or more attributes from the subset of identified attributes;
• redirecting the search request to the non-relational database;
• performing a search in the non-relational database based on the attributes included in the search request;
• and
• returning a search results summary from the search in the non-relational database,
• wherein the search results summary includes record IDs and attributes for one or more index instances corresponding to one or more records in the relational database.