Replication system and program
AssigneeHitachi, Ltd.
InventorHiroshi Yokouchi
Life of this patent
Estimating the term…
Abstract
Data of a plurality of master tables can be replicated in one replica table. A job to access a plurality of tables can be executed by accessing one replica table, and hence the job execution time is minimized. A correspondence is established between data using, as a key, particular data in the data of a plurality of master tables. The data field for the key is defined by the replication definition. Timing of replication for the replica table is also defined in the program to execute replication. The replication program generates, at execution thereof, the control table according to the definition and manages the operation states of a plurality of master tables and the replication state of the replica table to thereby conduct replication for the replica table at the defined timing.
Claims14
A replication system for generating one replica table using a plurality of master tables, according to operation information of addition, update, and deletion in a plurality of master tables associated with to a database, comprising:
- means for matching data items of said plurality of master tables by use of particular data in the master tables as a joining key to join each other;
- and
- means responsive to said matching means for replicating the matched data items based on said joining key to generate one replica table.
A replication system, wherein for a master table in which data has not been inserted, particular data indicating absence of data is set in place of insufficient data of the master table to thereby conduct a replication.
A replication program for use in a system in which a plurality of database servers are connected to a computer, said replication program implementing the operation of replication by the computer comprising the steps:
- controlling a replication control table;
- acquiring master table operation information stored in said database servers;
- extracting a joining key contained in the master table operation information and data associated with the joining key;
- updating replication control information contained in the replication control table according to the joining key and the data associated with the joining key;
- and
- operating a replica table according to the replication control information.
Dependencies are inferred from the claim text.