JP4344447B2 - Test data generation apparatus, test data generation method, and storage medium storing program for causing computer to perform processing in system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a test data generation apparatus that generates test data equivalent to actual operation for system testing. Specifically, the present invention generates test data in which confidential information is protected by concealing data being used in actual operation. Provided is a test data generation device that restores items necessary for verification of test data after a test is performed in accordance with authentication.
[0002]
The present invention also relates to such a test data generation method and a storage medium storing a program for causing a computer to perform processing in the system.
[0003]
[Prior art]
In system development, system testing according to actual operation before system introduction is an indispensable process. In the system test, since more realistic operation is tested, more realistic test data corresponding to the data actually used is required. Therefore, conventionally, a system test is carried out by diverting data already accumulated in business, or a fictitious data assuming actual operation is created and the system test is performed.
[0004]
[Problems to be solved by the invention]
However, the conventional test data creation has the following problems.
[0005]
Some systems that are developed may handle very sensitive information. In addition, system development often includes developers other than information managers who manage highly confidential information. Therefore, conventionally, test data composed of fictitious data that can be disclosed has been created. In creating test data, it is necessary to create data in consideration of not only system characteristics but also information characteristics. Furthermore, in the case of a test that processes a large amount of data, since it is necessary to process a large amount of data that can occur randomly and continuously, a large amount of process and time are required to create the test data.
[0006]
Further, when it is necessary to create test data in accordance with the level of disclosure of the person in charge of development, further steps are required, and the burden on the information manager who manages these several types of test data has increased.
[0007]
Therefore, the first problem of the present invention is to generate test data in which confidential information is protected by concealing data that is being used in actual operation, and is necessary for verification of test data after test execution according to authentication. It is to provide a test data generation device for restoring items.
[0008]
Similarly, the second problem of the present invention is to generate test data in which confidential information is protected by concealing data in use in actual operation, and verification of test data after test execution according to authentication It is to provide a test data generation method for restoring items necessary for the test.
[0009]
A third object of the present invention is to provide a storage medium storing a program for causing a computer to perform the processing in the test data generating apparatus as described above.
[0010]
[Means for Solving the Problems]
In order to solve the first problem, the present invention provides a test data generation apparatus for generating test data in which information data is concealed, as described in claim 1. the above Information data Selected by user Item Against How to conceal Obtained from the user Concealment method Get Means, Selected by the above user item Information item number and the concealment method obtained from the above user In Store Concealment information storage means for In the above information data, Concealment information Data corresponding to the item number stored in the file is stored by the concealment method stored in the concealment information file. Concealment By Test data generating means for generating test data.
[0011]
Since such a test data generation device conceals already used information data and generates test data, realistic test data can be created. Since the concealment setting means can set the concealment method according to the item of the information data, it is possible to create test data according to the disclosure level of the tester who uses the test data.
[0012]
The information data is, for example, highly confidential information data such as customer information.
[0013]
From the viewpoint that the information data can be concealed according to the set concealment method, the present invention provides the test data generation means, as described in claim 2, wherein the test data generation means sequentially records the information data. The concealment method is set by the random concealment means for taking out and replacing the item for which the concealment method is set by the concealment method setting means with the same item of another record selected at random, and the concealment method setting means A character replacement unit that replaces the item of the information data with a predetermined character string, and the information data is concealed by the random replacement unit or the character replacement unit based on the concealment information. it can.
[0014]
Such a test data generation apparatus can conceal a specified item by random replacement or character replacement.
[0015]
In addition, from the viewpoint that the concealment method can be set according to the item of information data, the present invention is as described in claim 3, Up Concealment method Get By means The above user Referable Define the information data items Data item definition analyzing means for creating an item definition information file, and the concealment method Get Means the above Item definition information file Use The A screen for acquiring the concealment method from the user is displayed on the display unit. The Above to the user Set the concealment method according to the information data item Let Can be configured.
[0016]
Since such a test data generation device can analyze the item definition of information data, it is not necessary to manually analyze the item definition of information data.
[0017]
The definition information includes an item name that constitutes a record of information data, a data format attribute of each item, the number of digits, and the like.
[0018]
Also , The present invention, as described in claim 5, The test data generation means stores the concealed item number and the original data contents in association with each other in the concealment history file, and the test data generation device further informs the user of the above A concealment restoration specifying means for selectively specifying restoration of the concealed item of the test data; the above Items for which restoration is specified by the hidden restoration specification means number Recovery information storage means for storing, In the test data above Restore Of the specified item number Items, By referring to the concealment history file, the original data contents And a data restoring means for restoring.
[0019]
Since such a test data generation device can specify and restore the test data items, the test data can be restored according to the disclosure level of the tester who verifies the test data.
[0020]
further , The present invention claims 6 As described in Authentication means for authenticating the input password, and when the authentication by the authentication means is successful, the concealment restoration designation means, the restoration information storage means, and the data restoration means are valid. To be Composed.
[0021]
Such a test data generation device can select and hide items of information data to be concealed, and can further select and restore items to be restored among the items of concealed test data. . Therefore, it is possible to generate test data according to the public level of the tester, and to restore the test data according to the public level of the verifier who verifies the test data after the test.
[0022]
In order to solve the second problem, the present invention claims 7 As described in Computer In a test data generation method for generating test data in which information data is concealed, A concealing method acquisition procedure in which the computer acquires a concealment method for an item selected by the user for the information data from the user, an item number of the item selected by the user, and a concealment method acquired from the user In the concealment information storage procedure for storing the concealment information file in the concealment information file, Concealment information Data corresponding to the item number stored in the file is stored by the concealment method stored in the concealment information file. Concealment By Test data generation procedure for generating test data Execution Configured to do.
[0023]
Furthermore, in order to solve the third problem, the present invention provides 8 In a storage medium storing a program for causing a computer to perform processing in a test data generation device that generates test data in which information data is concealed, A concealment method acquisition procedure for acquiring from the user a concealment method for an item selected by the user for the information data in the computer, an item number of the item selected by the user, and a concealment method acquired from the user In the concealment information storage procedure for storing the concealment information file in the concealment information file, Concealment information Data corresponding to the item number stored in the file is stored by the concealment method stored in the concealment information file. Concealment By Test data generation procedure for generating test data Let it run Composed.
[0024]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[0025]
A hardware configuration of a computer system in which a test data generation apparatus according to an embodiment of the present invention is configured is, for example, as shown in FIG.
[0026]
In FIG. 1, this system includes a CPU (Central Processing Unit) 10, a memory unit 11, a display unit 12, an input unit 13, a disk unit 14, and a CD-ROM driver 15. These units 10, 11, 12, 13, 14 and the CD-ROM driver 15 are connected to the bus B.
[0027]
The CPU 10 controls the test data generation device according to the program stored in the memory unit 11 and performs processing in the test data generation device as described later. The memory unit 11 includes a RAM and a ROM, and stores programs executed by the CPU 10, data necessary for processing by the CPU 10, data obtained by processing by the CPU 10, and the like. Further, a partial area of the memory unit 11 is allocated as a work area used for processing by the CPU 10.
[0028]
The display unit 12 displays various information necessary for the user under the control of the CPU 10. The input unit 13 includes a mouse, a keyboard, and the like, and is used for a user to input various information necessary for performing test data generation processing as will be described later.
[0029]
The disk unit 14 is constituted by a hard disk unit, for example, and stores various files and programs.
[0030]
The test data generation processing program according to the present invention is provided to the system by, for example, the CD-ROM 20. That is, when the CD-ROM 20 storing the program related to the test data generation process is set in the CD-ROM driver 15, the CD-ROM driver 15 reads the program from the CD-ROM 20, and the read program is It is installed in the disk unit 14 via the bus B. When the test data generation process is activated, the CPU 10 starts the process according to the program installed in the disk unit 14. The medium for storing the program is not limited to the CD-ROM 20 and may be any computer-readable medium.
[0031]
The test data generation device according to an embodiment of the present invention is configured as shown in FIG. 2, for example.
[0032]
As shown in FIG. 2, the test data generating apparatus mainly includes a concealment processing unit 100 that conceals existing data and a concealment restoration processing unit 200 that restores concealed data. The concealment processing program for controlling the concealment processing unit 100 and the concealment restoration processing program for controlling the concealment restoration processing unit 200 are executed by the CPU 10 shown in FIG. Further, the existing data to be concealed is, for example, customer data actually used in business where confidentiality is required.
[0033]
The concealment processing unit 100 includes an authentication password setting processing unit 101 that sets a password in the created concealment information, a concealment method designation processing unit 102 that designates a concealment method, and data that generates data according to the designated concealment method A data processing unit 103, a data item information DB (database) for managing a list of information about customer data items, and concealment information for managing a concealment method for each item designated by the concealment method designation processing unit 102 It has DB31 and customer data DB33 which manages the customer data required on business. These DBs are stored in the disk unit 14 shown in FIG.
[0034]
In the concealment processing unit 100, after the concealment information file is created in the concealment information DB 31 according to the password set by the authentication password setting processing unit 101, the concealment method designation processing unit 102 is managed in the data item information DB. For each data item, the presence / absence of concealment and the concealment method designated by the user are recorded in the concealment information file 31 and stored in the concealment information DB 31, and the data generation processing unit 103 uses the concealment information file based on the customer data DB 33. Is concealed and test data is generated, and the history of the concealment method is stored in the concealment history DB 31. The test data is stored in the test data file 400.
[0035]
Thereafter, each test data stored in the test data DB is provided (published) as pre-update test data 410 to a tester or the like of the developed system. The developed system is, for example, a business application that processes customer data. The provided pre-update test data 410 is processed by performing a test of the developed business application 25, and becomes post-update test data 420.
[0036]
When the post-update test data 420 needs to be verified, the concealment restoration processing unit 200 is executed.
[0037]
The concealment restoration processing unit 200 includes a password authentication processing unit 201 that authenticates a password input by a user, a restoration method designation processing unit 202 that designates a restoration method of data concealed according to password authentication, A data restoration processing unit 203 for restoring data in accordance with the designated restoration method. The concealment restoration processing unit 200 includes a restoration information DB 50 in which a restoration method is set for each data item and a restored restoration test data DB 48, and a data item information DB 30 and a concealment information DB 31 equivalent to the concealment processing unit 100. Or share these DBs with the concealment processing unit 100. Similar to the concealment processing unit 100, these DBs are stored in the disk unit 14 shown in FIG.
[0038]
The concealment restoration process is executed to verify the updated test data file 420 processed by the test execution. The test data file 430 of the concealment restoration processing unit 200 corresponds to the updated test data file 420.
[0039]
In the concealment restoration processing unit 200, password authentication is performed by the password authentication processing unit 201, and verification of the test data file 430 processed in the test execution is executed according to the success or failure of the authentication.
[0040]
When password authentication is successful in the concealment restoration processing unit 200, the restoration method designation processing unit 202 refers to the data item information from the data item information DB 30 and the concealment information file from the concealment information DB 31, and the restoration method designated by the user. Is stored in the restoration information DB 50. Next, the concealment history DB 31 and the restoration information DB 50 are referred to by the data restoration processing unit 203, and the test data file 430 is restored to become a restored test data file 480. The restoration test data file 480 is provided to the user as restoration data 205 and verified.
[0041]
When password authentication fails in the concealment restoration processing unit 200, the CPU 10 prohibits concealment restoration of the test data file 430, and the test data 207 that is concealed for verification is provided to the user and verified.
[0042]
The concealment processing method executed by the CPU 10 shown in FIG. 1 in the concealment processing unit 100 will be described with reference to the flowcharts of FIGS. 3 to 5 and FIGS. 6 to 16 showing details as appropriate.
[0043]
3 to 5, first, data item analysis processing is performed in steps S111 to S113. FIG. 6 is a diagram illustrating an example of data item analysis. FIG. 6A is a diagram showing the contents of the data item definition file, and FIG. 6B is a diagram showing the contents of the data item information file.
[0044]
The CPU 10 reads a desired data item definition file in which data items are defined from the customer data DB 33 shown in FIG. 2 (step S111). Here, the data item definition file is, for example, a COBOL registration file of a database managed in the COBOL language as shown in FIG. The COBOL registration file defines a plurality of items, and an item related to one “data definition record” is shown in FIG. The “data definition record” is composed of six items. For example, the customer code is indicated by 10 alphanumeric characters “X (10)”, the customer name is indicated by 20 kana characters “N (20)”, and mail. The number is indicated by 10 alphanumeric characters “X (10)”, the address is indicated by 20 characters “N (20)”, the telephone number is indicated by 12 alphanumeric characters “X (12)”, and the sales amount is expressed numerically. It is defined to indicate eight digits “9 (08)”.
[0045]
The CPU 10 analyzes this “data definition record”, and extracts the item name, the attribute of the item indicated by X, N, or 9, and the number of digits indicated in parentheses (step S112).
[0046]
The CPU 10 creates a data item information file according to the order of items defined in the “data definition record” in FIG. 6A and stores it in the data item information DB shown in FIG. 2 (step S113). The data item information file of the created “data definition record” has contents as shown in FIG. 6B, for example.
[0047]
If a data item information file has been created in advance, the data item analysis processing performed in steps S111 to S113 may be omitted.
[0048]
The once stored data item information file is read again by the CPU 10 (step S114), the data item information (each item, attribute and number of digits) of the data item information file is taken in and temporarily stored in the memory unit 11 in the order of storage. (Step S115).
[0049]
CPU10 acquires an authentication password from a user (step S116). The processing in step S116 corresponds to the authentication password setting processing unit 101 shown in FIG.
[0050]
Further, the CPU 10 displays the acquired data item information on the display unit 12 shown in FIG. 1, and acquires information on the concealment method from the user (steps S117 to S120). That is, for example, the CPU 10 displays a concealment method definition screen 300 as shown in FIG. 7 on the display unit 12 shown in FIG. The concealment method definition screen 300 includes display areas for a data item list 301, a concealment method 302, and a concealment detail definition 303. The user selects an item that needs to be concealed from the data item list 301 (step S117). Next, when the user selects either “random replacement” or “character replacement” in the concealment method 302, the user's selection is displayed in the concealment method column of the data item list 302 (step S118). When the user selects “random replacement”, the CPU 10 prohibits the setting of the concealment detailed definition 303, and when the user selects “character replacement”, the CPU 10 permits the concealment detailed definition 303 to be set. When the user selects “character replacement”, the detailed concealment definition 303 becomes valid, and the character replacement method can be set in detail (step S119). In the concealment detail definition 303, “range designation” and “replacement character reference method” are set. “Specify range” includes selection of “replace all” and “partially replace”, and when “partially replace” is selected, the character replacement start position (from which character starts) is further selected. Either “start position” is designated, or the position at which the character replacement is to be ended (number of characters to end) is designated by “end position”. Here, when the “start position” is blank, it is the first character, and when the “end position” is blank, it is the last character. “Replacement character reference method” includes selection of “arbitrary character designation” and “table reference”, and when “arbitrary character designation” is selected, “two-byte character” is further selected as “arbitrary character”. An arbitrary character is input at the designated input position depending on whether it is replaced with “1-byte character”. When selecting “reference table”, a directory and a file name in which replacement characters are stored in “table file name” are input to a specified input position, or a desired file is specified by clicking a reference button.
[0051]
For example, the user selects the item name “address” to be concealed in the data item list 301, and selects “character replacement” in the concealment method 302. Further, in the concealment detailed definition 303, as a detailed method of “character replacement”, it is specified that partial replacement starts from the seventh character by range specification, and concealment is performed by an optional character “*” of 2-byte character replacement. In this case, as shown in the concealment method definition screen 300, “character replacement” is displayed for the concealment method of the item name “address” specified in the data item list 301, and “part 7 / "Arbitrary character *." Is displayed.
[0052]
Further, the user determines whether there is another data item that defines concealment (step S120). If there is another data item that defines concealment, steps S117 to S119 must be repeated to conceal. Set the concealment method for certain items.
[0053]
The CPU 10 writes the information set by the user on the concealment method definition screen 300 of FIG. 7 to the concealment information file (step S121). For example, from FIG. 8, the authentication password set in step S116 is stored in the first record as shown in FIG. 8A, and the concealment method is stored in the second and subsequent records as shown in FIG. 8B. The concealment information file 310 for the second and subsequent records shown in FIG. 8B stores only information for which the concealment method is set by the user on the concealment method definition screen 300 of FIG. That is, information regarding items NO2 to 5 (item names “customer name”, “zip code”, “address”, and “phone number”) shown in the data item list 301 of the concealment method definition screen 300 in FIG. Are sequentially stored in the records of SEQ1 to SEQ4 shown in FIG. The CPU 10 stores the concealment information file 310 in the concealment information DB 31 shown in FIG. The concealment information file 310 includes, for example, “item No.”, “concealment method”, “range specification”, in addition to the number “SEQ” for managing records, according to the setting items on the concealment method definition screen 300 in FIG. It includes items including “start position”, “end position”, “reference method of replacement character”, “double byte character”, “single byte character”, and “table file name”.
[0054]
The processing in steps S117 to S121 corresponds to the concealment method designation processing unit 102 shown in FIG.
[0055]
In order to create a test data file that can be disclosed, the CPU 10 first takes out and copies a desired customer data file from the customer data DB shown in FIG. 1 and creates the same file (step S122). For example, if the desired customer data file is a customer data file 330 as shown in FIG. 9, the customer data file 330 is copied to create a test data file 400.
[0056]
The CPU 10 extracts records from the concealment information file 310 shown in FIG. 8B in the order of SEQ numbers, and determines the concealment method from the record item “concealment method” (step S123). If the concealment method is “random replacement”, random replacement processing is performed in steps S141 to S146, and if it is “character replacement”, character replacement processing is performed in steps S151 to S156.
[0057]
Hereinafter, the concealment method will be described with reference to the example of the concealment information file 310 shown in FIG. The random replacement method will be described with reference to FIGS. 10 to 12 as appropriate, and the character replacement method will be described with reference to FIGS. 13 to 15 as appropriate.
[0058]
In step S123, the CPU 10 extracts the first record (SEQ1) from the concealment information file 310 shown in FIG. 8B. The extracted record SEQ1 is shown in FIG. As shown in FIG. 10A, since “random” is specified in the “concealment method” item of the record SEQ1, the concealment process proceeds to step S141.
[0059]
The CPU 10 sets the information of “item No.” and “concealment method” of the record SEQ1 in FIG. 10A in the register of the memory unit 11 in FIG. 1 (step S141). In this case, the test data file 400 copied in step S122 is concealed by the “random replacement method” in the test data file 400 copied in step S122 based on the information of “item No.” and “concealment method”. Show.
[0060]
A desired customer data file is read from the customer data DB shown in FIG. 1, and the first record is taken out (step S142). An example of the extracted record is shown in FIG.
[0061]
The CPU 10 obtains the record number (destination) to be replaced by a random number in order to conceal the item “customer name” of the record by a random replacement method. Et The destination record corresponding to the record number is extracted from the test data file 400 created in step S112. The “customer name” of the record extracted in step S142 is stored in “customer name” of the destination record (step S143). For example, when the record number obtained from the random number is 4, the fourth record of the test data file 400 shown in FIG. 9 is extracted. Then, as shown in FIG. 11C, the customer name “Kenji Suzuki” of the fourth record is the first record of the customer data file taken out in step S142 by the CPU 10 (see FIG. 10B). Is replaced with “Noboru Yamada”.
[0062]
The CPU 10 writes the record in which the customer name is replaced by the random replacement method at a predetermined record position in the test data file 400 (step S144). In this case, the fourth record of the test data file 400 is replaced, but the record of the customer data file 330 is not changed.
[0063]
Furthermore, the CPU 10 adds information related to the record used in the random replacement method to the concealment history file (step S145). For example, as shown in FIG. 11D, the concealment history file includes “SEQ” indicating a record number automatically assigned, and “item” indicating an item number of a replacement source record used in the random replacement method. “NO”, the record number “record number” of the exchange source used in the random exchange method, the “movement destination record number” indicating the record number of the migration destination where the information is concealed, and the data of the exchange source used for concealment "Original data content". In this case, “2” is stored in “Item No.”, “1” is stored in “Record Number”, “4” is stored in “Destination Record Number”, and “Noboru Yamada” is stored in “Original Data Contents”. The
[0064]
The CPU 10 determines whether or not random replacement processing has been performed for all records in the test data file 400 (step S146). If all records have not been randomly exchanged, the next record is read from the customer data file 330 in step S142, and in accordance with the “item number” and “concealment method” set in the register in step S141, S143 is similarly applied. To S145, the concealment process (in this case, random replacement process) of the test data file 400 is repeated. When random replacement processing is performed on all records, the concealment processing performs step S125. Thus, the “concealment method” designated for the “item No.” designated by the record SEQ1 of the concealment information file 310 is completed.
[0065]
In the test data file 400 after the random replacement set for the data item set in step S141, in this case, as shown in FIG. 12A, all record items “customer name” are replaced, and As shown in FIG. 12B, concealment history information is created in the concealment history file according to the number of records in the test data file 400.
[0066]
The CPU 10 determines whether or not the concealment process has been completed for the data item to be concealed (step S125). In this case, since the concealment process has not been completed, the process returns to step S123, the next record SEQ2 is extracted from the concealment information file shown in FIG. 8B, and is designated by referring to the register set in step S141. “Concealment method” designated for “item No.” is performed. In this case, since “random” is designated as the concealment method for item No. 2, steps S141 to S146 are executed again to perform random replacement processing.
[0067]
Again, based on the determination in step S125, the process returns to step S123. The CPU 10 extracts the next record SEQ3 from the concealment information file shown in FIG. 8B and performs the “concealment method” designated for the designated “item No” (step S123). In this case, steps S151 to S156 are performed in order to process character replacement for item No4.
[0068]
The CPU 10 sets the “item No.” and “concealment method” information of the record SEQ3 in FIG. 13A in the register of the memory unit 11 in FIG. 1 (step S151). In this case, the information of “item No.” and “concealment method” indicates that the test data file copied in step S122 is all concealed by the “character replacement method” of the data item “address”.
[0069]
A desired customer data file is read from the customer data DB shown in FIG. 1, and the first record is taken out (step S152). An example of the extracted record is shown in FIG.
[0070]
The CPU 10 takes out the record of the test data file 400 in order to conceal the item “address” of the record by the character replacement method. Based on the information in the record SEQ3 of the concealment information file shown in FIG. 13A extracted in step S123, the characters from the seventh byte to the end of the “address” item of the record of the extracted test data file 400 are changed to the two-byte character “ * "Is substituted (step S153).
[0071]
Further, the CPU 10 stores each record of the replaced test data file 400 in the test data file 400 (step S154). In this case, as shown in FIG. 14C, the data item “address” of the first record of the extracted test data file 400 is concealed. In this case, the record of the customer data file is not changed.
[0072]
next , The CPU 10 adds information related to the record used in the character replacement method to the concealment history file (step S155). In this case, for example, as shown in FIG. 14D, the concealment history file is “4” for “item NO”, “1” for “record number”, and “1” for “destination record number”. “1” and “original data contents” store “1-3-12 Aoba, Asahi-ku, Tokyo”.
[0073]
The CPU 10 determines whether or not character replacement processing has been performed on all records in the test data file 400 (step S156). If the character replacement process has not been performed for all the records, the next record is read from the customer data file 330 in step S152, and in accordance with the “item No.” and “concealment method” set in the register in step S151, S153 is similarly applied. To S155, the concealment process (in this case, the character replacement process) of the test data file 400 is repeated. When the character replacement process is performed on all the records, the concealment process performs step S125. Thus, the “concealment method” designated for the “item No.” designated in the record SEQ4 of the concealment information file 310 is completed.
[0074]
Set for the data item set in step S151 Character substitution In this case, in the test data file 400 later, as shown in FIG. 15A, all the record items “address” are replaced with characters, and as shown in FIG. Concealment history information is created according to the number of records in the test data file 400.
[0075]
The CPU 10 determines whether or not the concealment process has been completed for the data item to be concealed (step S125). If all the data items to be concealed are not processed, the next record is extracted from the concealment information file 310 shown in FIG. 8B, and the random replacement process or the character replacement process is repeated again. When all the data items to be concealed have been processed, the concealment process ends.
[0076]
The processing from step S122 to S125 (including steps S141 to S146 and steps S151 to S156) corresponds to the data generation processing unit 103 shown in FIG.
[0077]
FIG. 16 is a diagram illustrating an example of the file contents after the concealment process.
[0078]
FIG. 16A shows an example of the test data file 400 after the concealment process. 16A, based on the information in the concealment information file 310 in FIG. 8B, the “customer name”, “zip code”, “address”, and “phone number” of the test data file 400 shown in FIG. "Is shown hidden.
[0079]
FIG. 16B shows an example of the concealment history file 310 after the concealment process. FIG. 16B shows history information concealed based on the information of the concealment information file 310 of FIG. 8B.
[0080]
The above concealment process can conceal highly confidential customer information that is actually used, so that more realistic test data can be easily created. It is also possible to reduce the time spent for creating test data.
[0081]
In addition, since test data in which items to be concealed are selected can be created, various test data can be created according to the disclosure level.
[0082]
The test data file 400 created by the concealment process is disclosed to the tester as a pre-update test data file 410 shown in FIG. The tester uses the published pre-update test data file 410, for example, to test the business application 25 in FIG. In FIG. 2, the post-update test data file 420 indicates the pre-update test data file 410 used by the business application 25 when the test is performed. After the test is performed, the updated test data file 420 is verified by restoring the concealment by the concealment restoration processing unit 200 as necessary.
[0083]
Next, in the concealment restoration processing unit 200 shown in FIG. 2, the concealment restoration processing method executed by the CPU 10 shown in FIG. 1 will be described with reference to the flowcharts of FIGS. 17 and 18 and FIGS. explain.
[0084]
17 and 18, when the user inputs a password (step S211), the CPU 10 shown in FIG. 1 reads the password stored in the history information file 310 (step S212). The CPU 10 authenticates the password by comparing the data (password) entered by the user in step S211 with the password read from the history information file 310 in step S212 (step S213). The processing from step S211 to S213 corresponds to the password authentication processing unit 201 shown in FIG.
[0085]
If the password authentication process in step S213 fails, the concealment restoration process performs step S251. The CPU 10 reads the test data file 430 (step S251), and displays the contents of the test data file 430 (hidden data 207) on the display unit 12 of FIG. 1 (step S252). The concealment restoration process ends.
[0086]
If the password authentication process in step S213 is successful, the concealment restoration process performs step S214.
[0087]
The CPU 10 reads a desired data item information file (see FIG. 6B) from the data item information DB 30 (step S214), and takes in the data item information (step S215). Further, the CPU 10 reads a desired concealment information file from the concealment information DB 31 and displays, for example, a concealment restoration definition screen 600 as shown in FIG. 19 on the display unit 12 of FIG. 1 according to the fetched data item information. (Step S216).
[0088]
When the concealment restoration definition screen 600 is displayed on the display unit 12, the user selects an item that requires restoration from the data item list 610 of the concealment restoration definition screen 600 (step S217), and selects the restoration button 621. Clicking with a mouse or the like defines concealment restoration (step S218). It is determined whether there is another data item that needs to be restored (step S219). If there is a data item, step S217 and step S218 are repeated. When canceling the definition of concealment restoration, the cancel button 622 is clicked.
[0089]
When the definition of concealment restoration by the user on the concealment restoration definition screen 600 is completed, the CPU 10 writes the restoration information file 500 as shown in FIG. 20 (step S220). As shown in FIG. 20, the restoration information file 500 stores, in “item No.”, the number of the data item that needs to be restored among the data items to be hidden by the concealment process. The restoration information file 500 is stored in the restoration information DB 50.
[0090]
The processing from step S214 to step S220 corresponds to the restoration method designation processing 202 shown in FIG.
[0091]
Next, the CPU 10 sorts the concealment history file 310 using the data item “record number” as a key. FIG. 21 is a diagram illustrating an example of sorting the concealment history file 310. The concealment history file 310 before sorting becomes a concealment history file 311 after sorting that facilitates concealment restoration processing in units of records by sorting using the data item “record number” as a key.
[0092]
The CPU 10 reads the test data file 430 to be concealed and restored, and extracts one record (step S222). In this case, the first record is extracted from the test data file 430 as shown in FIG.
[0093]
Further, the CPU 10 reads the concealment history file 311 that has been sorted in step S221, and extracts a record of concealment information related to the record extracted in step S222 (step S223). In this case, the CPU 10 extracts the first record SEQ1 (information on item No. 2) of the sorted concealment history file 311.
[0094]
The “item No.” of the record of the concealment history file 310 that has been read is compared with the “item No.” of the restoration information file 500 shown in FIG. 20 to determine whether it is a data item to be restored (step S224). In this case, the item No. 2 of the record of the concealment history file 310 read into the restoration information file 500 is not included in the restoration information file 500, that is, is not a restoration target, so step S266 is performed without processing step S225.
[0095]
The CPU 10 determines whether or not a record is captured from the sorted concealment history file 311 read in step S223 for concealment history information corresponding to one record of the captured test data file 310 (step S226). In this case, the concealment history information related to one record of the captured test data file 310 includes four records for items Nos. 2, 3, 4, and 5 in the sorted concealment history file 311 as shown in FIG. There is. The CPU 10 determines that the concealment history information for one record has not been read, and executes step S223 again to capture the next record SEQ6 (information on item No. 3). Since item No. 3 is not a concealment restoration target, the same processing as item No. 2 described above is performed. Based on the determination in step S226, step S223 is subsequently executed again, and the next record SEQ11 (information on item No. 4) is fetched. Since item No. 4 is determined to be a concealment restoration target in step S224, step S225 is performed.
[0096]
When there is an “item No.” of the record of the concealment history file 310 read in the restoration information file 500, that is, when the CPU 10 is to be restored, the “original data content” of the record corresponds to “item No.”. The item is set in the record item of the extracted test data file 430 shown in FIG. 22A (step S225). In this case, as shown in FIG. 23C, the “address” of the item No. 4 of the extracted record of the test data file 430 shown in FIG. 22A is the item No. 4 of the record SEQ11 of the concealment history file 310. Replaced with “original data contents” for “1-3-12 Aoba, Asahi-ku, Tokyo”.
[0097]
Based on the determination in step S226, the last concealment history information (record SEQ16 of the sorted concealment history file 311) regarding the record of the test data file 430 is read, and steps S223 to S225 are executed as described above. Therefore, in this case, as shown in FIG. 23D, the “telephone number” of the item No. 5 of the extracted record of the test data file 430 shown in FIG. 23C is the record SEQ16 of the concealment history file 310. Is replaced with “original data content” regarding item No. 5 and becomes “541-291-5555”.
[0098]
The record of the restored test data file 430 is written in the restored test data file 480 shown in FIG. 2 (step S227).
[0099]
The CPU 10 determines whether restoration processing has been performed for all the records in the test data file 430 (step S229). If restoration processing has not been performed for all records, the processing from step S22 to S227 is performed as described above.
[0100]
The processing from step S221 to S228 described above corresponds to the data restoration processing unit 203 shown in FIG.
[0101]
On the other hand, when the restoration process is performed for all the records, the CPU 10 reads the restoration test data file 480. In this case, as shown in FIG. 24, all records of the two items “address” and “phone number” of the restoration test data file 480 are restored.
[0102]
The CPU 10 displays the read restoration test data file 480 on the display unit 12 in FIG. 1 as restoration data 205 (see FIG. 2).
[0103]
The CPU 10 determines whether to perform the concealment restoration definition process again (step S231). When the definition process of concealment restoration by the user is performed again, the concealment restoration process returns to step S214 and repeats the above process. On the other hand, when the definition process for concealment restoration by the user is performed again, the concealment restoration process ends.
[0104]
In the concealment restoration process, test data can be verified according to password authentication. For example, when the administrator of customer data restores to conceal hidden data, all the concealed items can be selected and restored and verified. When a tester who is not a customer data administrator verifies test data after the test is performed, the administrator can select and restore only items that are deemed necessary for verification.
[0105]
As described above, the test data generating apparatus according to the present invention generates test data that can be disclosed by concealing highly confidential information, and restores only items necessary for verification of test data after the test is performed. Make it possible.
[0106]
In the above example, the processing from step S117 to S120 shown in FIG. 4 corresponds to the concealment method setting means of claim 1, and the processing at step S121 shown in FIG. 4 is the concealment information storage means of claim 1. 4 and FIG. 5 corresponds to the test data generation means of claim 1.
[0107]
Further, the processing from step S214 to S219 shown in FIG. 17 corresponds to the concealment restoration specifying means of claim 5, the processing in step S220 shown in FIG. 17 corresponds to the restoration information storage means of claim 5, and FIG. And the processing from step S221 to S228 shown in FIG. 18 corresponds to the data restoring means of claim 5.
[0108]
【The invention's effect】
As described above, according to the present invention described in claims 1 to 5, since test data is generated by concealing already used information data, realistic test data can be created. . Since the concealment setting means can set the concealment method according to the item of the information data, it is possible to create test data according to the disclosure level of the tester who uses the test data.
[0109]
In addition, according to the present invention described in claims 5 to 6, since the test data items can be specified and restored, the test data is restored according to the disclosure level of the tester who verifies the test data. Is possible.
[0110]
According to the invention of claim 7, the information data item to be concealed can be selected and concealed, and the item to be restored is further selected and restored from the concealed test data item. can do. Therefore, it is possible to generate test data according to the public level of the tester, and to restore the test data according to the public level of the verifier who verifies the test data after the test.
[0111]
Furthermore, according to the present invention of claims 8 to 10, it is possible to generate test data according to the public level of the tester, and at the public level of the verifier who verifies the test data after the test is performed. Accordingly, it is possible to provide a test data generation method capable of restoring test data.
[0112]
Furthermore, according to the present invention of claims 11 to 13, it is possible to provide a storage medium storing a program for causing a computer to perform the processing in the test data generating apparatus as described above.
[0113]
[Brief description of the drawings]
FIG. 1 is a diagram illustrating a hardware configuration.
FIG. 2 is a diagram illustrating a configuration of a test data generation apparatus.
FIG. 3 is a flowchart showing a concealment process.
FIG. 4 is a flowchart showing a concealment process.
FIG. 5 is a flowchart showing a concealment process.
FIG. 6 is a diagram illustrating an example of analysis of a data item.
FIG. 7 is a diagram illustrating an example of a concealment method definition screen.
FIG. 8 is a diagram illustrating a data configuration example of a concealment information file.
FIG. 9 is a diagram illustrating creation of a test data file.
FIG. 10 is a diagram illustrating an example of a random replacement method.
FIG. 11 is a diagram illustrating an example of a random replacement method.
FIG. 12 is a diagram showing an example of file contents after random replacement.
FIG. 13 is a diagram illustrating an example of a character replacement method.
FIG. 14 is a diagram illustrating an example of a character replacement method.
FIG. 15 is a diagram illustrating an example of file contents after character replacement.
FIG. 16 is a diagram illustrating an example of file contents after concealment processing;
FIG. 17 is a flowchart showing concealment restoration processing;
FIG. 18 is a flowchart showing concealment restoration processing.
FIG. 19 is a diagram illustrating an example of a concealment restoration definition screen.
FIG. 20 is a diagram illustrating a data configuration example of a restoration information file.
FIG. 21 is a diagram illustrating an example of sorting of concealment history files.
FIG. 22 is a diagram illustrating an example of a concealment restoration method.
FIG. 23 is a diagram illustrating an example of a concealment restoration method.
FIG. 24 is a diagram illustrating an example of file contents after concealment restoration processing;
[Explanation of symbols]
10 CPU
11 Memory unit
12 Display unit
13 Input unit
14 disk units
16 CD-ROM driver
20 CD-ROM
B bus
100 Concealment processing unit
101 Authentication password setting processing part
102 Specification processing part of concealment method
103 Data generation processing unit
200 Concealment restoration processing part
201 Password authentication processing part
202 Restoration method designation processor
203 Data restoration processing unit

Claims (8)

In a test data generation device that generates test data in which information data is concealed,
A concealment method obtaining means for obtaining from the user a concealment method against the item selected by the user with respect to the information data,
And hiding information storage means for storing and hiding method acquired from the item number and the user of the item the user selected hiding information file,
In the above information data, the test data for generating test data by concealed by the concealment method that the data corresponding to the item number stored in the concealed information file stored in the concealment information file A test data generation device having generation means. The test data generation device according to claim 1,
The test data generation means includes
Random exchanging means for sequentially taking out records from the information data, and exchanging items for which the concealment method is set by the concealment method setting means with the same items of randomly selected other records;
Character replacement means for replacing the item of the information data in which the concealment method is set by the concealment method setting means with a predetermined character string;
A test data generation device configured to conceal the information data by random replacement means or character replacement means based on the concealment information. The test data generation device according to claim 1,
It has a data item definition analysis means for creating an item definition information file defining the items of the user can see a said information data on SL concealment method acquisition unit,
The concealing method acquisition means uses the item definition information file is displayed on the display unit a screen for acquiring the concealment method from the user, the concealment method in accordance with the items of the information data to the user test data generating apparatus to so that is set. In the test data generation device according to any one of claims 1 to 3 ,
Having password acquisition means for acquiring a password from the user ;
The hiding information storage means, the test data generating apparatus a password that the acquired and adapted to store in association with the concealed information file. In the test data generation device according to any one of claims 1 to 4,
The test data generation means associates the concealed item number with the original data content and stores it in the concealment history file,
The test data generation device further includes:
A concealment restoration designation means for selectively allowing the user to restore the concealed item of the test data;
A restoration information storing means for storing the item number recovered is specified by the concealment recovery designation unit,
A test data generation device comprising: data restoration means for restoring an item having an item number designated for restoration in the test data with the original data content by referring to the concealment history file . In the test data generation device according to claim 5,
Having an authentication means for authenticating the entered password;
If the authentication of the password by the authentication means is successful, the concealed restoring a designation unit, the restoration information storing means and the test data generation apparatus that the above data restoring means is effective. In a test data generation method in which a computer generates test data in which information data is concealed, the computer includes:
A concealment method acquisition procedure for acquiring from the user a concealment method for an item selected by the user for the information data;
A concealment information storage procedure for storing the item number of the item selected by the user and the concealment method acquired from the user in a concealment information file;
In the above information data, the test data for generating test data by concealed by the concealment method that the data corresponding to the item number stored in the concealed information file stored in the concealment information file A test data generation method for executing the generation procedure. In a storage medium storing a program for causing a computer to perform processing in a test data generation device that generates test data in which information data is concealed ,
A concealment method acquisition procedure for acquiring from the user a concealment method for an item selected by the user for the information data;
A concealment information storage procedure for storing the item number of the item selected by the user and the concealment method acquired from the user in a concealment information file;
In the above information data, the test data for generating test data by concealed by the concealment method that the data corresponding to the item number stored in the concealed information file stored in the concealment information file storing the generated instructions and Ru is an execution program computer-readable storage medium.

Images