Reusing existing query plans in a database system
US9317552B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 30, 2013 |
| Grant date | Apr 19, 2016 |
| Priority date | — |
| Expiry date | Jul 9, 2033 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24524
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for executing query plans preprocesses a user's queries to identify and extract select parameters of the query, creates a skeletal query with reference to the extracted parameters, creates and compiles an executable version of the skeletal query, then executes the compiled version of the skeletal query using the particular parameters in the current query. The compiled version of the parameterized skeletal query is stored, and when another query is submitted that matches the skeletal query (but with potentially different parameters), the previously compiled skeleton query is executed with the parameters of this latter query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.