Automatic index recommendations for improved query performance
US12242479B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 31, 2024 |
| Grant date | Mar 4, 2025 |
| Priority date | — |
| Expiry date | Jan 31, 2044 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/213
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems and methods described herein relate to automatic index recommendations for improved database query performance. Candidate indexes are identified. The candidate indexes are associated with a database query that is classified as a slow query. A feature vector is generated for each candidate index to represent statement features and statistical features associated with the candidate index. The feature vectors are provided to one or more machine learning models to obtain an index recommendation value for each candidate index. An index recommendation is presented at a user device. The index recommendation identifies a first index of the candidate indexes based at least partially on the index recommendation value obtained for the first index. User input indicative of a user selection of the first index is received. A database schema is updated to include the first index in response to the user input.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.