US 11,853,301 B1
Sharing compiled code for executing queries across query engines
Ippokratis Pandis, Menlo Park, CA (US); Naresh Chainani, Mountain View, CA (US); Kiran Kumar Chinta, Fremont, CA (US); Venkatraman Govindaraju, Fremont, CA (US); Andrew Edward Caldwell, Santa Clara, CA (US); Naveen Muralimanohar, San Jose, CA (US); Martin Grund, Lafayette, CA (US); Fabian Oliver Nagel, Mountain View, CA (US); and Nikolaos Armenatzoglou, Belmont, CA (US)
Assigned to Amazon Technologies, Inc., Seattle, WA (US)
Filed by Amazon Technologies, Inc., Seattle, WA (US)
Filed on Mar. 29, 2019, as Appl. No. 16/370,614.
Int. Cl. G06F 16/00 (2019.01); G06F 16/2455 (2019.01); G06F 16/2458 (2019.01); G06F 16/22 (2019.01); G06F 16/2453 (2019.01); G06F 16/242 (2019.01)
CPC G06F 16/24552 (2019.01) [G06F 16/2255 (2019.01); G06F 16/2443 (2019.01); G06F 16/2445 (2019.01); G06F 16/2458 (2019.01); G06F 16/24539 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
at least one processor; and
a memory, storing program that when executed by the at least one processor cause the at least one processor to implement a query engine;
the query engine, configured to:
receive a query to a database;
generate a plurality of portions of code for a query execution plan to perform the query;
before compiling the plurality of portions of code:
determine that a portion of code of the plurality of portions of code for the query execution plan is not compiled and that the portion of code is not stored in a local store of one or more portions of compiled code at the query engine,
obtain a compiled version of the portion of code of the plurality of portions of code from a global store, wherein the compiled version of the portion of code of the plurality of portions of code stored in the global store was previously generated for a prior query execution plan to perform a prior query received at a second query engine, and
store the compiled version of the portion of code obtained from the global store in the local store; and
use the compiled version of the portion of code of the plurality of portions of code obtained from the global store and stored in the local store instead of compiling the portion of code when executing the query execution plan to perform the query.