JPH0325640A - Data base updating system - Google Patents

Abstract

PURPOSE:To update a data base without contradiction and to improve the reliability of an on-line processing system by checking the update history of the data base. CONSTITUTION:A data base updating system is equipped with a host computer 1, terminal equipment 2, data base 3, data base information retrieving means 10, retrieved data base display means 20, data base update history information saving means 21, update data base information retrieving means 30 to retrieve data base information desiring to be updated, data base update history check means 40 to execute the matching of the data base update history, data base information updating means 50 and reprocessing instructing and informing means 60. Thus, the update history of the referred data base information is sampled and matching is executed between the sampled update history and update history already provided in the above mentioned data base. Then, the data base information are updated and the data base can be updated without the contradiction.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a method for referencing and updating database information of a host computer in an online processing system.

[Conventional technology]

The method of updating database information on a host computer in a conventional online processing system is as follows: (1) Search for database information to be updated in advance, and display the searched database information on a terminal device.

(2) Then, input the information to be changed from the terminal device, search again for the database information to be updated, replace the searched database information with the change information input from the terminal device, and store it in the database.

This is an update method.

[Problem to be solved by the invention]

In the conventional database information update method described above, if the database information has already been updated at the timing of updating the database information, if the process is executed as is, the updated result will not necessarily be stored in the database with the contents intended by the user. The disadvantage is that it is not possible.

In addition, in order to prevent this inconsistency, it is necessary to individually check whether the searched database information has already been updated, which poses the problem of complicating program creation and increasing the number of man-hours required for program creation. be.

SUMMARY OF THE INVENTION An object of the present invention is to provide a database update method that eliminates the above-mentioned drawbacks and problems, allows database updates to be performed without contradiction, and can be easily incorporated when creating a program.

[Means to solve the problem]

The structure of the database update method of the present invention is an online processing system that includes a host computer and a terminal device, and in which the database of the host computer is referenced and updated from the terminal device. The information processing apparatus is characterized in that it includes means for collecting information, and means for matching the collected update history with update history already stored in the database to update the database information.

〔Example〕

Next, the present invention will be explained with reference to the drawings.

FIG. 1 is a schematic diagram showing the structure of an embodiment of the present invention.
2 is a host computer, 2 is a terminal device, 3 is a database, 10 is a database information search means, 20 is a search database display means for displaying the database information searched by the database information search means 1, 2l is a database update history information saving means, 30 4 is an update database information search procedure for searching database information to be updated;
Reference numeral 0 indicates a database update history check means for matching database update history, 50 indicates a database information update means, and 60 indicates a reprocessing instruction notification means.

In this embodiment, first, the database information search means 10 searches for database information requested by the terminal device 2 . At this time, the update history of the searched database is collected.

Next, in a search database information display procedure 20, information is displayed on the terminal device 2. At this time, the searched database update history is saved by the database update history information saving means 21.

The search database information display means 20 receives change information from the terminal device 2 displaying the database information in an update database information search procedure 30, and searches for database information to be updated.

Next, the database update history means 40 compares and determines the current update history of the database to be updated with the update B history information saved by the database update history information save means 21, and if the update histories match, the database Control is passed to the information updating means 50 to actually update the database.

If the database update history checking means 40 does not match the update histories, control is passed to the reprocessing instruction notifying means 60 and a reprocessing instruction is displayed on the terminal device 2.

〔Effect of the invention〕

As described above, the present invention has the effect of improving the reliability of an online processing system by checking the update history of the database and updating the database without causing any discrepancies.

[Brief explanation of drawings]

FIG. 1 is a schematic diagram showing the structure of an embodiment of the present invention. 1...Host computer, 2...Terminal device, 3...Database, 10...
・Database information search means, 20... Search database information display means, 21... Database update history information saving means, 30... Update database information search means, 40... . . . Database update history checking means, 50 . . . Database information updating means, 60 . . . Reprocessing instruction notification means.

Claims (1)

[Claims] In an online processing system that includes a host computer and a terminal device, and that refers to and updates a database of the host computer from the terminal device, means for collecting an update history of the referenced database information, and a means for collecting the update history of the referenced database information, A database update method characterized by comprising means for updating database information by performing matching with an update history held in the database.