Data Federation Query Suggestion

• US 20150106353A1
• Filed: 10/14/2013
• Published: 04/16/2015
• Est. Priority Date: 10/14/2013
• Status: Active Grant

• Current Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Original Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Inventors: Nguyen, Filip, Elias, Filip
• Granted Patent: US 9,633,123 B2
• Time in Patent Office: Days
• US Class Current: 707/707
• CPC Class Codes: G06F 16/954 Navigation, e.g. using categorised browsing

Abstract

Systems and methods are provided for data federation query suggestion. An example system includes a query constraint database including at least one query constraint and a query constraint resolving module that receives from a user a query to search a federated database using a federated database search engine and determines if the query satisfies at least one query constraints. The system further includes a query suggestion module that determines a query suggestion if the query does not satisfy at least one query constraints.

Claims

1. A system for data federation query suggestions, the system comprising:

a query constraint database including at least one query constraint

a query constraint resolver that receives from a user a query to search a federated database using a federated database search engine and determines if the query satisfies at least one query constraints; and

a query suggestion module that determines a query suggestion if the query does not satisfy at least one query constraints.

2. The system of claim 1, wherein each of the at least one query constraints include a set of column query patterns having a two component tuple.

3. The system of claim 2, wherein the query satisfies the at least one query constraints when each of the set of column query patterns in the least one query constraint is satisfied.

4. The system of claim 2, wherein the query suggestion includes a fix to the query corresponding to the at least one query constraints.

5. The system of claim 4, wherein the fix includes each of the at least on column query patterns not satisfied by the query.

6. The system of claim 1 wherein the query constraint resolver transmits the query to the federated database search engine if the query is compliant with the at least one query constraints.

7. The system of claim 1, wherein query constraint resolver receives an updated query to search the federated database using the federated database search engine, wherein the updated query is compliant with the at least one query constraints.

8. The system of claim 1, wherein the at least one query constraint is configured to prevent access to secure data in the federated database.

9. The system of claim 1, wherein a data architect defines each of the at least one query constraints, and wherein the data architect further configures the federated database search engine.

10. The system of claim 1, wherein the query is a structured query language (SQL) query.

11. A method for data federation query suggestions, the method comprising:

receiving a query to search a federated database using a federated database search engine;

determining, using one or more hardware processor of a query constraint system, if the query satisfies at least one query constraints; and

determining a query suggestion if the query does not satisfy at least one query constraints.

12. The method of claim 11, wherein each of the at least one query constraints include a set of column query patterns having a two component tuple.

13. The method of claim 12, wherein the query satisfies the at least one query constraints when each of the set of column query patterns in the least one query constraint is satisfied.

14. The method of claim 12, wherein the query suggestion includes a fix to the query corresponding to the at least one query constraints.

15. The method of claim 14, wherein the fix includes each of the at least on column query patterns not satisfied by the query.

16. The method of claim 11 further comprising:

transmitting the query to the federated database search engine if the query is compliant with the at least one query constraints.

17. The method of claim 11 further comprising:

receiving an updated query to search the federated database using the federated database search engine, wherein the updated query is compliant with the at least one query constraints.

18. The method of claim 11, wherein the at least one query constraint is configured to prevent access to secure data in the federated database.

19. The method of claim 11, wherein the query is a structured query language (SQL) query.

20. A non-transitory computer readable medium comprising a plurality of machine-readable instructions which when executed by one or more processors of a server are adapted to cause the server to perform a method comprising:

receiving a query to search a federated database using a federated database search engine;

determining if the query satisfies at least one query constraints, wherein each of the at least one query constraints include a set of column query patterns having a two component tuple, and wherein the query satisfies the at least one query constraints when each of the set of column query patterns in the least one query constraint is satisfied; and

determining a query suggestion if the query does not satisfy each of the set of column query patterns in the least one query constraint, wherein the query suggestion includes a fix to the query corresponding to the at least one query constraints, and wherein the fix includes each of the at least on column query patterns not satisfied by the query.