JP2011039723A - Test data creation device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily create test data having attributes which are equivalent to those of production data while preventing the leakage of personal information included in the production data. <P>SOLUTION: Production data transmitted from a low order server to a high order server of a business system under operation are received in parallel or in the middle, and personal information included in the production data is converted on the basis of predetermined data conversion definition information, and test data whose data attributes are equal to those of the production data from which any individual cannot be predetermined are created, and the created test data are transmitted to a test object server as the alternative object of the high order server. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a test data creation apparatus for creating test data necessary for operation tests of various computer systems.

  In recent years, daily operations of companies and the like are supported by computer systems. When developing and maintaining such a business system, it must be operated under the same conditions as the business environment and the operation of the program must be fully verified. In other words, since a large amount of data is handled in the actual operation of the business system, a large amount of test data that assumes every actual operation state is required even in the test stage. However, it is often difficult to create a large amount of high-quality test data. Therefore, in the case of performing a test, data created in actual operation (hereinafter referred to as “production data”) is often used as test data.

  The ETC (Electronic Toll Collection System) system is a business system that collects tolls on expressways, and usage data is sent between the central management server and the servers installed at each tollgate every time the vehicle passes through the tollgate. Are being sent and received. In this ETC system, usage details data transmitted in large quantities from day to night from each toll gate server is aggregated for each credit card number in the central management server, and the created billing information is transmitted to the credit card company. Therefore, when testing the central management server, which is a higher-level server constituting this business system, it is necessary to perform a test using the usage details data (production data) created in the actual operation. However, since usage details data includes personal information such as credit card numbers, it is necessary to protect personal information such as restrictions on users who can access usage details data and prohibition of usage details data when testing. Various measures are also necessary.

  As a technology related to personal information protection, create take-out data that cannot identify personal information from production data including personal information, create test data with attributes equivalent to production data from this take-out data, and There is known a test data creation device that prevents unauthorized leakage of data and improves the efficiency of test data creation (see Patent Document 1).

JP 2008-65687 A

  However, in the above technique, since the production data including the personal information is temporarily stored in the database and then the production data is modified to create test data, the database can be accessed. Personal information may be leaked. In addition, a large-scale business system operation test requires a large number of personnel, but if there are many users who can access production data, management of information becomes more difficult.

  In view of the above-described problems of the prior art, the present invention provides a test data creation device that can easily create test data having attributes equivalent to production data while preventing leakage of personal information included in production data. For the purpose.

  A test data creation device according to the present invention includes a data receiving unit that receives production data transmitted from a lower server to an upper server in an operational business system, and the production data based on predetermined data conversion definition information. A data conversion unit that converts the personal information included, creates test data that has the same data attributes as the production data, and cannot identify an individual, and a test target that is the replacement target of the host server for the created test data And a data transmission unit for transmission to the server.

  ADVANTAGE OF THE INVENTION According to this invention, the test data creation apparatus which can create test data with the attribute equivalent to production data easily is provided, preventing the leakage of the personal information contained in production data.

1 is a block diagram showing an example of a system to which a test data creation apparatus according to Embodiment 1 of the present invention is applied. The figure which shows the hardware structural example of the test data creation apparatus shown in FIG. The block diagram which shows the structural example of the test data creation apparatus shown in FIG. The figure which shows the specific example of the memory content of the data conversion definition memory | storage part shown in FIG. The flowchart which shows the process example of the test data creation apparatus shown in FIG. The figure explaining the data conversion process in the data conversion part shown in FIG. The block diagram which shows the example of the system with which the test data creation apparatus which concerns on Embodiment 2 of this invention is applied. The block diagram which shows the structural example of the test data creation apparatus shown in FIG. 8 is a flowchart showing a processing example of the test data creation device shown in FIG. The block diagram which shows the example of the system with which the test data creation apparatus which concerns on Embodiment 3 of this invention is applied. FIG. 11 is a block diagram illustrating a configuration example of the test data creation apparatus illustrated in FIG. 10. 11 is a flowchart showing a processing example of the test data creation apparatus shown in FIG.

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
<Embodiment 1>
FIG. 1 is a block diagram showing an example of an ETC system to which a test data creation apparatus 1 according to Embodiment 1 of the present invention is applied. Here, in the ETC system to which the test data creation device 1 is applied, the toll gate server 4 (lower server) of each tollgate on the expressway is connected to one existing central management server 2 (upper server) via the network 3. A computer system that manages toll collection on highways. Specifically, when an ETC vehicle 6 equipped with an ETC vehicle-mounted device passes through the ETC gate 5 connected to the toll gate server 4, the stored information of the ETC card inserted into the ETC vehicle-mounted device is transmitted by ETC via wireless communication. When the information is read by the lane device of the gate 5 and this information is transmitted to the toll gate server 4, the toll gate server 4 transmits the usage details data including the toll according to the toll section and the vehicle type to the existing central management server 2. To do. In addition, the existing central management server 2 stores the usage details data transmitted from each tollgate server 4 in a database (not shown), and manages it with the card number and the usage date and time. Then, the existing central management server 2 aggregates the usage details data stored in the database for each card user and transmits the billing information to the credit card company system 7.

  Similar to the existing central management server 2, the test data creation device 1 is connected to the toll gate server 4 via the network 3, and receives the usage details data that is the actual data from the toll gate server 4. This is a computer that performs predetermined conversion processing on the data to create test data, and transmits the test data to the new central management server 8 that is an alternative to the existing central management server 2. In the new central management server 8, various operation tests are performed based on the test data.

  FIG. 2 is a diagram illustrating a configuration example of a computer applied to the test data creation apparatus 1 according to an embodiment of the present invention. As shown in the figure, a computer applied to the test data creation apparatus 1 includes a CPU (Central Processing Unit) 11, a ROM (Read Only Memory) 12, a RAM (Random Access Memory) 13, an input / output interface 14, and a system. The bus 15, the input device 16, the display device 17, the auxiliary storage device 18, and the communication device 19 are included.

  The CPU 11 is a processing device that executes various arithmetic processes using programs and data stored in the ROM 12 and the RAM 13. The ROM 12 is a read-only storage device that stores basic programs and environment files for causing the computer to function. The RAM 13 is a storage device that stores a program executed by the CPU 11 and data necessary for execution of each program, and can be read and written at high speed. The input / output interface 14 is a device and a program that mediate connection between various hardware and the system bus 15. The system bus 15 is an information transmission path shared by the CPU 11, ROM 12, RAM 13 and input / output interface 14.

  The input / output interface 14 is connected with hardware such as an input device 16, a display device 17, an auxiliary storage device 18, and a communication device 19. The input device 16 is a device that processes input from a user, and is, for example, a keyboard or a mouse. The display device 17 is a device that displays a calculation result, a creation screen, and the like to the user, and is, for example, a CRT, a liquid crystal display, a plasma display, or the like. The auxiliary storage device 18 is a large-capacity storage device that stores programs and data, and is, for example, a hard disk device.

  FIG. 3 is a block diagram showing a configuration example of the test data creation apparatus 1 shown in FIG. As shown in the figure, the test data creation apparatus 1 includes a data reception unit 101, a data conversion definition creation unit 102, a data conversion definition storage unit 103, a data conversion unit 104, and a data transmission unit 105.

  The data receiving unit 101 is a program that receives usage details data (production data) transmitted from the toll gate server 4 (lower server) to the existing central management server 2 (upper server) during operation of the ETC system (business system). is there. In the present embodiment, the existing central management server 2 and the test data creation device 1 are set in advance as transmission destinations of the usage details data in the toll gate server 4, and the test data creation device 1 has the same data as the existing central management server 2. Are received in parallel.

  The data conversion definition creation unit 102 is a program that creates data conversion definition information that defines items to be converted in the usage details data and stores the data conversion definition information in the data conversion definition storage unit 103. In this embodiment, information that can identify an individual is a conversion target, but the conversion target can be arbitrarily specified. FIG. 4 is a diagram showing a specific example of the contents stored in the data conversion definition storage unit 103 shown in FIG. Here, in addition to the data item name, data start position, data length, and data type included in the usage details data (message) transmitted from the toll booth server 4, a conversion flag for determining an item that needs to be converted is stored. It is indicated that the credit card number and the card expiration date are to be converted.

  The data conversion unit 104 converts personal information included in the usage specification data based on the data conversion definition information stored in advance in the data conversion definition storage unit 103, and specifies the individual whose usage attribute data and data attributes are equal. This program creates test data that cannot be used. The conversion method is not particularly limited as long as it is an irreversible conversion. However, in order to obtain data that can be stored in the database (not shown) of the newly installed central management server 8, data type conversion is not performed, and data attributes (data length) And the data type) are the same as the usage details data.

  The data transmission unit 105 is a program that transmits the test data created in the data conversion unit 104 to the new central management server 8 that is a replacement target (test target) of the existing central management server 2 (higher server).

  Hereinafter, the operation of the test data creating apparatus 1 configured as described above will be described with reference to the drawings. FIG. 5 is a flowchart showing a processing example of the test data creation apparatus 1 shown in FIG.

In step S <b> 501, the data conversion unit 104 acquires data conversion definition information from the data conversion definition storage unit 103.
In S <b> 502, the data receiving unit 101 receives the usage details data from each tollgate server 4.

In step S <b> 503, the data conversion unit 104 outputs test data created by converting data related to personal information, which is an item to be converted in the usage specification data, based on the data conversion definition information to the data transmission unit 105. FIG. 6 is a diagram for explaining data conversion processing in the data conversion unit 104 shown in FIG. Here, a plurality of usage details data are received, and the data includes a toll gate ID, credit card number, card expiration date, usage date and time, toll and vehicle model code. Among these data items, It is shown that data conversion is performed for credit card numbers and card expiration dates, and test data is created in which the credit card numbers and card expiration dates in the usage statement data are changed to data that cannot be estimated. .
In step S504, the data transmission unit 105 transmits the test data output from the data conversion unit 104 to the new central management server 8 that is a test target, and ends the process.

  As described above, according to the test data creation apparatus 1 according to the present embodiment, personal information in the received usage details data is modified while maintaining the data attributes, and thus the personal information is protected. A test environment can be created and a system that can easily switch between operation and test can be constructed. Further, because the test data created in the data conversion unit 104 is transmitted in real time to the new central management server 8 that is the test target, the same load as that applied to the existing central management server 2 in operation is loaded. The reliability of the driving test can be further increased.

<Embodiment 2>
FIG. 7 is a block diagram illustrating an example of a system to which the test data creation apparatus 1 according to the second embodiment of the present invention is applied. As shown in the figure, the test data creation apparatus 1 according to the present embodiment differs from the first embodiment in the transmission of the existing central management server 2 and the toll gate server 4 operating in the toll gate central management center. After the arrangement, the apparatus is configured to be able to connect to the new central management server 8 to be tested by moving the apparatus to the test site. It is assumed that the existing central management server 2 is directly connected to the toll gate server 4 when the connection between the test data creation device 1 and the existing central management server 2 is released.

  FIG. 8 is a block diagram illustrating a configuration example of the test data creation apparatus 1 illustrated in FIG. As shown in the figure, the test data creation device 1 according to the present embodiment is configured to further include a test data storage unit 106 with respect to the test data creation device 1 according to the first embodiment. In addition, since the code | symbol common with the code | symbol attached | subjected in FIG. 2 represents the same object, description is abbreviate | omitted and below demonstrates a different location in detail.

  The test data storage unit 106 is a storage device that stores the test data created by the data conversion unit 104. When connected to the existing central management server 2, the data conversion unit 104 outputs the usage statement data sequentially received by the data reception unit 101 to the data transmission unit 105 as it is, and the data conversion definition storage unit 103. Based on the data conversion definition information acquired from the test data, test data obtained by converting personal information included in the usage details data is created, and this test data is sequentially stored in the test data storage unit 106.

  When the data transmission unit 105 receives a test data transmission request from the new central management server 8 after being connected to the new central management server 8, the data transmission unit 105 acquires the test data from the test data storage unit 106. Transmission to the management server 8 is performed.

  Hereinafter, the operation of the test data creating apparatus 1 configured as described above will be described with reference to the drawings. FIG. 9 is a flowchart showing a processing example of the test data creation apparatus 1 shown in FIG.

  In S901, the data transmission unit 105 determines whether or not it is connected to the existing central management server 2 in operation. If it is determined that the connection is established, the process proceeds to S902. On the other hand, if it is determined that it is not connected, it is in a standby state until it is connected.

In step S <b> 902, the data conversion unit 104 acquires data conversion definition information from the data conversion definition storage unit 103.
In step S <b> 903, the data receiving unit 101 receives usage details data from each tollgate server 4.

In step S <b> 904, the data transmission unit 105 transmits the usage details data received by the data reception unit 101 to the existing central management server 2.
In step S <b> 905, the data conversion unit 104 converts data related to personal information that is a conversion target item in the usage details data based on the data conversion definition information, and creates test data.

  In step S906, the data conversion unit 104 stores the test data created by the conversion in the test data storage unit 106.

  In S907, the data receiving unit 101 determines whether or not the connection with the existing central management server 2 has been released. If it is determined that the connection has been released, the process proceeds to S908. On the other hand, if it is determined that the connection is maintained, the process returns to S903, and the creation and storage of test data are repeated until the connection is released.

  In step S908, the data transmission unit 105 determines whether or not it is connected to the new central management server 8 to be tested. If it is determined that the connection is established, the process proceeds to S909. On the other hand, if it is determined that the connection is not established, the standby state is maintained until the new central management server 8 is connected.

  In S909, when the data transmission unit 105 receives a test data transmission request from the new central management server 8, the data transmission unit 105 extracts the test data stored in the test data storage unit 106, and this test data is the new central management which is the test target. The data is transmitted to the server 8, and the process is terminated.

  As described above, according to the test data creation device 1 according to the present embodiment, the test data creation device 1 is stored in the test data creation device 1 after temporarily storing the test data obtained by modifying the personal information of the usage details data. Since it is possible to connect to the newly installed central management server 8 installed at a place, a test environment using production data can be easily constructed. In other words, the test environment based on the test data obtained by modifying the operation environment and personal information can be easily switched by attaching / detaching the test data creation device 1. For this reason, when production data is borrowed from a road operator for testing on the development side, the reliability and reliability of driving tests should be improved while ensuring data integrity and safety for road operators. Can do.

<Embodiment 3>
FIG. 10 is a block diagram illustrating an example of a system to which the test data creation device 1 according to Embodiment 3 of the present invention is applied. As shown in the figure, unlike the first embodiment, the ETC system to which the test data creation apparatus 1 according to the present embodiment is applied includes two servers, an existing central management server 2A and an existing central management server 2B. One server is operated, and the other server is on standby. Here, a case is shown in which the existing central management server 2A is operated and the existing central management server 2B on standby is set as a test target. The test data creation device 1 is arranged between the existing central management servers 2A and 2B and each toll gate server 4, and is configured as a node that relays the usage details data.

  FIG. 11 is a block diagram showing a configuration example of the test data creation apparatus 1 shown in FIG. As shown in the figure, the test data creation device 1 according to the present embodiment is configured to further include a test target switching unit 107 with respect to the test data creation device 1 according to the first embodiment. In addition, since the code | symbol common with the code | symbol attached | subjected in FIG. 2 represents the same object, description is abbreviate | omitted and below demonstrates a different location in detail.

  The test target switching unit 107 is a program that changes a test data transmission destination based on externally input test target designation information and switches a test target server. In the present embodiment, the test target designation information is recorded in an environment file (not shown) and is referred to by the data transmission unit 105 at the time of data transmission, and is designated by either the existing central management server 2A or the existing central management server 2B. Is done. Examples of the external input method include a method of displaying a test object switching screen (not shown) and selecting it using the input device 16 such as a mouse, and a method of providing a switch in the test data creation device 1. It is done.

  Hereinafter, the operation of the test data creating apparatus 1 configured as described above will be described with reference to the drawings. FIG. 12 is a flowchart showing a processing example of the test data creation apparatus 1 shown in FIG.

  In step S1201, the test target switching unit 107 determines the presence / absence of external input information that is a test target switching request. If it is determined that there is a request to switch the test target, the process proceeds to S1202. On the other hand, if it is determined that there is no request to switch the test target, the process proceeds to S1203.

In S1202, the data transmission unit 105 updates the test target designation information that defines the data transmission destination based on the external input information.
In S <b> 1203, the data receiving unit 101 receives usage details data from each tollgate server 4.
In step S1204, the data transmission unit 105 acquires test target designation information.

In step S1205, the data transmission unit 105 transmits the usage details data received by the data reception unit 101 to the operating server (existing central management server 2A) based on the test target designation information.
In step S <b> 1206, the data conversion unit 104 acquires data conversion definition information from the data conversion definition storage unit 103.
In step S1207, the data conversion unit 104 converts data related to personal information, which is an item to be converted in the usage details data, based on the data conversion definition information, and creates test data.

  In S1208, the data transmission unit 105 transmits the test data created in the data conversion unit 104 to the test target server (existing central management server 2B) based on the test target designation information, and ends the process.

  As described above, according to the test data creation apparatus 1 according to the present embodiment, it is possible to easily switch between a test environment and an operation environment that can be tested after data protection is performed on confidential information such as personal information. Leakage of personal information can be prevented when using.

  Note that the present invention is not limited to the above-described embodiment as it is, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage. In addition, various inventions can be formed by appropriately combining a plurality of components disclosed in the embodiment. That is, some components may be deleted from all the components shown in the embodiment. Furthermore, constituent elements over different embodiments may be appropriately combined.

  For example, in the above embodiment, the test data creation apparatus 1 is applied to the ETC system, but the business system to be applied is not limited to this, and may be other business systems such as a financial system, an order shipment system, and an electronic medical record management system. It can be used for testing a business system in which production data including personal information and confidential information transmitted from a lower server (or terminal) connected to a network is processed by the upper server.

  In addition, the data conversion target item can be changed by updating the environment file. However, if the change is not required depending on the configuration of the business system or production data, it may be defined directly in the conversion program. . The design can be arbitrarily changed.

  Further, in the second embodiment, the test data transmission timing stored in the test data storage unit 106 is assumed to be a test data transmission request. Since the usage time data reception time data (utilization date and time) is stored separately from the modified data, the test data is transmitted to the data transmission unit 105 at the same time as reception to adjust the data amount per unit time. This makes it possible to apply the same load to the newly installed central management server 8 as the load applied to the existing central management server 2 in operation even when the test location and time are different, and to improve the reliability of the operation test. It can be further increased.

DESCRIPTION OF SYMBOLS 1 ... Test data creation apparatus 2, 2A, 2B ... Existing central management server 3 ... Network 4 ... Toll gate server 5 ... ETC gate 6 ... ETC vehicle 7 ... Credit card company system 8 ... New central management server 11 ... CPU
12 ... ROM
13 ... RAM
DESCRIPTION OF SYMBOLS 14 ... Input / output interface 15 ... System bus 16 ... Input device 17 ... Display device 18 ... Auxiliary storage device 19 ... Communication device 101 ... Data receiving unit 102 ... Data conversion definition creation unit 103 ... Data conversion definition storage unit 104 ... Data conversion unit 105 ... Data transmission unit 106 ... Test data storage unit 107 ... Test target switching unit

Claims (5)

A data receiving unit for receiving production data transmitted from the lower server to the upper server in the operating business system;
A data conversion unit that converts personal information included in the production data based on predetermined data conversion definition information, creates test data that has the same data attributes as the production data and cannot identify an individual, and
A data transmission unit for transmitting the created test data to a test target server to be a replacement target of the upper server;
A test data creation device comprising: A test data storage unit for storing the test data created in the data conversion unit;
The data conversion unit stores the test data created by the conversion in the connection state with the host server in the test data storage unit, and the data transmission unit stores the test data in the connection state with the test target server. The test data creation apparatus according to claim 1, wherein the test data stored in a data storage unit is extracted and transmitted to the test target server.   The test data creation apparatus according to claim 1, further comprising a test target switching unit that changes a transmission destination of the test data based on externally input test target designation information and switches the test target server.   The data transmission unit adjusts a data transmission amount per unit time based on reception time data included in the test data stored in the test data storage unit, and transmits the test data to the test target server. The test data creation device according to claim 2. The upper server is a central management server that centrally manages the collection of tolls at a toll booth provided in a plurality of expressway networks; and
The subordinate server is connected to the central management server via the network at the toll gate, and generates usage data and transmits it to the central management server each time a vehicle equipped with an ETC on-board unit passes through the toll gate If it is a tollgate server to
The data receiving unit receives the usage specification data as the production data, and the data conversion unit converts the credit card number included in at least the usage specification data to create the test data. The test data creation device according to any one of claims 1 to 4.

Images