Method and system for providing a learning optimizer for federated database systems
US7610264B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 28, 2005 |
| Grant date | Oct 27, 2009 |
| Priority date | — |
| Expiry date | Dec 2, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for accelerating execution of a query on a federated database system. 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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.