Systems and methods for database query efficiency improvement
US10963438B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 17, 2020 |
| Grant date | Mar 30, 2021 |
| Priority date | — |
| Expiry date | Nov 17, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/287
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and systems for database query efficiency improvement are disclosed. In one embodiment, a method includes mirroring a primary database to a secondary database; creating a testing database comprising the schema; receiving a query; running the query on the testing database; and evaluating the query by: identifying predicates in the query; determining most common values for each column name by querying the secondary database; creating, for each column name, a list comprising at least one of the most common values; creating a test predicate comprising one of the column names and an entry for the list corresponding to the column name; creating a test query comprising one or more test predicates; determining a resource utilization of the query by running each of the test queries on the secondary database; and providing, to a user interface for display, an efficiency improvement recommendation when the resource utilization exceeds a threshold.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.