RECOMMENDATION PLATFORM FOR STRUCTURED QUERIES

• US 20180075092A1
• Filed: 09/15/2016
• Published: 03/15/2018
• Est. Priority Date: 09/15/2016
• Status: Active Grant

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Original Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Inventors: Hernandez Sanchez, Ivan Dario, Paulk, Roderic, Meredith, Sheldon Kent
• Granted Patent: US 10,452,652 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/248 Presentation of query results

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.

Claims

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 a 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 user, wherein the rank is based upon a number of queries of the recommended user with respect to a database, a data table, or a field associated with the search.

11. The device of claim 9, wherein the at least one recommended subject comprises a recommended database, wherein the rank 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, wherein the rank is based upon at least one of:

a volume of queries associated with the recommended data table;

or

a volume of joining of the recommended data table.

13. The device of claim 11, wherein the at least one recommended subject comprises a recommended field, wherein the rank 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 user, wherein the rank is based upon a number of queries of the recommended user with respect to a database, a data table, or a field associated with 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.