Recommendation platform for structured queries

• US 10,452,652 B2
• Filed: 09/15/2016
• Issued: 10/22/2019
• Est. Priority Date: 09/15/2016
• Status: Expired due to Fees

• 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
• Primary Examiner(s): Dang, Thanh-Ha
• Application Number:
  US15/266,009
• Publication Number:
  US 20180075092A1
• Time in Patent Office: 1,132 Days
• Field of Search: 707722
• 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;

returning the first query record in response to the search; and

generating at least one recommendation based upon the search, wherein the at least one recommendation identifies at least one recommended subject, wherein the at least one recommended subject includes a recommended user, wherein the recommended user is selected for the at least one recommendation based upon a rank of the recommended user with respect to the at least one parameter of the search, wherein the rank of the recommended user 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.

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:

presenting the at least one recommendation to a user generating the search.

6. The device of claim 5, wherein the presenting the at least one recommendation comprises presenting at least one query record associated with the at least one recommended subject.

7. The device of claim 5, 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.

8. The device of claim 1, wherein the at least one recommended subject further comprises a recommended database, wherein the 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, 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.

9. The device of claim 1, wherein the at least one recommended subject further comprises a recommended data table, 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, wherein the rank of the recommended data table 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.

10. The device of claim 1, wherein the at least one recommended subject further 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.

11. 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;

returning the first query record in response to the search; and

generating at least one recommendation based upon the search, wherein the at least one recommendation identifies at least one recommended subject, wherein the at least one recommended subject includes a recommended user, wherein the recommended user is selected for the at least one recommendation based upon a rank of the recommended user with respect to the at least one parameter of the search, wherein the rank of the recommended user 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.

12. The non-transitory computer-readable storage medium of claim 11, 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.

13. The non-transitory computer-readable storage medium of claim 11, wherein the operations further comprise:

presenting the at least one recommendation to a user generating the search.

14. The non-transitory computer-readable storage medium of claim 13, wherein the presenting the at least one recommendation comprises presenting at least one query record associated with the at least one recommended subject.

15. 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;

returning, by the processor, the first query record in response to the search; and

generating, by the processor, at least one recommendation based upon the search, wherein the at least one recommendation identifies at least one recommended subject, wherein the at least one recommended subject includes a recommended user, wherein the recommended user is selected for the at least one recommendation based upon a rank of the recommended user with respect to the at least one parameter of the search, wherein the rank of the recommended user 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.

16. The method of claim 15, 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.

17. The method of claim 16, 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.

18. The method of claim 15, 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.

19. The method of claim 15, further comprising:

presenting the at least one recommendation to a user generating the search.

20. The method of claim 19, wherein the presenting the at least one recommendation comprises presenting at least one query record associated with the at least one recommended subject.