Database management method of invoking a function retrieving index type definition, cataloging particular index which has not yet been supported by a database system

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 with a routine invoking data 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 routine invoking data representing a data invoking a routine for searching an index of said index type;
• (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 a routine invoking data for an index of said index type corresponding to said acquired index type name;
• (d) generating an execution plan based on said acquired routine invoking data;
• and
• (5) in executing said execution plan, referring to the index corresponding to said acquired index type name and invoking a relevant routine based on the routine invoking data.

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 (a) an index name, (b) an index type name of the index type in an index corresponding to said index name, (c) a data for invoking a routine for searching an index of said index type, (d) column information included in a column of a table defining said index and (e) a function name identifying a function for accessing said index into first correspondence and cataloging the first correspondence as index information;
• (2) (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 and a data for invoking a routine for searching an index when said function name and said column information match said cataloged function name and said cataloged column information,
• (d) generating an execution plan based on said acquired routine invoking data;
• and
• (3) in executing said execution plan, referring to the index corresponding to said acquired index type name and invoking a relevant routine based on the routine invoking data.

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) upon reception of said processing request including a name of a function and column information used by said function,
• relating (a) an index name, (b) an index type name of the index type in an index corresponding to said index name, (c) a data for invoking a routine for searching an index of said index type, (d) column information included in a column of a table defining said index and (e) a function name identifying a function for accessing said index into first correspondence and cataloging the first correspondence as index information,
• referring to the cataloged index information to acquire a relevant one of said cataloged index type names corresponding to said function name and said column information and a data for invoking a routine for searching an index when said function name and said column information match said cataloged function name and said cataloged column information,
• generating an execution plan based on said acquired routine invoking data;
• and
• (2) in executing said execution plan, referring to the index corresponding to said acquired index type name and invoking said routine based on the routine invoking data.

A database management system, comprising:

• means for 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 said parameter data type invoking a routine searching an index of an index type identified by said index type name;
• means for 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;
• (a) means, upon reception of said processing request including a name of a function and column information used by said function, (b) for 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) for 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;
• and (d) for generating an execution plan based on said acquired routine invoking data and said acquired data type of parameter;
• and
• means, in executing said execution plan, for 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.

A computer-implemented program for performing a database management method 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 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;
• and (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.

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:

• relating an index type name with a parameter data type into first correspondence and cataloging the first correspondence as index type definition information, said index type name representing a type of a particular index which has not yet been supported by a database system, and said parameter data type transferring a routine managing an index of an index type identified by said index type name;
• relating the index type name with data invoking a routine for searching the index of said index type into a second correspondence and cataloging the second correspondence as routine definition information;
• relating an index name, an index type name of the index type in an index corresponding to said index name, a first function name for generating an input key for maintaining said index, and a second function name identifying a function for accessing said index into a third correspondence and cataloging the third correspondence as index definition information;
• upon receipt of said processing request including a third function name and a fourth function name designated by a function of said third function name, referring to said index definition information to acquire said cataloged index type name corresponding to said second function name and said first function name when said third function name and said fourth function name match said cataloged second function name and said cataloged first function name, referring to said index type information to acquire the data type of said cataloged parameter corresponding to said acquired index type name, generating an execution plan based on said acquired index type name and said acquired data type of parameter;
• and
• in executing said execution plan, referring to said routine definition and invoking a routine for reference to an index corresponding to said acquired index type name based on a routine invoking data corresponding to said acquired index type name.

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:

• relating an index type name with a parameter data type into first correspondence and cataloging the first correspondence as index type definition information, said index type name representing a type of a particular index which has not yet been supported by a database system, and said parameter data type transferring a routine managing an index of an index type identified by said index type name;
• relating the index type name with data invoking a routine for searching the index of said index type into a second correspondence and cataloging the second correspondence as routine definition information;
• relating an index name, an index type name of the index type in an index corresponding to said index name, a first function name for generating an input key for maintaining said index, and a second function name identifying a function for accessing said index into a third correspondence and cataloging the third correspondence as index definition information;
• upon receipt of said processing request including a third function name and a fourth function name designated by a function of said third function name, referring to said index definition information to acquire said cataloged index type name corresponding to said second function name and said first function name when said third function name and said fourth function name match said cataloged second function name and said cataloged first function name, referring to said index type information to acquire the data type of said cataloged parameter corresponding to said acquired index type name, referring to said routine definition information to acquire said cataloged routine invoking data corresponding to said acquired index type name, generating an execution plan based on said acquired routine invoking data and said acquired data type of parameter;
• and
• in executing said execution plan, invoking said routine based on the routine invoking data when a routine corresponding to said acquired routine invoking data is executed.