Patent ID: 8832143

Claim:
A method of providing instructions from a database client to a database server, comprising: receiving a plurality of embedded structured query language (SQL) instructions; sending the plurality of embedded SQL instructions to the database server, wherein the database server analyzes the plurality of embedded SQL instructions; receiving, from the database server and based on the analyzing by the database server, a representation of a first instruction and an associated identifier, wherein the first instruction comprises a pre-processed dynamic SQL instruction converted from a first embedded SQL instruction from the plurality of embedded SQL instructions; storing the representation of the first instruction and the associated identifier in a cache; receiving a second instruction from an application, wherein the second instruction is not identical to the first instruction and comprises a second embedded SQL instruction from the plurality of embedded SQL instructions; matching the representation of the first instruction and the second instruction; retrieving the associated identifier from the cache based on the matching; and sending the associated identifier to the database server, wherein, upon receiving the associated identifier the database server executes the first instruction.