JPH0452736A - Inter-data base matching control system - Google Patents

Abstract

PURPOSE:To attain an economical maintenance system where no time/labor is needed for updating data by adding an auxiliary storage to the optional one of plural work stations and receiving the updating information via the auxiliary storage when the contents of the data bases are updated by those work stations. CONSTITUTION:The work stations 1 and 2 contain the data bases 4 and 5 of the same contents and are connected to each other via a communication circuit 3. An auxiliary storage 8 is added to one of both stations 1 and 2 and available to both stations. Then one of both stations 1 and 2 updates the contents of both bases 4 and 5 and stores the updating information into the storage 8. Thus the other work station receives the updating information via the storage 8 and updates its own data base. Then it is possible to obtain an inter-data base matching control system that requires no time/labor for the data updating maintenance.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to a consistency control method between a plurality of databases,
In particular, it relates to a consistency control method between multiple databases via communication lines.

[Conventional technology]

In the conventional consistency control method between multiple databases, in order to manage each workstation that has a database with the same content, updates consisting of update data related to new registrations and revisions, and information necessary for this update work are used. Information was stored on movable media, transported to each workstation, and coordinated.

[Problem to be solved by the invention]

The above-mentioned conventional consistency control method between multiple databases stores update information consisting of updated data and information necessary for this update on a movable medium every time update work such as new registration or revision is performed. However, since the work for transporting and matching the parts to each workstation is carried out, there is a problem in that it requires a very large amount of time and man-hours for movement, matching work, etc. until the matching is done.

An object of the present invention is to enable other workstations to know the contents of database update work performed on each workstation, and to perform consistency control online, thereby saving time and effort in maintenance for data updates. Its purpose is to provide a consistency control method between multiple databases.

[Means to solve the problem]

The consistency control method between a plurality of databases according to the present invention includes a plurality of workstations having databases with the same content and connected through a communication line, and a plurality of workstations attached to any one of the plurality of workstations. an auxiliary storage device that can be used from a workstation, and when one of the plurality of workstations updates the contents of the database and stores the updated information in the auxiliary storage device, the other plurality of workstations update the contents of the database and store the updated information in the auxiliary storage device. The configuration is such that the update information is received through the server and the database of the server itself is updated.

[Example] Next, an example of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of one embodiment of the present invention.

The workstation 1.2 is connected via a communication line 3 and controls databases 4 and 5, and an optical disk 6.7 that stores update history data including update data when the database is updated. . Further, the workstation 2 controls the auxiliary storage device 8. Workstation 1 can control auxiliary storage device 8 via workstation 2 .

FIG. 2 is a diagram showing the structure of update information to be stored in the auxiliary storage device.

The matching request source terminal address 9 indicating the location of the updated workstation, the matching request destination terminal address 10 indicating the location of the workstation controlling the auxiliary storage bag W8, the matching target database name 11, the update order 12, and the update Update information 15 is composed of content 13 and update history data 14 including update data.

Next, the operation will be explained.

When the operator operates the workstation 1 to update data in the database 4, update history data 14 containing the updated data is written to the optical disk 6. Next, in the workstation 1, in order to transfer the update history data 14 containing this update data to other databases for updating and consistency, the update information 15 consisting of information necessary for update work is transferred. The data is created and transferred to the auxiliary storage device 8 via the communication line 3 and workstation 2. The auxiliary storage device 8 stores the received update information 15 as a management information file. The workstations 2 other than the workstation 1 read the management information file in the auxiliary storage device 8 as appropriate, write the update information 15 to the optical disk 7, and thereafter write the matching target database name 11 and update order 12 obtained at this time. Then, the database 5 that it controls is updated by referring to the update contents 13 and the update history data 14 including the update data.

Although only two workstations are displayed in this embodiment, it is clear from conventional technology in this field that even three or more workstations can be controlled mutually via communication lines. However, this is omitted because it is not an important matter in the present invention.

〔Effect of the invention〕

As explained above, the present invention adds an auxiliary storage device to any one of a plurality of workstations, and when the plurality of workstations updates the contents of a database, the updated information is sent via this auxiliary storage device. By receiving this information, other workstations can also know the details of the database update work performed on each workstation, and consistency control can be performed online, reducing the time and effort required to update data. This has the effect of making economical maintenance possible.

[Brief explanation of drawings]

FIG. 1 is a block diagram of an embodiment of the present invention, and FIG. 2 is a diagram showing the structure of update information to be stored in an auxiliary storage device. 1.2...Workstation, 3...
・Communication line, 4.5...Database, 6,7
...Optical disk, 8... Auxiliary storage device, 9 ... Matching request source terminal address, 10
・・・・・・Terminal address of matching request destination, 11...
...Name of database to be matched, 12...
Update rank, 13... Update content, 14...
・Update history data, 15... Update information. Agent Patent Attorney Oto Uchihara Figure 1 Figure 2

Claims (1)

[Claims] comprising a plurality of workstations having databases with the same content and connected through communication lines, and an auxiliary storage device attached to any one of the plurality of workstations and usable from the plurality of workstations, When one of the plurality of workstations updates the contents of the database and stores the updated information in the auxiliary storage device, the other plurality of workstations receive the updated information via the auxiliary storage device and store the updated information in their own database. A consistency control method between multiple databases that is characterized by updating.