Incremental repair of query plans
US7739269B2 · kind B2 · utility
13Cited by
6References
17Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jan 19, 2007 |
| Grant date | Jun 15, 2010 |
| Priority date | — |
| Expiry date | Aug 17, 2027 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Database systems use a plan cache to avoid the overheads (e.g., time, money) of query recompilation. Query plans can become invalidated by updates to the statistics on data or changes to the physical database design. Once a plan is invalidated, it can be repaired utilizing one or more of the disclosed embodiments. Incremental repair of query plans includes reusing parts of the current plan rather than discarding the plan entirely when it is invalidated. Repair to an existing query plan is attempted before resorting to full recompilation.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.