JPH10232803A - Program conversion system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a program conversion system for easily and surely converting a program sentence by an ISAM form to the program sentence by a relational data base language. SOLUTION: This system is provided with an instruction extraction part 11 for extracting the program sentence relating to access to the data base of the ISAM form from a conversion origin program 2, an automatic SQL sentence generation part 12 for automatically generating an SQL sentence for defining a relational data base and a table, etc., for using data base definition information extracted from the program sentence extracted by the instruction extraction part 11 by applying it to a prepared routine sentence and an automatic program generation part 13 for completing the program sentence required for relational data base access by applying the SQL sentence generated by the automatic SQL sentence generation part 12 to the prepared routine sentence and automatically generating a program (post conversion program 3) for accessing the relational data base by SQL.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a program conversion method for accessing a database built on an information processing system, and more particularly to an ISAM (Indexed Sequencing).
The present invention relates to a method for converting a sentence of a database access part when converting a program using a database of a ential access method format into a program using a relational database.

[0002]

2. Description of the Related Art In a program executed in an information processing system, a program statement such as a declaration statement or an execution statement for accessing a database built in the system is usually described. Various processes are continuously performed based on the access result of the executable statement.

[0003] By the way, with the change of the use form of the system, when an ISAM format database (hereinafter referred to as "ISAM database") constructed on the information processing system is to be migrated to a relational database, an ISAM database and a relational database are required. In this case, since the access method is greatly different, it is necessary to rewrite not only the database but also rewrite a program sentence in the ISAM format in the program into a program sentence in the relational database. This rewriting operation is usually performed manually.

[0004] However, such a technique causes a decrease in execution performance due to inadequate knowledge of both the ISAM and the relational database, and further requires manual accuracy reduction and conversion. To solve this problem, there is a "program conversion processing system" disclosed in Japanese Patent Application Laid-Open No. 63-11537. FIG. 23 is a block diagram showing this conventional "program conversion processing method".
In this method, a database access part is analyzed from a program to be converted to generate extracted data, and the program is converted based on the information.

[0005] As a general program conversion method, there is an "programming language automatic conversion method and apparatus, and a computer system" disclosed in Japanese Patent Application Laid-Open No. 1-312233. FIG. 24 is a block diagram showing the “programming language automatic conversion method and device and the computer system”. In this method, automatic conversion between two programming languages expressed by a grammar that does not correspond one-to-one increases conversion efficiency based on the context of a conversion target sentence.

[0006] Also, as a method relating to the generation of an SQL embedded portion, there is a "program generation method" disclosed in Japanese Patent Application Laid-Open No. 3-182933. FIG. 25 is a block diagram showing the “program generation method”. in this way,
SQ based on table definition with processing specifications etc. as input
A program in which L is embedded is generated.

[0007]

However, in the conventional "program conversion processing method" disclosed in Japanese Patent Application Laid-Open No. 63-1111537, processing is performed for each extracted data, and a conversion corresponding file is processed according to the contents of the command word column. Index,
In addition, since the corresponding original program is drawn,
There is a problem that it is not possible to sufficiently cope with the processing of the AM database and the processing of the table in the relational database, which have greatly different structures, only by converting individual elements.

Further, in the conventional "programming language automatic conversion method and apparatus and computer system" disclosed in Japanese Patent Application Laid-Open No. HEI 1-312233, two programming languages expressed by a grammar that does not correspond to general one-to-one correspondence are used. Japanese Patent Laid-Open No. 63-1111537 discloses a method of analyzing before and after a target sentence for automatic conversion and determining a sentence after the conversion.
In the same manner as in Japanese Patent Publication No.
When the structure is significantly different, such as AM and a relational database, there is a problem that it is not possible to cope sufficiently.

Further, in the conventional "program generation method" disclosed in Japanese Patent Application Laid-Open No. 3-182293, the S program for accessing a relational database using a processing specification or the like is used.
The purpose is to generate a program in which QL is embedded, and in the process of converting the program, it is possible to use only a part called SQL sentence generation. With regard to automatic generation of an SQL sentence, there is a problem in that a means of designating from a specification is employed, and all information necessary for the SQL sentence must be provided to the specification.

SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and an object of the present invention is to automatically extract a program sentence in an ISAM format from an application program using a database, and to extract the program sentence in a relational database language. To provide a program conversion system that can easily and surely convert to a program sentence.

[0011]

In order to achieve the above object, a program conversion system according to a first aspect of the present invention provides a program conversion system which uses an indexed access file as a database. A program statement related to the access to the indexed access file, such as a definition statement defining records, data, etc., and an execution statement such as a database access instruction, into a program statement for using a relational database managed by a relational database management system. In a program conversion system that generates a converted program using a relational database by converting, a statement extraction unit that extracts a program statement related to access to an indexed access database from the conversion source program, and a statement extraction unit. Yo A relational database definition statement automatic generation means for automatically generating a relational database definition statement for defining a relational database definition statement for defining a relational database and a table to be used by applying database definition information extracted from the extracted definition statement to a fixed form sentence prepared in advance; A relational database program sentence automatic generation means for automatically generating a program necessary for accessing the relational database by applying a relational database definition sentence generated by the database definition sentence automatic generation means to a fixed form sentence prepared in advance.

In a program conversion system according to a second aspect, in the first aspect, the relational database definition sentence automatic generation means is arranged such that the conversion source program stores zero or more files having a cumulative sequential file and an index. A first fixed phrase that is used only when the program has a form using the first fixed phrase, and the relational database program sentence automatic generation means has a second fixed phrase corresponding to the first fixed phrase. It is.

[0013] In a third aspect of the present invention, in the first aspect of the present invention, the relational database definition sentence automatic generation means includes: a conversion source program that stores a cumulative index file and zero or more files having an index; 3rd use only if the program has a form that uses
The relational database program sentence automatic generation means has a fourth fixed sentence corresponding to the third fixed sentence.

According to a fourth aspect of the present invention, in the program conversion system according to the first aspect, the relational database definition sentence automatic generation means includes a cumulative index file which the conversion source program can randomly access with a key. A fifth fixed phrase used only when the program has a form using zero or more files having an index, wherein the relational database program sentence automatic generation means corresponds to the fifth fixed phrase. It has a sixth fixed form sentence.

According to a fifth aspect of the present invention, in the program conversion system according to the first aspect, the relational database definition sentence automatic generation means uses the cumulative type sequential file and the total file having the index as the conversion source program. And a seventh fixed phrase used only when the program has a mode of updating the total file based on the execution result of the program statement describing the total command, wherein the relational database program statement automatic generation means includes: , And an eighth fixed sentence corresponding to the seventh fixed sentence.

A program conversion system according to a sixth aspect of the present invention is the program conversion system according to the first aspect, wherein a fixed form sentence designating means for designating one to be used from a plurality of fixed forms prepared by the relational database program sentence automatic creation means. It has.

According to a seventh aspect of the present invention, in the program conversion system according to the first aspect, the relational database definition statement automatic generation means is arranged such that the conversion source program is based on data of a sequential file in which the conversion source program is cumulative. The program is used only when the program has a form that refers to an index file, and has a ninth fixed phrase that combines the files based on the data. Has a tenth fixed phrase corresponding to the fixed phrase.

According to an eighth aspect of the present invention, in the program conversion system according to the first aspect, the relational database definition statement automatic generation means refers to the index file based on data of the sequential file in which the conversion source program is cumulative. The program has an eleventh fixed phrase that is used only when the program has a form and associates each of the files based on the data to generate a view. It has a twelfth fixed phrase corresponding to the fixed phrase.

[0019]

Preferred embodiments of the present invention will be described below with reference to the drawings. In this embodiment, a case where SQL is used as a relational database language will be described. Of course, it is needless to say that the present invention can be applied to other relational database languages.

Embodiment 1 FIG. 1 is a schematic configuration diagram showing an embodiment of a program conversion system according to the present invention. This system constitutes a part or the whole of an information processing system. The system shown in FIG. 1 includes a program conversion unit 10 including an instruction extraction unit 11, an automatic SQL statement generation unit 12, and a program automatic generation unit 13, and an input processing unit 1. The program conversion unit 10 performs a program conversion process in which the conversion source program 2 is input and, if necessary, the contents set by a system engineer or the like from the input processing unit 1 are input and converted into the converted program 3. Will be.

The instruction extracting unit 11 is provided as sentence extracting means, and extracts a program sentence related to access to the indexed access database from the conversion source program 2. The SQL sentence automatic generation unit 12 is provided as a relational database definition sentence automatic generation unit, and is used by applying database definition information extracted from the definition sentence extracted by the instruction extraction unit 11 to a prepared fixed sentence. , A relational database definition statement (SQL statement) for defining a table is automatically generated. The program automatic generation unit 13 is provided as a relational database program statement automatic generation unit, and applies a SQL statement generated by the SQL statement automatic generation unit 12 to a standardized sentence prepared in advance, thereby generating a program statement necessary for relational database access. After completion, a program (the converted program 3) for accessing the relational database by SQL is automatically generated.

In the present embodiment, the conversion source program 2 is described so as to use an ISAM file as a database, and zero or more master files having an accumulation type sequential file (accumulation file) and an index are defined. COB that uses and references the product master file “SHOMAS” based on the data contained in the cumulative file “RUISEKI”
OL program. In the case of the COBOL program, information on the indexed access file, the database, and the record (data) included in the record (data) length, format, etc. used in the COBOL program is declared in advance by a definition statement, and READ, MOVE, etc. The database is actually accessed by an executable statement such as an instruction. Also, in the present embodiment, it is assumed that a program statement (such as an item move instruction) that handles information about a data item in the database is also included in the executable statement. In the present embodiment, the converted program 3 is stored in the relational database RD.
It is a Visual Basic program accessed by O (Remote Data Object).

A feature of this embodiment is that a program sentence of a relational database is automatically generated by applying database information obtained from the conversion source program 2 to a fixed sentence based on a prepared SQL sentence. It is. As a result, a program in the ISAM format can be easily and reliably converted into a program in the relational database.

Next, the operation of this embodiment will be described with reference to the flowchart shown in FIG.

In step 100, the instruction extracting unit 11
Is the data record definition (FILE
CONTROL, SELECT, etc.), file access instructions (OPEN, REA
D, MOVE, etc.), and program statements such as an item move instruction (MOVE) are extracted. For example, the statement of COBOL shown in FIG. 3 is extracted. Note that this extraction is performed in advance by COBO
A conventional method such as sequentially comparing statements included in the statement list of L with each program statement of the conversion source program 2 can be used.

In step 110, the SQL sentence automatic generation unit 12 automatically generates an SQL sentence in which each of the above-described cumulative file and master file is associated with a table. This means that the file name is the table name and the FD clause is SELECT
It can be generated by associating a key with an input parameter in the CT statement field. The SQL sentence automatic generation unit 12 in the present embodiment is used only when the conversion source program 2 is a program having a form using an accumulated file and zero or more files (master files) having an index. And the database definition information extracted from the conversion source program 2, that is, the names of the cumulative file, the master file, and the data contained in each of them, are simply inserted into the underlined portions of this fixed phrase. A relational database definition statement (SQL statement) can be generated.

In step 120, the program automatic generation unit 13 generates the SQ generated by the SQL statement automatic generation unit 12.
An SQL statement written as the post-conversion program 3 is automatically generated based on the L statement. In the present embodiment, RUISEKI
The S-ID indicating the product ID referenced from the table is a key for referring to the product master. The automatic program generation unit 13 in the present embodiment has a second fixed expression shown in FIG. 5 corresponding to the first fixed expression possessed by the automatic SQL sentence generation unit 12. This fixed phrase is the basis (framework) of the post-conversion program 3. The converted program 3 can be automatically generated simply by fitting the SQL sentence generated by the SQL sentence automatic generation unit 12 into the underlined portion of the second fixed sentence shown in FIG.

As described above, according to the present embodiment, the conversion source program 2 is used only when the conversion source program 2 is a program having a form using an accumulated file and zero or more master files having an index. Is prepared in advance, so that the conversion source program 2 only needs to pay attention to the extraction of information on the cumulative file and the master file. In addition, since the second fixed phrase preliminarily defining a structure in which the cumulative file is read one record at a time and the master file is referred to by using a specific item as a key is prepared in advance, a program for accessing the relational database is prepared. Can be easily and reliably performed.

Embodiment 2 In the present embodiment,
The conversion source program 2 is described in such a manner that the ISAM file is used as a database, and is sorted in the key order using a cumulative index file (cumulative file) and zero or more master files having an index. COB that refers to the product master file “SHOMAS” based on the data contained in the matching cumulative file “RUISEKI”
OL program.

Next, the operation of this embodiment will be described with reference to the flowchart shown in FIG.

In step 200, the instruction extracting unit 11
Extracts a program sentence such as a data record definition from the conversion source program 2. This processing is performed in the first embodiment.
, The details are omitted.

In step 210, the SQL sentence automatic generation unit 12 automatically generates an SQL sentence in which each of the above-mentioned cumulative file and master file is associated with a table. This means that the file name is the table name and the FD clause is SELECT
A key can be associated with an input parameter in the CT statement field. The SQL sentence automatic generation unit 12 according to the present embodiment is a program having a form in which the conversion source program 2 uses a cumulative index file (cumulative file) and zero or more files (master files) having an index. It has the third fixed form sentence shown in FIG. 7 which is used only in the case. In this fixed phrase, ORDE is added to the first fixed phrase.
An RBY clause is added, and the database definition information extracted from the conversion source program 2, that is, the cumulative file, the master file and the names of the data included in each, and the RUIID that is the key of the cumulative file are read in this order. A relational database definition sentence (SQL sentence) can be generated simply by fitting it into the underlined portion of the fixed sentence.

In step 220, the program automatic generation unit 13 generates the SQ generated by the SQL statement automatic generation unit 12.
An SQL sentence written as the post-conversion program 3 based on the L sentence is automatically generated by using a fourth fixed sentence corresponding to the third fixed sentence. In the present embodiment,
"S" which is the product ID referenced from the "RUISEKI" table
-ID "is a key for referring to the product master. The contents of the converted Visual Basic program are the same as those of the first embodiment except for the SQL statement.

As described above, according to the present embodiment, the conversion source program 2 uses a cumulative index file and zero or more master files having an index, and sorts them in key order by associating them. Since the third fixed phrase shown in FIG. 7 which is used only when the program has the form shown in FIG. 7 is prepared in advance, only the extraction of the information on the cumulative file and the master file from the conversion source program 2 is performed. Attention should be paid to In other words, ORDER BY that specifies key order reading in the third fixed phrase
Since the phrase is set, it is possible to read the record one record at a time, and to easily and reliably convert the program into a post-conversion program in a form in which the master file is referred to using a specific item as a key.

Embodiment 3 FIG. In the present embodiment,
The conversion source program 2 is described so as to use an ISAM file as a database, and uses a cumulative index file (cumulative file) that can be randomly accessed with a key and zero or more master files having an index. Then, the COBOL program refers to the product master file “SHOMAS” based on the data included in the cumulative file “RUISEKI”.

Next, the operation of this embodiment will be described with reference to the flowchart shown in FIG.

In step 300, the instruction extracting unit 11
Extracts a program sentence such as a data record definition from the conversion source program 2. This processing is performed in the first embodiment.
, The details are omitted.

In step 310, the SQL sentence automatic generation unit 12 automatically generates an SQL sentence in which each of the above-described cumulative file and master file is associated with a table. This means that the file name is the table name and the FD clause is SELECT
A key can be associated with an input parameter in the CT statement field. The SQL sentence automatic generation unit 12 according to the present embodiment includes a cumulative index file (cumulative file) that the conversion source program 2 can randomly access with a key, and zero or more files (master files) having an index. The fifth fixed phrase shown in FIG. 9 which is used only when the program has a form using. This fixed phrase is set so that “RUIID”, which is the key of the accumulation file, can be given from the outside by adding a WHERE clause to the first fixed phrase. A database definition statement (SQL statement) can be generated.

In step 320, the program automatic generation unit 13 generates the SQ generated by the SQL statement automatic generation unit 12.
An SQL sentence written as the post-conversion program 3 based on the L sentence is automatically generated by using a sixth fixed sentence corresponding to the fifth fixed sentence. In the present embodiment, the “RUISEKI” table is referred to based on a key given from the outside, and the product ID “S-ID” is a key for referring to the product master. Visual converted as shown in Fig. 10
This shows a Basic program (sixth fixed phrase). The SQ generated by the SQL sentence automatic generation unit 12 is underlined in FIG.
By simply inserting the L sentence, the post-conversion program 3 can be automatically generated.

As described above, according to the present embodiment, the conversion source program 2 uses a cumulative index file that can be randomly accessed with a key and a program that uses zero or more master files having an index. In this case, the fifth fixed phrase shown in FIG. 9 that is used only in the case of is prepared in advance, so that the conversion source program 2 only needs to pay attention to the extraction of information on the cumulative file and the master file. Will be. That is, since the WHERE clause is set in the fifth fixed phrase, the record corresponding to the key specified from the outside is read, and the conversion to the post-conversion program in the form of referring to the master file using the specific item as a key is easy and reliable. Can be done.

Embodiment 4 FIG. In the present embodiment,
An execution result of a program statement in which the conversion source program 2 is described so as to use the ISAM file as a database, and uses a cumulative type sequential file (cumulative file) and a totaling file having an index and describes a totaling instruction. Having a form for updating the aggregation file based on the COBOL
Program. More specifically, the cumulative file “RU
This program adds the sales value "URIAGE" from "ISEKI" to the total of the total file "SHUUKEI" for each product.

Next, the operation of this embodiment will be described with reference to the flowchart shown in FIG.

In step 400, the instruction extracting unit 11
Extracts a program sentence such as a data record definition from the conversion source program 2. For example, the COBO shown in FIG.
The statement of L is extracted. This process is the same as step 100 in the first embodiment, and thus details are omitted.

In step 410, the SQL sentence automatic generation unit 12 automatically generates an SQL sentence in which each of the above-mentioned accumulation file and total file is associated with a table. This is because the file name is the table name and the FD clause is SELECT
In the statement field, keys can correspond to input parameters. The SQL sentence automatic generation unit 12 according to the present embodiment has a form in which the conversion source program 2 updates a total file using a cumulative index file (cumulative file) and a file having an index (total file). It has a seventh fixed phrase shown in FIG. 13 which is used only when it is a program. Therefore, this fixed phrase UP
Make the key correspond to the input parameter in the SET clause of the DATE statement. This makes it possible to generate a relational database definition sentence (SQL sentence) simply by inserting the instruction for updating the total value into the underlined portion of the seventh fixed-form sentence.

In step 420, the program automatic generation unit 13 generates the SQ generated by the SQL statement automatic generation unit 12.
An SQL sentence written as the post-conversion program 3 based on the L sentence is automatically generated by using an eighth fixed sentence corresponding to the seventh fixed sentence. In the present embodiment,
Referring to the “RUISEKI” table in order, the “GOU” of the “SHUUKEI” table row that matches the product ID “S-ID”
Update the “KEI” field. V of the result converted to FIG.
This shows an isual Basic program (eighth fixed phrase). The converted program 3 can be automatically generated simply by fitting the SQL sentence generated by the SQL sentence automatic generation unit 12 into the underlined portion shown in FIG.

As described above, according to the present embodiment, the conversion source program 2 executes the program statement in which the aggregation command is described by using the accumulation type sequential file (accumulation file) and the aggregation file having the index. FIG. 1 used only for a program that updates a tally file based on the result
Since the seventh fixed phrase shown in FIG. 3 is prepared in advance, the conversion source program 2 only needs to pay attention to the extraction of information on the cumulative file and the master file. That is, by using the seventh fixed phrase, the cumulative file is read one record at a time, the total file is referred to using the specific item as a key, and the total data is added to the total file. Can be performed easily and reliably.

Embodiment 5 In each of the above embodiments, it has been described that the conversion source program 2 having a specific form defined in advance is easily and reliably converted to a program using a relational database by using a predetermined fixed phrase.

In this embodiment, the first to fourth embodiments are described.
In this embodiment, a system engineer or the like can manually select a form that matches the conversion source program 2 to be converted from the four forms described above. The input processing unit 1 shown in FIG. 1 is provided as a fixed sentence designating unit for designating one to be used from among the plurality of fixed sentences prepared by the SQL sentence automatic generation unit 12 in the present embodiment. , A system engineer or the like selects any form from the input processing unit 1.

Next, the operation of this embodiment will be described with reference to the flowchart shown in FIG.

Upon receiving the form of the conversion source program 2 selected by the system engineer (step 500), the input processing unit 1 performs one of the conversion processes according to the program form (steps 510 to 5).
40). That is, conversion processing using any of the prepared fixed sentences is performed. Since the contents of each conversion process (steps 510 to 540) have been described in the above embodiments, the details of the contents will be omitted.

As described above, according to the present embodiment, a system engineer or the like can manually select a program conforming to the format of a conversion source program to be converted from a plurality of predetermined specific formats. Therefore, it is possible to specify database-related information extracted from the conversion source program. This has the feature that the form of the converted program can be specified in advance, and the range of the form in which the program can be converted can be expanded.

In the above description, one of the processes described in the first to fourth embodiments is selected. However, another conversion process in which another fixed sentence form is prepared is added as a selection target. be able to.

Embodiment 6 FIG. In the present embodiment,
COBO having a form in which the conversion source program 2 refers to an index file based on data of a cumulative type sequential file
Let it be an L program. In particular, in the present embodiment, the master file “SHOMAKI” is obtained from the accumulated file “RUISEKI”.
For the part referring to "S", an SQL statement including a relational database joining process is automatically generated and the converted program 3
The feature is to embed in.

Next, the operation of this embodiment will be described with reference to the flowchart shown in FIG.

In step 600, the instruction extracting unit 11
Extracts a program sentence such as a data record definition from the conversion source program 2. This processing is performed in the first embodiment.
Is the same as step 100, and the processing result shown in FIG. 3 is obtained.

In step 610, the SQL sentence automatic generation unit 12 combines the "RUISEKI" table and the "SHOMAS" table in which the above-mentioned cumulative file "RUISEKI" and master file "SHOMAS" correspond to the tables, by performing a relational operation. A reference SQL sentence including a process is generated.
In the SQL sentence automatic generation unit 12 according to the present embodiment, the conversion source program 2 is a cumulative sequential file (cumulative file).
Ninth fixed phrase that is used only when the program has a form that refers to the index file based on the above data. By using the fixed phrase shown in FIG. 17 in the case of such a conversion source program 2, it is determined from the information that the cumulative forward file and the master file having the index are referred to and associated with each other.
From the column “S-ID” in the table to the column “SH” in the “SHOMAS” table
It is possible to automatically generate a relational database definition sentence (SQL sentence) simply by associating it with the OID "and inserting it into the underlined portion of the fixed sentence shown in FIG.

In step 620, the program automatic generation unit 13 generates the SQ generated by the SQL statement automatic generation unit 12.
An SQL sentence written as the post-conversion program 3 based on the L sentence is automatically generated by using a tenth fixed sentence corresponding to the ninth fixed sentence. FIG. 18 shows the tenth
Is shown, and the underlined part of this fixed phrase is SQL
By inserting the SQL sentence generated by the automatic sentence generation unit 12, the post-conversion program 3 that sequentially refers to the rows can be automatically generated.

As described above, according to the present embodiment, the ninth fixed format is used only when the conversion source program is a program having a mode of referring to the index file based on the data of the cumulative sequential file. Since the sentences are prepared in advance, it is convenient to pay attention only to the extraction of information on each file from the conversion source program, which is convenient. In addition, since the tenth fixed phrase which is the basis of the converted program corresponding to the ninth fixed phrase is prepared in advance, the conversion to the program for accessing the relational database can be easily and reliably performed. Can be. In addition, for a part that refers to the master file from the accumulated file, an SQL statement including a connection process of the relational database is automatically generated and embedded in the program, so that only the data combined based on the SQL statement unique to the program is read. Since it is not necessary to specify the key and refer to the master file, the converted program 3 having a simple program structure and high execution performance can be automatically generated.

Embodiment 7 FIG. In the present embodiment,
COBO having a form in which the conversion source program 2 refers to an index file based on data of a cumulative type sequential file
Let it be an L program. In particular, in the present embodiment, the master file “SHOMAKI” is obtained from the accumulated file “RUISEKI”.
For the part referring to "S", an SQL statement including the join processing of the relational database is automatically generated and the view "RUISEKI_SH
It is characterized in that it is registered as "OMAS".

Next, the operation of the present embodiment will be described with reference to the flowchart shown in FIG.

In step 700, the instruction extracting unit 11
Extracts a program sentence such as a data record definition from the conversion source program 2. This processing is performed in the first embodiment.
Is the same as step 100, and the processing result shown in FIG. 3 is obtained.

In step 710, the SQL sentence automatic generation unit 12 joins the “RUISEKI” table and the “SHOMAS” table, each of which corresponds to the cumulative file “RUISEKI” and the master file “SHOMAS”, with the relational operation. An SQL sentence for generating a view “RUISEKI_SHOMAS” including processing is automatically generated. S in the present embodiment
The QL sentence automatic generation unit 12 has an eleventh fixed phrase used only when the conversion source program 2 is a program having a mode of referring to an index file based on data of a cumulative sequential file (cumulative file). doing. By using this fixed sentence in the case of such a conversion source program 2, a view is automatically generated by associating a cumulative file with a master file based on data in the cumulative file. That is, from the information that the cumulative type sequential file and the master file having the index are referenced and associated, the “RUISEKI” table column “S-ID” to “S-ID”
The view definition portion of the relational database definition sentence (SQL sentence) can be automatically generated simply by associating it with the underlined portion of the fixed sentence shown in FIG. 20 in association with the column "SHOID" of the "HOMAS" table.

Further, in step 720, the SQL sentence automatic generation unit 12 automatically generates a view reference portion of the SQL sentence referring to the view RUISEKI_SHOMAS simply by fitting it into the underlined portion of the eleventh fixed sentence shown in FIG. Can be.

In step 730, the program automatic generation unit 13 generates the SQ generated by the SQL statement automatic generation unit 12.
An SQL sentence written as the post-conversion program 3 based on the L sentence is automatically generated by using a twelfth fixed sentence corresponding to the eleventh fixed sentence. FIG. 22 shows the first
2 is shown, and SQ is added to the underlined portion of the fixed phrase.
By inserting the SQL sentence generated by the automatic L sentence generation unit 12, the post-conversion program 3 that sequentially refers to the rows from the “RUISEKI_SHOMAS” view can be automatically generated.

As described above, according to the present embodiment, the conversion into the post-conversion program 3 for accessing the relational database can be performed easily and reliably.
For the part that refers to the master file from the accumulated file, an SQL statement including the join processing of the relational database is automatically generated and registered as a view, so it is necessary to refer to the master file by specifying the key just by reading the view Therefore, the converted program 3 having a simple program structure and good execution performance can be automatically generated.

[0066]

According to the present invention, a converted program that uses a relational database is generated by applying database definition information extracted from a definition sentence relating to access to an indexed access database to a fixed phrase prepared in advance. Therefore, the program conversion process can be easily and reliably performed.

Also, a first fixed phrase to be used only when the conversion source program is a program having a form using a cumulative sequential file and zero or more files having an index is prepared in advance. Therefore, it is only necessary to pay attention to the extraction of information on each of the files from the conversion source program, which is convenient. In addition, since the second fixed phrase that is the basis of the converted program corresponding to the first fixed phrase is prepared in advance, the conversion to the program that accesses the relational database can be easily and reliably performed. Can be.

Also, a third fixed phrase to be used only when the conversion source program is a program having a form using a cumulative index file and zero or more files having an index is prepared in advance. Therefore, it is only necessary to pay attention to the extraction of information on each of the files from the conversion source program, which is convenient. In addition, since the fourth fixed phrase that is the basis of the converted program corresponding to the third fixed phrase is prepared in advance, the conversion to the program that accesses the relational database can be easily and reliably performed. Can be.

Further, the fifth embodiment is used only when the conversion source program is a program having a form using a cumulative index file which can be randomly accessed with a key and zero or more files having an index. Since the fixed phrase is prepared in advance, the conversion source program only needs to pay attention to the extraction of information on each of the above files, which is convenient. In addition, since the sixth fixed phrase that is the basis of the converted program corresponding to the fifth fixed phrase is prepared in advance, the conversion to the program that accesses the relational database can be easily and reliably performed. Can be.

Further, the conversion source program is used only when the conversion source program is a program that uses a cumulative sequential file and an aggregation file having an index and updates the aggregation file based on the execution result of a program statement describing an aggregation instruction. The seventh
Is prepared in advance, so that it is only necessary to pay attention to the extraction of information on each of the files from the conversion source program, which is convenient. In addition, since the eighth fixed phrase that is the basis of the converted program corresponding to the seventh fixed phrase is prepared in advance, the conversion to the program that accesses the relational database can be easily and reliably performed. Can be.

Further, since a system engineer or the like can manually select a program that matches the format of the conversion source program to be converted from a plurality of specific formats specified in advance, a database-related program extracted from the conversion source program can be selected. Information can be specified. This has the feature that the form of the converted program can be defined in advance,
In addition, the range of the form in which the program can be converted can be expanded.

Also, a ninth fixed phrase to be used only when the conversion source program is a program having a mode of referring to the index file based on the data of the cumulative sequential file is prepared in advance. From the conversion source program, it is only necessary to pay attention to the extraction of information on each of the above files, which is simple. In addition, since the tenth fixed phrase which is the basis of the converted program corresponding to the ninth fixed phrase is prepared in advance, the conversion to the program for accessing the relational database can be easily and reliably performed. Can be. In particular, for the part that refers to the index file from the accumulated file, the relational database definition statement including the relational database connection processing is automatically generated and embedded in the program, so that it is linked based on the program-specific relational database definition statement. Since it is not necessary to refer to the index file by designating a key only by reading the data thus converted, it is possible to automatically generate a converted program having a simple program structure and high execution performance.

In the case where the conversion source program is a program that refers to an index file based on the data of a cumulative sequential file, a relational database definition statement including a relational database joining process is automatically generated and viewed. Since the eleventh fixed form sentence registered as "?" Is prepared in advance, the extraction of the information on each of the above files from the conversion source program is only required, which is convenient. Also, since the twelfth fixed phrase that is the basis of the converted program corresponding to the eleventh fixed phrase is prepared in advance, the conversion to the program that accesses the relational database can be easily and reliably performed. Can be. Also,
In particular, for the part that refers to the index file from the cumulative file, the relational database definition statement including the relational database join processing is automatically generated and registered as a view. , It is possible to automatically generate a converted program having a simple program structure and good execution performance.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram showing an embodiment of a program conversion system according to the present invention.

FIG. 2 is a flowchart showing an operation in the first embodiment.

FIG. 3 is a diagram illustrating a part of a conversion source program extracted by an instruction extraction unit according to the first embodiment;

FIG. 4 is a diagram showing an SQL sentence which is an output of the SQL sentence automatic generation unit according to the first embodiment.

FIG. 5 is a diagram showing a converted program which is an output of a program automatic generation unit according to the first embodiment.

FIG. 6 is a flowchart showing an operation according to the second embodiment.

FIG. 7 is a diagram illustrating an SQL sentence output from an automatic SQL sentence generation unit according to the second embodiment.

FIG. 8 is a flowchart showing an operation in the third embodiment.

FIG. 9 is a diagram illustrating an SQL sentence output from an automatic SQL sentence generation unit according to the third embodiment.

FIG. 10 is a diagram showing a converted program which is an output of a program automatic generation unit according to the third embodiment.

FIG. 11 is a flowchart showing an operation in the fourth embodiment.

FIG. 12 is a diagram illustrating a part of a conversion source program extracted by an instruction extraction unit according to the fourth embodiment.

FIG. 13 is a diagram showing an SQL sentence which is an output of an SQL sentence automatic generation unit according to the fourth embodiment.

FIG. 14 is a diagram showing a converted program which is an output of a program automatic generation unit according to the fourth embodiment.

FIG. 15 is a flowchart showing an operation in the fifth embodiment.

FIG. 16 is a flowchart showing an operation in the sixth embodiment.

FIG. 17 is a diagram illustrating an SQL sentence output from an automatic SQL sentence generation unit according to the sixth embodiment.

FIG. 18 is a diagram showing a converted program which is an output of a program automatic generation unit according to the sixth embodiment.

FIG. 19 is a flowchart showing an operation in the seventh embodiment.

FIG. 20 is a diagram illustrating an SQL sentence (view definition portion) output from an SQL sentence automatic generation unit according to the seventh embodiment.

FIG. 21 is a diagram illustrating an SQL sentence (view reference portion) output from an SQL sentence automatic generation unit according to the seventh embodiment.

FIG. 22 is a diagram showing a converted program which is an output of an automatic program generation unit according to the seventh embodiment.

FIG. 23 is a block diagram showing a conventional “program conversion processing method”.

FIG. 24 is a block diagram showing a conventional “programming language automatic conversion method and device and computer system”.

FIG. 25 is a flowchart showing an operation procedure of a conventional “program generation method”.

[Explanation of symbols]

1 input processing unit, 2 conversion source program, 3 converted program, 10 program conversion unit, 11 instruction extraction unit, 12 SQL statement automatic generation unit, 13 program automatic generation unit.

Claims (8)

[Claims] 1. An indexed access file access, such as a definition statement defining a database, a record, data, etc. to be used, and an executable statement such as a database access instruction, included in a conversion source program using an indexed access file as a database. In a program conversion system for generating a converted program using a relational database by converting a related program statement into a program statement for using a relational database managed by a relational database management system, Sentence extracting means for extracting a program sentence related to access to an indexed access database from the database, and applying database definition information extracted from the definition sentence extracted by the sentence extracting means to a prepared fixed sentence. A relational database definition statement automatic generation means for automatically generating a relational database definition statement for defining the relational database and table to be used, and a fixed phrase prepared in advance for the relational database definition statement generated by the relational database definition statement automatic generation means And a relational database program statement automatic generation means for automatically generating a program necessary for accessing the relational database by applying to the program. 2. The relational database definition sentence automatic generation means is used only when the conversion source program is a program having a form using a cumulative forward file and zero or more files having an index. The program conversion system according to claim 1, further comprising a first fixed sentence, wherein the relational database program sentence automatic generation means has a second fixed sentence corresponding to the first fixed sentence. 3. The relational database definition sentence automatic generation means is used only when the conversion source program is a program having a form using a cumulative index file and zero or more files having an index. 3. The program conversion system according to claim 1, further comprising a third fixed sentence, wherein the relational database program sentence automatic generation unit has a fourth fixed sentence corresponding to the third fixed sentence. 4. The relational database definition sentence automatic generation means has a form in which the conversion source program uses a cumulative index file that can be randomly accessed with a key and zero or more files having an index. A fifth fixed sentence used only when the program is a program, wherein the relational database program sentence automatic generation means has a sixth fixed sentence corresponding to the fifth fixed sentence. 2. The program conversion system according to 1. 5. The relational database definition statement automatic generation means, wherein the conversion source program uses a cumulative forward file and an aggregation file having an index, and based on an execution result of a program statement describing an aggregation instruction. A seventh fixed phrase used only when the program has a form for updating the aggregation file, the relational database program sentence automatic generation means includes an eighth fixed phrase corresponding to the seventh fixed phrase. 2. The program conversion system according to claim 1, further comprising: 6. A program conversion system according to claim 1, further comprising a fixed phrase designating unit for designating a plurality of fixed phrases prepared by said relational database program sentence automatic generating unit. . 7. The relational database definition sentence automatic generation means is used only when the conversion source program is a program having a form in which the conversion source program refers to an index file based on data of a cumulative type sequential file. And a ninth fixed phrase for combining the files based on the data, wherein the relational database program sentence automatic generation means has a tenth fixed phrase corresponding to the ninth fixed phrase. The program conversion system according to claim 1, wherein: 8. The relational database definition sentence automatic generation means is used only when the conversion source program is a program having a form of referring to an index file based on data of a cumulative sequential file, and Generating a view by associating each of the files based on the first
2. The program conversion system according to claim 1, wherein the relational database program sentence automatic generation means has a twelfth fixed form sentence corresponding to the eleventh fixed form sentence. 3.