Recommendation platform for structured queries

Abstract

In one example, a processor receives a structured query, parses the structured query into components, and stores the structured query, the components, and at least one attribute regarding the structured query in a first query record of a query record storage platform, the at least one attribute comprising a user identification of a user generating the structured query. The processor may then receive a search associated with the query record storage platform, where the search includes at least one parameter, and where the at least one parameter specifies at least one of the structured query, at least one of the components, or at least one of the at least one attribute regarding the structured query, and return the first query record in response to the search.

What is claimed is: 
     
         1 . A device comprising:
 a processor; and   a computer-readable storage medium storing instructions which, when executed by the processor, cause the processor to perform operations, the operations comprising:
 receiving a structured query; 
 parsing the structured query into components; 
 storing the structured query, the components, and at least one attribute regarding the structured query in a first query record of a query record storage platform, the at least one attribute including a user identification of a user generating the structured query; 
 receiving a search associated with the query record storage platform, the search including at least one parameter, the at least one parameter specifying at least one of: the structured query, at least one of the components, or at least one of the at least one attribute regarding the structured query; and 
 returning the first query record in response to the search. 
   
     
     
         2 . The device of  claim 1 , wherein the at least one attribute further comprises at least one of:
 a time of the structured query; or   a size of a result of the structured query.   
     
     
         3 . The device of  claim 2 , wherein the at least one of the at least one attribute includes:
 the user identification of the user generating the structured query;   the time of the structured query; or   the size of the result of the structured query.   
     
     
         4 . The device of  claim 1 , wherein the components include at least one of:
 a database specified in the structured query;   a data table specified in the structured query;   a field specified in the structured query;   a date range specified in the structured query;   a time range specified in the structured query; or   a type of data operation specified in the structured query.   
     
     
         5 . The device of  claim 1 , wherein the operations further comprise:
 generating at least one recommendation based upon the search, wherein the at least one recommendation identifies at least one recommended subject.   
     
     
         6 . The device of  claim 5 , wherein the operations further comprise:
 presenting the at least one recommendation to a user generating the search.   
     
     
         7 . The device of  claim 6 , wherein the presenting the at least one recommendation comprises presenting at least one query record associated with the at least one recommended subject. 
     
     
         8 . The device of  claim 6 , wherein the operations further comprise:
 receiving a feedback regarding the at least one recommendation from the user generating the search; and   adjusting at least one rank of the at least one recommended subject based upon the feedback.   
     
     
         9 . The device of  claim 5 , wherein the at least one recommended subject is selected for the at least one recommendation based upon a rank of the at least one recommended subject with respect to the at least one parameter of the search. 
     
     
         10 . The device of  claim 9 , wherein the at least one recommended subject comprises a recommended database, and wherein the at least one recommended database is selected for the at least one recommendation based upon a rank of the recommended database with respect to the at least one parameter of the search. 
     
     
         11 . The device of  claim 10 , wherein the rank of the recommended database is based upon at least one of:
 a volume of queries associated with the recommended database; or   a volume of joining of data tables of the recommended database.   
     
     
         12 . The device of  claim 9 , wherein the at least one recommended subject comprises a recommended data table, and wherein the recommended data table is selected for the at least one recommendation based upon a rank of the recommended data table with respect to the at least one parameter of the search. 
     
     
         13 . The device of  claim 9 , wherein the at least one recommended subject comprises a recommended field, wherein the recommended field is selected for the at least one recommendation based upon a rank of the recommended field with respect to the at least one parameter of the search, wherein the rank of the recommended field is based upon at least one of:
 a volume of queries associated with the recommended field; or   a volume of joining over the recommended field.   
     
     
         14 . A non-transitory computer-readable storage medium storing instructions which, when executed by a processor, cause the processor to perform operations, the operations comprising:
 receiving a structured query;   parsing the structured query into components;   storing the structured query, the components, and at least one attribute regarding the structured query in a first query record of a query record storage platform, the at least one attribute including a user identification of a user generating the structured query;   receiving a search associated with the query record storage platform, the search including at least one parameter, the at least one parameter specifying at least one of: the structured query, at least one of the components, or at least one of the at least one attribute regarding the structured query; and   returning the first query record in response to the search.   
     
     
         15 . The non-transitory computer-readable storage medium of  claim 14 , wherein the components include at least one of:
 a database specified in the structured query;   a data table specified in the structured query;   a field specified in the structured query;   a date range specified in the structured query;   a time range specified in the structured query; or   a type of data operation specified in the structured query.   
     
     
         16 . The non-transitory computer-readable storage medium of  claim 14 , wherein the operations further comprise:
 generating at least one recommendation based upon the search, wherein the at least one recommendation identifies at least one recommended subject; and   presenting the at least one recommendation to a user generating the search.   
     
     
         17 . The non-transitory computer-readable storage medium of  claim 16 , wherein the presenting the at least one recommendation comprises presenting at least one query record associated with the at least one recommended subject. 
     
     
         18 . The non-transitory computer-readable storage medium of  claim 16 , wherein the at least one recommended subject is selected for the at least one recommendation based upon a rank of the at least one recommended subject with respect to the at least one parameter of the search. 
     
     
         19 . The non-transitory computer-readable storage medium of  claim 18 , wherein the at least one recommended subject comprises a recommended database, and wherein the at least one recommended database is selected for the at least one recommendation based upon a rank of the recommended database with respect to the at least one parameter of the search. 
     
     
         20 . A method comprising:
 receiving, by a processor, a structured query;   parsing, by the processor, the structured query into components;   storing, by the processor, the structured query, the components, and at least one attribute regarding the structured query in a first query record of a query record storage platform, the at least one attribute comprising a user identification of a user generating the structured query;   receiving, by the processor, a search associated with the query record storage platform, the search including at least one parameter, the at least one parameter specifying at least one of: the structured query, at least one of the components, or at least one of the at least one attribute regarding the structured query; and   returning, by the processor, the first query record in response to the search.