Patent ID: 7024406

Claim:
A computer-implemented method for processing a database statement submitted by a client application to a database system, comprising: precompiling a database statement based on a string received from the client application; and caching the precompiled database statement in response to a call from the client application to close the precompiled database statement; caching the string used to precompile the precompiled database statement in association with the cached precompiled database statement; and in response to a call from the client application to precompile another database statement based upon another string, performing the steps of: checking whether the string associated with the cached precompiled database statement matches the other string; if the string associated with the cached precompiled database statement matches the other string, then establishing the cached precompiled database statement as a result of precompiling the other database statement based upon the other string; and if the string associated with the cached precompiled database statement does not match the other string, then precompiling the other database statement based on the other string.