JP2011039902A - Apparatus and method for processing data, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To restore a database of an actual system corresponding to reception data, into a database of a test system when testing the test system using reception data of the actual system. <P>SOLUTION: An actual system 200 is an actually operating computer system, and a test system 400 is a computer system to be tested. A testing device 100 collects reception data received from an external system 300 by a computer 202, intra-computer data showing transitions of data processing in the computer 202, and a database state data showing the process of updating in a database 201 and uses collected data to restore the database 201 at the time point of data processing on reception data by the computer 202 and updates a test database 401 in accordance with the restored database 201 and outputs reception data to a test target computer 402 and makes the computer 402 respond to the reception data by using the updated test database 401. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a system test of a computer system.

In an IT system, a conventional test tool using actual data collects data received from an external system to a computer on a network in the actual system, and outputs the received data from the test tool to a computer to be tested in the test system. Thus, a test is performed (for example, Patent Document 1).
In other words, conventionally, the actual system that is actually operating includes a computer, the computer is connected to an external system via a network, and the test system is expected to perform the same operation as the actual system. In this case, the test tool collects the received data received from the external system by the actual system computer from the network, the test tool outputs the collected received data to the test system computer, and performs the test on the test system computer. This is performed using actual data (received data received by an actual system computer from an external system).

  In addition, transmission / reception data between the external system and the actual system computer is collected on the network, and the received data among the transmission / reception data is input from the test tool to the test system computer, and the response of the test system computer to the received data. There has also been proposed a method in which a test tool inputs a transmission result, collates the input transmission result with transmission data among the transmission / reception data, and performs a higher quality test (for example, Patent Document 2).

JP 2000-196705 A JP 2007-145156 A

  The conventional system test method using a test tool that uses real data is the same as the status of the test system database at the start of the test, and the test system receives the data collected from the real system network. Although testing is performed by applying data, it takes a long time to restore the state of the database at the time of receiving arbitrary received data. There is a problem of getting worse.

  One of the main objects of the present invention is to solve the above-mentioned problems. In a system test of a computer system including a database, the operation in the real system is performed by using the received data collected from the real system. When reproducing, the main purpose is to efficiently and faithfully restore the state of the database of the actual system corresponding to the received data to the database of the test system.

The data processing apparatus according to the present invention
It is connected to a first system including a first computer that transmits and receives data to and from a communication destination system, and a first database that is updated based on data processing in the first computer. A data processing device,
A reception data processing time information input unit for inputting reception data processing time information indicating, as reception data processing time, a time of data processing performed on the reception data received by the first computer from the communication destination system;
A first database state information input unit that indicates a progress of update in the first database and inputs first database state information capable of restoring the first database at an arbitrary time by following the progress of the update; ,
Based on the received data processing time indicated in the received data processing time information, the update process indicated in the first database status information is followed, and the first computer performs data processing on the received data. And a first database restoring unit that restores the first database at the time of execution.

  According to the present invention, it is possible to restore the state of the first database at the processing time of the received data by following the progress of the update in the first database until the processing time of the received data in the first computer. The state of the first database can be efficiently reproduced in another database, and the efficiency of the test can be improved.

FIG. 3 is a diagram illustrating an example of a system configuration according to the first embodiment. 1 is a diagram illustrating a configuration example of a test apparatus according to Embodiment 1. FIG. FIG. 3 is a flowchart showing an operation example of the test apparatus according to the first embodiment. FIG. 3 is a flowchart showing an operation example of the test apparatus according to the first embodiment. FIG. 3 is a diagram showing a recording example of network data according to the first embodiment. FIG. 4 is a diagram showing a recording example of computer internal data according to the first embodiment. FIG. 4 is a diagram showing a recording example of database state data according to the first embodiment. FIG. 4 is a diagram illustrating an example of a test data generation procedure according to the first embodiment. FIG. 3 is a flowchart showing an operation example of a network data collection unit according to the first embodiment. FIG. 4 is a flowchart showing an operation example of a database state data collection unit according to the first embodiment. FIG. 3 is a flowchart showing an operation example of a computer internal data collection unit according to the first embodiment. FIG. 3 is a flowchart showing an operation example of a test data management unit according to the first embodiment. FIG. 3 is a flowchart showing an operation example of a test execution unit according to the first embodiment. FIG. 4 is a flowchart showing an operation example of a database restoration unit according to the first embodiment. FIG. 3 is a flowchart showing an operation example of a test network / data input / output unit according to the first embodiment; FIG. 6 is a flowchart showing an operation example of an external system simulation unit according to the first embodiment. FIG. 4 is a flowchart showing an operation example of a test data editing unit according to the first embodiment. FIG. 3 is a flowchart showing an operation example of a test execution control unit according to the first embodiment. FIG. 4 is a flowchart showing an operation example of a test result confirmation unit according to the first embodiment. FIG. 3 is a flowchart showing an operation example of an input / output control unit according to the first embodiment. FIG. 3 is a diagram illustrating a hardware configuration example of the test apparatus according to the first embodiment.

Embodiment 1 FIG.
FIG. 1 shows a system configuration example according to the present embodiment.

In FIG. 1, a real system 200 is a computer system that is actually operating, and is an example of a first system.
The actual system 200 includes a computer 202 that transmits / receives data to / from an external system 300 that is a communication destination system, and a database 201 that is updated based on data processing in the computer 202.
The computer 202 is an example of a first computer, and the database 201 is an example of a first database.

The test system 400 is a computer system to be tested, and is expected to perform the same operation as the actual system 200.
The test system 400 also includes a test target computer 402 and a test database 401 used by the test target computer 402.
The test target computer 402 is a test target whether or not it operates in the same manner as the computer 202 of the real system 200.
The test database 401 restores the contents of the database 201 of the real system 200 when testing the test target computer 402.
The test system 400 is an example of the second system, the test target computer 402 is an example of the second computer, and the test database 401 is an example of the second database.

  The input / output device 500 is a display device such as a liquid crystal monitor connected to the test device 100 and an input device such as a keyboard and a mouse.

The test apparatus 100 is an example of a data processing apparatus.
The test apparatus 100 receives transmission data (data from the computer 202 to the external system 300) and reception data (data from the external system 300 to the computer 202) transmitted and received between the computer 202 of the actual system 200 and the external system 300. Collect computer internal data indicating the transition of data processing in the computer 202, collect database state data indicating the update process in the database 201, collect the received data, computer internal data, and database state data. The database 201 at the time when the computer 202 performs data processing on the received data from the external system 300 is restored.
Then, the test apparatus 100 outputs the received data of the computer 202 to the test target computer 402 and updates the test database 401 so as to match the contents of the restored database 201, and the test target computer 402 is updated. Response data for the received data is generated using the later test database 401.
In addition, the test apparatus 100 acquires response data from the test target computer 402, collates the transmission data collected from the real system 200 side with the response data from the test target computer 402, and the test target computer 402 is connected to the computer 202. It is determined whether or not a similar operation is being performed.
Since the state of the database 201 at the time when the data processing is performed on the received data in the computer 202 is reproduced in the test database 401, if the test target computer 402 performs the same operation as the computer 202, the response data And the transmitted data match.

FIG. 2 shows an internal configuration example of the test apparatus 100.
Hereinafter, each element of the internal configuration of the test apparatus 100 will be described.

The database state data collection unit 101 collects database state data of the database 201 of the real system 200.
The database status data is information that indicates the progress of the update in the database 201 and can restore the database 201 at an arbitrary time by following the progress of the update.
The database state data is an example of first database state information, and the database state data collection unit 101 is an example of a first database state information input unit.
Specifically, the database state data is a backup file that is all information related to the database 201 at a certain point in time, and a database log file that is write information to the database 201.
Further, the database state data collection unit 101 reads the data analysis data from the data analysis data storage unit 115 to collect the database state data to be discarded, and collects the collected database state data. The database status data to be discarded is discarded, and the database status data not to be discarded is stored in the database status data storage unit 104.
The data to be discarded is data that is not used for restoring the database 201, and is, for example, a Select statement for the database 201.

The computer internal data collection unit 102 collects computer internal data from the computer 202 of the real system 200.
The computer internal data is information indicating the transition of data processing in the computer 202, such as a log file of an application operating on the computer 202.
The computer internal data always has the data ID of the reception data or transmission data processed by the computer 202, and at least the time of data processing performed on the reception data received from the external system 300 by the computer 202 (reception data Processing time).
The computer internal data is an example of reception data processing time information, and the computer internal data collection unit 102 is an example of a reception data processing time information input unit.
Further, the computer internal data collection unit 102 reads the data analysis data from the data analysis data storage unit 115 to collect the computer internal data collected by acquiring the pattern of the computer internal data to be discarded. The internal computer data to be discarded is discarded, and the internal computer data not to be discarded is stored in the internal computer data storage unit 105.
Note that the data to be discarded is data that is not used for restoring the database 201, for example, data regarding processing that is not related to reception data or transmission data.

The network data collection unit 103 collects all network data that flows on the network connecting the external system 300 and the computer 202 of the real system 200.
The network data collection unit 103 is connected to, for example, a mirror port of a network switch arranged in a network between the computer 202 and the external system 300, and is a network that transmits and receives between the computer 202 and the external system 300 from the mirror port. -You may make it capture data.
The network data always has a unique data ID. The network data from the external system 300 to the computer 202 is received data, and the network data from the computer 202 to the external system 300 is transmitted data. One transmission data always corresponds to one reception data.
The network data collection unit 103 is an example of a reception data input unit and a transmission data input unit.
In addition, the network data collection unit 103 reads the data analysis data from the data analysis data storage unit 115 to collect the network data pattern to be discarded, and collects the collected network data. Among them, the network data to be discarded described in the data analysis data is discarded, and the network data not to be discarded is stored in the network data storage unit 106.
The data to be discarded is data that is not used for restoring the database 201, and is, for example, ACK data for reception confirmation.

The database state data storage unit 104 stores database state data.
FIG. 7 shows an example of database state data management in the database state data storage unit 104.
The database state data is a backup file that is all information related to the database 201 at a certain point in time, and a database log file that is write information to the database 201.
The backup file is managed by “File name” and “Contents of backup file”.
The database log is managed by “File name”, “DB processing time” that is the time when the processing by the database 201 is performed, and “processing content” that is the data processing content by the database 201.

The computer internal data storage unit 105 stores computer internal data.
FIG. 6 shows an example of management of computer internal data in the computer internal data storage unit 105.
The computer internal data includes “data processing time” that is the time when the computer 202 performed data processing, “data ID” that is associated with “data ID” of network data (FIG. 5) described later, It is managed by “processing content” which is data processing content by 202.

The network data storage unit 106 stores network data.
FIG. 5 shows an example of network data management in the network data storage unit 106.
The network data includes a “data ID” associated with the “data ID” of the computer internal data (FIG. 6), a “data generation time” that is the generation time of transmission data or reception data, and an external system 300 ( “Sender IP” indicating the IP address of the computer 202 (in the case of transmission data) or the IP address of the computer 202 (in the case of reception data) or the external system 300 (in the case of transmission data) And “content” that is an excerpt of transmission data or reception data.

The test data management unit 107 associates database state data, computer internal data, and network data, and generates test data used when the database restoration unit 110 described later restores the database 201.
The test data is, for example, data shown in FIG.
Details of the test data and details of the test data creation procedure will be described later.

  The test data storage unit 108 stores the test data generated by the test data management unit 107.

If there is a test execution request from the test execution control unit 118, the test execution unit 109 acquires test data from the test data storage unit 108, and the database restoration unit stores information on the acquired database data of the test data. To 110.
In addition, the test execution unit 109 acquires the reception data and transmission data corresponding to the received data ID and the transmission data ID indicated in the acquired test data from the network data collection unit 103, and acquires the received data. The data is output to the test network data input / output unit 111.
The test execution unit 109 inputs response data, which is a response to the received data of the test target computer 402, from the test network / data input / output unit 111.
In addition, the test execution unit 109 associates the response data of the test target computer 402 with the transmission data acquired from the network data collection unit 103 based on the transmission data ID of the test data in the test result data storage unit 113. Output. The response data is also referred to as test result data.

The database restoration unit 110 acquires the database state data from the database state data storage unit 104 using the information on the database state data input from the test execution unit 109, and the computer 202 receives the received data using the acquired database state data. The database 201 at the time when data processing is performed is restored to the test database 401.
Note that, among the functions of the test data management unit 107 and the database restoration unit 110, a combination of the functions related to the restoration of the test database 401 is an example of the first database restoration unit.
The function related to the update of the test database 401 among the functions of the database restoration unit 110 is an example of the second database update unit.

  The test network data input / output unit 111 outputs the reception data input from the test execution unit 109 to the external system simulation unit 112, and also inputs response data to the reception data from the external system simulation unit 112, and tests this The data is output to the execution unit 109.

The external system simulation unit 112 outputs the received data input from the test network data input / output unit 111 to the test target computer 402, and also inputs response data for the received data from the test target computer 402, and uses this data for testing. Output to the network data input / output unit 111.
The response data is an example of verification target data.
The external system simulation unit 112 is an example of a reception data output unit and a verification target data input unit.

  The test result data storage unit 113 stores the transmission data input from the test execution unit 109 and the test result data (response data) in association with each other.

The test result confirmation unit 114 collates the transmission data stored in association with the test result data storage unit 113 and the test result data (response data), and outputs the collation result data indicating the collation result to the input / output control unit 120. To do.
The test result confirmation unit 114 is an example of a data collation unit.

  The data analysis data storage unit 115 stores data analysis data indicating a pattern to be discarded for each of database state data, computer internal data, and network data.

  If there is a request from the input / output control unit 120, the test data generation unit 116 requests the test data management unit 107 to generate test data.

The test data editing unit 117 processes the reception data stored in the network data storage unit 106 according to the designation of the user of the test apparatus 100, and processes the transmission data paired with the reception data. The received data and the transmitted data are output to the test data management unit 107.
The processing of the reception data and the transmission data is, for example, a change of parameter values included in the reception data and the transmission data.
The test data editing unit 117 is an example of a reception data processing unit and a transmission data processing unit.

  The test execution control unit 118 requests the test execution unit 109 to execute a test based on an instruction from the user of the test apparatus 100.

  The input / output control unit 120 serves as an interface of the input / output device 500 used by the user of the test apparatus 100, receives an instruction from the user via the input / output device 500, and includes a data analysis data storage unit 115 and a test data generation unit 116. In addition, the verification result data is input from the test result confirmation unit 114, and the verification result data is presented to the user via the input / output device 500.

  In FIG. 2, the database state data storage unit 104, the computer internal data storage unit 105, the network data storage unit 106, the test data storage unit 108, and the test result data storage unit 113 are storage devices such as a hard disk and a memory. .

  Next, an outline of an operation example of the test apparatus 100 will be described with reference to the flowcharts of FIGS. 3 and 4.

In FIG. 3, first, the network data collection unit 103 inputs network data transmitted and received between the computer 202 and the external system 300 (S301), and stores the network data in the network data storage unit 106. At this time, if there is network data to be discarded, the network data collection unit 103 discards the network data to be discarded.
Further, the computer internal data collection unit 102 inputs the computer internal data of the computer 202 (S302) (reception data processing time information input step), and stores the computer internal data in the computer internal data storage unit 105. At this time, if there is computer internal data to be discarded, the computer internal data collection unit 102 discards the computer internal data to be discarded.
Further, the database state data collection unit 101 inputs the database state data of the database 201 (S303) (first database state information input step), and stores the database state data in the database state data storage unit 104. At this time, if there is database status data to be discarded, the database status data collection unit 101 discards the database status data to be discarded.
Note that the order of S301 to S303 may be changed, and may not be processed in the order shown in FIG.

Next, the test data management unit 107 generates test data using the network data, the computer internal data, and the database state data (S304) (first database restoration step).
A procedure for generating test data by the test data management unit 107 will be described with reference to FIG.

  The network data shown in FIG. 8 is the same as that shown in FIG. 5, the computer internal data is the same as that shown in FIG. 6, and the database state data is the same as that shown in FIG.

The test data management unit 107 first pairs a record of received data with a corresponding record of transmission data (step (1)).
In the present embodiment, it is assumed that the computer 202 receives data from the external system 300 and transmits a response to the received data.
The test data management unit 107 extracts a pair of received data record and transmission data record based on the “data ID” field and the like.
For example, in the “data ID”, the first digit value of “1” represents received data, the first digit value of “2” represents transmission data, and the second digit or less is a pair. If the same value is numbered in the received data and the transmitted data, pair the two records with the same value in the second digit and the first value is “1”. It is assumed that the record of received data is a record of which the first value is “2”.
In the example of FIG. 8, “data ID: 100001” is a record of received data, and “data ID: 20001” is a record of transmission data paired.

Next, the test data management unit 107 searches the computer internal data for a record that includes the same “data ID” as the “data ID” of the received data extracted in step (1), and includes it in the retrieved record. The “data processing time” is extracted (step (2)).
The extracted “data processing time” is the time (reception data processing time) when the computer 202 performed data processing on the reception data detected in step (1).
In the example of FIG. 8, "2009060609151334" (2009/06/09 10: 15: 13.34) in the first row is extracted.
If multiple records containing the same “data ID” as the “data ID” of the received data extracted in step (1) are extracted from the computer internal data, the first record in the extracted Select the record that indicates the time of the first data processing for the received data.

Next, the test data management unit 107 specifies the newest backup file among the backup files before the “data processing time” extracted in step (2), and also specifies from the database state data. The database log record that is newer than the backup file and whose time before the “data processing time” of the computer internal data extracted in step (2) is indicated in “DB processing time” is specified. (Step (3)).
In the example of FIG. 8, “2009090608.bak” (the backup file dated June 08, 2009), which is the backup file earlier than “2009060609151334” identified in step (2) and the newest backup file. ) Is extracted. Further, the time is later than “2009090608.bak” and is earlier than “2009090910151334” (“2009090900012839” (2009/06/09 00: 01: 28.39 seconds)... (2009/06/09 10: 13: 28.34)) is extracted.
Next, the test data management unit 107 extracts the received data ID and the transmitted data ID extracted in step (1), the file name of the backup file extracted in step (3), and extracted in step (3). Test file is created by describing the file name and DB processing time of the database log indicated in the record (step (4)) and stored in the test data storage unit 108.

Next, in FIG. 3, based on an instruction from the user, the test execution unit 109 reads the test data stored in the test data storage unit 108, and database state data information (backup) among the read test data. (File information and database log information) are output to the database restoration unit 110, and the database restoration unit 110 restores the state of the database 201 (S305) (first database restoration step).
More specifically, the database restoration unit 110 stores the database state data based on the database state data information (file name of backup file, file name of database log and DB processing time) input from the test execution unit 109. The corresponding database state data is acquired from the unit 104, the update process indicated in the acquired database state data is traced until the reception data processing time is reached (the update process is reproduced), and the computer 202 receives the received data. The state of the database 201 at the time when data processing is performed is restored to the test database 401 (S306). At this time, the database restoration unit 110 can directly access the test database 401 via another computer.

Next, the test execution unit 109 acquires the reception data and transmission data corresponding to the received data ID and the transmission data ID indicated in the acquired test data from the network data collection unit 103, and acquires the received data. The data is output to the test network / data input / output unit 111, the test network / data input / output unit 111 outputs the received data to the external system simulation unit 112, and the external system simulation unit 112 receives the received data to the test target computer 402. Is output (S307).
In addition, the test execution unit 109 associates the transmission data acquired from the network data collection unit 103 with the ID of the reception data paired with the transmission data, and temporarily stores the data until response data for the reception data is input.

In FIG. 4, first, the external system simulation unit 112 inputs response data to the received data from the test target computer 402, and the external system simulation unit 112 outputs the response data to the test network data input / output unit 111. The network data input / output unit 111 outputs response data to the test execution unit 109 (S401).
Note that the response data from the test target computer 402 includes the ID of the corresponding received data.

Next, the test execution unit 109 associates the transmission data corresponding to the response data input in S401 with the response data and outputs it to the test result data storage unit 113, and the test result data storage unit 113 associates the response data with the transmission data. (S402).
That is, when the ID of the received data included in the input response data matches the ID of the received data associated with the temporarily stored transmission data, the test execution unit 109 The response data and the transmission data are associated and output to the test result data storage unit 113.

Next, the test result confirmation unit 114 collates the response data associated with the test result data storage unit 113 and the transmission data to determine whether or not they match (S403).
If the two match, the test target computer 402 is performing the same operation as the computer 202. On the other hand, if the two do not match, the test target computer 402 is performing a different operation from the computer 202. .

  Next, the test result confirmation unit 114 generates collation result data indicating the collation result of S403 and outputs the collation result data to the input / output control unit 120. The input / output control unit 120 outputs the collation result data to the input / output device 500, The input / output device 500 displays the collation result data and notifies the collation result to the user (S404).

  As described above, the test apparatus according to the present embodiment can restore the state of the database in the real system by following the update process in the database in the real system based on the processing time of the received data in the real system. The state of the system database can be efficiently reproduced in the database of the test system, and the efficiency of the test can be improved.

In the description of FIG. 3 and FIG. 4, the example in which the test of the test target computer 402 is performed using the reception data and the transmission data that are distributed between the computer 202 and the external system 300 as they are. Accordingly, the test computer 402 may be tested using the processed reception data and transmission data processed by the test data editing unit 117.
That is, the test data editing unit 117 inputs a user instruction including the reception data ID (or transmission data ID) to be processed via the input / output device 500 and the input / output control unit 120, and the user has received the instruction. A pair of reception data and transmission data is acquired from the network data storage unit 106, and the reception data and transmission data are processed in accordance with a user instruction (for example, a specific parameter value in the reception data is changed to change the reception data) Correspondingly, the parameter value in the transmission data is changed), a new reception data ID and transmission data ID are given to the processed reception data and transmission data, and the reception after processing together with the new reception data ID and transmission data ID Data and transmission data are stored in the network data storage unit 106.
If test data including the same reception data ID or transmission data ID as the processing target reception data ID or transmission data ID designated by the user is stored in the test data storage unit 108, the test data The editing unit 117 generates a copy of the test data, and converts the generated reception data ID and transmission data ID into a new reception data ID and transmission data ID (processed reception data and transmission data ID). Rewriting (data in the database state data is kept as it is), and the test data after rewriting the reception data ID and transmission data is stored in the test data storage unit 108.
Thereafter, when the user selects test data including a new reception data ID and transmission data ID and requests execution of the test, the processing from S304 in FIG. 3 is performed.
That is, the test execution unit 109 reads the test data indicating the IDs of the processed reception data and transmission data, reads the processed reception data and transmission data from the network data storage unit 106, and processes the reception data. Is output to the test target computer 402, response data for the received data after processing is input from the test target computer 402, and the test result confirming unit 114 compares the response data from the test target computer 402 with the processed transmission data. Is done.

  In this way, the reception data and transmission data transmitted and received between the computer 202 and the external system 300 can be processed, and the test target computer 402 can be tested using the processed reception data and transmission data. By simple operation, the test system can be tested under conditions different from those of the actual system, and a multifaceted test can be performed.

  Next, the network data collection unit 103, the database state data collection unit 101, the computer internal data collection unit 102, the test data management unit 107, the test execution unit 109, the database restoration unit 110, the test network data input / output unit 111 Details of the operations of the external system simulation unit 112, the test data editing unit 117, the test execution control unit 118, the test result confirmation unit 114, and the input / output control unit 120 will be described.

FIG. 9 is a flowchart illustrating an operation example of the network data collection unit 103.
The network data collection unit 103 reads the data analysis data from the data analysis data storage unit 115, and acquires the network data pattern to be discarded (S901).
Further, the network data collection unit 103 collects all network data flowing on the network connecting the external system 300 and the computer 202 of the real system 200 (S902).
Next, the network data collection unit 103 discards the network data to be discarded described in the data analysis data among the collected network data, and stores the network data not to be discarded as network data storage The data is stored in the unit 106 (S903).

FIG. 10 is a flowchart illustrating an operation example of the database state data collection unit 101.
The database state data collection unit 101 reads data analysis data from the data analysis data storage unit 115 and acquires a pattern of database state data to be discarded (S1001).
The database state data collection unit 101 collects database state data of the database 201 of the real system 200 (S1002).
The database state data collection unit 101 discards the database state data to be discarded described in the data analysis data among the collected database state data, and stores the database state data not to be discarded in the database state data storage unit 104. Save (S1003).

FIG. 11 is a flowchart showing an operation example of the computer internal data collection unit 102.
The computer internal data collection unit 102 reads the data analysis data from the data analysis data storage unit 115 and acquires the pattern of the computer internal data to be discarded (S1101).
The computer internal data collection unit 102 collects computer internal data from the computer 202 of the real system 200 (S1102).
The computer internal data collection unit 102 discards the computer internal data to be discarded described in the data analysis data among the collected computer internal data, and stores the computer internal data not to be discarded in the computer internal data storage unit 105. Save (S1103).

FIG. 12 is a flowchart illustrating an operation example of the test data management unit 107.
If there is a test data generation request from the test data generation unit 116, the test data management unit 107 generates test data.
First, the test data management unit 107 acquires network data from the network data storage unit 106 (S1201), and among the acquired network data, network data that has not been paired yet is received data and this data. 1 to 1 is paired with the transmission data corresponding to (S1203).
Next, the test data management unit 107 identifies computer internal data having the same data ID as the data ID of the received data from the computer internal data storage unit 105 (S1204).
Next, the test data management unit 107 specifies the newest backup file that is older than the data processing time of the specified computer internal data from the database state data. Furthermore, a database log that is newer than the acquired backup file and older than the data processing time of the specified computer internal data is specified from the database state data (S1205).
Finally, the test data management unit 107 stores, in the test data storage unit 108, the data IDs of the paired reception data and transmission data, and the specified backup file and database log information as test data. (S1206).
Note that the test data management unit 107 performs the processes of S1203, S1204, S1205, and S1206 until there is no unprocessed network data (S1202 and S1207).

FIG. 13 is a flowchart illustrating an operation example of the test execution unit 109.
If there is a request for acquiring a test data list from the test execution control unit 118, the test execution unit 109 generates a list of test data that can be executed from the test data storage unit 108, and the test execution control unit 118 (S1301).
If there is a test execution request from the test execution control unit 118, the test execution unit 109 acquires the test data indicated in the test execution request from the test data storage unit 108 (S1302).
The test execution unit 109 outputs the database state data information of the acquired test data to the database restoration unit 110 (S1303).
The test execution unit 109 acquires network data (reception data and transmission data) from the network data storage unit 106 on the basis of the data ID of the acquired reception data of the test data, and acquires the acquired reception data from the test network Output to the data input / output unit 111 (S1304). The acquired transmission data is temporarily stored until response data is input.
Further, the test execution unit 109 inputs the response of the output received data as test result data (response data), and outputs it to the test result data storage unit 113 together with the stored transmission data (S1305).

FIG. 14 is a flowchart illustrating an operation example of the database restoration unit 110.
The database restoration unit 110 acquires database state data (backup file and database log) from the database state data storage unit 104 using the database state data information input from the test execution unit 109, and acquires the acquired database state data. Is used to restore the state of the database 201 of the real system 200 (S1401).
In addition, the database restoration unit 110 updates the test database 401 of the test system 400 so as to match the contents restored in S1401 (S1402).

FIG. 15 is a flowchart showing an operation example of the test network / data input / output unit 111.
The test network data input / output unit 111 outputs the reception data input from the test execution unit 109 to the external system simulation unit 112 (S1501).
Further, the test network / data input / output unit 111 receives test result data (response data) which is a response to the received data from the external system simulation unit 112, and outputs this to the test execution unit 109 (S1502).

FIG. 16 is a flowchart illustrating an operation example of the external system simulation unit 112.
The external system simulation unit 112 outputs the reception data input from the test network / data input / output unit 111 to the test target computer 402 (S1601).
The external system simulation unit 112 also inputs test result data (response data) that is a response to the received data from the test target computer 402, and outputs this to the test network data input / output unit 111 (S1602).

FIG. 17 is a flowchart illustrating an operation example of the test data editing unit 117.
If there is a network data list acquisition request from the input / output control unit 120, the test data editing unit 117 creates a list of network data indicating editable received data IDs from the test data storage unit 108, This list is output to the input / output control unit 120 (S1701).
Further, the test data editing unit 117 inputs the received data ID to be edited from the input / output control unit 120 (S1702).
Next, the test data editing unit 117 acquires the reception data corresponding to the reception data ID specified in S1702 and the transmission data to be paired from the network data storage unit 106, and inputs the acquired reception data and transmission data. It outputs to the output control part 120 (S1703).
Next, the test data editing unit 117 inputs the editing contents for the reception data and the transmission data from the input / output control unit 120 (S1704).
Next, the test data editing unit 117 performs the editing specified in S1704 on the reception data and transmission data, and the edited reception data and transmission data together with the new reception data ID and transmission data ID is a network data storage unit. 106, the test data including the same reception data ID as the editing target reception data ID designated by the user is acquired from the test data storage unit 108, and a copy of the test data is generated. Then, the generated duplicate reception data ID and transmission data ID are rewritten to new reception data ID and transmission data ID, and the test data after rewriting the reception data ID and transmission data is stored in the test data storage unit 108 ( S1705).

FIG. 18 is a flowchart illustrating an operation example of the test execution control unit 118.
The test execution control unit 118 receives a request for acquiring a test data list from the input / output control unit 120, and outputs the request to the test execution unit 109 (S1801).
Next, the test execution control unit 118 receives the test data list from the test execution unit 109 and outputs it to the input / output control unit 120 (S1802).
Next, the test execution control unit 118 receives from the input / output control unit 120 a test execution request in which test data to be tested is clearly specified, and outputs a test execution request to the test execution unit 109 ( S1803).

FIG. 19 is a flowchart illustrating an operation example of the test result confirmation unit 114.
The test result confirmation unit 114 sequentially inputs transmission data and test result data associated with each other in the test result data storage unit 113 from the test result data storage unit 113 (S1901).
Next, the test result confirming unit 114 collates the input transmission data with the test result data (S1902), generates collation result data indicating the collation result, and if there is a request from the input / output control unit 120, the collation result data Are output to the input / output control unit 120 and collation result data designated by the input / output control unit 120 is output to the input / output control unit 120 (S1903).

  FIG. 20 is a flowchart illustrating an operation example of the input / output control unit 120.

  When the data analysis data is input from the input / output device 500, the input / output control unit 120 stores the data analysis data in the data analysis data storage unit 115 (S2001).

  If there is a request for test data generation from the input / output device 500, the input / output control unit 120 outputs a test data generation request to the test data generation unit 116 (S2002).

Also, if there is a request for editing test data from the input / output device 500, the input / output control unit 120 executes the following.
First, if there is a request for editable network data list display, this is output to the test data editing unit 117 (S2003).
Next, the network data list indicating the editable received data ID is input from the test data editing unit 117, and this is output to the input / output device 500 (S2004).
Next, if there is a request for acquiring network data designated from the input / output device 500, the network data acquisition request is output to the test data editing unit 117 (S2005).
Next, network data (reception data and transmission data) is input from the test data editing unit 117 and output to the input / output device 500 (S2006).
Finally, edit contents are input from the input / output device 500 and output to the test data editing unit 117 (S2007).

If there is a request for test execution from the input / output device 500, the input / output control unit 120 executes the following.
First, if there is a request to display a list of test data that can be executed, this is output to the test execution control unit 118 (S2008).
Next, an executable test data list is input from the test execution control unit 118, and is output to the input / output device 500 (S2009).
Finally, if there is a request for execution of the designated test data from the input / output device 500, the execution of the test for the test data is output to the test execution control unit 118 (S2010).

If there is a request for confirming the test result from the input / output device 500, the input / output control unit 120 executes the following.
First, if there is a request for collation result data list display, a collation result data list acquisition request is output to the test result confirmation unit 114 (2011).
Next, a collation result data list is input from the test result confirmation unit 114 and is output to the input / output device 500 (S2012).
Next, if there is a request for confirmation of collation result data from the input / output device 500, a request for obtaining collation result data designated by the input / output device 500 is output to the test result confirmation unit 114 (S2013).
Finally, if collation result data is input from the test result confirmation unit 114, it is output to the input / output device 500 (S2014).

  As described above, in the present embodiment, a test system that reproduces the actual system can be provided. Therefore, even in the IT system test including the database that has been low in test quality, the actual data and the actual system are provided. High-quality tests can be performed using the same environment.

As described above, in the present embodiment,
An apparatus that supports testing of a system using an external system, a working real system including a computer and a database, and a test system including a test target computer and a test system database having the same configuration as the real system. ,
Network data collection means for collecting network data on a network connecting the external system and the computer;
Database state data collection means for collecting data on the state of the database of the real system (database state data);
Computer internal data collection means for collecting data (computer internal data) related to processing information of the computer of the real system;
Test data management means for creating test data by associating the network data and the database state data using the computer internal data;
Database restoration means for restoring the test database using the database state data corresponding to the network data to be tested before performing the test;
Network data reproduction means for testing for inputting the collected network data from the test apparatus to the test target computer of the test system;
A test apparatus having a data collating unit that collates a response to the network data input to the test target computer and the network data that is a response to the input network data has been described.

In the present embodiment,
Data analysis means for analyzing the network data and the database state data, and the computer internal data;
A test apparatus having means for reading data analysis data serving as an analysis standard used by the data analysis means has been described.

In the present embodiment,
Test data generating means for generating the test data according to the operation of the input / output device by a tester;
A test apparatus having test data editing means for editing the test data according to the operation of the input / output device by the tester has been described.

  In the present embodiment, the test apparatus having the test execution means for executing the test data according to the operation of the input / output device by the tester has been described.

In the present embodiment,
The test apparatus having the test result confirming means for confirming the data collation result by the data collating means according to the operation of the input / output device by the tester has been described.

In the present embodiment,
A test apparatus has been described that has means for distributing input values from the input / output device by the tester to each function and input / output control means for displaying the output value from the test device to the tester on the input / output device.

Finally, a hardware configuration example of the test apparatus 100 shown in the present embodiment will be described.
FIG. 21 is a diagram illustrating an example of hardware resources of the test apparatus 100 illustrated in the present embodiment.
The configuration in FIG. 21 is merely an example of the hardware configuration of the test apparatus 100, and the hardware configuration of the test apparatus 100 is not limited to the configuration illustrated in FIG. .

In FIG. 21, the test apparatus 100 includes a CPU 911 (also referred to as a central processing unit, a central processing unit, a processing unit, a processing unit, a microprocessor, a microcomputer, and a processor) that executes a program.
The CPU 911 is connected to, for example, a ROM (Read Only Memory) 913, a RAM (Random Access Memory) 914, a communication board 915, a display device 901, a keyboard 902, a mouse 903, and a magnetic disk device 920 via a bus 912. Control hardware devices.
Further, the CPU 911 may be connected to an FDD 904 (Flexible Disk Drive), a compact disk device 905 (CDD), a printer device 906, and a scanner device 907. Further, instead of the magnetic disk device 920, a storage device such as an optical disk device or a memory card (registered trademark) read / write device may be used.
The RAM 914 is an example of a volatile memory. The storage media of the ROM 913, the FDD 904, the CDD 905, and the magnetic disk device 920 are an example of a nonvolatile memory. These are examples of the storage device.
The database state data storage unit 104, the computer internal data storage unit 105, the network data storage unit 106, the test data storage unit 108, the test result data storage unit 113 described in this embodiment are the RAM 914, the magnetic disk device 920, etc. It is realized by.
A communication board 915, a keyboard 902, a mouse 903, a scanner device 907, an FDD 904, and the like are examples of input devices.
The communication board 915, the display device 901, the printer device 906, and the like are examples of output devices.

  The communication board 915 is connected to the network. For example, the communication board 915 may be connected to a LAN (local area network), the Internet, a WAN (wide area network), a SAN (storage area network), or the like.

The magnetic disk device 920 stores an operating system 921 (OS), a window system 922, a program group 923, and a file group 924.
The programs in the program group 923 are executed by the CPU 911 using the operating system 921 and the window system 922.

The RAM 914 temporarily stores at least part of the operating system 921 program and application programs to be executed by the CPU 911.
The RAM 914 stores various data necessary for processing by the CPU 911.

The ROM 913 stores a BIOS (Basic Input Output System) program, and the magnetic disk device 920 stores a boot program.
When the test apparatus 100 is activated, the BIOS program in the ROM 913 and the boot program in the magnetic disk device 920 are executed, and the operating system 921 is activated by the BIOS program and the boot program.

  The program group 923 stores programs that execute the functions described as “˜unit” (other than “˜data storage unit”) in the description of the present embodiment. The program is read and executed by the CPU 911.

In the description of the present embodiment, the file group 924 includes “determination of”, “restoration of”, “update of”, “collation of”, “generation of”, “evaluation of”, Information, data, signal values, variable values, and parameters indicating the results of the processing described as “setting of”, “registration of”, “selection of”, etc. are “~ file” or “˜database”. It is memorized as each item.
The “˜file” and “˜database” are stored in a recording medium such as a disk or a memory. Information, data, signal values, variable values, and parameters stored in a storage medium such as a disk or memory are read out to the main memory or cache memory by the CPU 911 via a read / write circuit, and extracted, searched, referenced, compared, and calculated. Used for CPU operations such as calculation, processing, editing, output, printing, and display.
Information, data, signal values, variable values, and parameters are stored in the main memory, registers, cache memory, and buffers during the CPU operations of extraction, search, reference, comparison, calculation, processing, editing, output, printing, and display. It is temporarily stored in a memory or the like.
Also, the arrows in the flowchart described in this embodiment mainly indicate input / output of data and signals, and the data and signal values are the RAM 914 memory, the FDD904 flexible disk, the CDD905 compact disk, and the magnetic disk device. It is recorded on a recording medium such as a 920 magnetic disk, other optical disks, minidisks, and DVDs. Data and signals are transmitted online via a bus 912, signal lines, cables, or other transmission media.

  In addition, what is described as “to part” (other than “to data storage part”) in the description of the present embodiment may be “to circuit”, “to apparatus”, and “to equipment”. Also, “˜step”, “˜procedure”, and “˜processing” may be used. That is, what is described as “˜unit” (other than “˜data storage unit”) may be realized by firmware stored in the ROM 913. Alternatively, it may be implemented only by software, only hardware such as elements, devices, substrates, wirings, etc., or a combination of software and hardware, and further a combination of firmware. Firmware and software are stored as programs in a recording medium such as a magnetic disk, a flexible disk, an optical disk, a compact disk, a mini disk, and a DVD. The program is read by the CPU 911 and executed by the CPU 911. In other words, the program causes the computer to function as “to part” (other than “to data storage part”) of the present embodiment. Alternatively, the procedure or method of “˜unit” (other than “˜data storage unit”) of the present embodiment is executed by a computer.

  As described above, the test apparatus 100 shown in this embodiment includes a CPU as a processing device, a memory as a storage device, a magnetic disk, a keyboard as an input device, a mouse, a communication board, and a display device as an output device, a communication board, and the like. As described above, the computer includes the functions indicated as “˜unit” (other than “˜data storage unit”) using these processing devices, storage devices, input devices, and output devices.

  DESCRIPTION OF SYMBOLS 100 Test apparatus, 101 Database state data collection part, 102 Computer internal data collection part, 103 Network data collection part, 104 Database state data storage part, 105 Computer internal data storage part, 106 Network data storage part, 107 Test data Management unit, 108 Test data storage unit, 109 Test execution unit, 110 Database restoration unit, 111 Test network / data input / output unit, 112 External system simulation unit, 113 Test result data storage unit, 114 Test result confirmation unit, 115 Data analysis data storage unit, 116 test data generation unit, 117 test data editing unit, 118 test execution control unit, 120 input / output control unit, 200 real system, 201 database, 202 computer, 300 external system, 400 Test system, 401 test database, 402 computer to be tested, 500 input / output device.

Claims (7)

It is connected to a first system including a first computer that transmits and receives data to and from a communication destination system, and a first database that is updated based on data processing in the first computer. A data processing device,
A reception data processing time information input unit for inputting reception data processing time information indicating, as reception data processing time, a time of data processing performed on the reception data received by the first computer from the communication destination system;
A first database state information input unit that indicates a progress of update in the first database and inputs first database state information capable of restoring the first database at an arbitrary time by following the progress of the update; ,
Based on the received data processing time indicated in the received data processing time information, the update process indicated in the first database status information is followed, and the first computer performs data processing on the received data. A data processing apparatus comprising: a first database restoring unit that restores the first database at the time of execution. The data processing device further includes:
Connected to a second system including a second computer and a second database used by the second computer;
The data processing device further includes:
A reception data input unit for inputting the reception data;
A reception data output unit for outputting the reception data input by the reception data input unit to the second computer;
2. The data processing according to claim 1, further comprising: a second database updating unit that updates the second database so as to match the first database restored by the first database restoring unit. apparatus. The data processing device further includes:
A transmission data input unit for inputting transmission data transmitted from the first computer to the communication destination system as a response to the reception data;
Verification in which the second computer uses the second database updated by the second database update unit to input data generated as a response to the received data input from the received data output unit as verification target data The target data input section,
The data processing according to claim 2, further comprising: a data collating unit that collates the transmission data input by the transmission data input unit and the verification target data input by the verification target data input unit. apparatus. The first database state information input unit includes:
A backup file that periodically records the contents of the first database and a log file that indicates an update history in the first database are input as the first database state information,
The first database restoration unit
A backup file and a log file corresponding to a period before the reception data processing time indicated in the reception data processing time information are extracted, and the reception data processing time is reached using the extracted backup file and log file. The first database is restored at the time when the first computer performs data processing on the received data by following the progress of the update in the first database. A data processing apparatus according to any one of the above. The data processing device further includes:
Connected to a second system including a second computer and a second database used by the second computer;
The data processing device further includes:
A reception data input unit for inputting the reception data;
A received data processing unit for processing the received data input by the received data input unit;
A transmission data input unit for inputting transmission data transmitted from the first computer to the communication destination system as a response to the reception data;
A transmission data processing unit that processes the transmission data input by the transmission data input unit;
A received data output unit that outputs the received data processed by the received data processing unit to the second computer as processed received data;
A second database updating unit that updates the second database to match the first database restored by the first database restoring unit;
Using the second database updated by the second database updating unit, the second computer inputs data generated as a response to the processed received data input from the received data output unit as verification target data A data input unit to be verified,
5. The data verification unit according to claim 1, further comprising: a data collation unit that collates the transmission data processed by the transmission data processing unit and the verification target data input by the verification target data input unit. A data processing device according to any one of the above. It is connected to a first system including a first computer that transmits and receives data to and from a communication destination system, and a first database that is updated based on data processing in the first computer. A data processing method by a computer,
A reception data processing time information input step in which the computer inputs reception data processing time information indicating, as reception data processing time, a time of data processing performed by the first computer on reception data received from the communication destination system; ,
First database state information in which progress of update in the first database is indicated and the computer inputs first database state information that can restore the first database at an arbitrary time by following the progress of the update An input step;
The computer follows the update process indicated in the first database state information based on the reception data processing time indicated in the reception data processing time information, and the first computer And a first database restoring step of restoring the first database at the time of performing data processing on the data processing method. It is connected to a first system including a first computer that transmits and receives data to and from a communication destination system, and a first database that is updated based on data processing in the first computer. On the computer,
A received data processing time information input process for inputting received data processing time information indicating a time of data processing performed on the received data received by the first computer from the communication destination system as a received data processing time;
A first database state information input process in which the progress of the update in the first database is indicated, and the first database state information capable of restoring the first database at an arbitrary time is traced by following the progress of the update; ,
Based on the received data processing time indicated in the received data processing time information, the update process indicated in the first database status information is followed, and the first computer performs data processing on the received data. A program for executing a first database restoration process for restoring the first database at the time of execution.

Images