JPH10240575A - Inspecting method for batch update processing program for large-amount data file - Google Patents

Abstract

PROBLEM TO BE SOLVED: To confirm the adequacy of the process of a program to be inspected by inputting input data to the program to be inspected and its processing result data to an inspecting program and confirming their contents. SOLUTION: A large-amount data file 1 is prepared, the program 2 to be inspected 2 is executed by inputting its data X, and processing result data Y are stored in a processing result data file 3. The processing result data Y and data X before the processing are read out and inputted to the inspecting program 4, which performs inspection. The inspecting program 4 matches the data X before the processing and data Y after the processing against each other, record by record, to confirm that the both have the same data. Then the adequacy of single-item level among generated inspection items is confirmed and correlativity is confirmed on condition that the confirmation can be done. Then the adequacy of update results of contents before and after the processing as to each item is confirmed. Data decided as abnormal one through the corrrelativity confirming process is outputted to a verification list 5.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for inspecting a program for updating a large amount of data files in a batch when the program is newly developed or modified.

[0002]

2. Description of the Related Art Conventionally, as an inspection method for a new development / modification of a program for batch updating of a large amount of data files, input conditions are set based on development specifications, and data created based on the input conditions is newly developed / modified. I was checking the result of having the program process it. However, in this method, there is a risk that the setting conditions may be omitted when setting the input conditions, and since the input conditions are created based on the designed specifications to the last, there is no approach to errors in the specifications themselves, so there is no specification defect. Because it is difficult to find, and there is a possibility that omission of confirmation may occur at the time of confirmation work, it depends largely on the experience of the person to be verified, and as a result, a complete inspection method has not been established.

As another inspection method for a program for updating a large amount of data collectively, for example, Japanese Patent Laid-Open No.
As disclosed in Japanese Patent Application Publication No. 1-364040, the result of processing with the “pre-correction program” and the “after-correction program”
There is a method to compare the result of processing in the above, but this method is effective only when the inspection target program is developed by modification, it is not applicable to new development, and also confirms the degrading of the function part not to be modified This method is not disclosed as a method for confirming the function to be corrected.

[0004]

In the case of a program for updating a large amount of data files such as pension data in a batch, if a defect occurs, the range of influence is expanded to a mouse formula, and there is a high risk of a serious accident. However, as described above, in the conventional inspection method, there are concerns about omission in setting of input conditions, difficulty in extracting a specification defect, and omission in confirmation, and there is a problem that a defect is missed during inspection.

SUMMARY OF THE INVENTION An object of the present invention is to eliminate omission of condition setting in a program for updating such a large amount of data files at a time, to ensure that a specification defect is extracted, prevent omission at the time of confirmation, and improve accuracy. An object of the present invention is to provide an inspection method of a mass data file batch update processing program capable of performing high inspection.

[0006]

In order to solve the above-mentioned problems, the inspection method of the present invention is based on a conventional method of collectively verifying the validity of a processing result from setting input conditions and confirming the results accompanying the setting. It was done. That is, in the past, a check was made that “if the input is A, the result is B”. However, the present invention is not limited to A and B, and verifies whether the processing result has validity. It is characterized in that the inspection contents by the inspection program focus on the processing result, that the inspection target program is executed assuming the actual processing at the time of inspection, and that machine verification is performed, and that the input of the inspection target program is performed. The validity of the processing of the inspection target program is confirmed by inputting the data and the processing result data to the inspection program and confirming the contents.

Specifically, a new development / modification program,
A first file storing a large amount of data assuming actual processing to be input to the new development / modification program;
A second file for storing processing result data obtained by causing the new development / modification program to process a large amount of data of the first file, a large amount of data of the first file, and the processing result data of the second file, The second program which is set by paying attention to the processing result of the new development / modification program
Item validity check of each item for each record of each file and confirmation of correlation between the items, and item update by comparing each item of the large amount of data of the first file with the processing result data of the second file An inspection program for performing a result validity check and outputting the contents of data determined to be abnormal as a verification list, and causing the newly developed / modified program to process a large amount of data in the first file; After storing the resulting data in the second file,
To the inspection program, a large amount of data of the first file and a processing result data of the second file are inputted, a single item validity check of each item of each record of the large amount of data of the second file and each item Confirmation of the correlation between the first
The item update result is validated by comparing each item of the large amount of data of the file with the processing result data of the second file, and the large amount of data is updated collectively by the verification list output by the validation. The feature is to check the validity of the development / modification program.

[0008]

Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a diagram showing the configuration of files necessary for realizing the inspection method according to the present invention and the flow of data between a newly developed / modified program and an inspection program. Large amounts of data (data before processing)
A file 1, a new development / modification program (program to be inspected) 2, a processing result data (post-processing data) file 3, an inspection program 4, and a verification list 5 are prepared.

FIG. 2 is a flowchart showing an example of a processing result inspection procedure in the inspection program 4 for inspecting whether the processing of the newly developed / modified program is appropriate.

An inspection procedure according to the present embodiment will be described below with reference to FIGS.

In FIG. 1, a large-volume data file 1, which is assumed to be a production process, which is an input of an inspection target program 2, is prepared, and the inspection target program 2 is executed by using this data X as an input. Store in file 3. Note that a large amount of data X
It is preferable to use the actual data (or a copy thereof) as it is, because the effect of this inspection method is enhanced when there are many data variations so that the inspection target program 2 can perform the pseudo actual processing.

Next, the processing result data Y output from the inspection target program 2 and stored in the processing result data file 3 and the pre-processing data X stored in the mass data file 1 are read out and input to the inspection program 4. The inspection is performed by the inspection program 4.

As shown in the flowchart of FIG. 2, the inspection program 4 first compares the pre-processing data X and the post-processing data Y in a record unit in step 6,
Make sure that both have the same data. If the match is not established, it is determined that the data is abnormal, and the next step 7
Then, the process proceeds to step 14, where “verification data exists” is output to the verification list 5.

If the match is established, in the next step 8, the validity at the single item level is checked among the inspection items created by focusing on the processing results. This single item level validity checking process includes a validity check, a range check, and the like for the value of the item itself in one record of the processed data Y. As a result of this check, the post-processing data Y having an item determined to be abnormal is output to the verification list 5 together with the pre-processing data X in step 14 after the determination in step 9.

When the validity at the single item level is confirmed, the correlation is confirmed in the next step 10. The process of step 10 is a process for confirming the correlation between the items among the inspection items created by focusing on the processing results,
Condition check between items in one record of post-processing data Y (for example, “if item A is B, then item a must be b”), logical check (for example, “item A + item B = item C”) ) Etc.

As a result of the correlation confirmation processing, the post-processing data Y having an item determined to be abnormal is stored in step 11
After that, the data is output to the verification list 5 together with the pre-processing data X in step 14 at step 14.

When the correlation confirmation processing is completed, in the next step 12, of the inspection items created focusing on the processing results, the contents before and after the processing for each item in one record are updated. Validate the results.
The validity check processing of the update result includes the same check (check of an unupdated item), a range check (particularly, an increase / decrease range check when the item to be checked is a numerical value), and a logical check (for example, “the item A after processing is X Then, item A before processing
Is Y ").

The post-processing data Y including the item determined to be abnormal in the update result validity confirmation processing is output to the verification list 5 together with the pre-processing data X in step 14 through step 13.

In the verification list 5, post-processing data Y and corresponding pre-processing data X having items determined to be abnormal as a result of the inspection are output, and the inspector verifies the list contents by visual confirmation. If it is determined that the problem is a problem, the trace to the inspection target program 2 is performed to find the cause. In other words, investigate where the consequential factors are. Thereby, it is possible to derive a defect of the inspection target program 2 and a problem in the processing method or specification.

FIG. 3 is a diagram showing an application example of the present invention.
Tens of millions of personal information data (data before processing) in public systems such as pensions stored in mass data file 1
Is input to a new program (or system) 2 developed for batch updating in accordance with the revision of relevant laws, etc., and batch updating is performed, and the processing result data (personal data updated for the new system) Processing result data file 3
And checks whether the processing of the new program 2 is correct by checking the validity of the data stored in the processing result data file 3 in accordance with the check items shown in the check content list 15. .

In the check content list 15, the validity check content 16, the correlation check content 17, and the update result check content 18 are set for each item by focusing on the processing result of the new program 2 to be inspected. FIG. 4 shows an example of the confirmation content list 15.

In FIG. 4, as the processing result data after the batch update, as shown, a key number 191, a name 19
2. Assuming personal information data including date of birth 193, item information 194 including items A, B,..., And amount information 195 including amounts x, y,..., Each item of item information 194, amount information 195 Also, validity confirmation contents 16, correlation confirmation contents 17, and update result confirmation contents 18 as shown are set for each amount.

For example, as for the item A, the content of the item A takes one of the values “1” to “3”, and it is set as the validity check 16 that no other value is possible. . If item B is “4”, item A is “2”, and if item B is other than “4”, item A should be “1” or “3”. Is set as

Further, if the item A is "3" before the process, it should be "3" after the process, and if the item before the process is other than "3", it should be "1" or "2" after the process. Something is set as the update result confirmation content 18.

With such a validity check, a new program 2 for collectively updating a large amount of personal information data such as pensions
The inspection program 4 can check whether the processing is correct.

In particular, at the time of inspection, there is no need to prepare test data to be input to the new program 2 to be inspected, and data used in actual production can be used for inspection as it is, so that preparations for inspection work are extremely high. It has the advantage of being easier.

[0028]

As described above, according to the inspection method of the present invention, by verifying the contents of data corresponding to the condition that should be regarded as a problem as a processing result and tracing to the inspection target program, And the problem with the processing method or specification can be easily derived.

Also, by focusing on the processing result, the setting of the condition is only related to the validity and correlation of the output item itself, so that the setting of the condition becomes easy, and omission of setting of the condition can be eliminated.

Further, by machine verification by the inspection program, problematic data can be easily and reliably extracted, and omission of confirmation can be eliminated.

[Brief description of the drawings]

FIG. 1 is a diagram showing a file prepared for realizing the inspection method of the present invention, a program to be inspected, and a data flow between the inspection programs.

FIG. 2 is a flowchart illustrating a processing result confirmation procedure by an inspection program.

FIG. 3 is a diagram showing an application example of the present invention.

FIG. 4 is an explanatory diagram showing an example of a confirmation content list 15;

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Large data file for production processing (data before processing), 2 ... New development / modification program (program to be inspected), 3 ... Processing result data file (data after processing), 4 ... Inspection program, 5 ... Verification list, 15 ... list of confirmation contents, 16 ... validity confirmation contents, 17 ... correlation confirmation contents, 18 ... update result confirmation contents.

Claims (1)

[Claims] An inspection method for a new development / modification of a program for batch updating of a large amount of data files, the method comprising: storing a new development / modification program; A first file, a second file storing processing result data obtained by causing the new development / modification program to process the large amount of data of the first file, a large amount of data of the first file, and the second file Inputting the processing result data of the second development / modification program, and confirming single item validity of each item for each record of the second file and checking the correlation between the items,
And an inspection program for checking the validity of the item update result by comparing each item of the large amount of data of the first file with the processing result data of the second file, and outputting the contents of the data determined to be abnormal as a verification list And prepare
After causing the newly developed / modified program to process the large amount of data of the first file and storing the processing result data in the second file, the inspection program is rewritten with the large amount of data of the first file. The processing result data of the second file is input, the single item validity check of each item for each record of the large volume data of the second file, the correlation confirmation between the items, and the large volume data of the first file are performed. And a new development / modification program for performing a batch update of a large amount of data with a verification list output by the process of validity checking by checking each item of the processing result data of the second file with each item. An inspection method of a mass data file batch update processing program characterized by confirming validity.