Patent ID: 7996387
Filing Date: 2011-08-09
Classification: G06F

Abstract:
1. A computer-implemented method comprising: a database server registering one or more functions included in a user-defined index that includes one or more auxiliary properties, wherein the one or more functions are operable to generate index entries of the user-defined index for the one or more auxiliary properties; wherein the one or more auxiliary properties are operational properties of the user-defined index that provide for performing evaluation operations based on the index entries of the user-defined index, and wherein the one or more auxiliary properties are different than, and in addition to, a primary property of the user-defined index that provides for evaluating a query operator associated with the user-defined index; the database server receiving a first statement that defines the user-defined index, wherein the first statement includes one or more parameters that define the one or more auxiliary properties; the database server invoking the one or more functions in response to the first statement, wherein the one or more functions when invoked generate and store the index entries of the user-defined index according to the one or more parameters that define the one or more auxiliary properties; wherein each index entry, of the user-defined index, includes a field for storing an identifier of a data row in a table, wherein the table is identified in the first statement; and wherein the method is performed by one or more computing devices.