Parallel, in-line, query capture database for real-time logging, monitoring and optimizer feedback
US8775413B2 · kind B2 · utility
60Cited by
4References
15Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Aug 22, 2008 |
| Grant date | Jul 8, 2014 |
| Priority date | — |
| Expiry date | Aug 14, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan is generated for the database query, which may be stored in an in-line query capture database. Execution of the query execution plan may be monitored in order to generate performance information, which also may be stored in the in-line query capture database. The data stored in in-line query capture database may be used during the initial generation of query execution plans, as well as for the re-optimization of a query execution plan, during the execution of the query execution plan.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.