Data retrieval apparatus, program and recording medium

1. A data retrieval apparatus that retrieves data from two or more databases that return retrieved data in response to a retrieval instruction, the data retrieval apparatus comprising:

a processor; and

a memory storing a virtual database that analyzes a retrieval request input from a user terminal to generate a retrieval instruction, executes the generated retrieval instruction in the database to acquire two or more retrieved data, and integrates the acquired two or more retrieved data to prepare a retrieval result responding to the retrieval request,

wherein the memory that stores the virtual database further includes:

a retrieval request translation circuit that analyzes the retrieval request and generates a retrieval instruction for retrieval from the two or more databases;

a retrieval instruction execution circuit that executes the retrieval instruction generated by the retrieval request translation circuit on any one or more of the two or more databases to acquire two or more retrieved data; and

a data integration processing circuit that integrates and processes the two or more retrieved data acquired by the retrieval instruction execution circuit to prepare a retrieval result responding to a data retrieval request,

wherein the data integration processing circuit includes

a reference scheme of acquiring reference data from one database according to a reference condition predefined for each of records of intermediate data acquired from another database, and complimenting an item missing from the intermediate data with an item from the reference data,

wherein the reference scheme includes

a sequential merge scheme of acquiring data to be retrieved from a reference source and data to be retrieved from a referenced database, rearranging the acquired data in an order of condition values of reference conditions, and thereafter, while sequentially reading reference source records and referenced database records one by one, comparing the condition values of the reference conditions, and integrate records where the reference conditions are satisfied.

2. A data retrieval apparatus that retrieves data from two or more databases that return retrieved data in response to a retrieval instruction, the data retrieval apparatus comprising:

a processor; and

a memory storing a virtual database that analyzes a retrieval request input from a user terminal to generate a retrieval instruction, executes the generated retrieval instruction in the database to acquire two or more retrieved data, and integrates the acquired two or more retrieved data to prepare a retrieval result responding to the retrieval request,

wherein the memory that stores the virtual database further includes

a retrieval request translation circuit that analyzes the retrieval request and generates a retrieval instruction for retrieval from the two or more databases;

a retrieval instruction execution circuit that executes the retrieval instruction generated by the retrieval request translation circuit on any one or more of the two or more databases to acquire two or more retrieved data; and

a data integration processing circuit that integrates and processes the two or more retrieved data acquired by the retrieval instruction execution circuit to prepare a retrieval result responding to a data retrieval request,

wherein the retrieval request translation circuit is configured to:

generate a retrieval instruction executable on a database to retrieve data from and a retrieval instruction executable by the data integration processing circuit; and

input an output of a retrieval instruction from a data integration processing circuit as a retrieval instruction to another data integration processing circuit to generate retrieval instruction to perform data integration processing in multiple stages.

3. A data retrieval apparatus that retrieves data from two or more databases that return retrieved data in response to a retrieval instruction, the data retrieval apparatus comprising:

a processor; and

a memory storing a virtual database that analyzes a retrieval request input from a user terminal to generate a retrieval instruction, executes the generated retrieval instruction in the database to acquire two or more retrieved data, and integrates the acquired two or more retrieved data to prepare a retrieval result responding to the retrieval request,

wherein the memory that stores the virtual database further includes

a retrieval request translation circuit that analyzes the retrieval request and generates a retrieval instruction for retrieval from the two or more databases;

a retrieval instruction execution circuit that executes the retrieval instruction generated by the retrieval request translation circuit on any one or more of the two or more databases to acquire two or more retrieved data; and

a data integration processing circuit that integrates and processes the two or more retrieved data acquired by the retrieval instruction execution circuit to prepare a retrieval result responding to a data retrieval request,

wherein the retrieval request translation circuit is configured to:

convert and apply an extraction condition for the virtual database indicated in a retrieval request into a retrieval instruction to the database;

execute classification and totaling requested in a retrieval request in advance in the database; and

perform processing of referring to a master managing a subject static attribute at a stage after data are aggregated without performing the processing during retrieval of detailed data to optimize the retrieval instruction to minimize a data amount transmitted from the database.