Database processing method and system

A relational database processing method of executing a function which is previously defined and registered in a database, in accordance with a processing request issued from an end user to execute a database processing, said method comprising the steps of:

• creating a table of index definition information such that a specific user-defined function is set in correspondence to a specific index which is used when carrying out an index access to data of a database region, and
• a table of module definition information such that a specific index, which is used when carrying out an index access to the data of the database region, is set in correspondence to an implementation module for subjecting the data of the database region to a specific processing;
• detecting, for a processing request for the database issued from an end user, the correspondence between a user-defined function under request and the specific index on the basis of said index definition information table;
• selecting from said module definition information table, a specific implementation module for carrying out an access using the specific index corresponding to the detection result by said detecting step;
• and
• executing the database processing using the selected implementation module.

A relational database processing system for executing a function which is previously defined and registered in a database, in accordance with a processing request to perform a database processing, said system comprising:

• a table for registering therein index definition information such that a specific user-defined function is set in correspondence to a specific index which is used when carrying out an index access to data of a database region;
• a table for registering therein module definition information such that a specific index which is used when carrying out an index access to the data of the database region, is set in correspondence to an implementation module for subjecting the data of the database region to a specific processing;
• detection means responsive a processing request for the database issued from an end user, for detecting the correspondence between a user-defined function under request and the specific index on the basis of said index definition information table;
• selection means responsive to the specific index corresponding to the detection result provided by said detection means for selecting from said module definition information registeration table, a specific implementation module for carrying out a database access;
• and
• execution means for executing the database processing using the implementation module selected by said selection means.

A computer readable recording medium for storing therein a program of implementing, using a computer, a relational database processing of executing a function which is previously defined and registered in a database, in accordance with a processing request to perform a database processing, said program comprising:

• program means for creating index definition information such that a specific user-defined function is set in correspondence to a specific index which is used when carrying out an index access to data of a database region;
• program means for creating module definition information such that a specific index which is used when carrying out an index access to the data of the database region, is set in correspondence to an implementation module for subjecting the data of the database region to a specific processing;
• program means responsive to a processing request for the database issued from an end user, for detecting on the basis of the index definition information, whether the correspondence between a user-defined function in request and the specific index is present or absent;
• selection program means for selecting from the module definition information, a specific implementation module for carrying out an access using the specific index corresponding to the detection result provided by said detection program means;
• and
• program means for performing the database processing using the implementation module selected by said selection program means.

A database processing method of executing, in accordance with a query from an end user, a user-defined function, which a registering user has previously defined and registered for a database in accordance with a query from the end user, to perform a database processing, said method comprising the steps of:

• registering, when the registering user defines unique indexes as an index type, information relating to data items which establish an index key constituting the index of interest in the form of a table in a database management system;
• registering, when creating an index using the index type which the registering user has defined, information used to identify a specified index type, information relating to table data required for maintaining the index of interest, and information relating to the user definition function used to carry out retrieval using the index of interest in the form of a table in said database management system;
• maintaining, in response to a data processing request for the table in which the index of interest is created, issued from the end user, the index of interest using table data which has been specified on the basis of the information relating to the tables;
• determining, in response to a judgement indicating that the information relating to the user-defined function is contained in a query request issued from the end user, that the index of interest be maintained as an index for use in implementation of the query;
• and
• executing, in order to carry out the query, the database processing using the index thus determined.

A computer readable recording medium for storing therein a program for implementing, using a computer, a database processing by executing, in accordance with a query from an end user, a user-defined function, which a registering user has previously defined and registered for a database in accordance with a query from the end user, said program comprising:

• program means for registering, when the registering user defines a unique index as an index type, information relating to data items becoming an index key constituting the index of interest in the form of a table in a database management system;
• program means for registering, when creating an index using the index type which the registering user has defined, information used to identify a specified index type, information relating to table data required for maintaining the index of interest, and information relating to the user-defined function used to carry out retrieval using the index of interest in the form of a table in said database management system;
• program means for creating, in response to a data processing request for the table, in which the index of interest is created, issued from the end user, the index key on the basis of the registered information relating to the data items which establish the index key constituting the index, and for maintaining the index of interest using the index key thus created;
• program means for determining, in response to a judgement indicating that the information relating to the user-defined function is contained in a query request issued from the end user, the index of interest being maintained as an index for use in implementation of the query;
• and
• program means for performing, in order to carry out the query, a database processing using the index thus determined.

A method of executing, using a computer, a retrieval database processing of executing a function previously registered in a database in accordance with a processing request to execute a database processing, said method comprising the steps of:

• registering in a table index definition information which is used to set a specific user-defined function in correspondence to a specific index which is used when carrying out an index access to data in a database region;
• registering in another table module definition information, which is used to set the specific index used when carrying out the index access to the data in the database region in correspondence to an implementation module for subjecting the data in the database region to a specific processing;
• in response to a processing request for the database issued from an end user, enabling the correspondence between the user-defined function under the request and the specific index to be detected on the basis of said index definition information registration table;
• and
• enabling, in order to execute the database processing, a specific implementation module for carrying out an access using a specific index corresponding to the detection result to be selected from the module definition information registration table.

A computer readable program product for recording therein a program for implementing, using a computer, a relational database processing software (architecture) for executing a function, which is previously defined and registered in a database, in accordance with a processing request to execute a database processing, said software comprising:

• product means for registering in a table index definition information which is used to set a specific user-defined function in correspondence to a specific index which is used when carrying out an index access to data in a database region;
• product means for registering in another table module definition information, which is used to set the specific index used when carrying out the index access to the data in the database region in correspondence to an implementation module for subjecting the data in the database region to a specific processing;
• product means for enabling, for a processing request for the database issued from an end user, the correspondence between the user-defined function in the request and the specific index to be detected on the basis of the index definition information registration table;
• and
• product means for enabling, in order to execute the database processing, a specific implementation module for carrying out an access using a specific index corresponding to the detection result to be selected from the module definition information registration table.