Method And System For Scalable Search Using MicroService And Cloud Based Search With Records Indexes

Abstract

A method for searching for information in a relational database includes: identifying a subset of attributes from attributes for each record in the relational database, the subset of attributes including a plurality of search attributes and a plurality of search summary attributes; extracting, via a processor, the subset of identified attributes from each record; creating in a cloud-based non-relational database platform an index instance corresponding to each record in the relational database, wherein each index instance in the cloud-based non-relational database includes the subset of identified attributes indexed to a corresponding record in the relational database; and in response to receiving a search request that includes one or more search attributes, searching the index instances in the cloud-based non-relational database for corresponding records in the relational database; and providing search results that include information from the corresponding records in the relational database, wherein the information is associated with the plurality of search summary attributes.

What is claimed is: 
     
         1 . A method, comprising:
 receiving, by a processing system including a processor, a search query directed to a relational database, wherein the search query includes one or more search attributes from records in the relational database;   verifying, by the processing system, that the one or more search attributes are included in an index instance in a cloud-based non-relational database;   reformatting, by the processing system, the search query as instructions recognized by an application programming interface of a cloud-based microservice;   submitting, by the processing system, the instructions to the application programming interface to cause the microservice to search the index instance in the cloud-based non-relational database for corresponding records in the relational database, wherein the searching the index instance is responsive to determining that a first group of the one or more search attributes included in the search query correspond to a second group of attributes contained in the index instance in the cloud-based non-relational database;   receiving, by the processing system, search results from the application programming interface of the cloud-based microservice, wherein the search results include one or more record identifiers; and   searching, by the processing system, the relational database based on the one or more record identifiers.   
     
     
         2 . The method of  claim 1 , further comprising:
 identifying, by the processing system, an additional search attribute included in the search query, wherein the additional search attribute is not included in the index instance; and   removing, by the processing system, the additional search attribute from the search query;   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the additional search attribute.   
     
     
         3 . The method of  claim 1 , further comprising:
 identifying, by the processing system, an additional search attribute included in the search query, wherein the additional search attribute is not included in the index instance; and   communicating, by the processing system, instructions to the microservice to modify the index instance in the cloud-based non-relational database to add the additional search attribute.   
     
     
         4 . The method of  claim 1 , further comprising:
 determining, by the processing system, that at least one of the one or more search attributes is an attribute updated more frequently than a periodic update of the relational database; and   removing, by the processing system, the at least one of the one or more search attributes from the search query;   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the at least one of the one or more search attributes.   
     
     
         5 . The method of  claim 1 , further comprising:
 identifying, by the processing system, an additional search attribute included in the search query;   determining, by the processing system, that additional search attribute is missing from the search results; and   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the additional search attribute.   
     
     
         6 . The method of  claim 1 , wherein one or more attributes in the search results are different than the one or more search attributes included in the search query. 
     
     
         7 . A system comprising:
 a processor; and   a memory storing executable instructions that, when executed by the processor, perform operations comprising:   receiving a search query directed to a relational database, wherein the search query includes one or more search attributes from records in the relational database;   verifying that the one or more search attributes are included in an index instance in a cloud-based non-relational database;   reformatting the search query as instructions recognized by an application programming interface of a cloud-based microservice;   submitting the instructions to the application programming interface to cause the microservice to search the index instance in the cloud-based non-relational database for corresponding records in the relational database, wherein the searching the index instance is responsive to determining that a first group of the one or more search attributes included in the search query correspond to a second group of attributes contained in the index instance in the cloud-based non-relational database;   receiving search results from the application programming interface of the cloud-based microservice, wherein the search results include one or more record identifiers; and   searching the relational database based on the one or more record identifiers.   
     
     
         8 . The system of  claim 7 , wherein the operations further comprise:
 identifying an additional search attribute included in the search query, wherein the additional search attribute is not included in the index instance; and   removing the additional search attribute from the search query;   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the additional search attribute.   
     
     
         9 . The system of  claim 7 , wherein the operations further comprise:
 identifying an additional search attribute included in the search query, wherein the additional search attribute is not included in the index instance; and   communicating instructions to the microservice to modify the index instance in the cloud-based non-relational database to add the additional search attribute.   
     
     
         10 . The system of  claim 7 , wherein the operations further comprise:
 determining that at least one of the one or more search attributes is an attribute updated more frequently than a periodic update of the relational database; and   removing the at least one of the one or more search attributes from the search query;   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the at least one of the one or more search attributes.   
     
     
         11 . The system of  claim 7 , wherein the operations further comprise:
 identifying an additional search attribute included in the search query;   determining that additional search attribute is missing from the search results; and   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the additional search attribute.   
     
     
         12 . The system of  claim 7 , wherein one or more attributes in the search results are different than the one or more search attributes included in the search query. 
     
     
         13 . The system of  claim 12 , wherein the operations further comprise communicating instructions to the microservice to modify the index instance in the cloud-based non-relational database to add the one or more attributes in the search results that are different than the one or more search attributes included in the search query. 
     
     
         14 . A non-transitory, machine-readable medium, comprising executable instructions that, when executed by a processing system including a processor, facilitate performance of operations, the operations comprising:
 a processor; and   a memory storing executable instructions that, when executed by the processor, perform operations comprising:   receiving a search query directed to a relational database, wherein the search query includes one or more search attributes from records in the relational database;   verifying that the one or more search attributes are included in an index instance in a cloud-based non-relational database;   reformatting the search query as instructions recognized by an application programming interface of a cloud-based microservice;   submitting the instructions to the application programming interface to cause the microservice to search the index instance in the cloud-based non-relational database for corresponding records in the relational database, wherein the searching the index instance is responsive to determining that a first group of the one or more search attributes included in the search query correspond to a second group of attributes contained in the index instance in the cloud-based non-relational database;   receiving search results from the application programming interface of the cloud-based microservice, wherein the search results include one or more record identifiers; and   searching the relational database based on the one or more record identifiers.   
     
     
         15 . The non-transitory, machine-readable medium of  claim 14 , wherein the operations further comprise:
 identifying an additional search attribute included in the search query, wherein the additional search attribute is not included in the index instance; and   removing the additional search attribute from the search query;   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the additional search attribute.   
     
     
         16 . The non-transitory, machine-readable medium of  claim 14 , wherein the operations further comprise:
 identifying an additional search attribute included in the search query, wherein the additional search attribute is not included in the index instance; and   communicating instructions to the microservice to modify the index instance in the cloud-based non-relational database to add the additional search attribute.   
     
     
         17 . The non-transitory, machine-readable medium of  claim 14 , wherein the operations further comprise:
 determining that at least one of the one or more search attributes is an attribute updated more frequently than a periodic update of the relational database; and   removing the at least one of the one or more search attributes from the search query;   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the at least one of the one or more search attributes.   
     
     
         18 . The non-transitory, machine-readable medium of  claim 14 , wherein the operations further comprise:
 identifying an additional search attribute included in the search query;   determining that additional search attribute is missing from the search results; and   wherein the searching the relational database comprises searching the relational database based on the one or more record identifiers and the additional search attribute.   
     
     
         19 . The non-transitory, machine-readable medium of  claim 14 , wherein one or more attributes in the search results are different than the one or more search attributes included in the search query. 
     
     
         20 . The non-transitory, machine-readable medium of  claim 19 , wherein the operations further comprise communicating instructions to the microservice to modify the index instance in the cloud-based non-relational database to add the one or more attributes in the search results that are different than the one or more search attributes included in the search query.