Query performance improvement of a query for a database application using rewrite
US12321347B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 29, 2024 |
| Grant date | Jun 3, 2025 |
| Priority date | — |
| Expiry date | Mar 29, 2044 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/80
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for improving a query performance of a query of a database application using rewrite includes introducing a database query into a database application to obtain a query result, analyzing the database query to identify index columns and a predicate column; identifying associated columns by determining if any associations exist between the index columns and the predicate column, calculating a confidence score value for each of the associated columns responsive to the associated columns and the predicate column, generating a list of associated columns with the confidence score values, generating a rewritten query by rewriting the database query based on the list of associated columns and the confidence score values and validating the rewritten query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.