Computer system, data retrieval method and database management computer

A data retrieval method for use in a computer system,

• the computer system including:
• a computer for outputting a result in response to a request that has been received;
• and
• a storage system for storing data output based on the request,
• the computer having a first processor, a first memory coupled to the first processor, and a first network interface coupled to the first processor,
• the storage system having a second processor, a second memory coupled to the second processor, a plurality of storage devices coupled to the second processor, for storing a plurality of pieces of the data, and a second network interface coupled to the second processor,
• the data retrieval method including the steps of:
• receiving, by the computer, the request;
• dividing, by the computer, the data stored in the plurality of storage devices;
• generating, by the computer, a plurality of processing procedures including an order of access to the data stored in the plurality of storage devices based on the request;
• obtaining, by the computer, load information indicating a load condition of the storage system;
• determining, by the computer, allotments for allocating the divided data to be processed by the generated plurality of processing procedures based on the obtained load information;
• and
• executing, by the computer, the generated plurality of processing procedures in parallel based on the determined allotments.

A database management computer for reading, in response to a request that has been received, data to be processed in the request from a storage system that stores the data, and executing the processing on the read data to output a result,

• the database management computer comprising a processor, a memory coupled to the processor, and a network interface coupled to the processor,
• the database management computer comprising:
• a request reception module for receiving the request;
• a processing procedure generation module for generating, based on the request, a plurality of processing procedures including an order of access to the data stored in a plurality of storage devices included in the storage system;
• a data division module for dividing the data stored in the plurality of storage devices;
• an information obtaining module for obtaining load information indicating a load condition of the storage system;
• an allotment determination module for determining, based on the obtained load information, allotments for allocating the divided data to be processed by the generated plurality of processing procedures;
• and
• a processing execution module for executing, based on the determined allotments, the generated plurality of processing procedures in parallel.