JPH1040089A - Method for generating data transfer program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To prevent the production of an error due to the mismatching of correspondence between a transfer file format and the definition of a relational data base management system(RDBMS) table and the production of a program description error in a specific part of SQL language (4th generation langage) in generating a data transfer program to a relational data base through a file. SOLUTION: The data transfer program is divided into a fixed logic part (11) and a variable part (10) requiring a change dependently upon the RDBMS table and a program is generated without encoding the program itself by automatically generating (2) the variable part by RDBMS table definition and a definition table (1, 8) corresponding to file record layout information. Consequently the production of a description error or a logic error to be a cause of the reduction of productivity is evaded and the productivity is improved.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for efficiently developing a data migration program for exchanging data between different systems such as a workstation and a personal computer from a host computer.

[0002]

2. Description of the Related Art Conventional methods, for example, Japanese Patent Application Laid-Open No. Hei 3-1829
In the method disclosed in No. 32, a program description portion unique to the SQL language (fourth generation language) is automatically generated to avoid a description error, thereby improving productivity.

However, in the above-mentioned method, when a program is created for the purpose of "data migration via a file", a program description error that causes an application error is often induced even in a portion other than the above at present. The places include data mapping between the source data and the destination data (data position / size and data attributes), the transfer operation during data transfer, and the selection of code conversion processing depending on the data attributes. It is. In connection with these, the probability of occurrence of an error is high in the definition of the data variables used in the above operation. These results in a decrease in productivity.

[0004]

In the conventional method,
Although the automatically generated program part is specialized for the fourth generation language, in the "development of data migration program via file" as the object of the present invention, a program description error easily occurs with respect to data migration, In addition, the following programming source parts in which consistency of the mutual contents is important are also considered as objects to be automatically generated.

[0005] 1. RD @ S (Relational
DataBase Management System
m) A table definition SQL statement for constructing a table above (ensure consistency with the program regarding data definition).

[0006] 2. Definition of a structure (ensures consistency of variable attribute and number of digits) for processing data in a record unit in a program.

[0007] 3. An attribute (size / position) information table of migration source data used to standardize each field processing (field extraction / code conversion) in a record in a program.

[0008] 4. Description part (host variable declaration / SQL description part) specific to the RDBMS precompiler in the program.

[0009] 5. Data transfer processing description part in the program.

[0010] The problem at present is that when describing the above items, coding is performed by a person, despite the fact that there is always basic information.

In the present invention, RDBMS is used as basic information.
Configuration information (data type and number of digits) required for table creation, and
Arranging information for associating new table items such as source file / record layout (field start position and number of digits) with source data, and generating all of the above items from the associated "unique" information Therefore, the aim is to reduce conventional program errors.

That is, according to the present invention, there is provided a program which requires the same logic in a data migration program via a file, by reducing coding errors due to inconsistencies in data attributes, digits, etc., and by realizing automatic program source generation. The aim is to improve development productivity.

[0013]

According to the present invention, there is provided a system for generating a program for migrating data to a relational database via a file, comprising: RDBMS table definition information (item name, data type, number of digits) File record format ( (Field start position, number of digits) on the basis of the table information associating the data from the file, the field division, the code conversion process, and the program including the access process to the RD @ S for registering the data after this process. It is automatically generated.

[0014]

The above object is achieved by introducing the following method. First, FIG. 1 describes, for each block, the processing contents of a program source, which is a final product when this method is used. In this method, the “data migration program via file” source is converted into a “variable part” (denoted by 7, 8, 11, and 13 in FIG. 1) which requires coding depending on the target table and file configuration. Correspond to 10 in FIG. 2) and “fixed part” of general-purpose processing logic (2, 3, 4, 5, 6, 9, and 9 in FIG. 1).
At 10, these are collectively divided into 11), a variable part is generated for each table, and a complete source is generated by reconstructing the fixed part together with the fixed part. Create an execution module.

The above-mentioned variable section stores information necessary for each of them as shown in FIG.
Is automatically generated based on the contents of the table definition information input sheet shown in (1). After checking the input contents, each component is stored as a file, and is identified by an extension obtained by adding a sequential number to the storage file name (2) in FIG. Items that are referred to from the table of FIG. 4 when automatically generating each variable portion are as follows.

<SQL Statement for Creating RD @ S Table> FIG. 5: RDBMS Table Definition SQL Statement—Table Name (1), Item Name (Japanese or $ K Name) (4, 5), Data Type (6), Number of Digits ( 7), decimal digits (8) <Program header file> Figure 6: Structure definition for data manipulation-item name ($ K name)
(5), data type (6), number of digits (7), decimal digits (8),
Processing target file name (3), data file name (10) FIG. 7: Data attribute table-start position (11), read digit (12), read decimal digit (13), kanji flag (14),
Processing target file name (3), data file name (10) FIG. 8: Host variable declaration-data type (6), item name (A
N @ name) (5), number of digits (7), decimal digits (8), file name to be processed (3), data file name (10) <Program source file> FIG. 9: Data transfer processing-item name ($ K name) ) (5), processing target file name (3), data file name (10) FIG. 10: Embedded SQL statement (1, 2)-item name (ANK)
The method of constructing a program flow (processing flow of FIG. 2) logically formed from the components generated by (name) (5), processing target file name (3), and data file name (10) is a variable part / fixed method. When each part is generated, the above RDBMS table structure SQL
A sequential number is added to the extension for each statement, program header file, and program source file, and a complete source is constructed based on this number.

By generating the variable part of FIG. 1 from the table definition information table, the type (input) man-hour becomes unnecessary, and the attribute / digit number of each table item is inconsistent at the time of data manipulation / transfer in the program. Nothing. In addition, since a check function before component generation can correct a portion that may cause a compile error, it can contribute to improvement in productivity.

A part of the program logic is shared as a fixed part, and the other variable parts are automatically generated by this tool (), so that the occurrence of a program logic error can be suppressed and the productivity is improved. it can.

[0019]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 shows the processing contents of a data migration program via a file for an "arbitrary table" which is a final product when the present invention is used. . After the start of the program (1), a data file open / DB (Database) connection process is performed (2), and one record of migration target data is read from the file (3). Reads one record as a data attribute table (all field information in the record is defined)
Based on (13), data division (5) and code conversion (6) are performed for each field, and the host variables (SQL
(Data area for transferring data to the RDBMS in the statement) (7). Here, the information of each field is not incorporated in the flow of the program, but is divided as a "data attribute table" (13), thereby increasing the versatility as the program logic. Then, when the setting of the host variables for all fields of one record is completed, an SQL statement is issued to the RDBMS to add / update the data (8).

When the end of record (EOF) is detected in the reading of the source data file in (3),
Confirm (or cancel) the command to the RDBMS (CO
MMIT / ROLLBAC), performs DB disconnection processing and closes the data file (9), and terminates this program (10).

FIG. 2 shows the flow of the present invention.
Here, the program shown in FIG. 1 corresponds to the execution module (13). As the components related to create the execution module (13), 8, 10 in FIG.
There are 11 and 12. Each of these will be described below.

Reference numeral 8 in FIG. 2 is a table definition input sheet (table definition specification), and FIG. 4 shows a detailed image thereof. This includes the following information for generating 10 (9) in FIG.
Table name (1), item name (Japanese, $ K) (4, 5),
The data type (6), the number of digits (7), and the decimal digits (8) are mainly used for generating table structure and SQL statement related information. Data file name (10), start position (11), read digit (12),
The read decimal digit (13), the kanji flag (14), and the key item flag (15) are mainly used for generating a data attribute table used when the program reads the migration source data. Other information includes a file name (2) (for saving when creating a variable part), a processing target file (3) (a data file to be processed this time), and a comment (16).

Reference numeral 10 in FIG. 2 denotes a program source (variable part) generated by the tool, which is composed of seven parts. What constitutes these will be described with reference to FIGS. FIG. 5 is an RDBMS table definition SQL statement.
Used to create a table above. This corresponds to 1 in FIG.
4 (5), 6, 7 and 8 are checked to see if data has been input, and generated according to the SQL grammar.

FIG. 6 shows a C language structure used when data is transferred in a program. When 10 in FIG. 4 matches the file to be processed in 3 in FIG. 4, 5, 7, and 8 in FIG.
Generated from the contents of

FIG. 7 shows a data attribute table in which one record read from a data file is cut out of fields necessary for transferring to a table, identification of whether or not to perform code conversion processing, and code conversion processing of a transfer destination. It is referred to in the program as information for storing within the data size. When 10 in FIG. 4 matches the processing target file in 3 in FIG. 4, 6, 7, 8, 11, 12, and 12 in FIG.
Generated from the contents of 13 and 14.

FIG. 8 shows a host variable declaration statement, which is a variable declaration unique to the fourth generation language. When 10 in FIG. 4 matches the processing target file in 3 in FIG. 4, 5, 6, and 6 in FIG.
Generated from the contents of 7, 8, and 16.

FIG. 9 shows a data transfer process, in which record contents (set in a structure) read from a file are shown in FIG.
This is the process of transferring the data contents to the host variables declared in and setting the data length. When 10 in FIG. 4 matches the processing target file in 3 in FIG. 4, 5, 6 in FIG.
Generated from the contents of

FIGS. 10 and 11 show embedded SQL statements.
This is a description for requesting a process to the DBMS. 4 in FIG.
If 0 matches the processing target file of 3 in FIG. 4, it is generated from the contents of 1 and 5 in FIG.

Reference numeral 11 in FIG. 2 denotes a fixed part of the program logic, which is used as common logic when executing the data migration program. Of the program processing in FIG. 2,
These are the portions indicated by 2, 3, 4, 5, 6, (7, 8) and 9 in FIG.

Reference numeral 12 in FIG. 2 is a complete program source file for executing the processing contents shown in FIG. 1, and is generated from 10 and 11 in FIG.

Referring to FIG. 2, the flow of processing in the embodiment of the present invention will be described. First, FIG.
The user input is received for each item using the table of (1).
This information can be substituted for this processing by reading it again when it is necessary to save this information as the table definition specification 8 in FIG. In (2), the output image of (10) is pre-generated based on the information input in (1) (9). If other options are to be set in the description contents of the SQL statement such as the table definition, the settings are modified here. In (3), before generating, check the input contents in (1), and check if invalid information ｛parameter specification error / data migration to migrate long data to short definition item (read digit> output digit, (Read decimal digits> output decimal digits)｝ is detected, and if there is an error, notification is made. If there is no error, a variable part source component is generated in (5), and FIGS.
1 is output to a file (10).
In (6), a complete program source (12) is generated based on (10) generated in (5) and the sequential number given to the file name from the source fixing unit (11). Finally, in (7), the program source of (12) is compiled and linked to generate an execution module of (13). The execution module (13) performs a process of adding / updating transfer source data to the RDBMS based on the procedure of FIG. 1, and a series of operations of the present invention ends.

As a specific example of the present invention, an operation when data is transferred from a sequential file on the host machine to RD @ S on the workstation will be described with reference to the example of FIG.
First, a file to be migrated is obtained from the host computer in (1) (10). RDBM in (2)
Based on the definition information of the new table created in S and the record format of the data file obtained in (1), the contents of the table definition information input sheet of FIG. 4 are input. The variable part (8) of the source is created by the method (3) according to the present invention,
In (4), a complete version of the program source (9) is generated from (8) and the source fixing unit. The completed source (9) is generated in (5) to make it an executable module. (6) Before executing the program, create a table on the RDBMS using the table definition SQL statement (8) (FIG. 5) generated in (7), and execute (10) by executing (6). Data transfer from the data file to the RDBMS (11).

In the above description, a program for transferring the contents of a data file on a host computer to a workstation has been described as an example.
The present invention can also be applied between personal computers, between workstations and personal computers, and between similar models. Also, in FIGS. 10 and 11, the S
As an example of a QL sentence, the I @ SERT sentence was taken up,
This method can also be applied to an UPDAT @, SELECT (FETC #) statement or the like.

[0034]

According to the present invention, in the development of a data migration program via a file, a source code can be generated for variable portions only by inputting definition information (table configuration definition information). For this reason, application errors due to inconsistencies in item attributes and digits, which have conventionally occurred in the coding method, can be avoided, and productivity can be improved. The fixed part of the program (+ variable part)
By applying the same logic as described above, a program logic error can be avoided, and also in this regard, the productivity of the data migration program can be improved.

[Brief description of the drawings]

FIG. 1 is a diagram showing processing contents of a data migration program via a file which is a final product according to the present invention.

FIG. 2 is a diagram showing a flow of processing according to the embodiment of the present invention.

FIG. 3 is a diagram for explaining an example of an embodiment of the present invention.

FIG. 4 is basic data for automatic generation in the present invention.
It is a figure showing a list of table definition and file format information input items.

FIG. 5 is a diagram showing an example of an RDBMS table definition SQL statement according to the present invention.

FIG. 6 is a diagram showing an example of a data manipulation structure definition according to the present invention.

FIG. 7 is a diagram showing an example of a data attribute table applied to the present invention.

FIG. 8 is a diagram showing an example of a fourth generation language using host variable declaration statement applied to the present invention.

FIG. 9 is a diagram showing an example of a copy statement for data transfer processing according to the present invention.

FIG. 10 is a diagram showing a first example of an embedded SQL sentence according to the present invention.

FIG. 11 is a diagram showing a second example of an embedded SQL sentence according to the present invention.

Claims (3)

[Claims] 1. A method for generating a program for migrating data to a relational database via a file, comprising:-RDBMS table definition information (item name, data type, number of digits)-file record format (field start position, number of digits) Based on the table information that associates the two, a program is automatically generated that includes a process of reading data from a file, dividing a field, and performing code conversion, and an access process to an RD @ S for registering the data after the process. Data migration program generation method. 2. The method according to claim 1, wherein the field division is performed by reading one record of data to be migrated from a file and cutting out the read one record for each field based on a data attribute table. Data migration program generation method. 3. A data migration program source, which depends on a target table or file configuration and requires coding, each of which includes a "variable section" and a general processing logic "
2. The data migration program generation method according to claim 1, wherein the data migration program is generated by dividing the data into a fixed part, generating a variable part for each table, and reconfiguring the variable part together with the fixed part.