JP2001084163A - Device and method for preliminarily examining influence of update processing and device and method for testing operation of update processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a device for preliminarily examining the influence of update processing for preliminarily examining influence at the time of updating data by automatic processing. SOLUTION: A device for preliminarily examining the influence of update processing is provided with an extraction key file preparing part 1 for preparing an extraction key file 12 from a data to be updated file 11, a pre-update database preparing part 2 for extracting data to be updated by an extraction key and storing the data in an environment for verification pre-update DB(database) 13, a post-update database preparing part 3 for extracting the data be updated by the extraction key and storing the data in an environment for verification post-update DB 14, an update processing part 4 for operating update processing to the environment for verification post-update DB 14 and storing the data in an environment for verification post-update DB 15 after update processing, and a comparing and verifying part 5 for comparing the data stored in the environment for verification pre-update DB 13 and the environment for verification post-update DB 15 after update processing by starting a comparing and verifying tool group, and preparing a verified result 16.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus and method for examining the influence of update processing in advance for investigating the influence of updating data, and to perform a test of the operation of an update processing program. The present invention relates to an operation test apparatus and method for an update processing program.

[0002]

2. Description of the Related Art In an insurance system, for example, various business data such as insurance underwriting information, repayment information, insurance accident information and the like are stored in separate databases and updated as needed, so that the latest data is always managed. I am trying to do it. In this case, it is not possible to know in advance the change in the statistical information of the business content based on the change in the data caused by the update process, and by performing the process statistically at the stage where the update has been performed to some extent in the operation state, For the first time, it is possible to ascertain the effect, but this could not be predicted in a non-operational state in advance. Also, like this,
Investigations of the effects of the update process were usually performed exclusively artificially. On the other hand, as a method of verifying the influence of the update processing in advance, for example, Japanese Patent Laid-Open No. 7-28384
However, this technique is intended for updating state transitions of a program, and is difficult to apply in order to investigate the influence of updating data in advance. It is.

[0003]

However, if the effect is known after the data has been updated to some extent, it may hinder the execution of business, so it is necessary to know the effect of the update process in advance. It is convenient if possible. In particular, if there is a risk that business data will be corrected frequently,
It would be advantageous if there was a method that could automatically execute such processing, but there was a problem that such a method was not known at all. In addition, when a modification of the update processing program occurs, it is convenient if it is possible to easily perform a test of whether the operation of the modified update processing program is good or not. However, there is a problem that such a method has not been known conventionally. there were.

SUMMARY OF THE INVENTION The present invention has been made in view of the above circumstances, and provides an apparatus and a method for preliminarily examining the influence of update processing, which can verify in advance data fluctuation due to update processing. It is an object. Another object of the present invention is to provide an operation test apparatus and method for an update processing program that can automatically perform an operation test on the update processing program.

[0005]

In order to solve the above-mentioned problems, the invention according to claim 1 relates to an apparatus for examining the influence of update processing, and extracts the update target data for each specified data file in the update target data file. Extraction key file creation means for creating a file containing a key; pre-update database creation means for extracting update target data from the data file by the extraction key and storing the data in the pre-update database of the verification environment; Means for extracting update target data from the data file and storing the updated data in the updated database of the verification environment, and performing update processing on the update target data stored in the updated database of the verification environment. Update processing to be executed and stored in the updated database of the verification environment after update processing Means, for comparing the data stored in the pre-update database of the verification environment with the data stored in the post-update database of the verification environment after the update process by starting a comparison verification tool group and comparing the data. And comparison verification means for generating verification results.

According to a second aspect of the present invention, there is provided an operation test apparatus for an update processing program, wherein an extraction key file for generating a file containing an extraction key for data to be updated for each specified data file in the data file to be updated. Creating means, pre-update database creating means for extracting update target data from the data file with the extraction key and storing the data in the pre-update database of the verification environment, and extracting update target data from the data file with the extraction key Means for creating an updated database to be stored in the updated database of the verification environment, and executing the update processing by executing the update processing program for the data to be updated stored in the updated database of the verification environment and updating the data. Update to be stored in the database after updating the verification environment after processing The comparison verification tool is activated by comparing the data stored in the pre-update database of the verification environment with the data stored in the post-update database of the verification environment after the update process, and performing a comparison. And a comparison verification means for generating a verification result, and an update processing program update means for updating the update processing program of the update processing means.

According to a third aspect of the present invention, there is provided a method for preliminarily examining the influence of an update process, wherein for each specified data file in an update target data file, a step of creating a file containing an extraction key for the update target data;
Extracting the data to be updated from the data file with the extraction key and storing it in the pre-update database of the verification environment, and extracting the data to be updated from the data file with the extraction key and updating the database of the verification environment And performing an update process on the data to be updated stored in the updated database of the verification environment and storing the updated data in the updated database of the verification environment after the update process. Create a verification result by starting a comparison verification tool group and comparing the data stored in the pre-update database of the environment with the data stored in the post-update database of the verification environment after the above update processing. And a step.

According to a fourth aspect of the present invention, there is provided a storage medium having recorded therein a program for conducting a preliminary investigation on the influence of an update process, and a computer-readable medium having recorded thereon a program for executing the method for conducting a preliminary investigation on the impact of an update process. A storage medium that stores an extraction key for the data to be updated for each of the specified data files in the data file to be updated, and extracts the data to be updated from the data file by using the extraction key, and verifies the environment. The update target data is stored in the pre-update database, the update target data is extracted from the data file by the extraction key, and is stored in the post-update environment of the verification environment. Update database for the verification environment after the update process The data stored in the pre-update database of the verification environment is compared with the data stored in the post-update database of the verification environment after the update process, and the comparison verification tool group is activated and compared. And a program for creating verification results.

According to a fifth aspect of the present invention, there is provided an operation test method of an update processing program, wherein for each specified data file in an update target data file, a step of creating a file containing an extraction key for the update target data; Extracting the data to be updated from the data file with the extraction key and storing it in the pre-update database of the verification environment, and extracting the data to be updated from the data file with the extraction key and updating the database of the verification environment And executing the update processing program on the data to be updated stored in the database after the update of the verification environment, executing the update processing, and storing in the updated database of the verification environment after the update processing And the steps stored in the pre-update database of the verification environment. Activating a group of comparative verification tools to create a verification result by comparing the data and the data stored in the updated database of the verification environment after the update processing, and updating the update processing program; And a step of performing

According to a sixth aspect of the present invention, there is provided a storage medium storing an operation test program for an update processing program, and a computer readable medium storing a program for executing the operation test method for the update processing program according to the fifth aspect. A storage medium that stores an extraction key for the data to be updated for each of the specified data files in the data file to be updated, and extracts the data to be updated from the data file by using the extraction key, and verifies the environment. The update target data is stored in the pre-update database, the update target data is extracted from the data file by the extraction key, and stored in the post-update environment of the verification environment in the post-update database. Start the update processing program and execute the update processing The data stored in the pre-update database of the verification environment after the update process is stored in the post-update database of the verification environment and the data stored in the post-update database of the verification environment after the update process are Then, a comparison verification tool group is activated, a comparison result is created by comparison, and a program for updating the update processing program is recorded.

[0011]

According to the structure of the present invention, for each specified data file in the data file to be updated, extraction key file creation means for creating a file containing an extraction key for the data to be updated, and update data from the data file by the extraction key. A pre-update database creating means for extracting and storing the pre-update database in the pre-update database of the verification environment, an after-update database creating means for extracting the data to be updated from the data file by the extraction key, and storing the data in the post-update database of the verification environment; Update processing means for executing update processing on the data to be updated stored in the database after the update of the verification environment and storing it in the database after the update of the verification environment after the update processing; The stored data and the updated database in the verification environment after the update process Against the data stored in the scan,
A comparison verification tool is provided to start the comparison verification tool group and create a verification result by comparison, so that the effect of the update process on the data file to be updated can be investigated beforehand in a non-operational state based on the verification result. It becomes possible to do.

In another configuration of the present invention, extraction key file creation means for creating a file containing an extraction key for data to be updated for each specified data file in the data file to be updated, Pre-update database creation means for extracting update target data and storing it in the pre-update database of the verification environment, and an updated database for extracting update target data from the data file with the extraction key and storing it in the post-update database of the verification environment Creation means and update processing for starting an update processing program for the data to be updated stored in the updated database of the verification environment, executing the update processing, and storing the updated data in the updated database of the verification environment after the update processing Means and data stored in the pre-update database of the verification environment A comparison verification unit that starts a comparison verification tool group and compares the data stored in the updated database of the verification environment after the update process to generate a verification result, and an update process of the update processing unit. Since the update processing program updating means for updating the program is provided, the quality of the updated update processing program can be easily recognized by comparing the verification results before and after the update of the update processing program.

[0013]

Embodiments of the present invention will be described below with reference to the drawings. The description will be specifically made using an embodiment. First Embodiment FIG. 1 is a block diagram showing a configuration of a device for investigating the influence of update processing according to a first embodiment of the present invention. As shown in FIG. 1, the apparatus for investigating the influence of update processing according to the present invention includes an extraction key file creation unit 1, a pre-update database creation unit 2, a post-update database creation unit 3, an update processing unit 4, And a comparison verification unit 5. The extraction key file creation unit 1 takes in data from a designated file and creates an extraction key file. The pre-update database creation unit 2 extracts pre-update data and stores it in the pre-update database of the verification environment (pre-update environment DB for verification). The post-update database creation unit 3 extracts pre-update data and stores it in the post-update database of the verification environment (post-update DB of verification environment). The update processing unit 4 starts the update process and creates an updated database of the verification environment after the update process (the updated DB for the verification environment after the update process). The comparison verification unit 5 activates a group of verification tools for the pre-update database of the verification environment and the post-update database of the verification environment after the update processing, and obtains a verification result.

Referring now to FIG. 1, the operation of the apparatus for checking the influence of the updating process in this example will be described. First, the extraction key file creator 1 fetches data from a specified file in the update target data file 11 and creates an extraction key file 12 using an extraction key. Here, the update target data file 11 stores, for example, various business data such as insurance underwriting information, repayment information, and insurance accident information in the insurance system in separate databases. The data in this case indicates, for example, proper nouns, dates, numerical values such as amounts, contract types, and the like.
The extraction key is a key for retrieving data for each policyholder in, for example, the above-described example. In this case,
A security key indicating a security number for identifying an insurance contract corresponds to this. In the insurance system, each of the business data described above is registered in a separate database, but basically has a unique configuration based on the security key. The extraction key created by the extraction key file creation unit 1 is obtained by converting a security key into a key system of each database described above. Therefore, the number of extraction keys (extraction key files) is equal to the number of databases to be extracted. Created.

Next, in the pre-update database creation unit 2,
Using the extraction key created by the extraction key creation unit 1, data is extracted from the database to be updated and stored in the intermediate file, and the data of the intermediate file is stored in the verification environment pre-update DB 13. The data of the verification environment pre-update DB 13 is not subjected to any data processing such as update thereafter. The post-update database creation unit 3 creates the post-update environment 14 for verification using the same contents as those stored in the pre-update environment DB 13 for verification. Specifically, for example, the verification environment update DB 14 is created using the data stored in the intermediate file created by the pre-update database creation unit 2 as it is.

The update processing unit 4 updates the verification environment DB after updating.
14 is subjected to a required update process, so that the verification environment after the update process is updated.
Create B15. Next, the comparison verification unit 5 activates a prepared group of comparison verification tools, and stores the data stored in the pre-verification environment update DB 13 and the post-verification environment update DB 15 after the update processing. The verification result 16 indicating the influence of the update process is created by comparing the data with the data that has been updated.

After such processing is performed for each database in the data file 11 to be updated, the data in the verification environment update DB 15 after the update processing is verified using the data shown in the verification result 16. By doing so, it is possible to know in advance the influence based on the update processing when the update processing is actually performed on the update target data in the operation state in the non-operation state. In this case, by verifying the updated data of the verification environment after the update process corresponding to the data before the update of the verification environment, it is determined whether the update method is correct or whether the update result is correct. You can know. The comparison between the pre-update data of the verification environment and the post-update data of the verification environment after the update process is based on the physical comparison result of the data stored in each database before and after the update, that is, the difference between the corresponding data. The verification may be performed, or the pre-update data value and the post-update data value may be totalized under certain conditions, and the verification may be performed by comparing and verifying the totaled result.

As described above, according to the apparatus and method for preliminarily examining the influence of the updating process in this example, a change in data when the updating process is performed on the data to be updated in each data file is verified in advance. Such verification can be performed for each database, and if there is no particular problem with the data fluctuation value obtained in each case, the environment in which the user actually operates the data It can be confirmed that the update processing performed by the update processing unit 4 may be performed. In addition, since the influence investigation of such an update process can be performed automatically by software, it is possible to avoid a human error when performing such a process manually.

Second Embodiment FIG. 2 is a block diagram showing a configuration of an operation test apparatus for an update processing program according to a second embodiment of the present invention. As shown in FIG. 2, the operation test apparatus of the update processing program according to the present invention includes an extraction key file creation unit 1, a pre-update database creation unit 2, and an after-update database creation unit 3
, An update processing unit 4A, a comparison verification unit 5, and an update processing program update unit 6. Among them, the extraction key file creation unit 1, the pre-update database creation unit 2, the post-update database creation unit 3, and the comparison verification unit 5 are the same as those in the first embodiment shown in FIG. is there. The update processing unit 4A activates an update processing program (before and after update), performs update processing of the verification environment update DB 14, and executes the verification environment update DB after the update processing.
Create 15. The update processing program update section 6 determines whether or not the update processing program has been updated. If the update processing program has not been updated, the update processing section 4A causes the update processing program to perform the update processing again with the updated update processing program. If it has been updated, all the processing ends.

Hereinafter, the operation of the operation test apparatus for the update processing program of this example will be described with reference to FIG. In this example, the operations of the extraction key file creation unit 1, the pre-update database creation unit 2, and the post-update database creation unit 3 are the same as those in the first embodiment shown in FIG. The update processing unit 4A first performs update processing on the data of the verification environment updated DB 14 created by the updated database creation unit 3 using an update processing program before update (before remodeling). DB after updating the verification environment
Create 15. Next, the comparison verification unit 5 activates a group of comparison verification tools prepared in advance and stores the data stored in the verification environment pre-update DB 13 and the data stored in the verification environment post-update DB 15 after the update processing. Verification result 1 showing the effect of the update process by comparing the
Create 6. Next, the update processing program update section 6 determines whether or not the update processing program used in the update processing section 4A has been updated. If the update processing program has not been updated, the update processing section 4A executes The verification environment update DB 14 is again updated by the updated (modified) update processing program. As a result, the comparison and verification unit 5 again compares the data stored in the pre-verification environment update DB 13 with the data stored in the post-verification environment update DB 15 after the update processing, thereby performing the update processing. Result 16 showing the effect of
Create When the update processing program updating unit 6 determines whether or not the update processing program used in the update processing unit 4A has been updated, if the update processing program is updated, the operation test device of the update processing program is determined. Is completed.

After performing such processing for each database in the data file 11 to be updated, the verification result 16 obtained by the pre-update update processing program in the verification result 16 and the updated update processing program By comparing with the verification result obtained by the above, when they match or when the expected result is obtained, the validity of the updated program can be confirmed.

As described above, according to the operation test apparatus of the update processing program of this example, when the update processing program is modified, the verification result obtained by the update processing program before the modification and the update after the modification are updated. By comparing the result of the verification with the verification result obtained by the processing program, it is possible to automatically perform a test as to whether or not there is an error in the updated processing program after the modification.

Although the embodiment of the present invention has been described in detail with reference to the drawings, the specific configuration is not limited to this embodiment, and there are design changes and the like without departing from the gist of the present invention. Even this is included in the present invention. For example, when the present invention is implemented by software, the hardware configuration includes a processing device such as a central processing unit (CPU), and a large-sized device for storing programs and data connected to the CPU and the like via a bus. High-speed low-speed memory and CPU
A known system having a high-speed memory serving as a work area, an input device and an output device for external connection and data transmission / reception, and the like, and equipped with a program for realizing the present invention, Can be realized. Furthermore, by preparing such a program in a state in which it is recorded on a medium of any format that can be read by the processing device, the same device or method can be universally used when a similar system is provided. Can be realized. Examples of such a medium include a magnetic tape, a floppy disk, and a CD-ROM (Compact Disk Read Only Memory).
And the like, and a magnetic tape device, a floppy disk drive, a CD-ROM drive, or the like may be used as the input device. In addition, the present invention is not limited to the insurance business, and can be used to perform a preliminary investigation of the impact when updating any data in a database composed of a large number of data of the same type, or to modify the update processing program. It is applicable when performing. In the present invention, the conversion of the extracted key into the key system of each database may be performed by a unique tool. Extraction of data from each database based on the extraction key may be performed by a utility of a general-purpose host computer, or may be performed using a unique tool. Furthermore, a tool group for comparing and verifying the pre-update environment database for verification with the post-update environment database for verification after the update process may be a unique tool group.

[0024]

As described above, according to the apparatus and method for preliminarily examining the influence of the updating process of the present invention and the storage medium storing the program for examining the impact of the updating process, the data to be updated in the data file to be updated can be obtained. In contrast, data fluctuations when performing update processing can be verified, so in an environment where data is actually operated, whether or not update processing can be performed is known in advance in a non-operation state. be able to. In addition, since the influence investigation of such an update process can be performed automatically by software, it is possible to avoid a human error when performing such a process manually. According to the update processing program operation test apparatus and method of the present invention and the storage medium on which the update processing program operation test program is recorded, when the update processing program is modified, the update processing program before the modification is used. By comparing the created verification result with the verification result created by the modified update processing program, it is possible to automatically test whether or not the modified update processing program has an error.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of an apparatus for investigating the influence of an updating process according to a first embodiment of the present invention;

FIG. 2 is a block diagram showing a configuration of an operation test device for an update processing program according to a second embodiment of the present invention.

[Explanation of symbols]

Reference Signs List 1 extracted key file creating section (extracted key file creating means) 2 pre-update database creating section (pre-update database creating means) 3 post-update database creating section (updated database creating means) 4,4A update processing section (update processing means) Reference Signs List 5 comparison verification unit (comparison verification unit) 6 update processing program update unit (update processing program update unit) 11 data file to be updated 12 extraction key file 13 DB before verification environment update 14 DB after verification environment update 15 after update processing DB 16 after verification environment update Verification result

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 5B042 HH12 JJ30 5B049 AA02 BB46 DD05 EE05 EE56 FF09 5B075 ND20 NK02 NR03 NR06 NR20 QP10 UU40 5B082 GA14

Claims (6)

[Claims] 1. An extraction key file creating means for creating a file containing an extraction key for data to be updated for each specified data file in the data file to be updated, and extracting the data to be updated from the data file with the extraction key. A pre-update database creating means for storing in the pre-update database of the verification environment, and an after-update database creating means for extracting update target data from the data file by the extraction key and storing the data in the post-update database of the verification environment, Update processing means for executing an update process on the data to be updated stored in the database after the update of the verification environment and storing it in the database after the update of the verification environment after the update process; and before updating the environment for the verification. Data stored in a database and a verification environment after the update process Against a stored in the updated database data, compare verify that a comparison verification means for the tool group compared to start to create a validation result of the updating process, characterized effect preliminary survey device. 2. An extraction key file creating means for creating a file containing an extraction key for the update target data for each specified data file in the update target data file, and extracting the update target data from the data file by the extraction key. A pre-update database creating means for storing in the pre-update database of the verification environment, and an after-update database creating means for extracting update target data from the data file by the extraction key and storing the data in the post-update database of the verification environment, Update processing means for starting an update processing program for the data to be updated stored in the updated database of the verification environment, executing the update processing, and storing the updated data in the updated database of the verification environment after the update processing, Data stored in the pre-update database of the verification environment A comparison verification unit that activates a group of comparison verification tools and compares the data stored in the updated database of the verification environment after the update process to create a verification result, and an update processing program of the update processing unit And an update processing program updating means for updating the operation program. Creating a file containing an extraction key for the update target data for each specified data file in the update target data file; extracting the update target data from the data file using the extraction key to verify the environment; Storing the data to be updated from the data file by the extraction key and storing it in the updated database of the verification environment; and storing the data to be updated in the updated database of the verification environment. Executing an update process on the data to be updated and storing it in an updated database of the verification environment after the update process; data stored in the pre-update database of the verification environment; and verification after the update process Comparison of the data stored in the database after the Impact preliminary survey method of updating process is characterized in that a step to create a verification result in comparison to start the tools. 4. A computer-readable recording medium on which a program for executing the method for preliminarily investigating the influence of the update process according to claim 3 is recorded, wherein extraction of update target data is performed for each specified data file in the update target data file. Create a file containing a key, extract the update target data from the data file by the extraction key, store it in the pre-update database of the verification environment, and extract the update target data from the data file by the extraction key. Stored in the updated database of the verification environment, store the data in the updated environment of the verification environment after the update process by performing an update process on the update target data stored in the updated database of the verification environment, Data stored in the pre-update database of the verification environment, and verification after the update process A program to check the impact of the update process, which is characterized by recording a program that launches a group of comparative verification tools and creates verification results against the data stored in the database after updating the usage environment Storage media. 5. A step of creating, for each specified data file in the data file to be updated, a file containing an extraction key for the data to be updated, extracting the data to be updated from the data file using the extraction key, and verifying the environment. Storing the data to be updated from the data file by the extraction key and storing it in the updated database of the verification environment; and storing the data to be updated in the updated database of the verification environment. Starting the update processing program for the data to be updated, executing the update processing, and storing the data in the pre-update database of the verification environment after the update processing, and the data stored in the pre-update database of the verification environment. Stored in the updated database of the verification environment after the update processing. Operating the comparison and verification tool group to generate a verification result with respect to the updated data, and updating the update processing program. . 6. A computer-readable recording medium storing a program for executing the operation test method of the update processing program according to claim 5, wherein extraction of the update target data is performed for each specified data file in the update target data file. Create a file containing the key,
Extracting the data to be updated from the data file with the extraction key and storing it in the pre-update database of the verification environment, and extracting the data to be updated from the data file with the extraction key and storing it in the database of the verification environment after updating Activating an update processing program for the data to be updated stored in the updated database of the verification environment, executing the update processing, and storing the updated data in the updated database of the verification environment after the update processing; A comparison verification tool is activated to compare the data stored in the pre-update database of the application environment with the data stored in the post-update database of the verification environment after the update process, and create a verification result. An operation test program for the update processing program, wherein a program for updating the update processing program is recorded. A storage medium storing the beam.