Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries
US7743052B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 14, 2006 |
| Grant date | Jun 22, 2010 |
| Priority date | — |
| Expiry date | Aug 10, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.