Patent ID: 6446062
Filing Date: 2002-09-03
Classification: G06F,Y10S

Abstract:
A cache manager for processing SQL statements included within an application that result in the retrieval and storage of data within a database, the cache manager being operatively coupled to a runtime library interface over which the SQL statements are received and the cache manager including an SQL cache for storing code segments generated for executing the SQL statements, the cache manager utilizing a search function for performing lengthy complex search operation involving comparing attributes of each SQL statement for locating an applicable code segment stored in the SQL cache to execute the particular SQL statement, the system further including:(a) static storage being associated with the runtime library interface, the static storage having a plurality of key areas for storing a corresponding number of key values, each key value established for each previously processed SQL statement; and, (b) the cache manager being operative for each SQL statement for which a key value has been established to access the key area within the static storage associated with the SQL statement to obtain the key value for locating the applicable code segment stored in the SQL cache for executing the SQL statement bypassing the search function.