Multi-phase query plan caching
US12135715B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 28, 2023 |
| Grant date | Nov 5, 2024 |
| Priority date | — |
| Expiry date | Apr 28, 2043 |
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 first lookup operation on a multi-phase cache based on the query. The subject technology performs, in response to a first cache miss of the multi-phase cache, parsing of the statement from the query. The subject technology performs, based on the parsing, a compilation process on the query to generate a compiled query plan, the compilation process determining an optimization and a generalization for the query. The subject technology determines that the compiled query plan is cacheable. The subject technology registers, in response to the compiled query plan being cacheable, a dummy entry in the multi-phase cache.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.