System, data combining method, integration server, data combining program, database system ,database system cooperation method, and database system cooperation program

A data combining method comprising:

• receiving, by an integration server, a request for combining a plurality of pieces of data from a client;
• transmitting, by the integration server, an inquiry to two of a plurality of DSs on the basis of the request;
• extracting, by a first DS of the two DSs, first data from a first DB on the basis of the received inquiry and generating a first hash value based on the first data;
• extracting, by a second DS of the two DSs, second data from a second DB on the basis of the received inquiry and generating a second hash value based on the second data;
• transmitting, by the first DS, the first hash value to the second DS;
• collating, by the second DS, the first hash value received from the first DS with the second hash value, transmitting, to the integration server, a collation result and at least a part of the second data, for which the first hash value and the second hash value are matched, and transmitting a matched part of hash values to the first DS;
• transmitting, by the first DS, at least a part of the first data that was a source of the matched part of hash values to the integration server;
• and
• combining, by the integration server, the data received from the first DS and the second DS on the basis of the collation result.

An integration server comprising:

• a communicator configured to communicate with a client and a plurality of DSs for managing DBs storing data associated with identification information;
• and
• an executor configured to:
• transmit an inquiry to two of a plurality of DSs on the basis of a request for combining a plurality of pieces of data in a case that the request has been received from the client;
• collate data received from a first DS of the two DSs with data received from a second DS of the two DSs on the basis of an identification information combination and transmit a result of combining matched data to the client, in a case that the identification information combination and data associated with one piece of identification information of the identification information combination have been received from the first DS and data associated with other piece of identification information of the identification information combination has been received from the second DS.

A data combining method comprising:

• receiving a request for combining a plurality of pieces of data from a client;
• transmitting an inquiry to two of a plurality of DSs for managing DBs storing data associated with identification information on the basis of the request;
• receiving an identification information combination and data associated with one piece of identification information of the identification information combination from a first DS of the two DSs and receiving data associated with other piece of identification information of the identification information combination from a second DS of the two DSs;
• collating the data received from the first DS with the data received from the second DS on the basis of the identification information combination;
• and
• transmitting a result of combining matched data to the client.

A data combining program for causing a computer to:

• receive a request for combining a plurality of pieces of data from a client;
• transmit an inquiry to two of a plurality of DSs for managing DBs storing data associated with identification information on the basis of the request;
• receive an identification information combination and data associated with one piece of identification information of the identification information combination from a first DS of the two DSs and receive data associated with other piece of identification information of the identification information combination from a second DS of the two DSs;
• collate the data received from the first DS with the data received from the second DS on the basis of the identification information combination;
• and
• transmit a result of combining matched data to the client.

A DS comprising:

• a DB;
• a communicator configured to communicate with an integration server for combining data and another DS different from its own device;
• a receiver configured to receive an inquiry based on a request for combining a plurality of pieces of data from the integration server using the communicator;
• an extractor configured to extract data of the DB on the basis of the received inquiry;
• a generator configured to generate a hash value based on the data extracted by the extractor;
• a switch configured to switch the status of the DS between a base point side device for transmitting the hash value generated by its own device to the other DS that has received the inquiry from the integration server, and an execution side device for collating a hash value generated by the other DS that has received the inquiry from the integration server with the hash value generated by its own device, by communicating with the other DS that has received the inquiry from the integration server using the communicator;
• and
• an executor configured to receive, in a case that the status of the DS is the execution side device, a hash value from a DS of the base point side device using the communicator, collate the hash value obtained by the generator with the received hash value, transmit a collation result and data serving as a source of a matched part of hash values to the integration server, and transmit matched part of hash values to the DS of the base point side device, and,
• configured to transmit, in a case that the status of the DS is the base point side device, the hash value generated by the generator to a DS of the execution side device using the communicator and transmit the data extracted by the extractor to the integration server using the communicator on the basis of information corresponding to a matched part of the hash values received from the DS of the execution side device.

A DS cooperation method comprising:

• receiving an inquiry based on a request for combining a plurality of pieces of data from an integration server;
• extracting data from a DB on the basis of the received inquiry;
• generating a hash value based on the extracted data;
• switching the status of the DS between a base point side device for transmitting the hash value generated by its own device to another DS that has received the inquiry from the integration server, and an execution side device for collating a hash value generated by the other DS that has received the inquiry from the integration server with the hash value generated by its own device by communicating with the other DS that has received the inquiry from the integration server;
• receiving, in a case that the status of the DS is the execution side device, a hash value from a DS of the base point side device, collating the hash value generated by its own device with the received hash value, transmitting a collation result and data serving as a source of a matched part of the hash values to the integration server, and transmitting the matched part of the hash values;
• and
• transmitting, in a case that the status of the DS is the base point side device, the hash value generated by its own device to a DS of the execution side device and transmitting the extracted data to the integration server on the basis of information corresponding to a matched part of the hash values received from the DS of the execution side device.

A DS cooperation program for causing a computer to:

• receive an inquiry based on a request for combining a plurality of pieces of data from an integration server for combining data;
• extract data from a DB on the basis of the received inquiry;
• generate a hash value based on the extracted data;
• switch the status of the DS between a base point side device for transmitting the hash value generated by its own device to another DS that has received the inquiry from the integration server, and an execution side device for collating a hash value generated by the other DS that has received the inquiry from the integration server with the hash value generated by its own device by communicating with the other DS that has received the inquiry from the integration server;
• receive, in a case that the status of the DS is the execution side device, a hash value from a DS of the base point side device, collate the hash value generated by its own device with the received hash value, transmit a collation result and data serving as a source of a matched part of the hash value to the integration server, and transmit matched part of the hash values to the DS of the base point side device;
• and
• transmit, in a case that the status of the DS is the base point side device, the hash value generated by its own device to a DS of the execution side device and transmit the extracted data to the integration server on the basis of the matched part of the hash values received from the DS of the execution side device.