JP5581894B2 - Data processing program automatic generation system - Google Patents

Description

  The present invention relates to automatic generation of a program, and in particular, performs data processing with reference to data in a database table constructed on an information processing system, stores the processing result in the database table again, or based on the processing result The present invention relates to a system that automatically generates a data processing program that updates or deletes data in a database table.

  An example of this type of data processing program automatic generation system is described in Patent Document 1. A data processing program automatic generation system described in Patent Document 1 (hereinafter referred to as a data processing program automatic generation system related to the present invention) includes a program skeleton prepared in advance in the system and a specification input from a user. From this, a data processing program is created.

  The program skeleton has, as a fixed part program regardless of the specification, a pre-processing part, a repetitive processing part following the pre-processing part, and a post-processing part following the repetitive processing part. In addition, the program skeleton includes the program fragment insertion position, the cursor definition statement insertion position, the work variable definition statement string insertion position, and the initial process insertion position as the insertion position of the part of the program fragment that changes according to the specification. , The output processing statement string insertion position is included in the repetition processing portion, and the end processing insertion position is included in the subsequent processing portion.

  The above specifications are the program name to be given to the generated program, the input table name, the input table item definition including the name and type information of each item of the input table, and the name of the input table item to be defined in the select statement Select item definition that includes, output table name and output table item definition that includes information on the name and type of each item in the output table, processing conditions indicating the conditions for processing each output table, insert, update, Process type that indicates the type of deletion, update when the process type is update and delete, update that indicates the condition for deleting, delete condition, and process that calculates the value of each item when the process type is insert and update Includes an output table processing definition that includes an expression, a select condition definition that includes conditions for obtaining data from the input table, and program customization information that includes other information to customize the program skeleton That.

  And the said data processing program automatic generation system completes a program by inserting the information acquired from the specification, and the information produced | generated from this information in the applicable location of a program skeleton. Specifically, the program name and program customization information are acquired from the input specifications, the acquired program name is inserted at the program name insertion position of the program skeleton, and the acquired program customization information is used for initial processing and end processing. Separately, the program skeleton is inserted at the initial processing insertion position and the end processing insertion position, respectively. Also, an input table item definition, a select item definition, and a select condition definition are acquired from the input specification, a cursor definition statement is generated from these, and inserted at the cursor definition statement insertion position of the program skeleton. Further, the data processing program automatic generation system obtains an output table item definition and an output table processing definition from the input specification, generates a work variable definition statement and an output processing statement from them, and generates a work variable of the program skeleton. Inserted at the definition statement string insertion position and output processing statement string insertion position, respectively.

  On the other hand, in an automatic program synthesis device, an abstract description language file (subscenario file) is input, a similar subscenario file is detected, a matching part is detected, and a common subscenario file is generated. There is a technique for assigning an ID to the common part (see, for example, Patent Document 2).

Japanese Patent No. 3871832 JP 2002-99415 A

  In the data processing program automatic generation system described in Patent Document 1 described above, a specification including all information necessary for the data processing program to be created is received as one input specification. It is necessary to prepare a specification including all necessary information in advance. Therefore, even if the program customization information, which is other information for customizing the program skeleton, may have the same specifications among some data processing programs, it contains all information for each data processing program to be created It is necessary to create and save specifications separately. Therefore, there has been a problem that the cost required for creating and storing the specifications increases.

  Patent Document 2 only describes generation of a common sub-scenario file and assigning an ID to the common part. The technique described in Patent Document 2 is applied to Patent Document 1. However, it is difficult to solve the above problem.

  An object of the present invention is to provide an automatic data processing program generation system that solves the problem described above, that is, the problem that the cost required to create and store specifications increases.

A data processing program automatic generation system according to an aspect of the present invention includes:
In a program that references data in a database table and inserts new data into the table, updates data in the table, or deletes data in the table, the pre-processing part, the iterative processing part, and the post-processing part A data processing program automatic generation system that automatically generates an entire program including a processing part based on a program skeleton and specifications,
A configuration comprising specification input means having a function of inputting individual specifications which are different specifications for each data processing program to be created, and a function of inputting common specifications which are different specifications for each group to which the data processing program to be created belongs Take.

  Since the present invention has the above-described configuration, it is possible to reduce the cost required for creating and storing specifications.

It is a block diagram which shows the structure of the 3rd Embodiment of this invention. It is a figure which shows the required information for every process classification in the structure of the specification in the 3rd Embodiment of this invention, and the output table process definition in a specification. It is a flowchart which shows the process of the cursor definition sentence production | generation means in the 3rd Embodiment of this invention. It is a flowchart which shows the process of the work variable definition sentence production | generation means in the 3rd Embodiment of this invention. It is a flowchart which shows the process of the output process sentence production | generation means in the 3rd Embodiment of this invention. It is a flowchart which shows the process of the program automatic synthesis means in the 3rd Embodiment of this invention. It is a figure which shows the structure of the cursor definition sentence skeleton used with the cursor definition sentence production | generation means in the 3rd Embodiment of this invention. It is a figure which shows the structure of the work variable definition sentence skeleton used by the work variable definition sentence production | generation means in the 3rd Embodiment of this invention. It is a figure which shows the structure of the output process sentence skeleton used by the output process sentence production | generation means in the 3rd Embodiment of this invention, and the structure of the insertion sentence of the skeleton, an update sentence, and a deletion sentence. It is a figure which shows the structure of the program skeleton in the 3rd Embodiment of this invention. It is a figure which shows the structure of the specification in the 4th Embodiment of this invention. It is a flowchart which shows the process of the cursor definition sentence production | generation means in the 4th Embodiment of this invention. It is a flowchart which shows the process which produces select item definition information in the 4th Embodiment of this invention. It is a block diagram which shows the structure of the 5th Embodiment of this invention. It is a figure which shows the structure of the specification in the 5th Embodiment of this invention. It is a processing flowchart which shows the process of the specification input means in the 6th Embodiment of this invention. It is a process flowchart which shows the process example of the 3rd Embodiment of this invention. It is a block diagram which shows the structure of the 8th Embodiment of this invention. It is a block diagram which shows the structure of the 1st Embodiment of this invention. It is a figure which shows an example of the common process specification used by this invention. It is a figure which shows another example of the common process specification used by this invention. It is a block diagram which shows the structure of the 2nd Embodiment of this invention. It is a figure which shows another example of the common process specification used by this invention.

Next, embodiments of the present invention will be described in detail with reference to the drawings.
[First embodiment]
Referring to FIG. 19, the data processing program automatic generation system 10 according to the first embodiment of the present invention inputs an individual specification 1A and a common processing specification 1B, and inputs the input individual specification 1A and common processing specification 1B. And a function for generating a data processing program based on a prepared program skeleton and outputting it as the generation program 2. The generated data processing program refers to the data in the database table and inserts new data into the table, updates the data in the table, and deletes data in the table. It is a processing program.

  The data processing program automatic generation system 10 includes a specification input unit 101. The specification input unit 101 includes an individual specification input unit 1011 and a common processing specification input unit 1012.

  The individual specification input unit 1011 has a function of inputting the individual specification 1A. The individual specification 1A is different for each data processing program to be created. The individual specification 1A includes, for example, a program name, input table item definition, select item definition, output table item definition, output table processing definition, and select condition definition. The individual specification 1A input by the individual specification input unit 1011 is transmitted to a subsequent processing function in the data processing program automatic generation system 10 and used for generating a program.

  The common processing specification input unit 1012 has a function of inputting the common processing specification 1B. The common processing specification 1B is different for each group to which the data processing program to be created belongs. A group is, for example, an individual group when a batch system is divided into several groups. The common processing specification 1B includes program customization information that is other information for customizing the program skeleton. The common processing specification 1B input by the common processing specification input unit 1012 is transmitted to a subsequent processing function in the data processing program automatic generation system 10 and used for generating a program.

  FIG. 20 is an example of the common processing specification 1B. In this example, the common processing specification 1B defines initial processing from 1000 to 1011 and defines end processing from 1013 to 1024. The initial process includes a start log output process, a common variable definition process, and a common error handle process. The end process includes an end log output process, a common variable definition process, and a common error handle process. These initial processing and end processing are acquired by the common processing specification input unit 1012 and transmitted to the subsequent processing function.

  FIG. 21 shows another example of the common processing specification 1B. In this example, the common processing specification 1B defines initial processing from 1000 to 1010 and defines end processing from 1012 to 1022. The content is slightly different from the common processing specification shown in FIG. These initial processing and end processing are acquired by the common processing specification input unit 1012 and transmitted to the subsequent processing function.

  FIG. 10 is an example of a program skeleton. The program skeleton 1001 in this example classifies a program written in a specific programming language into a part that changes according to the specification and a part that does not change according to the specification. The changing part is configured to have an insertion position of a program fragment created from the specification. In the example of FIG. 10, the program name insertion position 1002, the cursor definition sentence insertion position 1003, the work variable definition sentence string insertion position 1004, the “initial processing” insertion position 1005, and the output are inserted as the fragment insertion positions of this program. It has a processing statement string insertion position 1006 and an “end processing” insertion position 1007.

  Next, the operation of the data processing program automatic generation system 10 according to the present embodiment will be described.

  When a user automatically generates a data processing program using the data processing program automatic generation system 10, a file storing a specification 1A specific to the data processing program to be generated and a group to which the data processing program to be generated belongs are commonly used. The file storing the created common processing specification 1B is set on a storage device that can be read from the data processing program automatic generation system 10. Then, the data processing program automatic generation system 10 is activated.

  First, the data processing program automatic generation system 10 inputs the individual specification 1A from the individual specification input unit 1011 of the specification input means 101, and transmits it to the subsequent processing function. Further, the common processing specification 1B is input by the common processing specification input unit 1012 and transmitted to the processing function at the subsequent stage.

  Next, the data processing program automatic generation system 10 generates a program name, a cursor definition statement, a work variable definition statement, and an output processing statement to be inserted into the program skeleton based on the individual specification 1A by the processing function at the subsequent stage. In addition, the data processing program automatic generation system 10 acquires initial processing and end processing to be inserted into the program skeleton from the common processing specification 1B by the subsequent processing function.

  Next, the data processing program automatic generation system 10 generates the generation program 2 by inserting them into the corresponding portions of the program skeleton. Specifically, in the program skeleton 1001 of FIG. 10, the program name is inserted at the program name insertion position 1002, the cursor definition sentence is inserted at the cursor definition sentence insertion position 1003, and the work variable definition sentence is inserted at the work variable definition sentence string insertion position 1004. Initial processing “Initial processing is inserted at the insertion position 1005, output processing text is inserted at the output processing statement string insertion position 1006, and“ end processing ”is terminated at the insertion position 1007.

  Finally, the data processing program automatic generation system 10 outputs the generation program 2.

  As described above, according to the present embodiment, it is possible to reduce the cost required for creating and storing the specification. The reason is that, among the specifications, the common specification 1B, which is a different specification for each group to which the data processing program belongs, needs to be created and saved in units of groups, not for each individual data processing program.

[Second Embodiment]
Referring to FIG. 22, in the data processing program automatic generation system 10 according to the second embodiment of the present invention, compared with the first embodiment shown in FIG. It is different in having. The common process specification 1B includes a common process description to which a keyword is assigned and a plurality of process descriptions in which the keyword is inserted at a position where the common process description is inserted.

  The expansion unit 1013 receives the common processing specification 1B from the common processing specification input unit 1012, and expands the common processing description to which the keyword is assigned at the keyword insertion position in the plurality of processing descriptions included in the common processing specification 1B. It has the function to do. The common processing specification 1B subjected to the expansion processing by the expansion unit 1013 is transmitted to a subsequent processing function in the data processing program automatic generation system 10 and used for generating a program.

  FIG. 23 is an example of the common processing specification 1B. In this example, the common processing specification 1B defines initial processing from lines 1000 to 1005, defines end processing from lines 1007 to 1013, and defines common error processing from lines 1015 to 1020. The keyword “common error processing” is assigned to the defined common error processing. In the initial process and the end process, the keyword is enclosed by a special symbol ($ or the like) determined in advance at the position where the common error process is inserted.

  That is, the common process specification 1B of FIG. 23 describes only the start log output process individually during the initial process, and describes only the end log output process individually during the end process, and is common to both the initial process and the end process. The variable definition process and the common error handle process are not described separately, but are combined as a common process. As a result, the same process as in FIG.

  Next, the operation of the data processing program automatic generation system 10 according to the present embodiment will be described.

  When a user automatically generates a data processing program using the data processing program automatic generation system 10, a file storing a specification 1A specific to the data processing program to be generated and a group to which the data processing program to be generated belongs are commonly used. The file storing the created common processing specification 1B is set on a storage device that can be read from the data processing program automatic generation system 10. Then, the data processing program automatic generation system 10 is activated.

  First, the data processing program automatic generation system 10 inputs the individual specification 1A from the individual specification input unit 1011 of the specification input means 101, and transmits it to the subsequent processing function. Further, the common processing specification 1B is input by the common processing specification input unit 1012 and transmitted to the expansion unit 1013.

  Next, the expansion unit 1013 expands the common process description to which the keyword is assigned at the insertion position of the keyword in the plurality of process descriptions included in the common process specification 1B. Then, the common processing specification 1B after the expansion processing is transmitted to the subsequent processing function.

  The subsequent operations are the same as those in the first embodiment.

  As described above, according to the present embodiment, it is possible to reduce the cost required for creating and storing the specification. The reason is that, among the specifications, the common specification 1B, which is a different specification for each group to which the data processing program belongs, needs to be created and saved in units of groups, not for each individual data processing program.

  Further, according to the present embodiment, it is possible to further reduce the cost required for creating and storing the specifications as compared with the first embodiment. The reason is that when there are a plurality of processes including the same common process in the common specification 1B, it is not necessary to individually describe the common process in each of the plurality of processes.

  In addition, when there are a plurality of processes including the same common process in the common specification 1B, in the configuration in which the common process is individually described in each of the plurality of processes, if there is a need to change the common process later, Therefore, the amount of work increases, and inconsistency due to omission of changes tends to occur. On the other hand, according to the present embodiment, since only one point needs to be corrected, the cost required for maintenance can be reduced, and the occurrence of inconsistency due to omission of changes can be prevented.

[Third embodiment]
FIG. 1 is a block diagram showing a configuration example of a third embodiment of the data processing program automatic generation system of the present invention, and FIG. 17 is a flowchart showing an outline of the processing. First, the outline of the third embodiment will be described with reference to FIGS.

  In FIG. 1, a specification 1 indicating business requirements corresponds to a combination of the individual specification 1A and the common processing specification 1B in the first and second embodiments. Specification 1 includes a program name, an input table item definition, a select item definition, an output table item definition, an output table processing definition, a select condition definition, and program customization information as specifications that the program to be developed should satisfy. First, in 1701 of FIG. 17, the specification input means 101 inputs such a specification 1. Next, the program skeleton customization information acquisition unit 102 extracts the program name and program customization information as information necessary for customizing the program skeleton from the input specifications, and passes it to the automatic program synthesis unit 109 (1702). . Also, the cursor definition information acquisition unit 103 takes out the input table item definition, the select item definition, and the select condition definition as information necessary for generating the cursor definition statement from the input specifications, and the cursor definition statement generation unit Pass to 105 (1703). Furthermore, the output item processing information acquisition means 104 outputs the output table item definition and the output table processing definition as information necessary for generating the work variable definition statement and the output processing statement from the input specifications. It is taken out as information and passed to the work variable definition statement generation means 106 and the output processing statement generation means 107 (1704).

  Next, the cursor definition statement generation unit 105 processes the information received from the cursor definition information acquisition unit 103, and defines a table and an item to be referred to in the process specified by the specification in the database table. A sentence is generated and passed to the automatic program synthesis means 109 (1705). Further, the work variable definition sentence generation unit 106 processes the information received from the output item processing information acquisition unit 104, and stores the calculation results of each item of all output tables in which the processing type is insertion in the generation program. A variable definition statement is generated and passed to the automatic program synthesis means 109 (1706). Further, the output processing statement generation means 107 processes the information received from the output item processing information acquisition means 104, and among all the output tables in the generation program, the processing condition statement for the output table whose processing type is insertion. An output processing statement consisting of a field calculation statement and an insertion statement, and an output processing statement consisting of processing conditions and an update statement for an output table whose processing type is update, and an output table whose processing type is deletion In response to this, an output processing statement composed of a processing condition statement, an item calculation statement, and a deletion statement is generated and passed to the automatic program synthesis means 109 (1707).

  In FIG. 1, a program skeleton 108 is prepared by preparing a portion of a generated program that does not change regardless of what business requirements are given as specifications. In the framework of this program, there are embedded the program name, cursor definition statement, work variable definition statement, output processing statement, and one or more program fragment insertion positions as necessary. The purpose is to obtain a completed program by inserting a program fragment generated from the business requirements given in the specification.

  The automatic program synthesis means 109 inserts the program name acquired by the program skeleton customization information acquisition means 102 into the insertion position corresponding to the program name among the insertion positions of the program skeleton 108, and sets the insertion position corresponding to the cursor definition statement. The cursor definition statement generated by the cursor definition statement generation unit 105 is inserted, the work variable definition statement generated by the work variable definition statement generation unit 106 is inserted at the insertion position corresponding to the work variable definition statement, and the output processing statement is inserted. The program is inserted by inserting the output processing statement generated by the output processing statement generation unit 107 into the corresponding insertion position, and inserting the corresponding program statement fragment acquired by the program skeleton customization information acquisition unit 102 into the other insertion position. Automatically synthesize (1708).

  Next, details of the third embodiment of the present invention will be described with reference to FIGS.

  FIG. 2A is a diagram showing a configuration example of the specification 1 of FIG. Reference numeral 201 denotes the entire specification 1 and corresponds to the specification 1 in FIG. As shown in FIG. 2 (a), the specification 201 includes a program name 202 that is a name that a program generated from the specification should have, an input table name definition including the name of the input table, the name and type of each item. 203 and select item definition 204 that includes the name of the item to be defined in the select statement, and the name of the output table, and the name and type of each item. Output table item definition 205 that contains the information, processing conditions that indicate the conditions for processing each output table, processing type that indicates whether to insert, update, or delete, and update / delete when the processing type is update or delete Output table processing definition 206 that includes update / deletion conditions indicating the conditions for processing, processing expressions for calculating the value of each item when the processing type is insert and update, and conditions for acquiring data from the input table Select condition definition 207 including, and program skeleton Composed of program customization information 208. include other information required to customize.

  Information for each processing type necessary for the output table processing definition 206 is shown in a list in FIG. Referring to FIG. 2B, when the processing type is insertion, the processing formula is essential, the processing condition is arbitrary, and the update / deletion condition is unnecessary. When the processing type is update, the processing formula and the update condition are indispensable, and the process condition is arbitrary. When the processing type is deletion, the deletion condition is indispensable, the processing condition is arbitrary, and the processing formula is unnecessary. If no processing condition is specified, the processing is performed assuming that the processing condition is always satisfied. The specification input unit 101 in FIG. 1 inputs a specification having the configuration shown in FIG. 2 and passes it to the program skeleton customization information acquisition unit 102, the cursor definition information acquisition unit 103, and the output item processing information acquisition unit 104.

  The program skeleton customization information acquisition unit 102 extracts the part corresponding to the program name 202 and the program customization information 208 in FIG. 2 from the specification information passed from the specification input unit 101 and passes it to the automatic program synthesis unit 109. The cursor definition information acquisition unit 103 extracts the portions corresponding to the input table item definition 203, the select item definition 204, and the select condition definition 207 in FIG. 2 from the specification information passed from the specification input unit 101, and generates a cursor definition statement generation unit. Pass to 105. The output item processing information acquisition unit 104 extracts the parts corresponding to the output table item definition 205 and the output table processing definition 206 in FIG. 2 from the specification information passed from the specification input unit 101, and the work variable definition statement generation unit 106 It is passed to the output processing statement generation means 107.

  Next, the operation of the cursor definition sentence generation unit 105 will be described with reference to FIG. FIG. 3 is a flowchart showing the operation of the cursor definition sentence generation unit 105. 1 receives input table item definition information, select item definition information, and select condition definition information as cursor definition information from the cursor definition information acquisition unit 103 in 301 of FIG. In 302, only the item name specified in the select item definition information is extracted from the input table item definition information, and a select item string is created in a format according to the syntax of the programming language to be generated. In 303, only the name of the input table used in the select item definition information is extracted from the input table specified in the input table item definition information, and the select table column is formatted according to the syntax of the programming language to be generated. Create In 304, the selection condition definition information is processed into a format according to the syntax of the program language to be generated, and a selection condition statement is created. In 305, the select item string, select table string, and select condition created in 302, 303, and 304, respectively, are inserted into the corresponding insertion positions of the cursor definition skeleton to create a cursor definition statement. At 306, this cursor definition sentence is output and passed to the automatic program synthesis means 109 of FIG.

  FIG. 7 shows a configuration example of the cursor definition skeleton. Referring to FIG. 7, a cursor definition sentence skeleton 701 is a skeleton that depends on a specific programming language, and has a select item string insertion position 702, an input table string insertion position 703, and a select condition insertion position 704. In these blank portions, a select item string, an input table string, and a select condition, respectively, created by the cursor definition sentence generation unit of FIG. 1, are inserted to form a cursor definition sentence.

  Next, the operation of the work variable definition sentence generation unit 106 will be described with reference to FIG. FIG. 4 is a flowchart showing the operation of the work variable definition sentence generation means 106. 1 receives the output table item definition information from the output item processing information acquisition unit 104 in 401 of FIG. In general, one or more output tables can be specified. However, for an output table whose process type is update or delete, no work variable definition is required, so 402 is repeated for an output table whose process type is insertion. In 402, steps 403 to 405 are performed. In 403, a type definition statement that defines the record type of the output table is created. In 404, a statement that defines the work area variable with the type defined in 403 is created. In 405, the type definition statement created in 403 and the variable definition statement created in 404 are inserted into the corresponding insertion positions of the work variable definition skeleton. In step 406, the work variable definition sentence string completed by repeating 402 is output and passed to the automatic program generation means 109 in FIG.

  FIG. 8 shows a configuration example of the work variable definition skeleton. Referring to FIG. 8, the work variable definition skeleton 801 has a type definition sentence insertion position 802 and a variable definition sentence insertion position 803. In 405 of FIG. 4, a type definition sentence and a variable definition sentence are inserted at these insertion positions, respectively, to complete the work variable definition sentence. When there are a plurality of work variable definition statements, a plurality of completed work variable definition statements are combined into a work variable definition statement string.

  Next, the operation of the output processing statement generation means 107 will be described with reference to FIG. FIG. 5 is a flowchart showing the operation of the output processing statement generation means 107. 1 receives the output table item definition information and the output table processing definition information from the output item processing information acquisition unit 104 in 501 of FIG. Since generally one or more output tables can be specified, 502 is repeated for all output tables. In 503, a processing condition sentence is created from the processing condition information in the output table processing definition information received in 501. In 504, the processing type information in the output table processing definition information received in 501 is checked, and the subsequent processing branches depending on the value. Steps 505 to 507 are executed when the process type information is inserted, steps 508 to 509 are executed when the process type information is updated, and steps 510 to 511 are executed when the process type information is deleted. The

  In 505, the processing formula of each item in the output table processing definition information is processed to create an item calculation sentence. In 506, the output table item definition information is processed to create an insertion statement. In 507, the processing condition statement created in 503, the item calculation statement created in 505, and the insertion statement created in 506 are inserted into the corresponding insertion positions of the output processing skeleton to complete the output processing statement.

  In 508, the processing expression of each item in the output table process definition information and the output table item definition information are processed to create an update sentence. In 509, the processing condition statement created in 503, the update statement created in 508, and the output processing statement skeleton are inserted into corresponding insertion positions to complete the output processing statement.

  In 510, the output table item definition information is processed to create a deletion statement. In 511, the processing condition statement created in 503 and the deletion statement created in 510 are inserted into the corresponding insertion positions of the output processing statement skeleton to complete the output processing statement. If the output type is update or delete, nothing is inserted at the item calculation sentence insertion position of the output process sentence skeleton.

  In 512, all output processing sentence strings completed by repeating 502 are output and passed to the automatic program generation means 109 in FIG.

  FIG. 9A shows a configuration example of the output processing sentence skeleton. Referring to FIG. 9A, the output processing sentence skeleton 901 has a processing condition sentence insertion position 902, an item calculation sentence string insertion position 903, and an output sentence insertion position 904. In 507, 509, and 511 in FIG. 5, a processing condition sentence, an item calculation sentence, an insertion sentence / update sentence / deletion sentence are inserted at these insertion positions, respectively, and the output processing sentence is completed. Referring to FIG. 9A, the processing condition inserted at the processing condition sentence insertion position 902 is a conditional clause of the if sentence. Only when this condition is satisfied, it is inserted at the item calculation sentence insertion position 903. It can be seen that the output item calculation process and the output process to the output table inserted at the output sentence insertion position 904 are executed.

  FIGS. 9B to 9D show examples of templates in the PL / SQL language for inserted sentences, updated sentences, and deleted sentences inserted at the output sentence insertion position 904 in FIG. 9A. Referring to FIG. 9B, when the processing type is insertion, the output table name is extracted from the output table item definition information and assigned to << output table name >>, the item name is extracted, and ", ”To create a list of item names, assign it to << item name list >>, extract the name of the item, create a variable name in a certain way based on this, and use“, ” Connect to create a list of variable names and create an insert statement by substituting it into << variable name list >>.

  Referring to FIG. 9 (c), when the processing type is update, the name of the output table is extracted from the output table item definition information and assigned to << output table name >>, and the processing expression is calculated from the output table processing definition information. Take out, connect with "," to create an update statement list, assign it to << update statement list >>, extract the update condition from the output table processing definition information, and assign it to << update condition >> Create an update statement.

  Referring to FIG. 9D, when the processing type is deletion, the name of the output table is extracted from the output table item definition information and assigned to << output table name >>, and the deletion condition is set from the output table processing definition information. Create a delete statement by taking it out and assigning it to << deletion condition >>.

  Next, the operation of the automatic program synthesizing means 109 shown in FIG. 1 will be described with reference to FIGS. FIG. 10 is a diagram showing a configuration example of a program skeleton as already described.

  FIG. 6 is a flowchart showing the operation of the automatic program synthesis means 109. The program automatic synthesizing means 109 completes the program by inserting a program fragment created from the specification into the program fragment 108 at the position where the program fragment is inserted. Referring to FIG. 6, the program skeleton 108 of FIG. In 602, the program customization information, the cursor definition statement, the work variable definition statement sequence, and the output processing statement sequence are respectively converted into the program skeleton customization information acquisition unit 102, the cursor definition statement generation unit 105, and the work variable definition statement generation unit 106 in FIG. , Received from the output processing statement generation means 107. In step 603, the cursor definition statement received in 602 is inserted into the cursor definition statement insertion position of the program skeleton. In 604, the work variable definition statement string received in 602 is inserted at the work variable definition statement string insertion position of the program skeleton. In 605, the output processing statement string received in 602 is inserted into the output processing statement string insertion position of the program skeleton. In 606, the program name received in 602 is inserted into the program name insertion position of the program skeleton, and the program skeleton customization information is inserted into the insertion position indicated by the name. In the program skeleton of FIG. 10, “initial processing” and “end processing” correspond to this. However, as long as the description of the specification corresponds to the program skeleton, any number of insertion positions can be provided. In 607, all program fragments are inserted and a completed program is output.

  As described above, a program can be automatically created and output from a specification.

  In this description, the cursor definition skeleton, the work variable definition skeleton, the output processing statement skeleton, and the program skeleton are described according to the PL / SQL language. However, when a program of another programming language is automatically generated. Can generate a program of another programming language by preparing a skeleton according to the programming language to be generated.

  Further, in the processing flow charts of FIGS. 3, 4, 5, and 6, the portions described in parallel in the horizontal direction indicate that the processing order between them may be any order. For example, in FIG. 3, 302, 303, and 304 may be processed in this order, may be processed in the order of 304, 303, and 302, or may be processed together. It represents a good thing.

  As described above, in this embodiment, the program developer specifies the program name, the input table item definition, the select item definition, the output table item definition, the output table item calculation processing definition, and the select condition definition as individual specifications, programs A data processing program can be automatically generated simply by specifying customization information as a common processing specification. Therefore, it is possible to eliminate mistakes that have conventionally been mixed in the programming process, and it is possible to greatly improve the productivity of program development.

[Fourth embodiment]
Next, a fourth embodiment of the present invention will be described focusing on differences from the third embodiment.

  In the third embodiment, the specification 201 in FIG. 2 includes a program name 202, an input table item definition 203, a select item definition 204, an output table item definition 205, an output table item calculation process 206, a selection condition 207, and program customization information. It consisted of 208. Of these, the fourth embodiment is configured without the select item definition 204. That is, as shown in FIG. 11, program name 1102, input table item definition 1103, output table item definition 1104, output table processing definition 1105, select condition definition 1106 (above, individual specification), program customization information 1107 (common) Processing specifications).

  In the fourth embodiment, the specification input means 101 in FIG. 1 inputs specifications having the configuration as shown in FIG. 11, and program skeleton customization information acquisition means 102, cursor definition information acquisition means 103, and output item processing information acquisition. Passed to means 104. The cursor definition information acquisition unit 103 in FIG. 1 according to the fourth embodiment is a part corresponding to the input table item definition 1103, the output table processing definition 1105, and the selection condition definition 1106 from the specification information passed from the specification input unit 101. Is taken out and passed to the cursor definition sentence generation means 105.

  Next, detailed processing of the cursor definition statement generation means 105 in the fourth exemplary embodiment is shown in FIG. In 1201 of FIG. 12, input table item definition information, select condition definition information, and output table processing definition information are received from the cursor definition information acquisition unit 103 as cursor definition information. At 1202, select item definition information is created from input table item definition information and output table process definition information as shown in FIG. Subsequent processing is the same as the processing method of the cursor definition statement generation means 105 in the third embodiment shown in FIG.

  Referring to FIG. 13, first in 1301, the select table column and the select item column are made empty. In 1302, 1303 to 1306 are repeated for all items << item >> of all input tables << table >>. In 1303, whether the pair of << table >> and << item >>, that is, the item of the input table of interest, is used in the processing condition or processing expression or update / delete condition in the output table processing definition I'm testing it. If not used, move to the next repeating element. If used, in 1304, a set of << table >> and << item >> is added to the select item string. Then 1305 tests whether << table >> is in the select table column. If already, move to next repeating element. If not, << Table >> is added to the select table column in 1306. After repeating the above for all items in all input tables, in 1307, the select table column and the select item column are combined and output as select item definition information.

  As described above, the select item definition information in the third embodiment of the present invention can be automatically created. Therefore, in the processing from 1203 to 1207 in FIG. 12, a cursor definition sentence can be created by the same operation as that in FIG. 3 in the third embodiment.

  The operation of the other components is the same as that of the third embodiment.

  In the present embodiment, the user can automatically generate the same program as in the third embodiment without specifying select item information in the specification. There is an effect that the specification can be easily created.

[Fifth embodiment]
Next, a fifth embodiment of the present invention will be described focusing on differences from the third embodiment.

  FIG. 14 shows a configuration diagram according to the fifth embodiment of the present invention. Comparing FIG. 14 with FIG. 1, instead of the program skeleton 108 of FIG. 1 including one program skeleton, it has a program skeleton library 1411 that can hold any number of one or more types of program skeletons. A skeleton selection means 1412 is added.

  The specification 1401 is configured by combining program skeleton specifying information as compared with the specification 1 of FIG. The configuration of this specification is shown in FIG. Referring to FIG. 15, a specification 1501 includes a program name 1502, an input table item definition 1503, a select item definition 1504, an output table item definition 1505, an output table processing definition 1506, a select condition definition 1507 (and above, individual specifications), a program It consists of customization information 1509 (common processing specifications) and program skeleton identification information 1508. The program skeleton identification information 1508 may be included in either the individual specification or the common processing specification.

  The specification input unit 1403 in FIG. 14 inputs the specification having the configuration as shown in FIG. 15, and program skeleton identification information acquisition unit 1404, skeleton customization information acquisition unit 1405, cursor definition information acquisition unit 1406, output item processing Passed to information acquisition means 1407. The program skeleton specifying information acquisition unit 1404 in FIG. 14 takes out the program skeleton specifying information from the specification input by the specification input unit 1403 and passes it to the program skeleton selecting unit 1412. The program skeleton selecting unit 1412 takes out the program skeleton specified by using the program skeleton specifying information from the program skeleton library 1411 and passes this program skeleton to the program automatic synthesizing unit 1413. If the program cannot be identified using the program skeleton identification information, the user is notified as a specification error. The program automatic synthesizing unit 1413 includes the program name received from the program skeleton customization information acquisition unit 1405, the program customization information, and the cursor definition statement generation unit at the insertion position of the program fragment in the program skeleton received from the program skeleton selection unit 1412. The cursor definition statement received from 1408, the work variable definition statement sequence received from the work variable definition statement generation unit 1409, and the output processing statement sequence received from the output processing statement generation unit 1410 are the same as those in the third embodiment. Insert by the method, complete the program and output.

  The operation of the other components is the same as that of the third embodiment.

  In the present embodiment, various data processing programs can be automatically generated by preparing a plurality of program skeletons in which various processing forms are implemented. For example, a program based on a plurality of programming languages, a program based on different algorithms, and a program based on different abnormality processing methods can be automatically generated. Since a wider range of programs can be automatically generated, there is an effect that the application range is widened as compared with the third embodiment.

[Sixth embodiment]
Next, a sixth embodiment of the present invention will be described focusing on differences from the third embodiment.

  This embodiment is different from the third embodiment in that the specification is input by referring to the database definition information when the specification input unit 101 in FIG. 1 inputs the specification. The database definition information is the definition information of the database to be processed by the data processing program to be automatically generated. The database definition information is stored in a storage unit (not shown in FIG. 1) and can be referred to by the specification input means 101. It has become. FIG. 16 shows a flowchart of the processing of the specification input means 101 of FIG. 1 in the sixth embodiment.

  Referring to FIG. 16, the specification input means 101 of FIG. 1 first acquires only the names of the input table and output table used in the processing at 1601 and 1602. Next, in 1603 and 1604, the database definition information is searched from the names of the input table and the output table, respectively, and the item definition information of the corresponding input table and output table is acquired. Item definition information includes item names, types, comments on items, and the like. In 1605, the item definition information of the input table and output table acquired in 1603 and 1604 is presented on the screen. In 1606, specify the program name, select item definition, output table process definition, select condition definition, and program customization information by letting the specification input person use the input table and output table item definition information presented in 1605 on the screen. Let and get. Since the input table item definition and the output table item definition are retrieved from the database definition information by the specification input means 101, the user need not create them. When applied to the fourth embodiment, it is not necessary to create a select item definition.

  In addition, the item definition information of the input table and the output table is presented to the specification input person at 1605 and 1606 in FIG. 16, and the program name, the select item definition, the output table process definition, the select condition definition, the program are used. There are the following two methods (1) and (2) for specifying and acquiring the customization information.

(1) Input table and output table names, item names and types of each item are arranged along one axis of the matrix, select condition definition, program customization information, and output table name and type other than matrix When referring to the information of each item in the input table when specifying the select item definition, select condition definition, program customization information and output table processing definition in the specification, it is displayed in the corresponding cell of the matrix. By adding a symbol, the value of the input item can be referred to.
(2) The input table name, output table name, item name and type of each item are displayed on the screen in the form of a list, and the specification input user selects the selection item definition, selection condition definition, program customization information, and output table processing definition. When specifying the table name or item name in the display area on the screen by clicking with the mouse, the corresponding item name or table name is expanded to the specified area as character information. Specification can be entered without re-entering the item name.

  In the specification 1 of FIG. 1, the input table item definition 203 and the output table item definition 205 of FIG. 2 are the same information as the database table definition, and are already created when the database is created and stored in the database. It is normal. In this embodiment, the user does not specify the input table item definition and the output table item definition again as the processing specifications, but the user specifies only the names of the input table and the output table. Item definitions and output table item definitions are automatically retrieved from the information already stored in the database and obtained, thereby reducing the time and labor required for user specification descriptions and by manually specifying them. There is an effect that mistakes can be reduced.

[Seventh embodiment]
Next, a seventh embodiment of the present invention will be described focusing on differences from the third embodiment.

  In the present embodiment, the program skeleton 108 of FIG. 1 is inserted, for example, surrounded by special symbols so that the insertion trace can be clearly identified. The specification 1 includes generation program identification information indicating whether to generate a debugging program or a production program in either the individual specification or the common processing specification. This generated program identification information is input by the specification input means 101 together with other specification information, and passed to the automatic program synthesis means 109. The automatic program synthesizing means 109 switches between removing or leaving the debugging trace statement in the program skeleton 108 in accordance with the generated program identification information. In other words, when generating a production program, the debugging trace statement enclosed by special symbols in the program skeleton 108 is removed together with the special symbols, and when generating a debugging program, a program skeleton is generated. The debug trace sentence surrounded by special symbols in 108 is left as it is. At this time, special symbols may be removed, or may be left if there is no problem.

  According to the present embodiment, it is possible to switch between the generation of the debugging program and the generation of the production program by the generated program identification information in the specification 1.

[Eighth embodiment]
Next, an eighth embodiment of the present invention will be described with reference to FIG. Referring to FIG. 18, the eighth embodiment of the present invention includes a computer 1800 including a CPU, main memory, various input / output devices, and a recording medium 1803. The specification 1801 corresponds to a specification combining the individual specification 1A and the common processing specification 1B of the third embodiment, and the generation program 1802 corresponds to the generation program 2.

  A recording medium 1803 is a machine-readable recording medium such as a magnetic disk, a semiconductor memory, a CD-ROM, and the like. A data processing program automatic generation program is recorded on the recording medium 1803. The data processing program automatic generation program recorded in the recording medium 1803 is read into the computer 1800 when the computer 1800 is started up, etc., and by controlling the operation of the computer 1800, the specification input means 1804 on the computer 1800, Program skeleton customization information acquisition unit 1805, cursor definition information acquisition unit 1806, output item processing information acquisition unit 1807, cursor definition statement generation unit 1808, work variable definition statement generation unit 1809, output processing generation unit 1810, A program skeleton 1811 and automatic program synthesis means 1812 are realized. These functional units perform the same functions as those having the same names shown in FIG.

  In this description, the case where the present invention is applied to the third embodiment has been described. However, in the other embodiments as well, the corresponding data processing program automatic generation program may be recorded on the recording medium 1803. it can.

  As an application example of the present invention, it is possible to build a batch system automatic generation tool and improve the productivity, quality and maintainability of batch system development. In addition to the batch system, the same application can be made to a form system and a screen system program. In any case, there is a common process, and there are many overlapping parts in the common process.

DESCRIPTION OF SYMBOLS 1A ... Individual specification 1B ... Common process specification 2 ... Generation program 10 ... Data processing program automatic generation system 101 ... Specification input means 1011 ... Individual specification input part 1012 ... Common process specification input part 1013 ... Expanding part

Claims (7)

In a program that references data in a database table and inserts new data into the table, updates data in the table, or deletes data in the table, the pre-processing part, the iterative processing part, and the post-processing part A data processing program automatic generation system that automatically generates an entire program including a processing part based on a program skeleton and specifications,
A specification input means having a function of inputting individual specifications that are different specifications for each data processing program to be created and a function of inputting common processing specifications that are different specifications for each group to which the data processing program to be created belongs,
The program skeleton includes a pre-processing portion, a repetitive processing portion following the pre-processing portion, and a post-processing portion following the repetitive processing portion as a fixed portion program regardless of the specification, and varies depending on the specification. The program fragment insertion position includes the program name insertion position, the cursor definition statement insertion position, the work variable definition statement string insertion position, and the initial process insertion position in the preceding processing portion, and the output processing in the iteration processing portion It includes a sentence string insertion position and is configured to include an end processing position in the subsequent processing part.
The individual specification includes the program name to be given to the generated program, the input table name including the name of the input table and the name and type information of each item of the input table, and the input table item defined in the select statement. Select item definition including name, output table name and output table item definition including name and type information of each item of the output table, processing condition indicating conditions for processing each output table, insertion, update , The processing type that indicates the type of deletion, update when the processing type is update and deletion, update that indicates the conditions for deleting, and the deletion condition, and the value of each item when the processing type is insertion and update An output table processing definition including a processing expression and a selection condition definition including a condition for acquiring data from the input table are configured.
The common processing specification includes program customization information including other information for customizing the program skeleton,
and,
A program skeleton library stored in a storage device for storing a plurality of types of the program skeleton;
Program skeleton customization information acquisition means for extracting the program name from the individual specification input by the specification input means, and for extracting the program customization information from the common processing specification input by the specification input means;
Cursor definition information acquisition means for extracting an input table item definition, a selection item definition, and a selection condition definition from the individual specification input by the specification input means;
Output item processing information acquisition means for extracting output table item definitions and output table processing definitions from the individual specifications input by the specification input means;
A cursor definition statement generation unit that generates a cursor definition statement from information acquired by the cursor definition information acquisition unit, and extracts and generates only the item name specified in the select item definition from the input table item definition A select item string is generated in a format according to the syntax of the language, and only the name of the input table used in the select item definition is extracted from the input table specified in the input table item definition. Generate a select table column in a format according to the syntax, process the select condition definition into a format according to the syntax of the programming language to be generated, generate a select condition statement, select item column insertion position, input table column insertion position And the insertion position of the cursor definition skeleton that depends on the programming language to be generated, The resulting selection item column, and the cursor definition statement generating means for generating a cursor definition statement by inserting the select table column and the select condition,
A work variable definition statement generation unit that generates a work variable definition statement from an output table item definition acquired by the output item processing information acquisition unit and that corresponds to an output table whose processing type is insertion. For an output table that is an insert, generate a type definition statement that defines the record type of the output table, generate a variable definition statement that defines a work area variable with the defined type, and insert the type definition statement insertion position and variable A work variable definition statement generating means for generating a work variable definition statement by inserting the generated type definition statement and variable definition statement at a corresponding insertion position of a work variable definition skeleton having a definition statement insertion position;
From the output table item definition and output table processing definition acquired by the output item processing information acquisition means, if the processing type is insertion, an output processing statement including a processing condition statement, an item calculation statement, and an insertion statement is generated and processed. If the type is update, an output process statement including a processing condition statement and an update statement is generated. If the type is deletion, an output process statement including a processing condition statement and a deletion statement is generated. A means to generate a processing condition statement from the processing conditions of the output table processing definition, determine whether the processing type of the output table processing definition is insertion, update, or deletion. If the processing type is insertion, output An item calculation statement is generated from the processing expression of each item in the table processing definition, an insertion statement including the output table name, item name list, and variable name list is generated from the output table item definition, the processing condition statement insertion position, the item calculation statement Output processing with insertion position and output statement insertion position Generate the output processing statement by inserting the generated processing condition statement at the skeleton processing condition statement insertion position, the generated item calculation statement at the item calculation statement insertion position, and the generated insertion statement at the output statement insertion position. If the processing type is update, an update statement including an output table name, an update statement list, and an update condition is generated from the processing expression of each item of the output table processing definition and the output table item definition, and the output processing statement skeleton When the generated processing condition statement is inserted at the processing condition statement insertion position and the generated update statement is inserted at the output statement insertion position, respectively, and an output processing statement is generated. A deletion statement including a name and a deletion condition is generated, and the generated processing condition statement is inserted at the processing condition statement insertion position of the output processing statement skeleton, and the generated deletion statement is inserted at the output statement insertion position. An output processing statement generating means for generating Driven,
Program skeleton selection means for selecting one program skeleton designated by the user from the program skeleton library;
Of the data processing program, generated at the corresponding insertion position of the program skeleton selected by the program skeleton selection unit, the program name and program customization information acquired by the program skeleton customization information acquisition unit, and generated by the cursor definition statement generation unit The program is completed by inserting the cursor definition statement, the work variable definition statement generated by the work variable definition statement generating means, and the output processing statement generated by the output processing statement generating means, and the program is automatically synthesized. Means for automatically generating a data processing program. In a program that references data in a database table and inserts new data into the table, updates data in the table, or deletes data in the table, the pre-processing part, the iterative processing part, and the post-processing part A data processing program automatic generation system that automatically generates an entire program including a processing part based on a program skeleton and specifications,
A specification input means having a function of inputting individual specifications that are different specifications for each data processing program to be created and a function of inputting common processing specifications that are different specifications for each group to which the data processing program to be created belongs,
The program skeleton includes a pre-processing portion, a repetitive processing portion following the pre-processing portion, and a post-processing portion following the repetitive processing portion as a fixed portion program regardless of the specification, and varies depending on the specification. The program fragment insertion position includes the program name insertion position, the cursor definition statement insertion position, the work variable definition statement string insertion position, and the initial process insertion position in the preceding processing portion, and the output processing in the iteration processing portion It includes a sentence string insertion position and is configured to include an end processing position in the subsequent processing part.
The individual specifications are the program name to be given to the generated program, the input table name and the input table item definition including the name and type information of each item of the input table, the name of the output table and each of the output table Output table item definition that includes information on the item name and type, processing conditions that indicate the conditions for processing each output table, processing type that indicates whether to insert, update, or delete, and when the processing type is update or delete Get the data from the input table and the output table process definition that includes the update and delete conditions that indicate the conditions for updating and deleting, and the processing formula that calculates the value of each item when the process type is insert and update It includes a selection condition definition that includes conditions when
The common processing specification includes program customization information including other information for customizing the program skeleton,
and,
A program skeleton library stored in a storage device for storing a plurality of types of the program skeleton;
Program skeleton customization information acquisition means for extracting the program name from the individual specification input by the specification input means, and for extracting the program customization information from the common processing specification input by the specification input means;
Cursor definition information acquisition means for extracting an input table item definition, a selection condition definition, and an output table processing definition from the individual specifications input by the specification input means;
Output item processing information acquisition means for extracting output table item definitions and output table processing definitions from the individual specifications input by the specification input means;
A selection item definition is created from the input table item definition, the selection condition definition, and the output table processing definition acquired by the cursor definition information acquisition unit, and the selection item definition and the selection acquired by the cursor definition information acquisition unit are created. A cursor definition statement generating means for generating a cursor definition statement from a condition definition, generating a select item definition including the name of an input table item to be defined in a select statement from an input table item definition and an output table processing definition, Extracts only the item name specified in the select item definition from the input table item definition, generates a select item string in a format according to the syntax of the programming language to be generated, and creates the input table specified in the input table item definition. Of these, only the name of the input table used in the select item definition is extracted and selected in the format according to the syntax of the programming language to be generated. The table condition is generated, the select condition definition is processed into a format according to the syntax of the programming language to be generated, and the select condition statement is generated, and the select item string insertion position, the input table string insertion position and the select condition insertion position are set. A cursor definition statement generating means for generating a cursor definition statement by inserting the generated select item column, select table column and select condition at a corresponding insertion position of a cursor definition skeleton depending on a programming language to be generated;
A work variable definition statement generation unit that generates a work variable definition statement from an output table item definition acquired by the output item processing information acquisition unit and that corresponds to an output table whose processing type is insertion. For an output table that is an insert, generate a type definition statement that defines the record type of the output table, generate a variable definition statement that defines a work area variable with the defined type, and insert the type definition statement insertion position and variable A work variable definition statement generating means for generating a work variable definition statement by inserting the generated type definition statement and variable definition statement at a corresponding insertion position of a work variable definition skeleton having a definition statement insertion position;
From the output table item definition and output table processing definition acquired by the output item processing information acquisition means, if the processing type is insertion, an output processing statement including a processing condition statement, an item calculation statement, and an insertion statement is generated and processed. If the type is update, an output process statement including a processing condition statement and an update statement is generated. If the type is deletion, an output process statement including a processing condition statement and a deletion statement is generated. A means to generate a processing condition statement from the processing conditions of the output table processing definition, determine whether the processing type of the output table processing definition is insertion, update, or deletion. If the processing type is insertion, output An item calculation statement is generated from the processing expression of each item in the table processing definition, an insertion statement including the output table name, item name list, and variable name list is generated from the output table item definition, the processing condition statement insertion position, the item calculation statement Output processing with insertion position and output statement insertion position Generate the output processing statement by inserting the generated processing condition statement at the skeleton processing condition statement insertion position, the generated item calculation statement at the item calculation statement insertion position, and the generated insertion statement at the output statement insertion position. If the processing type is update, an update statement including an output table name, an update statement list, and an update condition is generated from the processing expression of each item of the output table processing definition and the output table item definition, and the output processing statement skeleton When the generated processing condition statement is inserted at the processing condition statement insertion position and the generated update statement is inserted at the output statement insertion position, respectively, and an output processing statement is generated. A deletion statement including a name and a deletion condition is generated, and the generated processing condition statement is inserted at the processing condition statement insertion position of the output processing statement skeleton, and the generated deletion statement is inserted at the output statement insertion position. An output processing statement generating means for generating Driven,
Program skeleton selection means for selecting one program skeleton designated by the user from the program skeleton library;
Of the data processing program, generated at the corresponding insertion position of the program skeleton selected by the program skeleton selection unit, the program name and program customization information acquired by the program skeleton customization information acquisition unit, and generated by the cursor definition statement generation unit The program is completed by inserting the cursor definition statement, the work variable definition statement generated by the work variable definition statement generating means, and the output processing statement generated by the output processing statement generating means, and the program is automatically synthesized. Means for automatically generating a data processing program. The common process specification includes a common process description to which a keyword is assigned, and a plurality of process descriptions in which the keyword is inserted at a position where the common process description is inserted.
3. The data processing program automatic generation system according to claim 1, wherein the specification input unit includes an expansion unit that expands the common process description at an insertion position of the keyword in the plurality of process descriptions. Specification input means, program skeleton customization information acquisition means, cursor definition information acquisition means, output item processing information acquisition means, cursor definition statement generation means, work variable definition statement generation means, output processing statement generation means, program skeleton selection means, and program automatic In a program comprising a synthesis means, referring to data in a database table, inserting new data into the table, updating data in the table, or deleting data in the table And a data processing program automatic generation system that automatically generates an entire program including a repetitive processing portion and a subsequent processing portion based on a program skeleton and specifications,
The program skeleton includes a pre-processing portion, a repetitive processing portion following the pre-processing portion, and a post-processing portion following the repetitive processing portion as a fixed portion program regardless of the specification, and varies depending on the specification. The program fragment insertion position includes the program name insertion position, the cursor definition statement insertion position, the work variable definition statement string insertion position, and the initial process insertion position in the preceding processing portion, and the output processing in the iteration processing portion It includes a sentence string insertion position and is configured to include an end processing position in the subsequent processing part.
The specification input means inputs individual specifications that are different specifications for each data processing program to be created, and common processing specifications that are different specifications for each group to which the data processing program to be created belongs,
The individual specification includes the program name to be given to the generated program, the input table name including the name of the input table and the name and type information of each item of the input table, and the input table item defined in the select statement. Select item definition including name, output table name and output table item definition including name and type information of each item of the output table, processing condition indicating conditions for processing each output table, insertion, update , The processing type that indicates the type of deletion, update when the processing type is update and deletion, update that indicates the conditions for deleting, and the deletion condition, and the value of each item when the processing type is insertion and update An output table processing definition including a processing expression and a selection condition definition including a condition for acquiring data from the input table are configured.
The common processing specification includes program customization information including other information for customizing the program skeleton ,
Previous SL program skeleton customize information obtaining means retrieves the program name from the individual specification input by the specification input means, taking out the program customization information from the common process specification input by the specification input means,
The cursor definition information acquisition unit extracts an input table item definition, a selection item definition, and a selection condition definition from the individual specification input by the specification input unit,
The output item processing information acquisition unit takes out the output table item definition and the output table processing definition from the individual specification input by the specification input unit,
The cursor definition statement generation means extracts only the item name specified in the select item definition from the input table item definition, generates a select item string in a format according to the syntax of the programming language to be generated, and inputs table item definition Extracts only the name of the input table used in the select item definition from the input table specified in, generates a select table column in a format according to the syntax of the programming language to be generated, and generates a select condition definition Generate a select condition statement by processing it into a format that conforms to the syntax of the programming language to be used. Insert the generated select item column, select table column, and select condition at the corresponding insertion position and place the cursor To generate a Yoshifumi,
The work variable definition statement generation unit generates a work variable definition statement from an output table item definition acquired by the output item processing information acquisition unit, corresponding to an output table whose processing type is insertion, and the generation Then, for an output table whose processing type is insert, generate a type definition statement that defines the record type of the output table, generate a variable definition statement that defines a work area variable with the defined type, and type definition statement Insert the generated type definition statement and variable definition statement at the corresponding insertion position of the work variable definition skeleton having the insertion position and the variable definition statement insertion position, and generate a work variable definition statement.
The output processing statement generation unit includes a processing condition statement, an item calculation statement, and an insertion statement when the processing type is insertion from the output table item definition and the output table processing definition acquired by the output item processing information acquisition unit. An output processing statement is generated. If the processing type is update, an output processing statement including a processing condition statement and an update statement is generated. If the processing type is deletion, an output processing including a processing condition statement and a deletion statement is generated. A statement is generated, and in the generation, a processing condition statement is generated from the processing conditions of the output table processing definition, it is determined whether the processing type of the output table processing definition is insertion, update, or deletion, and the processing type is inserted In the case of, an item calculation statement is generated from the processing expression of each item of the output table processing definition, an insertion statement including the output table name, item name list, and variable name list is generated from the output table item definition, and the processing condition statement insertion position , Item calculation statement insertion position and output statement insertion position The output processing statement skeleton inserts the generated processing condition statement at the processing statement insertion position, inserts the generated item calculation statement at the item calculation statement insertion position, and outputs the generated insertion statement at the output statement insertion position. If a processing statement is generated and the processing type is update, an update statement including an output table name, an update statement list, and an update condition is generated from the processing expression of each item of the output table processing definition and the output table item definition, and the output When the generated processing condition statement is inserted at the processing statement insertion position of the processing statement skeleton and the generated update statement is inserted at the output statement insertion position, an output processing statement is generated. A delete statement including an output table name and a delete condition is generated from the definition, the generated process condition statement at the processing condition statement insertion position of the output processing statement skeleton, and the generated delete statement at the output statement insertion position, respectively. Input to generate the output processing statement,
The program skeleton selection means selects one program skeleton designated by a user from a program skeleton library stored in a storage device for storing a plurality of types of the program skeleton,
The program automatic synthesizing means includes a program name and program customization information acquired by the program skeleton customization information acquisition means at a corresponding insertion position of the program skeleton selected by the program skeleton selection means in the data processing program, The program is completed by inserting the cursor definition statement generated by the cursor definition statement generation unit, the work variable definition statement generated by the work variable definition statement generation unit, and the output processing statement generated by the output processing statement generation unit. A method for automatically generating a data processing program to be output. Specification input means, program skeleton customization information acquisition means, cursor definition information acquisition means, output item processing information acquisition means, cursor definition statement generation means, work variable definition statement generation means, output processing statement generation means, program skeleton selection means, and program automatic In a program comprising a synthesis means, referring to data in a database table, inserting new data into the table, updating data in the table, or deleting data in the table A data processing program automatic generation method executed by a data processing program automatic generation system that automatically generates an entire program including a repetitive processing portion and a subsequent processing portion based on a program skeleton and specifications,
The program skeleton includes a pre-processing portion, a repetitive processing portion following the pre-processing portion, and a post-processing portion following the repetitive processing portion as a fixed portion program regardless of the specification, and varies depending on the specification. The program fragment insertion position includes the program name insertion position, the cursor definition statement insertion position, the work variable definition statement string insertion position, and the initial process insertion position in the preceding processing portion, and the output processing in the iteration processing portion It includes a sentence string insertion position and is configured to include an end processing position in the subsequent processing part.
The specification input means inputs individual specifications that are different specifications for each data processing program to be created, and common processing specifications that are different specifications for each group to which the data processing program to be created belongs,
The individual specifications are the program name to be given to the generated program, the input table name and the input table item definition including the name and type information of each item of the input table, the name of the output table and each of the output table Output table item definition that includes information on the item name and type, processing conditions that indicate the conditions for processing each output table, processing type that indicates whether to insert, update, or delete, and when the processing type is update or delete Get the data from the input table and the output table process definition that includes the update and delete conditions that indicate the conditions for updating and deleting, and the processing formula that calculates the value of each item when the process type is insert and update It includes a selection condition definition that includes conditions when
The common processing specification includes program customization information including other information for customizing the program skeleton ,
Previous SL program skeleton customize information obtaining means retrieves the program name from the individual specification input by the specification input means, taking out the program customization information from the common process specification input by the specification input means,
The cursor definition information acquisition unit takes out an input table item definition, a selection condition definition, and an output table processing definition from the individual specification input by the specification input unit,
The output item processing information acquisition unit takes out the output table item definition and the output table processing definition from the individual specification input by the specification input unit,
The cursor definition statement generating unit creates a select item definition from the input table item definition, the select condition definition, and the output table processing definition acquired by the cursor definition information acquiring unit, and the generated select item definition and the cursor definition The cursor definition statement is generated from the selection condition definition acquired by the information acquisition means, and in the generation, the selection item definition including the name of the input table item to be defined in the select statement from the input table item definition and the output table processing definition Is generated, only the item name specified in the select item definition is extracted from the input table item definition, the select item string is generated in a format according to the syntax of the programming language to be generated, and specified in the input table item definition. Extract the name of the input table used in the select item definition from the input table and follow the syntax of the programming language to be generated. Generate a select table column in the format, process the select condition definition into a format according to the syntax of the programming language to be generated, generate a select condition statement, select item column insertion position, input table column insertion position, and select condition insertion A cursor definition statement is generated by inserting the generated select item column, select table column and select condition at the corresponding insertion position of the cursor definition skeleton having a position and depending on the programming language to be generated,
The work variable definition statement generation unit generates a work variable definition statement from an output table item definition acquired by the output item processing information acquisition unit, corresponding to an output table whose processing type is insertion, and the generation Then, for an output table whose processing type is insert, generate a type definition statement that defines the record type of the output table, generate a variable definition statement that defines a work area variable with the defined type, and type definition statement Insert the generated type definition statement and variable definition statement at the corresponding insertion position of the work variable definition skeleton having the insertion position and the variable definition statement insertion position, and generate a work variable definition statement.
The output processing statement generation unit includes a processing condition statement, an item calculation statement, and an insertion statement when the processing type is insertion from the output table item definition and the output table processing definition acquired by the output item processing information acquisition unit. An output processing statement is generated. If the processing type is update, an output processing statement including a processing condition statement and an update statement is generated. If the processing type is deletion, an output processing including a processing condition statement and a deletion statement is generated. A statement is generated, and in the generation, a processing condition statement is generated from the processing conditions of the output table processing definition, it is determined whether the processing type of the output table processing definition is insertion, update, or deletion, and the processing type is inserted In the case of, an item calculation statement is generated from the processing expression of each item of the output table processing definition, an insertion statement including the output table name, item name list, and variable name list is generated from the output table item definition, and the processing condition statement insertion position , Item calculation statement insertion position and output statement insertion position The output processing statement skeleton inserts the generated processing condition statement at the processing statement insertion position, inserts the generated item calculation statement at the item calculation statement insertion position, and outputs the generated insertion statement at the output statement insertion position. If a processing statement is generated and the processing type is update, an update statement including an output table name, an update statement list, and an update condition is generated from the processing expression of each item of the output table processing definition and the output table item definition, and the output When the generated processing condition statement is inserted at the processing statement insertion position of the processing statement skeleton and the generated update statement is inserted at the output statement insertion position, an output processing statement is generated. A delete statement including an output table name and a delete condition is generated from the definition, the generated process condition statement at the processing condition statement insertion position of the output processing statement skeleton, and the generated delete statement at the output statement insertion position, respectively. Input to generate the output processing statement,
The program skeleton selection means selects one program skeleton designated by a user from a program skeleton library stored in a storage device for storing a plurality of types of the program skeleton,
The program automatic synthesizing means includes a program name and program customization information acquired by the program skeleton customization information acquisition means at a corresponding insertion position of the program skeleton selected by the program skeleton selection means in the data processing program, The program is completed by inserting the cursor definition statement generated by the cursor definition statement generation unit, the work variable definition statement generated by the work variable definition statement generation unit, and the output processing statement generated by the output processing statement generation unit. A method for automatically generating a data processing program to be output. In a program that references data in a database table and inserts new data into the table, updates data in the table, or deletes data in the table, the pre-processing part, the iterative processing part, and the post-processing part A computer that automatically generates the entire program with processing parts based on the program skeleton and specifications,
Function as a specification input means having a function of inputting individual specifications which are different specifications for each data processing program to be created and a function of inputting common processing specifications which are different specifications for each group to which the data processing program to be created belongs,
The program skeleton includes a pre-processing portion, a repetitive processing portion following the pre-processing portion, and a post-processing portion following the repetitive processing portion as a fixed portion program regardless of the specification, and varies depending on the specification. The program fragment insertion position includes the program name insertion position, the cursor definition statement insertion position, the work variable definition statement string insertion position, and the initial process insertion position in the preceding processing portion, and the output processing in the iteration processing portion It includes a sentence string insertion position and is configured to include an end processing position in the subsequent processing part.
The individual specification includes the program name to be given to the generated program, the input table name including the name of the input table and the name and type information of each item of the input table, and the input table item defined in the select statement. Select item definition including name, output table name and output table item definition including name and type information of each item of the output table, processing condition indicating conditions for processing each output table, insertion, update , The processing type that indicates the type of deletion, update when the processing type is update and deletion, update that indicates the conditions for deleting, and the deletion condition, and the value of each item when the processing type is insertion and update An output table processing definition including a processing expression and a selection condition definition including a condition for acquiring data from the input table are configured.
The common processing specification includes program customization information including other information for customizing the program skeleton,
And the computer
Program skeleton customization information acquisition means for extracting the program name from the individual specification input by the specification input means, and for extracting the program customization information from the common processing specification input by the specification input means;
Cursor definition information acquisition means for extracting an input table item definition, a selection item definition, and a selection condition definition from the individual specification input by the specification input means;
Output item processing information acquisition means for extracting output table item definitions and output table processing definitions from the individual specifications input by the specification input means;
A cursor definition statement generation unit that generates a cursor definition statement from information acquired by the cursor definition information acquisition unit, and extracts and generates only the item name specified in the select item definition from the input table item definition A select item string is generated in a format according to the syntax of the language, and only the name of the input table used in the select item definition is extracted from the input table specified in the input table item definition. Generate a select table column in a format according to the syntax, process the select condition definition into a format according to the syntax of the programming language to be generated, generate a select condition statement, select item column insertion position, input table column insertion position And the insertion position of the cursor definition skeleton that depends on the programming language to be generated, The resulting selection item column, and the cursor definition statement generating means for generating a cursor definition statement by inserting the select table column and the select condition,
A work variable definition statement generation unit that generates a work variable definition statement from an output table item definition acquired by the output item processing information acquisition unit and that corresponds to an output table whose processing type is insertion. For an output table that is an insert, generate a type definition statement that defines the record type of the output table, generate a variable definition statement that defines a work area variable with the defined type, and insert the type definition statement insertion position and variable A work variable definition statement generating means for generating a work variable definition statement by inserting the generated type definition statement and variable definition statement at a corresponding insertion position of a work variable definition skeleton having a definition statement insertion position;
From the output table item definition and output table processing definition acquired by the output item processing information acquisition means, if the processing type is insertion, an output processing statement including a processing condition statement, an item calculation statement, and an insertion statement is generated and processed. If the type is update, an output process statement including a processing condition statement and an update statement is generated. If the type is deletion, an output process statement including a processing condition statement and a deletion statement is generated. A means to generate a processing condition statement from the processing conditions of the output table processing definition, determine whether the processing type of the output table processing definition is insertion, update, or deletion. If the processing type is insertion, output An item calculation statement is generated from the processing expression of each item in the table processing definition, an insertion statement including the output table name, item name list, and variable name list is generated from the output table item definition, the processing condition statement insertion position, the item calculation statement Output processing with insertion position and output statement insertion position Generate the output processing statement by inserting the generated processing condition statement at the skeleton processing condition statement insertion position, the generated item calculation statement at the item calculation statement insertion position, and the generated insertion statement at the output statement insertion position. If the processing type is update, an update statement including an output table name, an update statement list, and an update condition is generated from the processing expression of each item of the output table processing definition and the output table item definition, and the output processing statement skeleton When the generated processing condition statement is inserted at the processing condition statement insertion position and the generated update statement is inserted at the output statement insertion position, respectively, and an output processing statement is generated. A deletion statement including a name and a deletion condition is generated, and the generated processing condition statement is inserted at the processing condition statement insertion position of the output processing statement skeleton, and the generated deletion statement is inserted at the output statement insertion position. An output processing statement generating means for generating Driven,
Program skeleton selection means for selecting one program skeleton designated by a user from a program skeleton library stored in a storage device for storing a plurality of types of the program skeleton,
Of the data processing program, generated at the corresponding insertion position of the program skeleton selected by the program skeleton selection unit, the program name and program customization information acquired by the program skeleton customization information acquisition unit, and generated by the cursor definition statement generation unit The program is completed by inserting the cursor definition statement, the work variable definition statement generated by the work variable definition statement generating means, and the output processing statement generated by the output processing statement generating means, and the program is automatically synthesized. Program to function as a means. In a program that references data in a database table and inserts new data into the table, updates data in the table, or deletes data in the table, the pre-processing part, the iterative processing part, and the post-processing part A computer that automatically generates the entire program with processing parts based on the program skeleton and specifications,
Function as a specification input means having a function of inputting individual specifications which are different specifications for each data processing program to be created and a function of inputting common processing specifications which are different specifications for each group to which the data processing program to be created belongs,
The program skeleton includes a pre-processing portion, a repetitive processing portion following the pre-processing portion, and a post-processing portion following the repetitive processing portion as a fixed portion program regardless of the specification, and varies depending on the specification. The program fragment insertion position includes the program name insertion position, the cursor definition statement insertion position, the work variable definition statement string insertion position, and the initial process insertion position in the preceding processing portion, and the output processing in the iteration processing portion It includes a sentence string insertion position and is configured to include an end processing position in the subsequent processing part.
The individual specifications are the program name to be given to the generated program, the input table name and the input table item definition including the name and type information of each item of the input table, the name of the output table and each of the output table Output table item definition that includes information on the item name and type, processing conditions that indicate the conditions for processing each output table, processing type that indicates whether to insert, update, or delete, and when the processing type is update or delete Get the data from the input table and the output table process definition that includes the update and delete conditions that indicate the conditions for updating and deleting, and the processing formula that calculates the value of each item when the process type is insert and update It includes a selection condition definition that includes conditions when
The common processing specification includes program customization information including other information for customizing the program skeleton,
And the computer
Program skeleton customization information acquisition means for extracting the program name from the individual specification input by the specification input means, and for extracting the program customization information from the common processing specification input by the specification input means;
Cursor definition information acquisition means for extracting an input table item definition, a selection condition definition, and an output table processing definition from the individual specifications input by the specification input means;
Output item processing information acquisition means for extracting output table item definitions and output table processing definitions from the individual specifications input by the specification input means;
A selection item definition is created from the input table item definition, the selection condition definition, and the output table processing definition acquired by the cursor definition information acquisition unit, and the selection item definition and the selection acquired by the cursor definition information acquisition unit are created. A cursor definition statement generating means for generating a cursor definition statement from a condition definition, generating a select item definition including the name of an input table item to be defined in a select statement from an input table item definition and an output table processing definition, Extracts only the item name specified in the select item definition from the input table item definition, generates a select item string in a format according to the syntax of the programming language to be generated, and creates the input table specified in the input table item definition. Of these, only the name of the input table used in the select item definition is extracted and selected in the format according to the syntax of the programming language to be generated. The table condition is generated, the select condition definition is processed into a format according to the syntax of the programming language to be generated, and the select condition statement is generated, and the select item string insertion position, the input table string insertion position and the select condition insertion position are set. A cursor definition statement generating means for generating a cursor definition statement by inserting the generated select item column, select table column and select condition at a corresponding insertion position of a cursor definition skeleton depending on a programming language to be generated;
A work variable definition statement generation unit that generates a work variable definition statement from an output table item definition acquired by the output item processing information acquisition unit and that corresponds to an output table whose processing type is insertion. For an output table that is an insert, generate a type definition statement that defines the record type of the output table, generate a variable definition statement that defines a work area variable with the defined type, and insert the type definition statement insertion position and variable A work variable definition statement generating means for generating a work variable definition statement by inserting the generated type definition statement and variable definition statement at a corresponding insertion position of a work variable definition skeleton having a definition statement insertion position;
From the output table item definition and output table processing definition acquired by the output item processing information acquisition means, if the processing type is insertion, an output processing statement including a processing condition statement, an item calculation statement, and an insertion statement is generated and processed. If the type is update, an output process statement including a processing condition statement and an update statement is generated. If the type is deletion, an output process statement including a processing condition statement and a deletion statement is generated. A means to generate a processing condition statement from the processing conditions of the output table processing definition, determine whether the processing type of the output table processing definition is insertion, update, or deletion. If the processing type is insertion, output An item calculation statement is generated from the processing expression of each item in the table processing definition, an insertion statement including the output table name, item name list, and variable name list is generated from the output table item definition, the processing condition statement insertion position, the item calculation statement Output processing with insertion position and output statement insertion position Generate the output processing statement by inserting the generated processing condition statement at the skeleton processing condition statement insertion position, the generated item calculation statement at the item calculation statement insertion position, and the generated insertion statement at the output statement insertion position. If the processing type is update, an update statement including an output table name, an update statement list, and an update condition is generated from the processing expression of each item of the output table processing definition and the output table item definition, and the output processing statement skeleton When the generated processing condition statement is inserted at the processing condition statement insertion position and the generated update statement is inserted at the output statement insertion position, respectively, and an output processing statement is generated. A deletion statement including a name and a deletion condition is generated, and the generated processing condition statement is inserted at the processing condition statement insertion position of the output processing statement skeleton, and the generated deletion statement is inserted at the output statement insertion position. An output processing statement generating means for generating Driven,
Program skeleton selection means for selecting one program skeleton designated by a user from a program skeleton library stored in a storage device for storing a plurality of types of the program skeleton,
Of the data processing program, generated at the corresponding insertion position of the program skeleton selected by the program skeleton selection unit, the program name and program customization information acquired by the program skeleton customization information acquisition unit, and generated by the cursor definition statement generation unit The program is completed by inserting the cursor definition statement, the work variable definition statement generated by the work variable definition statement generating means, and the output processing statement generated by the output processing statement generating means, and the program is automatically synthesized. Program to function as a means.

Images