Patent ID: 7519620
Filing Date: 2009-04-14
Classification: G06F,Y10S

Abstract:
1. A method for managing a plurality of master databases and a replica database generated from said plurality of master databases, comprising: storing, as replication control information, a plurality of names of master tables of the master databases, a name of the replica database generated from said plurality of master databases by join operations based on predetermined joining keys, joining keys used in said join operations, and timing conditions setting timings at which replications of data are performed to the replica database from the master tables to correlate with each other; in response to reception of a request for a data operation to a record stored in a first one of said master databases, storing as operation information the requested data operation to correlate identification information of an operated record with the master table name of the first master database on which the data operation request has been performed; determining whether a processing result of the data operation request meets the timing conditions; when the timing conditions are met, acquiring the master table name of the first master database on which said data operation request has been operated, one of said stored joining keys corresponding to said timing conditions, a second master table name of a second master database, and the replica database name to be joined by the joining key from the replication control information; referring to said stored operation information to acquire the record subject to data operation, said record belonging to a master table of the first master database on which the data operation has been made based on the data operation request; performing a joining processing with respect to said record subject to the data operation and said second master database to be joined using said joining key, by referring to the replication control information; reflecting a replica database record generated by the joining processing to said replica database to implement to said replica database the data operation based on said data operation request; and accessing the replica database in place of accessing the plurality of master databases when executing a job requiring accessing of the plurality of master databases, whereby time required for executing the job is minimized.