JP2002014860A - How to synchronize multiple databases - Google Patents

Abstract

(57) [Summary] The present invention provides a means for selecting grouped data when performing a synchronization procedure, so that only necessary parts can be synchronized. It is possible to optimize a synchronization method for synchronizing only necessary data and to shorten a synchronization processing time. In a system having a database of the same configuration in each of a server and a client, means for grouping data in the database and means for selecting a part of the group when performing a synchronization procedure are added. A method of synchronizing only the minimum required group of data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for reflecting change information of a database of a server and a client having the same database in both databases so as to make both data identical.

[0002]

2. Description of the Related Art A conventional synchronization method is disclosed in
As described in Japanese Patent Application Laid-Open No. 8280, when synchronizing a database, all data is subject to synchronization regardless of the presence or absence of a change, or all data that has changed since the previous synchronization is targeted.

[0003] The term "synchronization" used herein refers to a host having the same database and databases located on a plurality of clients. Both the host and client databases initially contain the same data, but are used separately so that data added / modified / deleted on one server or client side and data on the other server and client side The added / modified / deleted data will be present separately in both databases. In such a case, the data added / modified / deleted on one server side or client side is reflected on the other server side or client side, and only the necessary parts are used to make both databases identical.

[0004]

SUMMARY OF THE INVENTION As mentioned above,
In the conventional method, all data or all data that has changed since the previous synchronization is targeted for synchronization. There was a problem that it took time, and it was not possible to synchronize only the necessary data.

[0005] The present invention provides an optimization of a synchronization method for temporarily synchronizing only necessary data when performing a synchronization procedure.
It is another object of the present invention to provide a data synchronization method capable of shortening the synchronization processing time.

[0006]

SUMMARY OF THE INVENTION In order to achieve the above-mentioned object, the present invention provides a computer system in which a single host and a plurality of clients having the same type of database are used separately from each other. Is different data, the synchronization means to make the data of the database the same, and the data of each database, as the information on the change information of the data after the previous synchronization, based on the information, Means for targeting only data that has changed after the synchronization has been performed, and when synchronizing the plurality of databases, the data is grouped and divided in advance, and grouped when performing the synchronization procedure. By selecting such data, only the minimum necessary group of data can be synchronized.

[0007] The present invention also achieves the above-mentioned object.
A data synchronization method characterized in that data is grouped in advance, and a condition of whether or not to synchronize a database is set in advance, so that only a group of data that satisfies the set condition is synchronized. It is.

Further, according to the present invention, in the above-mentioned plurality of database synchronization methods, after synchronizing only some of the data groups selected or satisfying the conditions, both are finally made the same database. Therefore, the data synchronization method is characterized in that only a group of data not selected as a synchronization target in the previous synchronization processing can be synchronized later.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The configuration of an embodiment of the present invention will be described below with reference to FIG. FIG. 1 shows the configuration of a database synchronization system according to an embodiment of the present invention. In this embodiment, a LAN, WAN, or telephone line 1 is used.
The server 110 is implemented by a server 110 and a client 150 connected by 30. The server 110 has a CPU 117 that controls the entire apparatus, a storage device 111 that stores programs, dictionaries, and other various data. The synchronization program 112, the database synchronization service 114, the database 113 stored in the device 111, the data 116 defined in advance in the grouping stored in the database 113, and the synchronization and update history information for each of the data. The stored synchronization history record 115, the input device 118, and the display device 119 are present. The client 150 has a CPU 157 that controls the entire device, and a storage device 151 that stores programs, dictionaries, and other various data. And the synchronization program 1 stored in the storage device 151 2, a database 153, data 156 stored in the database 153 and defined in advance as a group, a synchronization history record 155 storing synchronization and update history information for each of the data, an input device 158, The display device 159 exists, and the server 11
The database 113 in 0 and the database 153 in the client 150 are databases having the same configuration.

FIGS. 2 and 3 show a flowchart of the client 150 in synchronizing the data 116 of the database 113 in the server 110 with the data 156 of the database 153 in the client 150. Here, it is assumed that the database synchronization service of the server 110 shown in FIG. 4 described later has been started.

First, a part or all of the data 116 in the database 113 in the server 110 is set as a synchronization target by a user operation in the client 150 which triggers the synchronization, or data satisfying a preset condition is used. (Step 200), and refer to the synchronization history record 155 in the client 150 to extract data updated since the previous synchronization processing was performed (Step 201). .

Next, the data extracted in step 201 is stored as an extraction file in the storage device 151 of the client 150 (step 202).

Next, whether the synchronization method specified in step 200 is a method in which a part of a data group divided in advance is selected or a method in which a group of data satisfying a preset condition is targeted (Step 203), and in the case of the above method, the information of “selected group” or “group that satisfies the condition” is stored as synchronization target information in the extraction file created in step 202 (step 204). If the synchronization method specified in step 200 is not a method of selecting a part of a data group divided in advance or a method of targeting a group of data satisfying a preset condition, the synchronization target information Step 20: "All groups" information
2 in the extracted file created in step 2 (step 20).
5).

Next, the extracted file generated in steps 204 and 205 is transmitted to the storage device 111 of the server 110 (step 206).

Next, it is confirmed whether or not the extracted file created by the server 110 has already been completed in the storage device 111 of the server 110 (steps 207 and 208). A copy is performed from the storage device 111 of the client 110 to the storage device 151 of the client 150 (step 210).

Next, it is confirmed that the extracted file created on the server 110 side can be copied to the storage device 151 of the client 150 (step 211), and if confirmed, the extracted file content of the server 110 is stored in the database 153 of the client 150. 156. At this time, the extracted file of the server 110 contains only the information of the group that is specified or satisfies the condition in step 200,
Only the information reflects the data of the server 110 (step 212).

Next, the synchronization history record 1 of the client 150
55 stores information that the groups specified or satisfying the conditions in step 200 are synchronized (step 21).
3), the synchronization process ends.

If it is not confirmed in step 208 that the extracted file created on the server 110 side has been completed in the storage device 111 of the server 110, the synchronization program 152 pre-specifies the extracted file within the timeout period. For example, if the process has returned to step 207 and the count has already exceeded (step 209), the group specified or satisfied in step 200 in the synchronization history record 155 of the client 150 is subjected to the synchronization process.
The information indicating that the extraction operation has been completed in step 50 is saved (step 215), and the synchronization processing ends.

Further, in step 211, the client 1
If it is not confirmed that the extracted file created on the server 110 side could be copied into the 50 storage devices 151, the process returns to step 210 if the synchronization program 152 specified beforehand and within the timeout period. The client 150 (step 214).
In the synchronization history record 155 of the server 1, the group specified or satisfied in step 200
The information that the extraction operation has been completed in step 10 is saved (step 215), and the synchronization processing ends.

FIG. 4 shows a database 1 in the server 110.
13 shows a flowchart of the server 110 in a process of synchronizing the data 116 of the T.13 with the data 156 of the database 153 in the client 150.

First, a database synchronization service is started by a user operation in the server 110 (step 30).
0).

Next, while there is no termination request by a user operation to the database synchronization service (step 3).
01), when the extracted file of the database 153 of the client 150 created in steps 202, 204 and 205 is copied to the database 113 of the server 110 and confirmed (steps 302 and 303), the extracted file of the copied client 150 is The contents are analyzed (step 304).

Next, as a result of the analysis, referring to the synchronization history record 155 in the client 150 performed in step 201, the data updated since the previous synchronization processing was performed is stored in the data 116 in the server 110. Are updated (step 305). Next, as a result of the analysis in step 305, the data in the group specified or satisfied in step 200 is referred to the synchronization history record 115 in the server 110 and updated after the previous synchronization processing with the client 150 is performed. The extracted data is extracted (step 306).

Next, the data extracted in step 306 is stored as an extraction file in the storage device 111 of the server 110 (step 307).

Next, the extracted file generated in step 307 is stored in the storage device 111 of the server 110 (step 308), and the process returns to step 301.

In step 303, steps 202 and 20
If it is not confirmed that the extracted file of the database 153 of the client 150 created in 4, 205 is copied to the database 113 of the server 110,
Return to step 301.

In step 301, when there is a termination request by a user operation to the database synchronization service, the database synchronization service is terminated.

According to the present embodiment, when the databases of both the server and the client are separately used, if only the specified data group is synchronized, the client side will have the minimum necessary data group or By synchronizing only data groups that satisfy the set conditions, the latest information on the target data can be obtained quickly.

According to the present embodiment, data that cannot be selected as a synchronization target in both the database of the server and the client can be later matched with the two databases, so that time can be used effectively. There is.

[0030]

According to the present invention, only a necessary part is synchronized by providing a means for grouping data in a database and a means for selecting a part of a group when performing a synchronization procedure. Therefore, it is possible to quickly obtain the latest information of the target data by synchronizing only the minimum necessary data group.

Further, according to the present invention, by providing a means for designating the condition of the target data at the time of performing the synchronization procedure, it is possible to synchronize only the data of the condition set in advance. The synchronization method for synchronization can be performed accurately, and the time for the synchronization process can be further reduced.

Further, according to the present invention, by providing a means for synchronizing only data that has not been targeted in the previous synchronization processing, both databases can be made identical later. Can be distributed freely.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a database synchronization system according to one embodiment of the present invention.

FIG. 2 is a first flowchart for explaining the operation of the embodiment on the client side.

FIG. 3 is a second flowchart describing the operation of the embodiment on the client side.

FIG. 4 is an exemplary flowchart for explaining the operation of the server according to the embodiment;

[Explanation of symbols]

110: server, 111: storage device, 112: synchronization program, 113: database, 114: database synchronization service, 115: synchronization history record, 116: grouped data in the database, 117: CP
U, 118: input device, 119: display device, 130: L
AN, WAN, or telephone line, 150 client, 151 storage device, 152 synchronization program, 15
3 ... database, 155 ... synchronization history record, 156 ... grouped data in the database, 157 ... C
PU, 158: input device, 159: display device.

Claims (3)

[Claims] 1. A method for synchronizing a plurality of databases in a system having a database of the same configuration in one server and a plurality of clients, wherein data in the databases is grouped and a synchronization procedure is performed. A data synchronization method comprising: selecting a part of a group, and synchronizing and synchronizing data of only a minimum necessary group between a server and a client. 2. The synchronization method according to claim 1, wherein a condition of whether or not to synchronize the database is set in advance, so that only a group of data satisfying the preset condition is synchronized. A data synchronization method, characterized in that: 3. The data synchronization method according to claim 1, wherein a group of data that is not selected as a synchronization target is stored, so that a group that is not synchronized is synchronized later. A data synchronization method characterized by being able to do.