Method and system for providing a learning optimizer for federated database systems
First Claim
1. A method for accelerating execution of a query on a federated database system, the federated database system being associated with an external data source, the query utilizing the external data source and being performed based upon a query execution plan, the method comprising:
- generating at least one optimizer query for the external data source utilized by the query, the at least one optimizer query being based on the query and for obtaining data related to the external data source;
providing the at least one optimizer query to the external data source for execution using the external data source; and
collecting at least one resultant from execution of the at least one optimizer query for use in generating a future query execution plan.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for method for accelerating execution of a query on a federated database system is disclosed. The federated database system is associated with an external data source, which is used by the query. The query is performed based upon a query execution plan. The method and system include generating an optimizer query for the external data source utilized by the query. The optimizer query is based on the query and obtains data related to the external data source. The method and system further include providing the optimizer query to the external data source and collecting at least one resultant from the optimizer query for use in generating a future query execution plan.
-
Citations
20 Claims
-
1. A method for accelerating execution of a query on a federated database system, the federated database system being associated with an external data source, the query utilizing the external data source and being performed based upon a query execution plan, the method comprising:
-
generating at least one optimizer query for the external data source utilized by the query, the at least one optimizer query being based on the query and for obtaining data related to the external data source;
providing the at least one optimizer query to the external data source for execution using the external data source; and
collecting at least one resultant from execution of the at least one optimizer query for use in generating a future query execution plan. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A system for accelerating execution of a query on a federated database system, the federated database system being associated with an external data source, the query utilizing the external data source and being performed based upon a query execution plan, the system comprising:
-
an optimizer query generator for generating at least one optimizer query for the external data source utilized by the query, the at least one optimizer query being based on the query and for obtaining data related to the external data source, the at least one optimizer query being provided to the external data source for execution;
a query feedback warehouse for storing statistics from execution of the at least one optimizer query, the statistics for use in generating a future query execution plan; and
a monitor for collecting the at least one resultant from execution the at least one optimizer query. - View Dependent Claims (16, 17, 18, 19)
-
-
20. A computer-readable medium containing a program for accelerating execution of a query on a federated database system, the federated database system being associated with an external data source, the query utilizing the external data source and being performed based upon a query execution plan, the program including instructions for:
-
generating at least one optimizer query for the external data source utilized by the query, the at least one optimizer query being based on the query and for obtaining data related to the external data source;
providing the at least one optimizer query to the external data source for execution using the external data source; and
collecting statistics from execution of the at least one optimizer query for use in generating a future query execution plan.
-
Specification