Patent ID: 6438536
Filing Date: 2002-08-20
Classification: G06F,Y10S

Abstract:
A method for enhancing the performance of a data manager that manages a relational database, the manager having a number of operatively coupled component layers for performing functions required for accessing the relational database file records in response to user query statements, the number of component layers including a first component layer for generating code used in executing the query statement in response to input representing an optimized form of the query statement and a number of lower component layers including at least a second lower component layer for performing predetermined functions required for executing the query statement, the method comprising the steps of:(a) expanding a subroutine library included within the first component layer to include a number of performance enhancing subroutines designed to execute functions performed by lower component layers substantially faster than if the functions were executed by the number of lower component layers, each performance enhancing subroutine including code for determining conditions under which the particular subroutine is to be invoked during query execution time; (b) during the generating of the code, the first component layer adding calls to the number of performance enhancing subroutines in place of normally included calls to lower component layers for causing the insertion of the different subroutines into the generated code from the subroutine library; and, (c) during query execution time, the first component layer executing the generated code by invoking the performance subroutines to perform the second lower layer functions based on the characteristics of query statement being processed for providing increased performance.