JP2005284474A - Data input device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data input device having a verification mode, which automatically prepares a document file for objectively determining the reliability of verified data, and enhances work efficiency of verification second time onward by using the document file. <P>SOLUTION: This data input device is characterized in that when the contents of data prepared by verification is different from existing data which is reference data, identification information of data with the difference is written as an updating record in a log file, and that when performing verification second time onward, the updating record prepared by the last verification is read from the log file, and only the updated data is used for verification. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a data input device having a verify mode.

Conventionally, a data input device having a verify mode has been used for inputting highly important data such as customer data and questionnaire survey data having a certain amount or more. In the data input device, a plurality of data items included in one customer data or one questionnaire are combined into one record, and the data file is organized by combining the records. In the verify mode of the data input device, input data is read as reference data, and the verify input and reference data are compared for each data item. At this time, since the reference data is not presented to the operator, it is determined that the data has been input correctly if the verification data input by the operator matches the reference data. If the verification input of a data item is different from the reference data, a dialog screen will be displayed and you will be prompted to select whether to use the current verification input as correct data or re-enter . The operator compares his / her verification input with the original data recorded in the customer list and survey form, and if it is confirmed that his / her input is correct, the operator corrects the data by using the data that has been verified.

Verify has the potential to significantly improve the quality of the data. However, the data quality improvement effect of verification depends on the honesty and politeness of the operator. If the operator responds to the modification dialog to accept his input without checking the accuracy, the quality may even be corrupted. With a normal data input device, there was no means for the data input manager or orderer to know whether or not the operator performed verification in good faith. As a result, in order to increase the reliability of verification, a method of performing verification again or more times is taken, and much labor is spent for that.

In order to improve the efficiency of the second and subsequent verification operations, a method of verifying only data that has been corrected at the previous verification can be considered. For example, in Patent Document 1, when re-verifying, the data of the “entry file” created at the time of verification is compared with the data of the “entry backup file” created based on the data before update, and only the data that is different is compared. It has been proposed to verify. The method disclosed in Patent Document 1 has problems such as a special “entry backup file” and a method for performing the third and subsequent verifications are not provided. In addition, the method of this document has a problem that no consideration is given to providing a material that can determine the reliability of verification.
JP 2000-293299 A

Improving the quality of input data through verification depends on the integrity and politeness of the input operator, and verification does not necessarily increase the quality and reliability of the data. In conventional data entry devices, data entry managers and orderers are not provided with materials that objectively determine whether the input operator has worked in good faith and whether the reliability of the verified data is high. There was a problem. In order to solve this problem, an object of the present invention is to automatically create an update record of verified data and provide it as a document file for objectively determining the reliability of verification work. Another problem is to enable only the data updated using the update record created in the previous verification to be verified in order to improve the efficiency of the second and subsequent verification operations. It is.

The invention claimed in this application is as follows.
(1) In a data input device having a verify mode, when the content of a data item in a record is modified compared to the existing data that is the reference data, A data input device, wherein the record identification information of the corrected data item and the data item identification information are written in a log file as an update record.
(2) When the contents of a data item in a record are modified, the modified data changes are logged as an update record in accordance with the record identification information and the data item identification information of the modified data item. The data input device as described in (1) above, wherein the data input device is written in a file.
(3) Compared with existing data whose data created by verification is compared with existing data, or when an existing record is deleted, the added or deleted record The data input device according to (1) or (2) above, wherein the record identification information is written as an update record in a log file.
(4) A data input device having a verify mode, in which the update record created by the previous verify is read from the log file when performing the second and subsequent verifications, and only the updated data is to be verified. The data input device as described in (1), (2) or (3) above.

  In the present invention, since an update record indicating the data update process is automatically created as a log file at the time of verification, the input operator is requested to perform work more psychologically and carefully. Further, the data input manager and the orderer can use this log file as a material for objectively judging the reliability of the data. For example, the administrator can confirm whether the correction has been made in the correct direction or in the wrong direction by comparing the correction result of the data item recorded in the log file with the original data. If it is determined that sufficient quality has been achieved by the update record, the verification operation can be completed with only one verification. When it is determined that the second and subsequent verifications are necessary, the update record immediately before being recorded in the log file is used to verify only the updated data, thereby greatly reducing the work. Can do. This procedure can be repeated as many times as necessary, and the problem of Patent Document 1 that cannot cope with the third and subsequent verifications is solved. In addition, if no update occurs in the second and subsequent verifications, it is possible to objectively confirm that the complete verification has been performed using the log file. Can be stored.

FIG. 1 is a block diagram showing a schematic configuration of an embodiment of the present invention. The apparatus of this embodiment comprises a data processing device 1 incorporating a data input program 5, a monitor-2, a keyboard 3, and an external storage device 4. The data input program accepts data input from the keyboard in accordance with the input format for each data item specified in the input data format 6 read at startup, and holds it in the data buffer 7 as input data.
FIG. 2 shows that the data input program 5 of the present embodiment has three different data input modes: an initial input mode, an initial verify mode, and a re-verify mode. In each mode, the data input program 5 is externally stored. The situation where the file of the device 4 is read and written is shown. All subsequent verifications are performed in re-verify mode.

Input data 7a created in each mode is output as a data file 4a. The data file is named “abc.dat” in this example.
In the verify mode, the data file created immediately before is read as the reference data 7b regardless of whether the verification is the initial verification or the re-verification. When the verification is completed, the input data 7a is output as a new data file. However, since there is an existing data file with the same name, rename the existing data file as a backup file 4b with a name that allows generation management. Output a new data file. In this embodiment, the backup file is named by adding a number representing the generation at the end of the extension, such as “abc.bak1”, [abc.bak2], and manages the generation of the backup file.

In the verify mode, regardless of whether the verification is the initial verification or the re-verification, if data different from the reference data 7b is input when data is input, a dialog is displayed and the data is different from the reference data. Check whether the data is officially adopted. When data different from the reference data is finally adopted, an update record 7c is created and output to the log file 4c.
In the re-verify mode, the update record at the last verification is read from the log file as the previous update record 7d. The data input program controls the display of records, the display of data items, and the reception of input data so that only the data updated last time is input. Data other than the previously updated data is copied from the reference data 7a to the input data 7b.
In addition to the data update record, the log file of this embodiment also records general work records 5a such as work start and end times, worker identification names, etc., as general work management data Is also available.

FIG. 3 shows the contents of the initial input data file, and FIG. 4 shows the contents of the data file created by the first verification. The data file of this example is created in a format called CSV (comma separated values). In this method, the data item names are enumerated on the first line, separated by commas, the data items on the second line are separated by commas in the order of the data item names on the first line, one record per line. Enumerated.

FIG. 5 shows an example of a log file. The serial number at the left end of the figure is a line number for explanation. In this log file, not only update records at the time of verification but also general work records since the start of input work are recorded. Lines 8 to 14 and 19 to 20 are update records, and the rest are general work records. In this log file, records from initial input to initial verification, secondary verification, and completion of verification are recorded in a write-once format. If secondary verification is required after the secondary verification, the record is appended to the same log file. Note that the mode used for the second and subsequent verifications is always the re-verification mode, but on the recording, the order of verification is specified.

In the update record of the log file in FIG. 5, one data update is recorded per line. Data update types include record addition, deletion, and data item correction, and the update type is written at the top of each line of the update record, such as “add”, “delete”, and “correct”. As will be described later, the type of update can be distinguished from how to write record identification information and data item identification information, but by specifying in this way, the readability of the document is enhanced.
In addition to the type of data update, the update record in FIG. 5 is composed of record identification information in the case of addition / deletion of records, and in the case of correction of data items, record identification information, data item identification information, and data Consists of changes.

In the update record of FIG. 5, a record number is used as record identification information. Among the record numbers, the parentheses “()” enclose the old record number of the data file before the update as reference data, and the bare record number is the new record number of the new data file. As record identification information, only the new record number is recorded in the added record, only the old record number is recorded in the deleted record, and the old and new record numbers are recorded in the data item. The record has been modified. According to line 10 of the log file, the second record of the reference data was deleted during verification. This is why there is no record corresponding to the updated data file in FIG. The 14th line of the log file indicates that a record with record number 4 has been added. This is why there is no corresponding record in the data file after the initial input in FIG.

In the update record of FIG. 5, the data item name is used as identification information of the updated data item. The description on the 11th line of the log file indicates that the content of the “sex” data item is corrected from “female” to “male” in the first record and the record that is the first in the reference data. In the 12th and 13th line of the log file, the “Age” data item is modified from “53” to “58” in the record No. 3 and the record No. 4 in the reference data, and the “Name 1” data item is It is recorded that it was corrected from “Yamashita” to “Yamagami”.
According to the log file of FIG. 5, it is recorded that secondary verification was performed and no data was updated at that stage (19th and 20th lines). In the secondary verification, the re-verification mode is used, and only the data items updated in the primary verification are subjected to verification. That is, “sex” of the first record, “age” and “name 1” of the third record, and all items of the fourth record which is a record added thereto are verified. In the re-verify mode, the data input program 5 displays only the corresponding record and performs control so that only the corresponding data item becomes the input item. Data items that are not subject to verification in the re-verify mode are copied from the reference data to create input data.

Since it is rare to add a new record or delete an existing record during verification, the function of adding or deleting a record can be omitted. That is, an update record composed only of record identification information is not essential.
In the correction of the data item, if there is record identification information and data item identification information, it is possible to confirm what kind of content has been changed as a result of the correction by referring to the data file. That is, it is not indispensable to describe the change contents of the data item in the log file in the correction record.

In the ISO9000 series, which is an international standard for quality management, "quality record management" is an important element of the quality management system. The log file of the update record automatically created by the data input device of the present invention can be used as a strict quality control record.

The block diagram which shows the outline of a structure of an Example. The figure which shows reading and writing of the file by a data input program. The figure which shows the content of the data file of initial input. The figure which shows the content of the data file created by verification. The figure which shows the content of a log file.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Data processing device, 2 ... Monitor, 3 ... Keyboard, 4 ... External storage device, 4a ... Data file, 4a1 ... Data item name, 4a2 ... Individual record, 4b ... Backup file, 4c ... Log file, 5 ... Data input Program, 5a ... General work record, 6 ... Input data format, 7 ... Data buffer, 7a ... Input data, 7b ... Reference data, 7c ... Update record, 7d ... Previous update record.

Claims (4)

A data input device that has a verify mode. When the content of a data item in a record is modified compared to the existing data that is the reference data, the data input device has been modified. A data input device characterized by writing record identification information and data item identification information of a data item to a log file as an update record. When the contents of a certain data item in a record are modified, the modified data changes are written to the log file as an update record in accordance with the record identification information and the data item identification information of the modified data item. 2. The data input device according to claim 1, wherein: The record identification information of the added or deleted record when a new record is added or the existing record is deleted compared to the existing data whose reference data is reference data 3. The data input device according to claim 1, wherein the data input device is written in a log file as an update record. A data input device having a verify mode, characterized in that, when performing the second and subsequent verifications, an update record created by the previous verification is read from a log file, and only the updated data is subjected to verification. The data input device according to claim 1, 2 or 3.

Images