Patent ID: 6353820
Filing Date: 2002-03-05
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 output 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, the method comprising the steps of:(a) adding an index processing performance enhancing subroutine to a subroutine library included within the first component layer, the index processing performance enhancing subroutine being designed to execute index processing functions performed by lower component layers substantially faster than if the function were executed by the lower component layers, and including code for determining conditions under which the particular subroutine is to be invoked during query execution time; (b) including calls in the generated output code to the index processing enhancing subroutine in place of normally included calls to the lower component layers for inserting the index processing enhancing subroutine into the generated code; and, (c) including logic within the index processing enhancing subroutine for determining if the index processing enhancing subroutine can be reliably invoked based on a predetermined set of conditions.