Data federation query suggestion

• US 9,633,123 B2
• Filed: 10/14/2013
• Issued: 04/25/2017
• Est. Priority Date: 10/14/2013
• Status: Expired due to Fees

• Current Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Original Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Inventors: Nguyen, Filip, Elias, Filip
• Primary Examiner(s): Syed, Farhan
• Application Number:
  US14/053,343
• Publication Number:
  US 20150106353A1
• Time in Patent Office: 1,289 Days
• Field of Search: None
• 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 non-transitory memory storing a query constraint database including at least one query constraints; and

at least one hardware processor in communication with the non-transitory memory and configured to execute;

a query constraint resolver that receives from a user a query to search a federated database comprising a plurality of non-integrated databases using a federated database search engine with a client identity of the user submitting the query and determines if the query satisfies the at least one query constraints for querying the plurality of non-integrated databases without submission of the query to each of the plurality of non-integrated databases, wherein the plurality of non-integrated databases are selected by a data architect for search using the query and stored to disparate memory storages connected over a network, wherein the data architect sets the at least one query constraint on views of result sets from the query of the plurality of non-integrated databases with query suggestions for non-compliant queries based on the client identity, wherein the each of the plurality of non-integrated databases comprise a separate query rule list, and wherein the federated database search engine transforms the query for the each of the plurality of non-integrated databases using the separate query rule list for the each of the plurality of non-integrated databases on receipt of the query; and

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

wherein the query constraint resolver further communicates, to the data architect, search results comprising at least one view for the query from the each of the plurality of non-integrated databases, wherein the at least one view comprises secure data, receives an update for re-optimization of the at least on query constraints from the data architect, wherein the update limits access to the secure data based on the client identity, and updates the at least one query constraints in the query constraint database based on the update for re-optimization received from the data architect.

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 one 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 query is a structured query language (SQL) query.

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

receiving a query to search a federated database comprising a plurality of non-integrated databases using a federated database search engine with a client identity of the user submitting the query, wherein the lurality of non-integrated databases are selected by a data architect for search using the query and stored to disparate memory storages connected over a network, wherein the data architect sets the at least one query constraint on views of result sets from the query of the plurality of non-integrated databases with query suggestions for non-compliant queries based on the client identity, wherein each of the plurality of non-integrated databases comprise a separate query rule list, and wherein the federated database search engine transforms the query for the each of the plurality of non-integrated databases using the separate query rule list for the each of the plurality of non-integrated databases on receipt of the query;

determining, using one or more hardware processor of a query constraint system, if the query satisfies at least one query constraints for querying the plurality of non-integrated databases without submission of the query to the each of the plurality of non-integrated databases;

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

communicating, to the data architect, search results comprising at least one view for the query from the each of the plurality of non-integrated databases, wherein the at least one view comprises secure data;

receiving an update for re-optimization of the at least on query constraints from the data architect, wherein the update limits access to the secure data based on the client identity; and

updating the at least one query constraints in the query constraint database based on the update for re-optimization received from the data architect.

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

11. The method of claim 10, 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.

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

13. The method of claim 12, wherein the fix includes each of the at least one column query patterns not satisfied by the query.

14. The method of claim 9 further comprising:

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

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

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

17. 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 comprising a plurality of non-integrated databases using a federated database search engine with a client identity of the user submitting the query, wherein the plurality of non-integrated databases are selected by a data architect for search using the query and stored to disparate memory storages connected over a network, wherein the data architect sets the at least one query constraint on views of result sets from the query of the plurality of non-integrated databases with query suggestions for non-compliant queries based on the client identity, wherein each of the plurality of non-integrated databases comprise a separate query rule list, and wherein the federated database search engine transforms the query for the each of the plurality of non-integrated databases using the separate query rule list for the each of the plurality of non-integrated databases on receipt of the query;

determining if the query satisfies at least one query constraints for querying the plurality of non-integrated databases without submission of the query to the each of the plurality of non-integrated databases, 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;

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;

communicating, to the data architect, search results comprising at least one view for the query from the each of the plurality of non-integrated databases, wherein the at least one view comprises secure data;

receiving an update for re-optimization of the at least on query constraints from the data architect, wherein the update limits access to the secure data based on the client identity; and

updating the at least one query constraints in the query constraint database based on the update for re-optimization received from the data architect.