JPH0573391A - Data base update system - Google Patents

Abstract

PURPOSE:To facilitate the abnormal update processing of a data base and to prevent double update when error data is inputted again. CONSTITUTION:A data base A update part 3 and a data base B update part 4 updates respectively corresponding data in a data base A6 and a data base B7 with data read in by a data read part 2, but if the data are abnormally updated, the data are supplied to an error file writing part 5, which adds a discrimination symbol indicating an abnormality generation source and stores the data in an error file 8. When the error is inputted again, the error file 8 is utilized.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database updating system.

[0002]

2. Description of the Related Art In a conventional database updating method, as shown in FIG. 2, data 21 is read by a data reading unit 22, and a database A updating unit 23 and a database B updating unit 24 correspond to a database 25 and a database 26, respectively. We are updating the data.

When an abnormality occurs due to defective data or the like, the processing history is examined and the data at the time of the abnormality is extracted from the data 21 and re-input to the data reading unit 22 to perform the abnormality processing. Are doing.

[0004]

The above-mentioned conventional database update method is used when defective data or abnormal update occurs.
There is a disadvantage that the data at the time of abnormality must be searched out from the data 21 which is the original data.

In the case of updating a plurality of databases as shown in FIG. 2, when the database A25 is normally updated by the database A updating section 23 and the database B26 is abnormally updated by the database B updating section 24. In addition, if the relevant data is re-input at the time of abnormality again, the database A2 should have been updated normally.
5 will be updated again by the database A updating unit 23, which has the drawback of double updating. In order to avoid such inconvenience, there is a drawback in that a dedicated data reading section must be prepared for each of the plurality of databases as shown in FIG.

An object of the present invention is to provide a database updating system which can easily carry out an abnormal process by holding data at the time of abnormal updating of a database.

[0007]

The database updating method of the present invention comprises a first storage means for storing a plurality of first type data and a second storage means for storing a second type data. , The data reading means for reading data from the outside or the second storage means, and the corresponding data in the first storage means are updated in response to the supply of the data from the data reading means, and the data is supplied during the abnormal update. It comprises an updating means for outputting the data as the second type of data, and a writing means for receiving the supply of the second type of data from the updating means and storing it in the second storage means.

[0008]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a database updating system of the present invention.

In FIG. 1, data 1 indicates a magnetic tape or the like on which original data is recorded. The data reading unit 2 reads the data 1 and supplies it to the database A updating unit 3 and the database B updating unit 4.

The database A update unit 3 is a database A
6 for updating the data, and updates the database A6 based on the data supplied from the data reading unit 2. When an abnormality occurs, the data supplied to the database A updating unit 3 at that time is supplied to the error data writing unit 5 as error data when the abnormality occurs.

The database B updating unit 4 is a database B.
7 for updating data, and the function thereof is the same as that of the database A updating unit 3.

The error data writing unit 5 writes the supplied error data in the error file 8.

The error file 8 stores error data, that is, data when the database is abnormally updated, and is used for re-input at the time of abnormal processing.

Next, an embodiment will be described with reference to FIG.

The data reading unit 2 reads the data 1 recorded on a magnetic tape or the like and supplies it to the database A updating unit 3 and the database B updating unit 4, respectively.

With regard to the updating operation, the updating operation of the database A6 by the database A updating section 3 and the updating operation of the database B7 by the database B updating section 4 are the same, so the updating operation of the database A6 will be described.

The database A updating unit 3 refers to the data of the database A6 corresponding to the data supplied from the data reading unit 2 and updates it. Then, it is checked whether it has been updated normally, and if it is normal, database A
Write the updated data in 6. In the case of abnormality, the data supplied from the data reading unit 2 is transferred to the error data writing unit 5
Supply to.

The error data writing unit 5 adds the identification symbol of the supply source to the supplied data and adds it to the error file 8
Write to. That is, for example, the identification symbol A is added to the data supplied from the database A updating unit 3 and the identification symbol B is added to the data supplied from the database B updating unit 4, and the error file 8 is written.

In this way, only the data at the time of the abnormal update is stored in the error file 8 together with the identification symbol indicating the abnormal source.

At the time of re-input of error data, the error file 8 is read from the data reading unit 2 as an input source and supplied to the database A updating unit 3 and the database B updating unit 4. The database A updating unit 3 checks the identification symbol. If the identification symbol is A, the updating operation of the database A6 is performed, and if the identification symbol is B, this data is invalidated. The database B updating unit 4 starts the updating operation only when the identification symbol is B.

When the number of databases is one and not one, it is not necessary to add an identification mark.

[0023]

As described above, according to the database updating method of the present invention, error data can be retained in a file and used when reloading the error data, whereby abnormal processing can be easily performed. Further, by adding the identification symbol of the error source to the error data, it is possible to prevent double update at the time of re-input.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a database updating system of the present invention.

FIG. 2 is a block diagram showing an example of a conventional database updating method.

FIG. 3 is a block diagram showing another example of a conventional database updating method.

[Explanation of symbols]

 1, 21, 31, 35 data 2, 22, 32, 36 data reading unit 3, 23, 33 database A updating unit 4, 24, 37 database B updating unit 5 error data writing unit 6, 25, 34 database A 7, 26,38 Database B 8 Error file

Claims (2)

[Claims] 1. A first storage means for storing a plurality of first-type data, a second storage means for storing a second-type data, and data from an external or the second storage means. A data reading means for reading, and an update for receiving the data from the data reading means and updating the corresponding data in the first storage means, and outputting the supplied data as a second type of data at the time of abnormal update A database updating method comprising means and writing means for receiving a second type of data from the updating means and storing it in the second storage means. 2. The apparatus according to claim 1, further comprising a plurality of first storage means and respective corresponding update means, wherein the writing means receives the second type data from the plurality of update means, respectively. An identification symbol for identifying the supply source is added and stored in the second storage means, and when the updating means receives the supply of the second type data with the identification symbol, only the corresponding updating means performs the update operation. A database updating method characterized by performing.