US 12,169,491 B1
Dynamic selection of plan interpretation to perform queries
Nemanja Boric, Berlin (DE); Venkatraman Govindaraju, Fremont, CA (US); Demala Palliye Gurunnanselage Shermal Ruwantha Fernando, Berlin (DE); Naresh Chainani, Mountain View, CA (US); Ippokratis Pandis, Menlo Park, CA (US); Kiran Kumar Chinta, Fremont, CA (US); Hui Shi, Santa Clara, CA (US); and Hanna Loboda, Longmont, CO (US)
Assigned to Amazon Technologies, Inc., Seattle, WA (US)
Filed by Amazon Technologies, Inc., Seattle, WA (US)
Filed on Sep. 28, 2022, as Appl. No. 17/936,344.
Int. Cl. G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 16/2455 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one processor; and
a memory, storing program instructions that when executed by the at least one processor, cause the at least one processor to implement a database system that implements both code generation with compilation and domain-specific language interpretation for query performance, wherein the database system is configured to:
receive a query to a database;
generate a plan to perform the query;
evaluate the plan to select between the code generation with compilation and the domain-specific language interpretation, for at least a portion of the plan, wherein the evaluation selects application of a domain-specific language to interpret and execute the portion of the plan to perform the query using one or more previously compiled executors instead of selecting to use the code generation with compilation implemented by the database system to execute the portion of the plan, wherein the one or more previously compiled executors were not compiled for a prior query received at the database system; and
return a result of the query obtained according to an execution of the plan.