Patent ID: 6556986
Filing Date: 2003-04-29
Classification: G06F,Y10S

Abstract:
A database management method of performing a processing of a database by invoking a function registered in the database in response to a request of the processing, comprising the steps of:(1) relating an index type name, a parameter data type and a data for invoking a routine for retrieving an index of said index type into first correspondence and cataloging the first correspondence as index type definition information, (a) said index type name representing a type of a particular index which has not yet been supported by a database system, and (b) said parameter data type invoking a routine searching an index of an index type identified by said index type name; (2) relating (a) an index name, (b) an index type name of the index type in an index corresponding to said index name, (c) column information included in a column of a table defining said index and (d) a function name identifying a function for accessing said index into second correspondence and cataloging the second correspondence as index definition information; (3) (a) upon reception of said processing request including a name of a function and column information used by said function, (b) referring to said index definition information to acquire a relevant one of said cataloged index type names corresponding to said function name and said column information when said function name and said column information match said cataloged function name and said cataloged column information, (c) referring to said index type definition information to acquire the data type of said cataloged parameter corresponding to said acquired index type name and a routine invoking data for searching an index of said index type; (d) generating an execution plan based on said acquired routine invoking data and said acquired data type of parameter; and (4) in executing said execution plan, referring to an index corresponding to said acquired index type name and invoking a routine based on a relevant routine invoking data corresponding to said acquired index type name.