Index selection in a database system
US7499907B2 · kind B2 · utility
246Cited by
7References
21Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Oct 12, 2001 |
| Grant date | Mar 3, 2009 |
| Priority date | — |
| Expiry date | Jan 20, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99939
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.