Patent ID: 7693913

Claim:
A storage medium storing a program to be executed by a computer for use by an application program to remote access a virtual database system that virtualizes one or more native databases as one virtual database, the virtual database system including a first computer furnished with the application program receiving a prescribed input parameter from a user, and a second computer which is connected to the first computer by way of a network and includes the one or more native databases, wherein execution of the program by the computer comprising: a source code input process to receive a source code of said application program; an input and output information extraction process to extract input and output information relating to a data manipulation language (DML) execution process for the virtual database from said source code based on data structure relationship information storing information relating to a relationship of data structures between the one or more native databases and virtual database; a RPC replacement process to replace a source code that includes a description part relating to the DML execution process for the virtual database with a replacement source code that includes a description relating to a remote procedure call (RPC) process; and a native DML execution program generation process to generate a native DML execution program that is to execute a DML execution process for the native databases based on the RPC process, wherein the native DML execution program generation process includes: a process to generate correlation information indicating a correlation among a DML instruction included in the DML execution process for said virtual database, said extracted input and output information comprising at least an input parameter given to the DML instruction and at least an output parameter outputted by the DML execution process, and one or more data items constituting a record of said native databases, based on the data structure relationship information; and a process to generate schedule information for a process executed by the aforementioned native DML execution program generation process based on said correlation information, the schedule information including an execution of a process for assembling results of the DML execution process for each of said one or more native databases and for making it one result of the DML execution process for said virtual database.