Patent ID: 8171018
Filing Date: 2012-05-01
Classification: G06F,Y10S

Abstract:
1. A method for generating machine executable code for implementing a query of a database, the database having tables and records of data, comprising the steps of: receiving a subject query; forming an execution plan corresponding to the subject query, the execution plan having a sequence of pieces and corresponding processes for implementing the pieces; and for at least one piece of the plan, (a) generating source code corresponding to the at least one piece of the plan using at least one of a plurality of different code generation techniques being selected as a function of an expected processing machine type of a plurality of expected processing machine types; and (b) compiling the generated source code to form machine executable code for implementing the subject query, said generated source code avoiding runtime interpretation of the pieces in the execution plan, wherein the code generated for at least one piece of the plan is cached in a centralized location to remain available to be used in processing a subsequent plan piece without rerunning the generating step.