JPH06119204A - Test data base generating system - Google Patents

Abstract

PURPOSE:To constitute a system so that the structure of a data base is generated from definition information at the time of generating the data base and the data base can be constructed by a simple input. CONSTITUTION:The system is provided with a library 1-2 for storing layout information of each record for constituting a data base 1-4, a data file 1-3 for storing test data base information, a data processor 1-1 for executing a data processing by inputting and outputting the data file 1-3, the data base, the library and the data file, and a keyboard display 1-5 for inputting and outputting the contents of the data file. A skeleton generating part 1-6 reads in library information, generates the skeleton of test data in the data file, a data input part 1-7 reads in its skeleton, writes it in the data file together with inputted data, and a data base loading part 1-8 reads in the data file, and writes it in 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 database creation method, and more particularly to a test method for a computer system, which is required for testing when a completed program is individually tested for each part during development of an online business processing program. Database creation method for creating simple test data in a database easily.

[0002]

2. Description of the Related Art Conventionally, in order to create test data in a database, it was inevitable to rely on business processing. Therefore, in order to carry out a test, it is premised that an online program for processing for creating data required for the test is completed. In this case, the test executor creates the test data while executing the online program.

[0003]

Conventionally, the data in the test database has been created by business processing. Therefore, at the time of developing the program, the development of the process for creating the data must be done in advance, and the test of the other parts cannot proceed until this part is completed. In addition, since it is necessary to perform a large number of processes in advance in order to execute the test, the efficiency of the test is poor and extra man-hours are required.

[0004]

A test database creating method according to the present invention comprises a database, a library for storing layout information of each record constituting the database, a data file for storing test database information, and the database. A data processing device for inputting and outputting data to and from a library and a data processing device, and an input / output device for inputting and outputting the contents of the data file, wherein the data processing device includes a skeleton generation unit, a data input unit, and a database load. The skeleton generation unit reads the library information, creates a skeleton of the test data in the data file, the skeleton is read by the data input unit, together with the data input from the input / output device. Write to the data file, last before Database loading unit is reading the data file, and writes to the database.

[0005]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a test database creating system of the present invention.

As shown in FIG. 1, in the test database creating method of this embodiment, the data processing device (1-1) uses C
It is a PU and includes a skeleton generation unit (1-6), a data input unit (1-7), and a database load unit (1-8). The library (1-2), the data file (1-3), and the database (1-4) are constructed using magnetic disks.

The input / output device is constructed by using a keyboard display (1-5).

Next, the operation of each component described above will be described. First, the skeleton generator (1-6) accesses the library (1-2) to access the database (1-
The layout information of the record of 4) is read, the record structure is analyzed, a skeleton having the information of the item name, the attribute, the number of digits, and the number which configures the record is created, and is written in the data file (1-3).

Next, the keyboard display (1-
In accordance with the instructions from 5), the data input section (1-7)
Skeleton information is read from the data file (1-3) under the control of the keyboard and the keyboard display (1-5)
The setting value information input from the keyboard is added and written in the data file (1-3).

Next, the test data definition file is read under the control of the database loading unit (1-8), converted into a database record format, and the database (1-
Write to 4).

Next, the processing of the test database creation method will be described using a specific example. 2, the library (2-1), the data file (2-4), and the database (2-7) are respectively the library (1-2), the data file (1-3), and the database (1-4) in FIG. ) Corresponds to.

The example of FIG. 2 illustrates a record image created on each of the above storage devices when creating a database record having a two-layer structure of a customer record and an account master record.

The customer record structure definition (2-2) and the account master record structure definition (2-3) are images of information written in the library (2-1), and in the example, business processing. It is composed of the copy source text that is cited when the program refers to the database (2-7). The skeleton (2-5) and the test data definition (2-6) are images of the information written in the data file (2-4).
Is the information created by the skeleton generator (1-6),
Test data definition (2-6) is the data input section (1-7)
It is the information created by.

The customer record (2-8) and the account master record (2-9) are records that compose the database (2-7) and are created by the database loading unit (1-8).

Arrows (2-10, 2-11, 2-1) in the figure
2) indicates the order in which each piece of information is created, and is written together with the name of the processing that creates each piece of information.

The skeleton generation process (2-10) is performed in the skeleton generation unit (1-6) and the library (2
Customer record structure definition read from (-1) (2-
2) and the account master record structure definition (2-3), analyze the attribute / digit number information for each defined item, convert the analyzed contents into the specified format, and convert it to the attribute / digit number. The skeleton (2
-5) is created. In the example of FIG. 2, from the customer record structure definition (2-2), the first item "store number" is analyzed as "3 digits of pack format", and converted into the notation "C303", The value is set to zero.

The data input process (2-11) is performed in the data input section (1-7), and the skeleton (2-5) is executed.
Is read from the data file (2-4) and displayed on the display of the keyboard display (1-5).
After that, the contents input from the keyboard of the keyboard display (1-5) are replaced with the initial value part of the skeleton (2-5) to create the test data definition (2-6), and the data file (2-4 ).

The database loading process (2-12)
The database loading unit (1-8) reads the test data definition (2-6) from the data file (2-4) and writes it in the database (2-7). On this occasion,
The sequence of records in the test data definition (2-6) is converted into a hierarchical structure according to a predetermined promise,
It is stored in the database (2-7).

In the example of the figure, since the first item "store number" is specified to be a 3-digit number in the pack format, the value "101" is converted into the pack format. Hereinafter, the data of "customer number" and "name" are assembled, and when the record is completed, it is stored as "customer record (2-8)" in the database (2-7). Similarly, the "account master record (2-9)" is also stored in the database (2-7) when the assembly is completed.

[0021]

As described above, according to the test database creating method of the present invention, when the database is created, the structure of the database is created from the definition information, so that the database can be built by simple input. it can. As a result, tests during program development can be executed efficiently and accurately, and development time can be shortened and quality can be improved.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a test database creation system of the present invention.

FIG. 2 is a flowchart showing an example of an operation in the test database creating method of the present embodiment.

[Explanation of symbols]

 1-1 Data processing device 1-2 Library 1-3 Data file 1-4 Database 1-5 Keyboard display 1-6 Skeleton generation unit 1-7 Data input unit 1-8 Database loading unit

Claims (1)

[Claims] 1. A database, a library for storing layout information of each record constituting the database, a data file for storing test database information, and input / output of the database, library and data file for data processing. A data processing device for performing and an input / output device for inputting / outputting the contents of the data file, wherein the data processing device includes a skeleton generating unit, a data input unit, and a database loading unit, and the skeleton generating unit stores library information. Read, create a skeleton of test data in the data file, the skeleton is read by the data input unit, write to the data file together with the data input from the input / output device, and finally the database load unit Load the data file A method for creating a test database, characterized by writing to the database.