Database processing method and apparatus using handle

A database processing method in a parallel database system which comprises request accepting servers each for accepting a processing request of data of a predetermined type and analyzing said request and allocating a process corresponding to said request to either one of said request accepting servers and at least one database processing server and said at least one database processing server for executing the process allocated by said request accepting servers, and in which said request accepting servers and said at least one database processing server are mutually connected through a network, comprising the steps of:

• a) preparing a handle which is a control block for managing a storage area of data as a processing target and which has information with respect to one of said servers in which said processing target data has been stored and a storing location thereof;
• b) when the data as a processing target corresponding to said processing request is processed in accordance with said processing request, executing a process according to said processing request by said request accepting server having accepted said processing request by using said handle regarding said processing target data;
• and
• c) when an entity of said processing target data is necessary in said step b), obtaining said entity of said processing target data on the basis of said handle and processing.

A parallel database system comprising:

• request accepting servers each for accepting a processing request of data of a predetermined type, analyzing said request, and allocating a process corresponding to said request to either one of said request accepting servers and at least one database processing server;
• said at least one database processing server for executing the process allocated by said request accepting server having accepted said request;
• and
• a network for mutually connecting said request accepting servers and said at least one database processing server, wherein
• when data as a processing target corresponding to said processing request is processed in accordance with said processing request, said request accepting server having accepted said request and said at least one database processing server to which said process was allocated transmit and receive a handle which is a control block to manage a storage area of said processing target data and which relates to the processing target data corresponding to said processing request between said request accepting server having accepted said request and said database processing server to which said process was allocated, and execute a process according to said processing request, and
• when the process according to said processing request is executed, in the case where an entity of said processing target data is necessary, the entity of said processing target data is obtained on the basis of said handle and processed.

A parallel database system comprising:

• request accepting servers each for accepting a processing request of data of a predetermined type, analyzing said request, and allocating a process corresponding to said request to either one of said request accepting servers and at least one database processing server;
• said at least one database processing server for executing the process allocated by said request accepting server having accepted said request;
• and
• a network for mutually connecting said request accepting servers and said at least one database processing server, wherein
• said handle is a control block to manage a storage area of data as a processing target and has information regarding one of said servers in which said processing target data has been stored and a storing position thereof, when the processing target data corresponding to said processing request is processed in accordance with said processing request by one of said request accepting servers, said one of said request accepting servers executes a process according to said processing request by using a handle regarding the processing target data, and when an entity of said processing target data is necessary, the entity of said processing target data is obtained on the basis of said handle and is processed.

A computer program embodied on a computer-readable medium for use in a parallel database system which comprises request accepting servers each for accepting a processing request of data of a predetermined type, analyzing said request, and allocating a process corresponding to said request to either one of said request accepting servers and at least one database processing server and said at least one database processing server for executing the process allocated by said request accepting server and in which said request accepting servers and said at least one database processing server are mutually connected through a network, comprising:

• program code means having a handle which is a control block to manage a storage area of data as a processing target and which has information with respect to one of said servers in which said processing target data has been stored and a storing position thereof;
• program code means for, when one of said request accepting servers processes the processing target data corresponding to said processing request in accordance with said processing request, allowing a process according to said processing request to be executed by said one of said request accepting servers by using a handle regarding the processing target data;
• and
• program code means for, when the process according to said processing request is executed and in the case where an entity of said processing target data is necessary, obtaining the entity of said processing target data on the basis of said handle and processing.