| CPC G06F 16/2456 (2019.01) [G06F 16/24537 (2019.01)] | 2 Claims |
|
1. An information processing apparatus communicably connected to a client terminal used by a user, a first database management device that manages a first database that stores a first table, and a second database management device that manages a second database that stores a second table, the information processing apparatus comprising:
a processor configured to:
receive, from the client terminal, a first query to request a result of a join operation process on the first and second tables;
create a second query to the first database management device based on the first query received;
receive a first table stored in the first database from the first database management device by performing, in the first database management device, a process on the second query created;
create a third query to the second database management device based on the first query received and the first table received;
receive a part of a second table stored in the second database from the second database management device by performing, in the second database management device, a process on the third query created; and
transmit, to the client terminal, a response to the first query based on the part of the second table received; and
a memory configured to store number-of records information indicating a number of first records included in the first table and a number of second records included in the second table, wherein
processes of creating a third query, receiving a part of a second table, and transmitting a response to the first query based on the part of the second table are performed in a case where at least one of the number of the first records and the number of the second records indicated by the number-of-records information stored in the memory is larger than or equal to a predetermined value, and
the processor is configured to:
create a fourth query to the second database management device based on the first query received in a case where a number of first records and a number of second records indicated by number-of-records information stored in the memory are less than the predetermined value;
receive a second table stored in the second database from the second database management device by performing, in the second database management device, a process on the fourth query created; and
transmit, to the client terminal, a result of a join operation process on the first table received and the second table received as a response to the first query.
|