Dynamically selecting among learned and non-learned indexes for data access
US12253994B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 5, 2023 |
| Grant date | Mar 18, 2025 |
| Priority date | — |
| Expiry date | Jul 5, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06N3/09
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The described technology relates to systems and techniques for accessing a database by dynamically choosing an index from a plurality of indexes that includes at least one learned index and at least one non-learned index. The availability of learned and non-learned indexes for accessing the same database provides for flexibility in accessing the database, and the dynamic selection between learned indexes and non-learned indexes provide for choosing the index based on the underlying data in the database and the characteristics of the query. Certain example embodiments provide a learned model that accepts a set of features associated with the query as input, and outputs a set of evaluated weights for respective features, which are then processed according to a set of rules to predict the most efficient index to be used.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.