# US 2023/0141506 A1 · Pre-constructed query recommendations for data analytics

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2023/0141506 A1
- Document ID: US20230141506A1
- Status: Published application
- Kind: A1
- Application number: 18/150,185
- Filed: 2023-01-04
- Published: 2023-05-11
- Earliest claimed: 2020-10-08
- Assignees: Google Inc.
- Applicants: Google LLC
- Inventors: Aryeh Hillman
- Web page: https://patentgrep.com/patent/US20230141506A1

## CPC

- G06F 16/2423: {Interactive query statement specification based on a database schema}
- G06F 16/2428: {Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence)}
- G06F 16/2443: {Stored procedures}
- G06F 16/2445: {Data retrieval commands; View definitions}
- G06F 16/252: {between a Database Management System and a front-end application}
- G06F 16/285: {Clustering or classification}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### Claim 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.

### Claim 2 (depends on 1)

The method of claim 1, wherein each directive of the plurality of directives comprises a query.

### Claim 3 (depends on 1)

The method of claim 1, wherein each directive of the plurality of directives comprises a markup language statement.

### Claim 4 (depends on 1)

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.

### Claim 5 (depends on 4)

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.

### Claim 6 (depends on 5)

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.

### Claim 7 (depends on 6)

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.

### Claim 8 (depends on 6)

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.

### Claim 9 (depends on 6)

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.

### Claim 10 (depends on 1)

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.

### Claim 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.

### Claim 12 (depends on 11)

The system of claim 11, wherein each directive of the plurality of directives comprises a query.

### Claim 13 (depends on 11)

The system of claim 11, wherein each directive of the plurality of directives comprises a markup language statement.

### Claim 14 (depends on 11)

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.

### Claim 15 (depends on 14)

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.

### Claim 16 (depends on 15)

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.

### Claim 17 (depends on 16)

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.

### Claim 18 (depends on 16)

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.

### Claim 19 (depends on 16)

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.

### Claim 20 (depends on 11)

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.
