Self-healing RDBMS optimizer
US7415455B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 17, 2006 |
| Grant date | Aug 19, 2008 |
| Priority date | — |
| Expiry date | Feb 7, 2027 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, computer program product, and system for triggering an update of statistics data used by a query optimizer of a relational database management system for determining an optimal execution plan for executing a received query request on a relational database is provided. A system dependent nominal performance value for executing the query request on a database system is determined. Additionally, an average actual performance value is determined by processing the query request. If a comparison between the average actual performance value and the system dependent nominal performance value yields a result which is greater than a first threshold value, an update cost value and a cost saving value are determined. If a comparison between the cost saving value and the update cost value yields a result which is greater than a second threshold value, the statistics data is updated.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.