JPH08263345A - Data base updating management method - Google Patents

Abstract

PURPOSE: To secure the matching of information between the work stations and a data base by adding the version information to the management information on both work stations and data base and then collating the version numbers of the work stations and the data base with each other periodically or in an updating state of the version number in a simple method. CONSTITUTION: A data base system consists of a data base 4 and the work stations 1 and 2 which have accesses to the base 4 via a network 3. Then the dictionary version information 13 and 23 which manage the version numbers in an updating state are supplied to the data base system together with the data base management information 43. In such a constitution, the version numbers of the work stations and the base 4 are collated with each other periodically or in an updating state of the version number for matching of them. Thus the matching of information is always secured between the work stations and the data base. Then the data base 4 can be retrieved with no error.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database update management method, and in particular, in a distributed data system, when updating the contents of a database from each workstation, it is necessary to match the information between the workstation and the database side. Regarding update management method.

[0002]

2. Description of the Related Art Conventionally, this type of database update management method transfers the updated dictionary information to each workstation when the database is updated,
Each workstation updates the dictionary information held therein to match the dictionary information. FIG. 3 is a block diagram showing the configuration of this conventional example.

In FIG. 3, first, the workstation 6
When the dictionary information 62 required for accessing the database is viewed with and the information required for the update processing is registered, the processing unit 61 generates update control data and transfers this control data to the database 9 via the network 8. It The control data received by the database 9 is decrypted by the processing unit 71,
Update the database body 92.

When the database updating process ends normally, a normal end notification and the updated dictionary information of the database body 92 are transferred to the workstation 6.

Further, the updated dictionary information is also transferred to other workstations 7. Each workstation writes the transferred dictionary information in the dictionary information 62, 72, and thereby the databases of each workstation and the database 9 can be matched.

The dictionary information is index-like information necessary for indexing the contents of the database, and when updating, this information may be updated at the same time as the contents are updated.

[0007]

As described above, in the conventional method, since the dictionary information on the workstation side is updated unilaterally by the update information from the database side,
If the workstation is stopped at the time of updating the database or if a line failure occurs, the dictionary information for this workstation is not updated and there is a problem that the dictionary information between the database and the workstation cannot be consistent.

Further, there is a problem that it is not possible to know that the dictionary information is not consistent on each workstation side.

[0009]

A database update management method of the present invention transfers update information and a version number relating to an updated part from a request source workstation that updates the database to the database, and the database updates the version number. And the version number on the database side are compared, and if they match, the database is updated with the update information and at the same time the version number is incremented by 1 and update completion information is transferred to all workstations including the request source workstation. If they do not match in the comparison, the update difference information and the database side version number are transferred to the request source workstation, and the request source workstation receives its update difference information and the database side version number. Possess At the same time as updating the written information and the version number, this abnormality is notified to the maintenance person, and even when the update completion information is received, the dictionary information and version number held by itself are updated, and other workstations update the update. When the completion information is received, the previous version number of the database side version number is compared with the own version number, and if they match, the held dictionary information and the version number are updated. This is a method of notifying the guardian of an abnormality.

Further, each of the workstations transfers its own version number to the database in a predetermined cycle, and the database receives the transfer and compares the version number with the version number to be held and responds with the matching / mismatching information. A method of returning to the workstation and updating the dictionary information and version number held by the workstation according to this information may be added to the workstation.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT An embodiment of the present invention will now be described with reference to the drawings. FIG. 1 is a block diagram showing the configuration of this embodiment, and FIG. 2 is a flow chart showing the update processing method in FIG.

In FIG. 1, two workstations 1 and 2 are connected to a database 4 via a network 3, and each workstation has a processing unit 11, dictionary information 12 and dictionary version information 13. are doing. Further, the database 4 has a processing unit 41, a database main body 42, and database management information 43.

The database body 42 in the database 4
Stores the database itself, and the database management information 43 stores the database version number (database version number) and dictionary information corresponding to the database version. The dictionary information for accessing the database main body 42 is stored in the dictionary information in each workstation, and the dictionary version number of the dictionary information is stored in the dictionary version information.

Next, referring to FIG. 2, the workstation 1
An update processing method for updating the database 4 will be described. The processing unit 11 searches the dictionary information 13 and adds the update information, and also searches the dictionary version information 14 to acquire the dictionary version number. The update information and the dictionary version number are transferred to the database 4 via the network 3 (step A1).

Upon receiving the update information and the dictionary version number, the processing unit 41 in the database 4 retrieves the database version number from the database management information 43 and compares it with the dictionary version number transferred from the workstation (A2).

If the comparison results match, the processing unit 41
Updates the database body 42 from the workstation with the update information. Furthermore, the database management information 43
The database version number is incremented by +1 and the dictionary information is stored (A3). Then, the dictionary information after the database update and the database version number are transmitted to the workstations 1 and 2. In particular, the normal termination notification is also transmitted to the workstation 1 (A4, A5).

The workstation 1 receiving this data updates the dictionary information 12 and the dictionary version number.
Also, the workstation 2 uses the dictionary version information 2
3 is searched and compared with the database version number transferred from the database 4 (A7). If the version number of the dictionary version information 23 is a number before counting up, the version number is counted up and the dictionary information is updated at the same time (A8). If the version number is not the number before counting up, the dictionary information 4 is abnormal, and the maintenance person is notified (A10).

On the other hand, the version numbers are compared in the database 4 (A2), and if they do not match, the processing section 41 does not update the database body 42. Also, the database version number of the database management information 43 is not counted up, and the difference of the dictionary information is transferred to the requesting workstation 1 together with the latest database version number (A9).

Upon receiving this data, the requesting workstation 1 judges that the dictionary information 12 in the workstation is not the latest, notifies the maintenance person of the abnormality, and updates the dictionary information with the difference information (A10). It should be noted that the requesting workstation 1 makes a renewal request (A1) after matching the database side by this operation.

Next, in order to further ensure the version matching between the workstation and the database, apart from the above-mentioned updating, a checking method that is regularly performed will be described. Each workstation periodically transfers the dictionary version number to the database 4, the database side compares the version numbers, and when an abnormality is detected, the difference between the dictionary information and the latest version number is sent to the requesting workstation. To transfer. The requesting workstation that received the above data determines that the dictionary information in the workstation is not the latest, updates the version number and the dictionary information, and at the same time notifies the maintenance person of the abnormality.

[0021]

As described above, according to the database update management method of the present invention, the dictionary version information is added to the workstation side and the database side, and this version information is compared and confirmed by a simple method when updating or periodically. Therefore, there is an effect that the consistency of information between each workstation and the database side is always secured and a highly reliable database system can be provided.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention.

FIG. 2 is a flowchart showing an update processing method in FIG.

FIG. 3 is a block diagram showing a configuration of a conventional example.

[Explanation of symbols]

 1, 2 workstations 3 network 4 database

Claims (2)

[Claims] 1. A transfer source of update information and a version number relating to an updated portion from a requesting workstation which updates the database, and the database compares the version number with the version number on the database side, and if they match, The database is updated with the update information, and at the same time, the version number is incremented by 1, the update completion information is transferred to all the workstations including the request source workstation, and if there is no match in the comparison, it is updated to the request source workstation. When the difference information and the version number on the database side are transferred, and the requesting workstation receives the update difference information and the version number on the database side, it updates the dictionary information and version number held by itself, and at the same time Anomaly Is also notified to the maintenance person, and when the update completion information is received, the dictionary information and version number held by itself are updated, and when the other workstations receive the update completion information, the version on the database side is updated. It is characterized by comparing the previous version number with its own version number and updating the dictionary information and version number it holds if they match, and notifying the guardian of this abnormality if they do not match. How to manage database updates. 2. Each of the workstations transfers its own version number to the database in a predetermined cycle, and the database receives the transfer and compares the version number with the stored version number to respond to the information of matching / mismatching. 2. The database update management method according to claim 1, wherein the database is returned to the workstation, and the workstation updates its own dictionary information and version number in accordance with this information.