Relational database synchronization method and a recording medium storing a program therefore
First Claim
1. A relational database synchronization method for synchronizing master data of a relational database held by a master machine with replica data which is a duplication of the master data and is held by each of a large number of replica machines, each replica machine usually operating with use of the replica data while in an off-line state with respect to the master machine, said relational database synchronization method comprising:
- connecting a replica machine to the master machine at an arbitrary time to make a request for synchronization;
extracting, in said replica machine, a record of which a day of last update is later than a master differential extraction completion time, from the replica data as a replica differential;
transferring the extracted replica differential to the master machine;
extracting, in the master machine, a record of which a replica differential reflection time is later than a master differential extraction completion time, as a master differential from the master data with reference to records held by said replica machine which has made the request for synchronization, and updating the master differential extraction completion time to a current time;
causing the replica differential to be reflected in the master data;
transferring the master differential and the updated master differential extraction completion time to said replica machine;
causing the master differential transferred from the master machine to be reflected in the replica data in said replica machine, and updating the master differential extraction completion time held by said replica machine to the transferred master differential extraction completion time; and
cutting off the connection between said replica machine and the master machine.
1 Assignment
0 Petitions
Accused Products
Abstract
A relational database synchronization method for synchronizing master data with data of replica machines, which data is updated usually with the replica machines disconnected from a master machine, so that there may be no inconsistency among the data. After a replica machine is connected to the master machine via a network at an arbitrary time, it extracts records of which the day of last update is later than a master differential extraction completion time, from replica data as replica differentials, and the master machine extracts records of which the replica differential reflection time is later than the master differential extraction completion time, from the master data as master differentials, updates the master differential extraction completion time to the current time, and causes the replica differentials to be reflected in the master data. The replica machine then causes the master differentials to be reflected in the replica data and updates the master differential extraction completion time. This completes the synchronization process and the connection with the master machine may be cut off thereafter at an arbitrary time.
149 Citations
10 Claims
-
1. A relational database synchronization method for synchronizing master data of a relational database held by a master machine with replica data which is a duplication of the master data and is held by each of a large number of replica machines, each replica machine usually operating with use of the replica data while in an off-line state with respect to the master machine, said relational database synchronization method comprising:
-
connecting a replica machine to the master machine at an arbitrary time to make a request for synchronization;
extracting, in said replica machine, a record of which a day of last update is later than a master differential extraction completion time, from the replica data as a replica differential;
transferring the extracted replica differential to the master machine;
extracting, in the master machine, a record of which a replica differential reflection time is later than a master differential extraction completion time, as a master differential from the master data with reference to records held by said replica machine which has made the request for synchronization, and updating the master differential extraction completion time to a current time;
causing the replica differential to be reflected in the master data;
transferring the master differential and the updated master differential extraction completion time to said replica machine;
causing the master differential transferred from the master machine to be reflected in the replica data in said replica machine, and updating the master differential extraction completion time held by said replica machine to the transferred master differential extraction completion time; and
cutting off the connection between said replica machine and the master machine. - View Dependent Claims (2, 3, 4)
-
-
5. A relational database synchronization method for synchronizing master data of a relational database held by a master machine with replica data which is a duplication of the master data and is held by each of a large number of replica machines, each replica machine usually operating with use of the replica data while in an off-line state with respect to the master machine, said relational database synchronization method comprising:
-
connecting a replica machine to the master machine at an arbitrary time to make a request for synchronization;
extracting, in said replica machine, a record of which a day of last update is later than a master differential extraction completion time, from the replica data as a replica differential;
transferring the extracted replica differential to the master machine;
registering said replica machine which has made the request for synchronization, in a master differential extraction queue in the master machine;
registering said replica machine which has made the request for synchronization, in a replica differential reflection queue in the master machine;
extracting a record of which a replica differential reflection time is later than a master differential extraction completion time, as a master differential from the master data with reference to records held by said replica machine which has made the request for synchronization and updating the master differential extraction completion time to a current time when a turn for said replica machine has come in the master differential extraction queue;
transferring the master differential and the updated master differential extraction completion time to said replica machine;
cutting off the connection between said replica machine and the master machine;
causing the master differential transferred from the master machine to be reflected in the replica data in said replica machine, and updating the master differential extraction completion time held by said replica machine to the transferred master differential extraction completion time; and
causing the replica differential to be reflected in the master data when a turn for said replica machine which made the request for synchronization has come in the replica differential reflection queue. - View Dependent Claims (6, 7, 8, 9)
-
-
10. A computer-readable recording medium storing a relational database synchronization program which includes master differential extracting means for extracting a record of which a replica differential reflection time is later than a master differential extraction completion time, as a master differential from master data of a relational database of a master machine with reference to records of replica data held by a replica machine which has made a request for synchronization, and for updating the master differential extraction completion time to a current time, master differential transferring means for transferring the master differential and the updated master differential extraction completion time to the replica machine, master differential reflecting means for causing the master differential transferred by said master differential transferring means to be reflected in the replica data and for updating the master differential extraction completion time held by the replica machine to the transferred master differential extraction completion time, replica differential extracting means for extracting a record of which a day of last update is later than the master differential extraction completion time, from the replica data as a replica differential, replica differential transferring means for transferring the replica differential extracted by said replica differential extracting means to the master machine, replica differential reflecting means for causing the replica differential transferred by said replica differential transferring means to be reflected in the master data, and queue processing means for managing order of execution of said master differential extracting means and said replica differential reflecting means.
Specification