JP2001256076A - Device and method for generating test data and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a test data generating device and method and a recording medium for easily and properly generating test data suitable for an actual environment. SOLUTION: When a user sets the parameter of test data generation, a test data preparing device connects to an already existing data base to obtain data storage information in the already existing data base, and then reads records stored in the table of the already existing data base while referring to the data storage information to calculate the characteristics of the column data, and after separating the already existing data base, generates test data by using the characteristics of the already existing data base. At the time of generating the test data, the test data preparing device connects to a data base to be developed, and stores the records of the prepared test data in the data base to be developed. Therefore, it is possible to prepare dummy test data more suitable for the situation by using the data stored in the actually operating already existing data base, and to properly realize the tuning of the data base.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a test data generation device, a test data generation method, and a recording medium, and more particularly, to a test data generation device, test data generation method, and recording for generating test data suitable for a real environment. Regarding the medium.

[0002]

2. Description of the Related Art In database development, database tuning plays an important role.
That is, generally, the tuning of the database is performed by various processes related to the database such as the size of a computer (computer) resource such as a memory and a cache allocated to a database object such as a table, a procedure, and a log file managed by a database management system (DBMS). The parameters are adjusted appropriately to improve response time, database availability and hit rate, etc.

In order to properly tune the database, it is necessary to apply a load to the database and examine the response. One method of applying the load is to store a large amount of dummy record data in a table. Stored and may be pre-evaluated.

[0004] Conventionally, "EASYCAP for ORAC", which is commercially available from Ibaraki Hitachi Information Service Co., Ltd., has been used as a test data generation tool for databases.
LE ”.

[0005] The test data generating tool for a database uses a minimum value, a maximum value, and a distribution (frequency distribution,
This is a tool that can specify the appearance frequency of data such as uniform distribution and normal distribution, and the range of data values. And
In the database test data generation tool, a user sets characteristics of generated data.

[0006]

However, in such a conventional test data generation tool for a database, since the characteristics of the generated data are set by the user, the existing database is reconstructed. In such a case, it is not always possible to generate data suitable for the real environment, and there is a demand for a test data generation method and apparatus capable of generating test data suitable for the real environment.

Therefore, according to the first aspect of the present invention, when generating test data necessary for reconstructing an existing database, data storage information is obtained from the existing database in which data is stored, and The data characteristics are calculated from the records stored in the existing database while referring to the obtained data storage information, and the test data necessary for the development target database is generated using the calculated data characteristics, and the generation is performed. The test data stored in the development target database is used to generate dummy test data that is more realistic based on the data stored in the existing database that is actually in operation, and tuning of the database is performed. It is an object of the present invention to provide a test data generation device that can be appropriately performed.

[0010] The invention according to claim 2 calculates the statistical characteristics of the data stored in the existing database, and generates test data using the calculated statistical characteristics, thereby realizing the actual situation immediately. It is an object of the present invention to provide a test data generating apparatus that can generate a desired number of test data and can easily and appropriately tune a database.

According to a third aspect of the present invention, data obtained by sampling a part of records stored in an existing database is used for calculating a feature. Test data that can reduce the processing time required for feature calculation by adjusting the number of samples, generate test data of the desired number according to the actual situation quickly, and perform database tuning quickly and appropriately. It is intended to provide a generator.

According to a fourth aspect of the present invention, if the data in the record is a numerical data type, random data is generated based on the distribution of the values of the data in the existing database, and the data is used for calculating the characteristics. By using
It is an object of the present invention to provide a test data generation device that generates test data in accordance with the actual situation even when the data is a numerical data type, and that can easily and appropriately tune a database.

According to a fifth aspect of the present invention, if the data in a record is of a non-numeric data type, random data is generated based on the data length of the data in an existing database, and the data is used for calculating a feature. It is an object of the present invention to provide a test data generation device that generates test data according to the actual situation even when the data is of a non-numeric data type and can easily and appropriately tune a database. .

According to the present invention, the generated test data is stored in the development target database in consideration of the reference relation between the tables using the data storage information, so that the restriction due to the reference between the tables is eliminated. Even with some database structure, test data is stored properly,
It is an object of the present invention to provide a test data generation device that can easily and appropriately tune a database.

According to a seventh aspect of the present invention, when storing the generated test data in a database to be developed, the records of the generated test data are sorted according to a key and duplicate records are deleted. It is an object of the present invention to provide a test data generation device capable of reducing the processing time when storing generated test data in a development target database and performing the tuning of the database quickly and appropriately.

According to an eighth aspect of the present invention, a test data generating device is constructed on a database management server and a client machine connected to a communication network, and on the client machine, data storage information obtaining means, feature calculating means, test The data generation means and the storage means are constructed, the data storage information obtaining means obtains the data storage information from the existing database managed by the database management server via the database management server, and the storage means,
A test data generator that stores test data in a development target database managed by a database management server via the database management server, thereby integrally tuning a plurality of databases existing on a network and improving usability. It is intended to provide.

According to the ninth aspect of the present invention, when test data necessary for reconstructing an existing database is generated, data storage information is obtained from the existing database in which data is stored, and the obtained data is obtained. The data characteristics are calculated from the records stored in the existing database while referring to the data storage information, and the test data required for the development target database is generated using the calculated data characteristics, and the generated test is generated. By storing data in the development target database, dummy test data that is more realistic can be generated using data stored in the existing database that is in operation, and database tuning can be performed appropriately. It is intended to provide a test data generation method that can be performed.

The invention according to claim 10 calculates the statistical characteristics of the data stored in the existing database, and generates test data using the calculated statistical characteristics, thereby realizing the actual situation immediately. It is an object of the present invention to provide a test data generation method capable of generating test data of a desired number and performing database tuning easily and appropriately.

According to an eleventh aspect of the present invention, data obtained by sampling a part of records stored in an existing database is used for calculating a feature, so that the existing database for calculating the feature can be used. Test data that can reduce the processing time required for feature calculation by adjusting the number of samples, generate test data of the desired number according to the actual situation quickly, and perform database tuning quickly and appropriately. It aims to provide a generation method.

According to a twelfth aspect of the present invention, when the data in a record is of a numeric data type, random data is generated based on the distribution of the value of the data in an existing database, and the data is used for calculating a feature. It is an object of the present invention to provide a test data generation method that generates test data in accordance with the actual situation even when the data is of a numerical data type, and that can easily and appropriately tune a database.

According to a thirteenth aspect of the present invention, when data in a record is of a non-numeric data type, random data is generated based on the data length of the data in an existing database, and the data is used for calculating a feature. It is an object of the present invention to provide a test data generation method that generates test data according to the actual situation even when the data is of a non-numeric data type, and enables easy and appropriate tuning of a database. .

According to the present invention, the generated test data is stored in the development target database in consideration of the reference relation between the tables using the data storage information. It is an object of the present invention to provide a test data generation method capable of appropriately storing test data even with a certain database structure and performing simple and appropriate tuning of the database.

According to a fifteenth aspect of the present invention, when storing the generated test data in a database to be developed,
By sorting the records of the generated test data according to the key and deleting duplicate records,
It is an object of the present invention to provide a test data generation method capable of reducing the processing time when storing generated test data in a database to be developed and quickly and appropriately tuning the database.

According to a sixteenth aspect of the present invention, there is provided a test data generating program for generating test data necessary for reconstructing an existing database on a recording medium, the test data generating program comprising: A data storage information acquisition processing step of acquiring data storage information,
A feature calculation processing step of calculating data features from records stored in an existing database while referring to the obtained data storage information; and a feature calculation process required for a database to be developed using the features of the data calculated in the feature calculation process. A test data generation processing step of generating test data, a storage processing step of storing the test data generated in the test data generation processing in a development target database,
By recording the test data generation program including the above, the information storage device reads the recording medium, thereby constructing a test data generation system, and using data stored in an existing database that is actually operating. It is another object of the present invention to provide a recording medium on which a program capable of generating dummy test data more suitable for the actual situation and appropriately performing database tuning is recorded.

[0023]

According to a first aspect of the present invention, there is provided a test data generating apparatus for generating test data necessary for reconstructing an existing database, wherein the data is stored. Data storage information obtaining means for obtaining data storage information from the existing database, and feature calculation means for calculating characteristics of the data from records stored in the existing database while referring to the data storage information. Test data generating means for generating test data necessary for a database to be developed using the characteristics of the data calculated by the characteristic calculating means, and the test data generated by the test data generating means to the database to be developed. The above object is achieved by providing a storage means for storing the information in the storage device.

According to the above configuration, when generating test data required for reconstructing an existing database, data storage information is obtained from the existing database in which data is stored, and the obtained data storage is obtained. Calculate the data characteristics from the records stored in the existing database while referring to the information, generate the test data required for the database to be developed using the calculated data characteristics, and compile the generated test data. Since it is stored in the development target database, it is possible to generate dummy test data that is more realistic based on the data stored in the existing database that is in operation,
The database can be tuned appropriately.

In this case, for example, as described in claim 2, the feature calculating means calculates a statistical feature of the data stored in the existing database, and the test data generating means determines the statistical feature of the data. The test data may be generated using a statistical feature calculated by a feature calculation unit.

According to the above configuration, the statistical characteristics of the data stored in the existing database are calculated, and the test data is generated using the calculated statistical characteristics. The number of test data can be generated, and the database can be tuned easily and appropriately.

Further, for example, as described in claim 3, the feature calculation means uses data obtained by sampling some records stored in the existing database for calculation of the feature. It may be something.

According to the above configuration, since data obtained by sampling some of the records stored in the existing database is used for calculating the feature, the data from the existing database for calculating the feature is used. By adjusting the number of samples, it is possible to reduce the processing time required for feature calculation, to quickly generate a desired number of test data according to the actual situation, and to quickly and appropriately tune the database. .

Further, for example, if the data in the record is a numerical data type, the feature calculating means may randomly determine the data in the record based on the distribution of the value of the data in the existing database. The data may be generated and used for calculating the feature.

According to the above configuration, if the data in the record is of a numeric data type, random data is generated based on the distribution of the values of the data in the existing database, and the data is used for calculating the characteristics. Therefore, even when the data is of a numerical data type, test data can be generated according to the actual situation, and the database can be tuned easily and appropriately.

For example, if the data in the record is of a non-numeric data type, the feature calculating means may randomly determine the data in the record based on the data length of the data in the existing database. The data may be generated and used for calculating the feature.

According to the above configuration, if the data in the record is of a non-numeric data type, random data is generated based on the data length of the data in the existing database, and the data is used for calculating the feature. Therefore, even when the data is of a non-numeric data type, test data can be generated according to the actual situation, and database tuning can be performed easily and appropriately.

Further, for example, as set forth in claim 6, the storage means uses the data storage information acquired by the data storage information acquisition means and takes into account the reference relation between the tables to generate the generated data. The test data may be stored in the development target database.

According to the above configuration, the generated test data is stored in the database to be developed in consideration of the reference relation between the tables using the data storage information. Even with a database structure, test data can be appropriately stored, and database tuning can be performed easily and appropriately.

For example, when storing the generated test data in the development target database, the storage unit sorts the generated test data records according to a key. Then, the duplicated record may be deleted.

According to the above configuration, when storing the generated test data in the database to be developed, the records of the generated test data are sorted according to the key, and duplicate records are deleted. Processing time for storing test data in the development target database can be reduced, and database tuning can be performed quickly and appropriately.

Further, for example, as set forth in claim 8, the test data generation device is constructed on a database management server and a client machine connected to a communication network, and stores the data storage information on the client machine. An acquisition unit, the feature calculation unit, the test data generation unit, and the storage unit are constructed, and the data storage information acquisition unit stores the data from the existing database managed by the database management server via the database management server. Get information,
The storage unit may store the test data in the development target database managed by the database management server via the database management server.

According to the above configuration, the test data generation device is constructed on the database management server and the client machine connected to the communication network, and the data storage information acquisition means, the feature calculation means,
A test data generation unit and a storage unit are constructed, and the data storage information obtaining unit obtains data storage information from an existing database managed by the database management server via the database management server. Since the test data is stored in the database to be managed through the database management server, a plurality of databases existing on the network can be tuned in an integrated manner, and the usability can be improved.

A test data generating method according to a ninth aspect of the present invention is a test data generating method for generating test data necessary for reconstructing an existing database,
A data storage information acquisition process for acquiring data storage information from the existing database in which data is stored, and a feature of calculating characteristics of the data from records stored in the existing database while referring to the data storage information Calculation processing; test data generation processing for generating test data necessary for a development target database using the characteristics of the data calculated in the characteristic calculation processing; and developing the test data generated in the test data generation processing. The above object is achieved by sequentially performing storage processing for storing in a target database.

According to the above configuration, when generating test data necessary for reconstructing an existing database, data storage information is acquired from the existing database in which data is stored, and the acquired data storage is acquired. Calculate the data characteristics from the records stored in the existing database while referring to the information, generate the test data required for the database to be developed using the calculated data characteristics, and compile the generated test data. Since it is stored in the development target database, it is possible to generate dummy test data that is more realistic based on the data stored in the existing database that is in operation,
The database can be tuned appropriately.

In this case, for example, in the test data generation method, the test data generation method calculates a statistical characteristic of the data stored in the existing database in the characteristic calculation process. In the test data generation process, the test data may be generated using the statistical features calculated in the feature calculation process.

According to the above configuration, the statistical characteristics of the data stored in the existing database are calculated, and the test data is generated using the calculated statistical characteristics. The number of test data can be generated, and the database can be tuned easily and appropriately.

For example, according to the present invention, in the method for generating test data, in the feature calculation processing, data obtained by sampling some records stored in the existing database may be used. May be used for calculating the feature.

According to the above configuration, some records stored in the existing database are sampled and used to calculate data characteristics. Therefore, a sample from the existing database for calculating the characteristics is used. By adjusting the number, the processing time required for feature calculation can be reduced,
It is possible to quickly generate a desired number of test data according to the actual situation, and quickly and appropriately tune the database.

Further, for example, in the test data generating method according to the present invention, in the feature calculation process, if the data in the record is a numerical data type,
Random data may be generated based on a distribution of values of the data in the existing database, and the data may be used for calculating the feature.

According to the above configuration, if the data in the record is of a numeric data type, random data is generated based on the distribution of the values of the data in the existing database, and the data is used for calculating the characteristics. Therefore, even when the data is of a numerical data type, test data can be generated according to the actual situation, and the database can be tuned easily and appropriately.

Further, for example, in the test data generating method according to the present invention, if the data in the record is a non-numeric data type in the feature calculation process, May be used to generate random data based on the data length, and use the data for calculating the feature.

According to the above configuration, if the data in the record is of a non-numeric data type, random data is generated based on the data length of the data in the existing database, and the data is used for calculating the feature. Therefore, even when the data is of a non-numeric data type, test data can be generated according to the actual situation, and database tuning can be performed easily and appropriately.

Further, for example, according to the present invention, the test data generating method includes the steps of:
The generated test data may be stored in the development target database by using the data storage information acquired in the data storage information acquisition process and considering a reference relationship between tables.

According to the above configuration, the generated test data is stored in the development target database in consideration of the reference relation between the tables using the data storage information. Even with a database structure, test data can be appropriately stored, and database tuning can be performed easily and appropriately.

For example, as described in claim 15, in the test data generation method, when the generated test data is stored in the database to be developed in the storage processing, the generated test data is stored in the database. Data records may be sorted according to the key to remove duplicate records.

According to the above configuration, when storing the generated test data in the database to be developed, the records of the generated test data are sorted according to the key, and duplicate records are deleted. Processing time for storing test data in the development target database can be reduced, and database tuning can be performed quickly and appropriately.

The recording medium according to the present invention is a test data generating program for generating test data required for reconstructing an existing database, wherein the test data is generated from the existing database in which data is stored. A data storage information acquisition processing step of acquiring data storage information; a feature calculation processing step of calculating a feature of the data from a record stored in the existing database with reference to the data storage information; A test data generation processing step of generating test data necessary for a development target database using the calculated characteristics of the data, and a storage processing of storing the test data generated in the test data generation processing in the development target database Recording a test data generator including steps More, it has achieved the above object.

According to the above configuration, there is provided a test data generating program for generating test data necessary for reconstructing an existing database on a recording medium, and storing data from the existing database in which data is stored. A data storage information acquisition processing step of acquiring information; a characteristic calculation processing step of calculating data characteristics from records stored in an existing database while referring to the data storage information; and a data characteristic calculated by the characteristic calculation processing A test data generation program including: a test data generation processing step of generating test data necessary for a development target database by using the test data generation method; and a storage processing step of storing test data generated in the test data generation processing in the development target database. Is stored in the information processing device. By taking this, a test data generation system can be built, and dummy data that is more relevant to the actual situation is generated using data stored in an existing database that is in operation. Tuning can be performed appropriately.

[0055]

Preferred embodiments of the present invention will be described below in detail with reference to the accompanying drawings. It should be noted that the embodiments described below are preferred embodiments of the present invention, and therefore, various technically preferable limitations are added. However, the scope of the present invention is not limited to the following description. The embodiments are not limited to these embodiments unless otherwise specified.

FIGS. 1 to 10 are diagrams showing an embodiment of a test data generation device, a test data generation method and a recording medium according to the present invention. FIG. FIG. 1 is a block diagram of a test data generation device 1 to which an embodiment of a generation method and a recording medium is applied.

In FIG. 1, a test data generating device 1
Is a database 2, a database management unit 3, a data storage information acquisition unit 4, a feature calculation unit 5, a data generation unit 6, a data storage unit 7, a database management unit 8, and a database 9.
And the like to generate test data for database tuning.

The test data generating apparatus 1 is a computer (computer) or the like that has a test data generating program recorded on a recording medium such as a CD (Compact Disc), MO (magneto-optical disk), or floppy (registered trademark) disk. It is built by letting you read.

In this embodiment, relational data will be described as test data.

The test data 2 is stored on a hard disk or RA
This is an existing database that is stored in a readable and writable memory such as M (Random Access Memory) and is used to generate test data.

The database management unit 3 stores the test data 2
And test data 2 is stored and read out.

The data storage information obtaining unit (data storage information obtaining means) 4 stores storage information stored in the database 2 via the database management unit 3, for example, a table,
Read definition information such as columns, data types, key attributes, and external reference constraints. The format of this data definition is SQL
(Structured Query Language).

The feature calculation unit (feature calculation means) 5 reads the record stored in the table of the database 2 via the database management unit 3 while referring to the storage information acquired by the data storage information acquisition unit 4, Calculate the characteristics of the column data.

Data generator (test data generator) 6
Generates test data using the characteristics of the column data calculated by the characteristic calculation unit 5 and outputs the generated test data to the data storage unit 7.

The database 9 includes a hard disk and RA
A development target database stored in a readable / writable memory such as M and developed based on the generated test data.

The database management unit 8 stores the database 9
, And store and read out the database 9.

The data storage unit (storage means) 7 collects the data generated by the data generation unit 6 into a record of a required number and stores it in the development target database 9 via the database management unit 8. The definition of the table in the database 9 to be developed is performed in advance.

Next, the operation of the present embodiment will be described. The test data creation apparatus 1 according to the present embodiment is characterized in that test data is created based on the features of the existing database 2 and stored in the database 9 to be developed.

That is, as shown in FIG. 2, when generating test data for the existing database 2, the test data generating apparatus 1 first sets the test data generating parameters by the user. The parameters are set by inputting from a built-in computer keyboard or the like, or by reading a recording medium storing the parameters created in advance (step S101).

When the parameters are set, the test data creation device 1 connects to the existing database 2 by the database management unit 3 (step S102).
The data storage information acquisition unit 4 performs a data storage information acquisition process of acquiring data storage information in the existing database 2 via the database management unit 3 (step S103).

Next, in the test data creation device 1, the feature calculation unit 5 reads the record stored in the table of the existing database 2 while referring to the data storage information acquired by the data storage information acquisition unit 4, A characteristic calculation process for calculating the characteristics of the column data is performed (step S10).
4), disconnect the database 2 from the database management unit 3 (step S105).

After calculating the characteristics of the existing database 2, the test data generation device 1 performs the test data generation process in which the data generation unit 6 generates test data using the characteristics of the existing database 2 (step S10).
6) When the test data is generated, the database management unit 8 is connected to the development target database 9 (step S).
107).

The test data creation device 1 performs a test data storage process in which the data storage unit 7 stores the created record of the test data in the development target database 9 via the database management unit 8 (step S108). Is completed, the database 9 is released from the database management unit 8, and the process is terminated (step S109).

Then, the test data creating apparatus 1 performs the feature calculation process in the feature calculation unit 5 in step S104.
For example, as shown in FIG. 3, this is performed by using data obtained by sampling some records stored in the existing database 2 for feature calculation.

That is, in the feature calculation process of step S104 in FIG. 2, the feature calculation unit 51 first sets a list of table names in the existing database 2 necessary for test data generation as shown in FIG. Step S20
1), records are sampled based on the sampling number for each table as a test parameter set in step S101 of FIG. 2 (step S20)
2). The sampling of the record is, for example, randomly extracted from a list of IDs uniquely added to each record by the test data creating apparatus 1 for each table.

When the record is sampled, the feature calculation unit 5 determines the data type and the feature calculation method for each column based on the test parameters set in step S101 of FIG. 2 and the data storage information obtained in step S103. Set parameters such as designation (step S203),
The feature is calculated based on the set parameters (set values) (step S204).

When the feature calculation unit 5 calculates the feature for the column, it checks whether the calculation of the feature has been completed for all columns (step S205), and the calculation of the feature has been completed for all columns. If not, the process returns to step S203, and the same processing is performed from the set of parameters (set values) for each column (step S2).
03 to S205).

When the calculation of the characteristics for all the columns is completed in step S205, the characteristic calculation unit 5 checks whether the calculation of the characteristics is completed for all the tables (step S206), and the calculation of the characteristics for all the tables is completed. If the processing has not been completed, the process returns to step S202, and the same processing is performed from the sampling of records (steps S202 to S206).

When the calculation of the characteristics for all the tables is completed in step S206, the characteristic calculating section 5 ends the characteristic calculating process.

Then, in the feature calculation process of step S204 in FIG. 3, the feature calculation unit 5 uses the statistical characteristics of the data stored in the existing database 2 as shown in FIG. Perform the calculation.

That is, as shown in FIG. 4, the feature calculating unit 5 first executes the steps S202 and S2 in FIG.
A frequency distribution is created for the set of data of the column of interest in the record sampled at 03 (step S301).

This frequency distribution is created, for example, when the data type of the column is integer-type numeric data, as shown in FIG.
The frequency distribution is created for the 500 records sampled in step S202. This frequency distribution is, for example, as shown in FIG. In FIG. 5, the horizontal axis is the data value, and the vertical axis is the number of records.

When the feature calculation unit 5 creates the frequency distribution,
A cumulative frequency distribution is created, and the characteristics of the existing database 2 are calculated (step S302). This cumulative frequency distribution is, for example, as shown in FIG. In FIG. 6, the horizontal axis is the data value, and the vertical axis is the number of records.

Then, the test data generating apparatus 1 performs the test data generating process by the test data generating section 6 in step S106 in FIG. 2 as shown in FIG.
This is performed using the statistical characteristics of the data stored in the existing database 2.

That is, the test data generating unit 6
As shown in (1), a list of table names in the development target database 9 required for test data generation is set (step S401), and for each table, a list of steps S10 in FIG.
The number of test records, which is a parameter set by the user in step 1, is set (step S402).

Next, the test data generation unit 6 calculates the parameters based on the parameters set by the user in step S101 of FIG. 2 and the data storage information obtained in step S103.
Parameters such as the data type and the specification of the feature calculation method obtained in step S204 of FIG. 3 are set for each column (step S403), and random data for the column is calculated based on the set parameters (step S403).
404).

When generating the random data, the test data generation unit 6 checks whether the generation of the random data has been completed for all the columns (step S405). If the generation of the random data has not been completed for all the columns, Returning to step S403, the same processing is performed from the setting of the parameter for each column (step S403).
403-S405).

When the generation of random data for all columns is completed in step S405, the test data generating unit 6 generates one record by connecting the random data obtained for each column (step S40).
6) It is checked whether the specified number of records set in step S402 has been reached (step S407).

If the number of records has not reached the specified number in step S407, the test data generator 6 returns to step S403 and performs the same processing as described above from the setting of parameters for each column (steps S403 to S407). If the specified number of records has been reached, it is checked whether the processing has been completed for all tables (step S408).

If the processing has not been completed for all the tables in step S408, the test data generation unit 6 returns to step S402 and sets the number of records for the next table, thus performing the same processing as described above (step S408). S402 to S408), step S408
When the processing is completed for all tables, the test data generation processing ends.

Then, the test data generation unit 6 performs the random data generation processing in step S404 in FIG. 7 by, for example, as shown in FIG. 8, the statistical characteristics of the data stored in the existing database 2. This is performed using

That is, the test data generation unit 6
As shown in (1), first, a uniform random number between "0" and "1" is generated (step S501), and step S20 in FIG.
For 500 records sampled in 2,
The cumulative frequency distribution created in step S302 in FIG.
), Random data is generated based on this characteristic (step S502). That is, step S
At 502, a random number is generated in consideration of the frequency distribution of the actual data.

As a method of generating random numbers according to a distribution other than the uniform distribution, generally, an inverse function method, a selection-rejection method, and the like are known. Is performed as follows. That is, for example, when the cumulative frequency distribution as shown in FIG. 6 is obtained, first, the cumulative frequency distribution is divided by 500 which is the total sampling number. This divided value is as shown in FIG. next,
The division value as shown in FIG. 9 is approximated by an analytical function such that the minimum value of the sampled data is “0” and the maximum value is “1”. The result of the approximation in this way is as shown in FIG. Then, assuming that the approximate value is the distribution function y = F (x) and the uniform random number generated in step S501 is y ₀ , the random number x _{0 to be obtained} is represented by the distribution function y =
As an inverse function of _{F (x), x 0 =} F - is calculated by ¹ (y _0).

When the data type of the existing database 2 is a character type, that is, a non-numeric type, a random number is used as the number of characters, that is, based on the distribution of the data length of the data of the existing database. In addition, a random character string can be generated.

The test data storage processing for storing the test data generated as described above in the development target database 9 uses, for example, the data storage information in the existing database 2 acquired in step S103 in FIG. In addition to performing storage in consideration of the reference relationship between tables, storage is also performed in consideration of the reference relationship between tables due to restrictions on keys (foreign keys).

That is, the table and the reference relation in the relational database are referred to as vertices (table → vertex) for convenience, and the reference relation is directed side (the direction of reference is the same as the side direction) (reference relation → It is assumed that a directed graph G = (V, E) with a directed edge. Note that V is a set of vertices, and E is a set of edges.

In this case, the insertion order of records in consideration of the reference relationship due to the restriction of the foreign key (FK) is such that the edge (x, y) ∈E connecting vertex x and vertex y is nu
The order of the vertices is obtained by assigning a number num (v) that satisfies m (x) <num (y).

[0098] Upon receiving the test data generated from the data generation unit 6, the data storage unit 7 stores records for each table in the order obtained as described above.

In the test data storage processing for storing the test data generated as described above in the database 9 to be developed, the test data generation device 1 stores the test data in the record of the generated test data. Is sorted according to the key, and duplicate records are deleted.

As described above, according to the present embodiment, when the test data necessary for reconstructing the existing database 2 is generated, the data storage information is extracted from the existing database 2 in which the data is stored. Acquisition, calculating data characteristics from the record information in the obtained data storage information, generating test data necessary for the development target database 9 using the calculated data characteristics,
The generated test data is stored in the database 9 to be developed.
Is stored in

Therefore, it is possible to generate dummy test data more in accordance with the actual situation by using data stored in the existing database 2 that is actually operating, and to appropriately tune the database 2. Can be.

In the present embodiment, the statistical characteristics of the data stored in the existing database 2 are calculated, and the test data is generated using the calculated statistical characteristics.

Therefore, it is possible to generate a desired number of test data according to the actual situation, and it is possible to easily and appropriately tune the database 2.

Further, in this embodiment, data obtained by sampling a part of records stored in the existing database 2 is used to calculate the characteristics of the data in the database 2.

Therefore, the processing time required for the feature calculation can be reduced by adjusting the number of samples from the existing database 2 for calculating the feature, and the desired number of test data according to the actual situation can be quickly obtained. By generating it, tuning of the database 2 can be performed promptly and appropriately.

Further, in the present embodiment, if the data in the record of the existing database 2 is of a numerical data type, random data is generated based on the distribution of the value of the data in the existing database 2, and The data is used to calculate features.

Therefore, even when the data of the existing database 2 is a numerical data type, it is possible to generate test data according to the actual situation, and the tuning of the database 2 can be performed easily and appropriately.

Further, in the present embodiment, if the data in the record of the existing database 2 is of a non-numerical data type, random data is generated based on the data length of the data in the existing database 2, and The data is used to calculate features.

Therefore, even when the data of the existing database 2 is of a non-numerical data type, it is possible to generate test data according to the actual situation, and the tuning of the database 2 can be performed easily and appropriately.

In this embodiment, the generated test data is stored in the development target database 9 in consideration of the reference relation between the tables using the data storage information.

Therefore, even in a database structure in which there is a reference restriction between tables, test data can be appropriately stored, and tuning of the database 2 can be performed easily and appropriately.

Further, when storing the generated test data in the database 9 to be developed, the records of the generated test data are sorted according to the key, and duplicate records are deleted.

Therefore, the processing time for storing the generated test data in the development target database 9 can be reduced, and the tuning of the database 2 can be performed quickly and appropriately.

Also, the present embodiment is directed to a test data generation program for generating test data necessary for reconstructing an existing database on a recording medium. A data storage information acquisition processing step of acquiring data storage information from
Existing database 2 referring to the data storage information
A feature calculation processing step of calculating data characteristics from the records stored in the database; a test data generation processing step of generating test data necessary for the development target database 9 using the data characteristics calculated by the characteristic calculation processing; And a storage processing step of storing test data generated in the test data generation processing in the database 9 to be developed.

Therefore, by causing the information processing device such as a computer to read the recording medium, the test data generation device 1 as a test data generation system or the test data generation device 20 to be described later can be constructed, and the actual operation is performed. By using the data stored in the existing database 2, dummy test data more in accordance with the actual situation can be generated, and the database 2 can be tuned appropriately.

In the above embodiment, the case where the test data generation device 1 is constructed as one device has been described. However, the test data generation device may be constructed by a server and a client machine connected to a network. Can be.

For example, as shown in FIG. 11, as a test data generating device 20, it is assumed that servers 22 and 23 connected to a network 21 have an existing database 2 and a database 9 to be developed. A data storage information acquisition unit 4, a feature calculation unit 5, a data generation unit 6, and a data storage unit 7 are constructed in a client machine 24 connected to 21.

The servers 22 and 23 and the client machine 24 connected to the network 21
In order to construct the test data generation device 20 by using a client machine 24 or servers 22 and 23, a CD,
It is constructed by reading a test data generation program recorded on a recording medium such as an MO or a floppy disk.

Such a test data generation device 20
The database management unit 3 of the server 22
The data distribution is collected and passed to the data storage information acquisition unit 4 of the client machine 24, whereby the same processing as described above is performed.
The test data generated by the data generator 6 of the client machine 24 is stored in the server 2 according to the information in the data storage 7.
The database management unit 8 of 3 is the database 9 to be developed
To be stored.

Thus, a plurality of databases existing on the network 21 can be tuned in an integrated manner, and the usability can be improved.

Although the invention made by the inventor has been specifically described based on the preferred embodiments, the present invention is not limited to the above-described embodiment, and various modifications may be made without departing from the gist of the invention. It goes without saying that it is possible.

For example, the existing data base 2 and the development target data base 9 to be tested by the test data generation device 1 and the test data generation device 20 are stored in the test data generation device 1 and the test data generation device 2024. However, the information may be stored in a predetermined recording medium, for example, a CD-ROM, another magnetic or optical recording medium, a semiconductor memory, or the like.

[0123]

According to the test data generating apparatus of the present invention, when generating the test data necessary for reconstructing the existing database, the data is stored in the existing database in which the data is stored. Obtain storage information, calculate data characteristics from records stored in the existing database while referring to the obtained data storage information, and perform tests necessary for the development target database using the calculated data characteristics. Data is generated and the generated test data is stored in the database to be developed, so dummy data that is more realistic is generated using data stored in the existing database that is actually running. And the database can be tuned appropriately.

According to the test data generating apparatus of the present invention, the statistical characteristics of the data stored in the existing database are calculated, and the test data is generated using the calculated statistical characteristics. Therefore, it is possible to generate a desired number of test data according to the actual situation, and it is possible to easily and appropriately tune the database.

According to the test data generating apparatus of the third aspect of the present invention, data obtained by sampling some of the records stored in the existing database is used for calculating the characteristics. By adjusting the number of samples from the existing database for calculation, the processing time required for feature calculation can be reduced, and the desired number of test data according to the actual situation can be quickly generated to tune the database. It can be done promptly and properly.

According to the test data generating apparatus of the present invention, if the data in the record is of a numerical data type, random data is generated based on the distribution of the value of the data in the existing database. Since the data is used for calculation of the feature, even when the data is of a numerical data type, test data that matches the actual situation can be generated, and tuning of the database can be performed easily and appropriately.

According to the test data generating apparatus of the present invention, if the data in the record is of a non-numeric data type, random data is generated based on the data length of the data in the existing database. Since the data is used for calculating the feature, even when the data is of a non-numeric data type, test data that matches the actual situation can be generated, and tuning of the database can be performed easily and appropriately.

According to the test data generation apparatus of the present invention, the generated test data is stored in the development target database in consideration of the reference relation between the tables using the data storage information. Even in the case of a database structure in which there is a reference restriction, test data can be appropriately stored, and database tuning can be performed easily and appropriately.

According to the test data generating apparatus of the present invention, when storing the generated test data in the database to be developed, the records of the generated test data are sorted according to the key and duplicated. Since the record is deleted, the processing time for storing the generated test data in the database to be developed can be reduced, and the database can be tuned quickly and appropriately.

According to the test data generating device of the present invention, the test data generating device is constructed on the database management server and the client machine connected to the communication network, and the data storage information is obtained on the client machine. Means, a feature calculating means, a test data generating means and a storing means, wherein the data storing information obtaining means obtains data storing information from an existing database managed by the database managing server via the database managing server, and stores the data storing information. However, test data is stored in the development target database managed by the database management server via the database management server,
A plurality of databases existing on the network can be tuned in an integrated manner, and the usability can be improved.

According to the test data generation method of the present invention, when generating test data necessary for reconstructing an existing database, the data storage information is obtained from the existing database in which the data is stored. And calculate the characteristics of the data from the records stored in the existing database with reference to the obtained data storage information, and use the characteristics of the calculated data to generate test data necessary for the database to be developed. Since the generated test data is generated and stored in the development target database, the dummy test data that is more suitable for the actual situation is generated using the data stored in the existing database in operation. And the database can be tuned appropriately.

According to the test data generating method of the present invention, statistical characteristics of data stored in an existing database are calculated, and test data is generated using the calculated statistical characteristics. Therefore, it is possible to generate a desired number of test data according to the actual situation, and it is possible to easily and appropriately tune the database.

According to the test data generation method of the present invention, since data obtained by sampling some of the records stored in the existing database is used for calculating the characteristics, the characteristics can be calculated. By adjusting the number of samples from the existing database for calculation, the processing time required for feature calculation can be reduced, and the desired number of test data according to the actual situation can be quickly generated to tune the database. It can be done promptly and properly.

According to the test data generating method of the twelfth aspect, if the data in the record is of a numerical data type, random data is generated based on the distribution of the value of the data in the existing database. Since the data is used for calculating the characteristics, even when the data is of a numerical data type, test data that matches the actual situation can be generated, and tuning of the database can be performed easily and appropriately.

According to the test data generation method of the present invention, if the data in the record is of a non-numeric data type, random data is generated based on the data length of the data in the existing database. Since the data is used for calculating the feature, even when the data is of a non-numeric data type, test data that matches the actual situation can be generated, and tuning of the database can be performed easily and appropriately.

According to the test data generation method of the present invention, the generated test data is stored in the development target database in consideration of the reference relation between the tables using the data storage information. Even in the case of a database structure in which there is a reference restriction, test data can be appropriately stored, and database tuning can be performed easily and appropriately.

According to the test data generating method of the present invention, when storing the generated test data in the database to be developed, the generated test data records are sorted according to the key and duplicated. Since the record is deleted, the processing time for storing the generated test data in the database to be developed can be reduced, and the database can be tuned quickly and appropriately.

According to the recording medium of the sixteenth aspect, a test data generating program for generating test data necessary for reconstructing an existing database, wherein the data is stored in the recording medium. A data storage information acquisition processing step of acquiring data storage information from an existing database, a feature calculation processing step of calculating data characteristics from records stored in the existing database while referring to the data storage information, and a feature calculation A test data generation processing step of generating test data necessary for the development target database using the characteristics of the data calculated in the processing, and a storage processing step of storing the test data generated in the test data generation processing in the development target database. Since the test data generation program including By having the body read by the information processing device, a test data generation system can be constructed, and dummy test data that is more relevant to actual conditions using data stored in an existing database that is in operation. Can be generated to properly tune the database.

[Brief description of the drawings]

FIG. 1 is a block diagram of a test data generation device to which a test data generation device, a test data generation method, and a recording medium according to an embodiment of the present invention are applied.

FIG. 2 is a flowchart showing test data generation processing by the test data generation device of FIG. 1;

FIG. 3 is a flowchart showing a detailed process in the case where the feature calculation process of FIG. 2 performs feature calculation by sampling some records of an existing database.

FIG. 4 is a flowchart showing detailed processing in the case where the feature calculation processing of FIG. 3 is performed using statistical characteristics of data in an existing database.

FIG. 5 is a view showing a frequency distribution created for 500 records sampled in the frequency distribution creation processing of FIG. 4;

FIG. 6 is a diagram showing a cumulative frequency distribution created from the frequency distribution of FIG. 5;

FIG. 7 is a flowchart showing detailed processing in the case where the test data generation processing of FIG. 2 is performed using the statistical characteristics of existing test data.

8 is a flowchart showing a detailed process in the case where the random data generation process of FIG. 7 is performed using statistical characteristics of data in an existing database.

9 is a diagram showing a division value obtained by dividing the cumulative frequency distribution of FIG. 6 by a sampling number when the uniform random number generation of FIG. 8 is performed by the inverse function method.

FIG. 10 is a diagram showing an approximate value obtained by approximating the division value of FIG. 9 with an analytical function based on sampling data.

FIG. 11 is a block diagram of the test data generation device when the test data generation device of FIG. 1 is constructed on a network.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 test data generation device 2 database 3 database management unit 4 data storage information acquisition unit 5 feature calculation unit 6 data generation unit 7 data storage unit 8 database management unit 9 database 20 test data generation device 21 network 22, 23 server 24 client machine

Claims (16)

[Claims] 1. A test data generating apparatus for generating test data necessary for reconstructing an existing database, comprising: data storage information for acquiring data storage information from the existing database in which data is stored. Acquisition means, feature calculation means for calculating the characteristics of the data from the records stored in the existing database with reference to the data storage information, and a development target using the characteristics of the data calculated by the characteristic calculation means Test data generating means for generating test data necessary for the database of the present invention, and storage means for storing the test data generated by the test data generating means in the database to be developed. Generator. 2. The feature calculation means calculates a statistical feature of the data stored in the existing database,
2. The test data generation device according to claim 1, wherein the test data generation unit generates the test data using a statistical feature calculated by the feature calculation unit. 3. The feature calculation unit according to claim 1, wherein data obtained by sampling a part of records stored in the existing database is used for calculation of the feature. 2. The test data generation device according to 2. 4. If the data in the record is of a numerical data type, the feature calculating means generates the random data based on a distribution of values of the data in the existing database, and generates the data. 4. The test data generation device according to claim 1, wherein the test data generation device is used for calculating a feature. 5. If the data in the record is a non-numerical data type, the feature calculation means generates random data based on the data length of the data in the existing database, and generates the data. 4. The test data generation device according to claim 1, wherein the test data generation device is used for calculating a feature. 6. The storage means uses the data storage information acquired by the data storage information acquisition means to store the generated test data in the database to be developed in consideration of a reference relationship between tables. The test data generation device according to any one of claims 1 to 5, wherein 7. The storage means stores the generated test data in the database to be developed.
7. The test data generation apparatus according to claim 1, wherein the generated test data records are sorted according to a key, and duplicate records are deleted. 8. The test data generating device is constructed on a database management server and a client machine connected to a communication network, and on the client machine, the data storage information acquiring unit, the feature calculating unit,
The test data generation unit and the storage unit are constructed, and the data storage information acquisition unit acquires the data storage information from the existing database managed by the database management server via the database management server, and the storage unit The test data generation device according to any one of claims 1 to 7, wherein the test data is stored in the database to be developed managed by the database management server via the database management server. . 9. A test data generation method for generating test data necessary for reconstructing an existing database, wherein the data storage information acquires data storage information from the existing database in which data is stored. An acquisition process, a feature calculation process of calculating a feature of the data from a record stored in the existing database while referring to the data storage information, and a development target using the feature of the data calculated in the feature calculation process. Test data generating processing for generating test data necessary for the database of the above, and storing processing for storing the test data generated in the test data generating processing in the development target database are sequentially performed. Generation method. 10. The test data generation method according to claim 1, wherein the feature calculation process calculates a statistical feature of the data stored in the existing database, and the test data generation process calculates the feature in the feature calculation process. The test data generation method according to claim 9, wherein the test data is generated using the obtained statistical characteristics. 11. The test data generating method according to claim 1, wherein in the feature calculation process, data obtained by sampling a part of records stored in the existing database is used for calculating the feature. The test data generation method according to claim 9, wherein the test data is generated. 12. The test data generation method according to claim 1, wherein, in the feature calculation processing, when data in the record is a numeric data type, random data is generated based on a distribution of values of the data in the existing database. The test data generation method according to claim 9, wherein the data is used for calculating the feature. 13. The test data generation method according to claim 1, wherein in the feature calculation processing, if data in the record is a non-numeric data type, random data is generated based on a data length of the data in the existing database. The test data generation method according to claim 9, wherein the data is used for calculating the feature. 14. The test data generation method according to claim 1, wherein the storage process uses the data storage information acquired in the data storage information acquisition process and considers a reference relationship between tables to generate the test data. 14. The test data generation method according to claim 9, wherein the test data is stored in the development target database. 15. The test data generating method according to claim 1, wherein in the storing process, when storing the generated test data in the database to be developed, the generated test data records are sorted according to a key and duplicated. The test data generation method according to any one of claims 9 to 14, wherein the deleted record is deleted. 16. A test data generation program for generating test data required for reconstructing an existing database, wherein the data storage information acquires data storage information from the existing database in which data is stored. An acquisition processing step, a feature calculation processing step of calculating a feature of the data from a record stored in the existing database while referring to the data storage information, and a feature of the data calculated in the feature calculation process. A test data generation program including: a test data generation processing step of generating test data required for a development target database; and a storage processing step of storing the test data generated in the test data generation processing in the development target database. A recording medium for recording the information.