JPH0573392A - Data base update system - Google Patents

Abstract

PURPOSE:To prevent double update when a data base is updated and to update the data base with efficiency by controlling input data. CONSTITUTION:A serial number control part 2 which reads input data 1 in compares with the contents of a serial number storage part 3. When the comparison result shows that the data is already processed, the data is skipped and when there is a serial number omission, the processing is stopped. When consistency is obtained, an update processing part 4 updates the data base 5.

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 the conventional database update method, when an update failure occurs during update, input data is re-edited again to eliminate double update and read again from the beginning. Then, it is supposed to be updated.

[0003]

The conventional database update method is inefficient because the input data needs to be edited again in the case of an update failure as described above. There is a drawback that the input data of the file is read.

An object of the present invention is to provide a database update method capable of efficiently inputting the input data without re-editing it in the case of an update failure, effectively preventing double update, and performing failure recovery processing. To provide.

[0005]

A database updating method of the present invention includes a database for storing a plurality of data, an updating processing means for updating the data in the database, and file name information of the latest updated data. The serial number storage means for storing serial number information and the input data including a series of serial number information and file name information in the file are supplied to the serial number storage means for the file name information and serial number information of this data. It comprises a serial number management means for comparing the stored file name information with the serial number information and performing a process corresponding to the comparison result.

[0006]

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.

The database updating method of this embodiment is shown in FIG.
As shown in, input data 1 realized by a magnetic tape, a magnetic disk, etc., a serial number storage section 3 for storing the file name and serial number of the input data 1, and the input data 1 are read, and the file name and serial number are read. The serial number management unit 2 manages data consistency and the like by comparing the file names and serial numbers stored in the serial number storage unit 3, the database 5, and the update processing unit 4 that updates the database 5.

Here, the file name is the name of the file in which the data is stored, and the serial number is a series of serial numbers sequentially assigned to all the data stored in the file.

In the above configuration, the serial number management unit 2 inputs the input data 1 and compares it with the file name and serial number in the serial number storage unit 3. If the file names are the same and the serial numbers are consistent (in this case, one larger than the serial number stored in the serial number storage unit 3), it is determined as "normal" and the input data 1 is updated by the update processing unit. 4 and stores the file name and serial number in the number storage unit 3.

If the file names are the same and the file numbers are equal to or lower than the serial number in the serial number storage unit 3, it is judged as "processed". If the file names are the same and are larger than the serial number in the serial number storage unit 2 by 2 or more, there is a missing serial number and it is determined as "abnormal". Also,
Even if the file name is different from the serial number storage unit 3, it is determined as "abnormal".

In the case of "normal", the update processing unit 4 is activated,
In the case of "processed", the serial number management unit 2 invalidates the input data and reads the next input data, and in the case of "abnormal", stops the process.

The update processing unit 4 updates the database 5. When there is no input data, the serial number management unit 2 initializes the serial number storage unit 3.

A specific example will be described with reference to FIG.

As input data 1, there are data having a file name "A" and serial numbers "112", "113", and "115", respectively, and the serial number storage unit 3 has a file name "A" and a serial number "112". The operation when stored is explained. This corresponds to the case where the data “A, 112” has been processed and an update failure occurs in the data “A, 113” and the data is re-input for recovery.

The serial number management unit 2 inputs the input data 1 in the serial number order,
First, the data of the file name "A" and the serial number "112" is read. The serial number management unit 2 compares it with “A, 112” in the serial number storage unit 3 and determines that it is “processed”. Then, the serial number management unit 2 reads the next data “A, 113”, compares it with the value in the serial number storage unit 3, judges that it is “normal” because there is consistency, and passes this data to the update processing unit 4, The serial number “113” is stored in the serial number storage unit 3.

The update processing unit 4 updates the database 5. Then, the serial number management unit 2 reads the next data "A, 115", compares it with "A, 113" in the serial number storage unit 3, determines that it is "abnormal", and stops the processing.

[0018]

As described above, according to the database updating method of the present invention, when re-inputting the input data for restoration, it is not necessary to consider the "processed data" and edit the input data as it is. It can be input, double update can be prevented and database update can be performed efficiently, and since the consistency of the file name is checked, the database is updated accurately without accidentally inputting another file. The effect is that you can.

[Brief description of drawings]

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

[Explanation of symbols]

 1 Input data 2 Serial number management unit 3 Serial number storage unit 4 Update processing unit 5 Database

Claims (3)

[Claims] 1. A database for storing a plurality of data, an update processing means for updating the data in the database, a serial number storage means for storing file name information and serial number information of the latest updated data, and a file. In response to the supply of input data including a series of serial number information and file name information, the file name information and serial number information of this data are converted into file name information and serial number information stored in the serial number storage means. A database update method comprising: a serial number management means for performing comparison and processing corresponding to the comparison result. 2. The serial number management means according to claim 1, when the comparison result is the first, the serial number of the serial number storage means is updated and the input data is output to the update processing means, and the comparison result is the second.
In the case of, the input data is invalidated as processed data, and when the comparison result is the third, it is judged as abnormal and the processing is stopped. 3. The method according to claim 2, wherein the first case has the same file name information and the serial number information of the input data is larger than that of the serial number storage means by 1, and the second case has the same file name information. When the serial number information of the input data is lower than that of the serial number storage means, and in the third case, when the file name information is different and when the file name information is the same, the serial number information of the input data is larger than that of the serial number storage means by 2 or more. A database update method characterized by: