Optimized validation of cached query plans
US12277117B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 29, 2024 |
| Grant date | Apr 15, 2025 |
| Priority date | — |
| Expiry date | Apr 29, 2044 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24539
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The subject technology receives a query, the query including a statement for performing the query. The subject technology performs a lookup operation on a stored plan cache based on the query. The subject technology performs, in response to a cache match of the query to a stored query plan in the stored plan cache based on the lookup operation, a validation process of the stored query plan. The subject technology determines whether the stored query plan is valid based on the validation process. The subject technology performs, in response to determining that the stored query plan is valid, a program building process for the stored query plan to generate a final query plan. The subject technology sends the final query plan to an execution node for execution.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.