Pre-constructed query recommendations for data analytics

Abstract

A process for recommending pre-constructed queries in data analytics includes writing different records to a correlation data structure correlating different data classifications of data to different queries and, subsequent to the writing, establishing a communicative connection by a data analytics application to an underlying database. Thereafter, a data model for data in the database may be constructed in the data analytics application and at least one of the different queries may be selected in the correlation data structure that correlates to the classification of the data in the data model. Finally, the selected one of the different queries may be displayed in the data analytics application to an end user so as to provide an intelligent recommendation for the addition of the selected one of the different queries without requiring the end user to alone and without assistance discover the suitability of the selected one of the different queries.

What is claimed is: 
     
         1 . A computer-implemented method executed by data processing hardware that causes the data processing hardware to perform operations comprising:
 obtaining a plurality of directives, each directive of the plurality of directives corresponding to respective data from a respective database;   for each respective directive of the plurality of directives, determining a respective classification of the respective data from the respective database corresponding to the respective directive;   constructing, using a data analytics application, a data model for underlying data in an underlying database;   determining, based on the data model, a classification of the underlying data;   determining that the classification of at least one of the plurality of directives matches the classification of the underlying data; and   based on determining that the classification of at least one of the plurality of directives matches the classification of the underlying data, displaying, to a user, the at least one of the plurality of directives.   
     
     
         2 . The method of  claim 1 , wherein each directive of the plurality of directives comprises a query. 
     
     
         3 . The method of  claim 1 , wherein each directive of the plurality of directives comprises a markup language statement. 
     
     
         4 . The method of  claim 1 , wherein the operations further comprise, for each of the plurality of directives, determining a respective correlation of the respective directive with the respective classification of the respective data from the respective database corresponding to the respective directive. 
     
     
         5 . The method of  claim 4 , wherein the operations further comprise, for each of the plurality of directives, adding, to a correlation data structure, the respective correlation of the respective directive with the respective classification of the respective data from the respective database corresponding to the respective directive. 
     
     
         6 . The method of  claim 5 , wherein determining that the classification of the at least one of the plurality of directives matches the classification of the underlying data comprises selecting, in the correlation data structure, the at least one of the plurality of directives based on the classification of the underlying data matching the respective classification of the at least one of the plurality of directives. 
     
     
         7 . The method of  claim 6 , wherein selecting the at least one of the plurality of directives comprises selecting the at least one of the directives correlated to a combination of classifications of data in the data model. 
     
     
         8 . The method of  claim 6 , wherein selecting the at least one of the plurality of directives comprises selecting a user interface view that is a visualization of a portion of the data model. 
     
     
         9 . The method of  claim 6 , wherein selecting the at least one of the plurality of directives comprises selecting of a report of data from a portion of the data model. 
     
     
         10 . The method of  claim 1 , wherein determining that the classification of the at least one of the plurality of directives matches the classification of the underlying data comprises:
 determining that the classification of the at least one of the plurality of directives is a partial match to the classification of the underlying; and   determining that the partial match satisfies a threshold.   
     
     
         11 . A system comprising:
 data processing hardware; and   
       memory hardware in communication with the data processing hardware, the memory hardware storing instructions that when executed on the data processing hardware cause the data processing hardware to perform operations comprising:
 obtaining a plurality of directives, each directive of the plurality of directives corresponding to respective data from a respective database; 
 for each respective directive of the plurality of directives, determining a respective classification of the respective data from the respective database corresponding to the respective directive; 
 constructing, using a data analytics application, a data model for underlying data in an underlying database; 
 determining, based on the data model, a classification of the underlying data; 
 determining that the classification of at least one of the plurality of directives matches the classification of the underlying data; and 
 based on determining that the classification of at least one of the plurality of directives matches the classification of the underlying data, displaying, to a user, the at least one of the plurality of directives. 
 
     
     
         12 . The system of  claim 11 , wherein each directive of the plurality of directives comprises a query. 
     
     
         13 . The system of  claim 11 , wherein each directive of the plurality of directives comprises a markup language statement. 
     
     
         14 . The system of  claim 11 , wherein the operations further comprise, for each of the plurality of directives, determining a respective correlation of the respective directive with the respective classification of the respective data from the respective database corresponding to the respective directive. 
     
     
         15 . The system of  claim 14 , wherein the operations further comprise, for each of the plurality of directives, adding, to a correlation data structure, the respective correlation of the respective directive with the respective classification of the respective data from the respective database corresponding to the respective directive. 
     
     
         16 . The system of  claim 15 , wherein determining that the classification of the at least one of the plurality of directives matches the classification of the underlying data comprises selecting, in the correlation data structure, the at least one of the plurality of directives based on the classification of the underlying data matching the respective classification of the at least one of the plurality of directives. 
     
     
         17 . The system of  claim 16 , wherein selecting the at least one of the plurality of directives comprises selecting the at least one of the directives correlated to a combination of classifications of data in the data model. 
     
     
         18 . The system of  claim 16 , wherein selecting the at least one of the plurality of directives comprises selecting a user interface view that is a visualization of a portion of the data model. 
     
     
         19 . The system of  claim 16 , wherein selecting the at least one of the plurality of directives comprises selecting of a report of data from a portion of the data model. 
     
     
         20 . The system of  claim 11 , wherein determining that the classification of the at least one of the plurality of directives matches the classification of the underlying data comprises:
 determining that the classification of the at least one of the plurality of directives is a partial match to the classification of the underlying; and   determining that the partial match satisfies a threshold.