Information processing program, information processing apparatus, and information processing method that optimize access to an external database based on calculated minimum processing load

An information processing apparatus comprising:

• a memory, and
• a processor coupled to the memory and configured to:
• receive a query for accessing data included in at least one of a plurality of external databases;
• specify, by the processor and based on measurement results of communication times taken for accessing the plurality of external databases, relation between the communication times taken for accessing the plurality of external databases;
• calculate, by the processor and when accepting an instruction to execute processing using the at least one of the plurality of external databases, at least one processing load when accessing the at least one of the plurality of external databases, based on the relation between the communication times;
• control, by the processor, an access to the data included in the at least one of the plurality of external databases according to a minimum calculated processing load among the at least one processing load;
• and
• execute the query based on the calculated minimum processing load, wherein
• in the specify the relation between the communication times,
• a ratio of the communication times taken for accessing the plurality of external databases is calculated,
• an acquisition time taken for acquisition of data from an internal database included in the computer is measured, and
• a ratio of the measured acquisition time to the communication time taken for accessing each of the plurality of external databases is calculated, and
• in the calculate the at least one processing load,
• a first processing load corresponding to each of the at least one of the plurality of external databases is calculated such that a ratio of the communication times taken for accessing the at least one of the plurality of external databases and a ratio of the first processing loads accompanying communication of data in a first size with the at least one of the plurality of external databases match,
• based on the calculated first processing load, the at least one processing load when accessing the at least one of the plurality of external databases is calculated,
• a second processing load accompanying acquisition of data in a second size from the internal database is acquired from a storage unit,
• the first processing load corresponding to each of the at least one of the plurality of external databases is calculated such that a ratio of the measured acquisition time to the communication time taken for accessing the at least one of the plurality of external databases and a ratio of the acquired second processing load to the first processing load corresponding to each of the at least one of the plurality of external databases match, and
• based on the calculated first processing load and the second processing load, the at least one processing load when accessing the at least one of the plurality of external databases is calculated.

An information processing method to be performed by a computer, the method comprising:

• receiving a query for accessing data included in at least one of a plurality of external databases;
• specifying, by the computer and based on measurement results of communication times taken for accessing the plurality of external databases, relation between the communication times taken for accessing the plurality of external databases;
• calculating, by the computer and when accepting an instruction to execute processing using the at least one of the plurality of external databases, at least one processing load when accessing the at least one of the plurality of external databases, based on the relation between the communication times;
• controlling, by the computer, an access to the data included in the at least one of the plurality of external databases according to a minimum calculated processing load among the at least one processing load;
• and
• executing the query based on the calculated minimum processing load, wherein
• in the specifying the relation between the communication times,
• a ratio of the communication times taken for accessing the plurality of external databases is calculated,
• an acquisition time taken for acquisition of data from an internal database included in the computer is measured, and
• a ratio of the measured acquisition time to the communication time taken for accessing each of the plurality of external databases is calculated, and
• in the calculating the at least one processing load,
• a first processing load corresponding to each of the at least one of the plurality of external databases is calculated such that a ratio of the communication times taken for accessing the at least one of the plurality of external databases and a ratio of the first processing loads accompanying communication of data in a first size with the at least one of the plurality of external databases match, and
• based on the calculated first processing load, the at least one processing load when accessing the at least one of the plurality of external databases is calculated,
• a second processing load accompanying acquisition of data in a second size from the internal database is acquired from a storage unit,
• the first processing load corresponding to each of the at least one of the plurality of external databases is calculated such that a ratio of the measured acquisition time to the communication time taken for accessing the at least one of the plurality of external databases and a ratio of the acquired second processing load to the first processing load corresponding to each of the at least one of the plurality of external databases match, and
• based on the calculated first processing load and the second processing load, the at least one processing load when accessing the at least one of the plurality of external databases is calculated.