JP4797378B2 - Data processing program automatic generation system, data processing program automatic generation method, and data processing program automatic generation program - Google Patents

Description

  The present invention relates to a data processing program automatic generation system, a data processing program automatic generation method, and a data processing program automatic generation program, and in particular, a data processing program for acquiring data from a database to a variable and updating data from a variable to a database. The present invention relates to a data processing program automatic generation system, a data processing program automatic generation method, and a data processing program automatic generation program.

  An example of a conventional automatic data processing program generation system is described in Patent Document 1. The data processing program automatic generation system described in Patent Document 1 performs data processing with reference to data in a database table constructed on the information processing system, and stores the processing result in the database table again. The present invention relates to a system that automatically generates a data processing program that updates or deletes data in a database table based on a result.

JP 2001-60150 A ([0017] to [0045], FIGS. 1 to 10)

  The data processing program generated by the system described in Patent Document 1 described above has the following problems because the data type and format are not considered in the data processing.

  In other words, in the data acquisition process that acquires data and stores it in a variable, or in the data update process that updates data with the contents of a variable, if there is a difference in type or format between the database and the variable, the type and format are matched. This means that a data conversion process is required.

  For example, data representing a date may be stored in a date format on the database, but may need to be handled as a character string as a variable. In such a case, when data is acquired from the database and stored in a variable, data conversion processing is required to convert the data from the date type to the character string type. When updating the database data with the value of the variable Requires a data conversion process to convert from a character string type to a date type.

  If such data conversion processing is described by the user himself / herself, there is a possibility that accurate data conversion processing cannot be described due to a description mistake or the like.

  An object of the present invention is to make a data processing program that performs data acquisition processing for acquiring data from a database and storing the data in a variable, or data updating processing for updating data in the database with the value of the variable, matching the data type and format. An object is to provide a data processing program automatic generation system, a data processing program automatic generation method, and a data processing program automatic generation program that are automatically generated including data conversion processing.

The data processing program automatic generation system of the present invention includes:
Specification input means for inputting the specifications of the data acquisition program stored in the specification storage unit;
A data conversion processing statement generation rule storage unit that holds data conversion processing statement generation rules for generating data conversion processing statements according to the specifications;
Data conversion processing statement generation means for generating a data conversion processing statement based on the data conversion processing statement generation rules according to the specifications;
A cursor definition statement generating means for generating a cursor definition statement for defining a cursor based on the data conversion process statement generated by the data conversion process statement generating means;
A data acquisition statement generation means for generating a data acquisition statement for acquiring data from the database;
A program skeleton storage unit in which the contents of the program template are stored in advance;
Inserting the cursor definition statement received from the cursor definition statement generation unit and the data acquisition statement received from the data acquisition statement generation unit into the contents of the program skeleton storage unit to generate a data acquisition program and generating program storage unit And a program synthesizing means.

In addition, the data processing program automatic generation method of the present invention generates a data conversion processing statement according to the specification of the data acquisition program,
Generate a data conversion processing statement based on the data conversion processing statement generation rules according to the specifications,
Generate a cursor definition statement that defines a cursor based on the data conversion processing statement,
Generate a data acquisition statement that acquires data from the database,
The data acquisition program is generated by inserting the cursor definition statement and the data acquisition statement into the contents of a program skeleton in which the contents of a program template are stored in advance.

Furthermore, the data processing program automatic generation program of the present invention is stored in a computer.
Generate a data conversion processing statement according to the specifications of the data acquisition program,
Generate a data conversion processing statement based on the data conversion processing statement generation rules according to the specifications,
Generate a cursor definition statement that defines a cursor based on the data conversion processing statement,
Generate a data acquisition statement that acquires data from the database using the cursor,
The cursor definition statement and the data acquisition statement are inserted into the contents of the program skeleton in which the contents of the program template are stored in advance, thereby generating the data acquisition program.

Furthermore, the data processing program automatic generation system of the present invention includes specification input means for inputting the specifications of the data acquisition program stored in the specification storage unit,
A data conversion processing statement generation rule storage unit that holds data conversion processing statement generation rules for generating data conversion processing statements according to the specifications;
Data conversion processing statement generation means for generating a data conversion processing statement based on the data conversion processing statement generation rules according to the specifications;
Output processing statement generating means for generating an output processing statement for outputting data based on the data conversion processing statement generated by the data conversion processing statement generating means;
A program skeleton storage unit in which the contents of the program template are stored in advance;
Program synthesizing means for inserting the output processing statement received from the output processing statement generating means into the contents of the program skeleton storage unit, generating a data acquisition program, and holding it in the generated program storage unit;

Furthermore, the data processing program automatic generation method of the present invention generates a data conversion processing statement according to the specification of the data acquisition program,
Generate a data conversion processing statement based on the data conversion processing statement generation rules according to the specifications,
Generate an output processing statement for outputting data based on the data conversion processing statement,
The data processing program is generated by inserting the output processing statement into the contents of a program skeleton in which the contents of a program template are stored in advance.

Furthermore, the data processing program automatic generation program of the present invention is stored in a computer.
Generate a data conversion processing statement according to the specifications of the data acquisition program,
Generate a data conversion processing statement based on the data conversion processing statement generation rules according to the specifications,
Generate an output processing statement for outputting data based on the data conversion processing statement,
The output processing statement is inserted into the contents of the program skeleton in which the contents of the program template are stored in advance, and the data acquisition program is generated.

  The present invention has an effect that the quality of a program can be stabilized in a project that requires development of a large number of data processing programs for acquiring data from a database. The reason is that by automatically generating a data conversion processing statement for data conversion, it is possible to implement a uniform data conversion processing statement according to the convention.

  In addition, the present invention has an effect that a problem does not occur even if a rule for implementing a data conversion processing statement for data conversion is changed during a project. The reason for this is that the rules for automatically generating data conversion processing statements are held in an easy format called data conversion processing statement generation rules, so it is easy to change and the generated program conforms to the changed rules. It is because it can be made.

  Furthermore, the present invention has the effect of reducing the man-hours for mounting the data conversion processing statement at the time of data acquisition. The reason is that the data conversion processing statement at the time of data acquisition is automatically generated, so that the user of this system does not need to write the data conversion processing statement. This is because it is necessary to define a data conversion processing statement generation rule in accordance with the project rules, but this is easy and the load for application is considered to be small.

  Next, embodiments of the present invention will be described in detail with reference to the drawings.

  Referring to FIG. 1 showing the configuration of the first embodiment of the present invention, the data processing program automatic generation system 2 of this embodiment uses a specification stored in the specification storage unit 1 as input information, and inputs a specification. Means 21, data conversion processing statement generation rule storage unit 22, data conversion processing statement generation unit 23, cursor definition statement generation unit 24, data acquisition statement generation unit 25, program skeleton storage unit 26, and program synthesis unit 27, and generates a generation program and outputs it to the generation program storage unit 3.

  The specification storage unit 1 holds data acquisition source table specifications, data acquisition destination variable specifications, and selection condition specifications as specifications to be generated in the present system, for example, as shown in FIG.

  The data acquisition source table specification includes a table name that is a name of a base table from which data is acquired, item names that are item names included in the table, and type information of these items.

  The data acquisition destination variable specification includes information on a variable name that is a name of the data acquisition destination variable, a type of the variable, and a corresponding item name that is a data acquisition source corresponding to the variable.

  For example, referring to the row 0221 in FIG. 2, the type of the item whose table name is the product master and whose item name is the product code is the 'char (9)' type. Also, referring to the row 0221, the variable whose variable name is the selected product category is the 'char (3)' type, and the corresponding item name is the product master. Indicates a product code.

  The specification input unit 21 inputs the specification stored in the specification storage unit 1 and passes it to the data conversion processing statement generation unit 23 and the data acquisition statement generation unit 25.

  The data conversion processing statement generation rule storage unit 22 holds in advance a data conversion processing statement generation rule as shown in FIG. 3, for example, as a data conversion processing specification automatically generated by this system.

  The data conversion processing statement generation rule includes a variable name indicating the name of a variable to which the data conversion processing statement generation rule is applied, a variable type indicating the type, a corresponding item name to which the data conversion processing statement generation rule is applied, and its type. It consists of the corresponding item type shown and the data conversion process to be generated.

  Here, the variable name and the corresponding item name may contain the description '$ {<numeric value}}' (where <numeric value> is an arbitrary number). In such a case, ′ $ {< This means that any character string can be entered in the numerical value>} ′ part. However, when there are a plurality of items having the same numerical value, it means the same character string.

  For example, referring to the row 031 in FIG. 3, when the variable name is' $ {1} product category 'and the corresponding item name is' $ {2} product code', 'SUBSTRB ($ { 2} means a data conversion processing statement generation rule that generates a data conversion processing statement of product code, 1,3) ′. Also, referring to the line 032, when the variable type is' char (8) ', the corresponding item name is' $ {1}', and the corresponding item type is' date ',' TO_CHAR ($ It means a data conversion processing statement generation rule for generating a data conversion processing statement {1}, ′ YYYYMMDD ′) ′.

  The data conversion processing statement generation unit 23 receives the specification from the specification input unit 21, generates a data conversion processing statement based on the information stored in the data conversion processing statement generation rule storage unit 22, adds it to the specification, and defines the cursor definition. Delivered to the sentence generator 24.

  The cursor definition statement generation unit 24 receives the specification including the data conversion process from the data conversion process statement generation unit 23, generates a cursor definition statement, and passes it to the program synthesis unit 27.

  The data acquisition statement generation unit 25 receives the specification from the specification input unit 21, generates a data acquisition statement, and transfers it to the program synthesis unit 27.

  The program skeleton storage unit 26 is a template of a program to be output regardless of the specifications, and contents as shown in FIG. 11 are stored in advance. In this embodiment, a data processing program that acquires data using a cursor from a database and stores the data in an existing variable is a generation target. In such a program, a cursor is defined. Common contents can always be used for portions other than the cursor definition statement and the data acquisition statement that acquires data using the cursor. The program skeleton storage unit 26 holds the common part, and the cursor definition sentence and the data acquisition sentence only indicate where to embed (for example, “<< cursor definition sentence insertion location in FIG. 11> > 'And' << data acquisition sentence insertion location >> ').

  The program synthesis means 27 inserts the cursor definition sentence received from the cursor definition sentence generation means 24 and the data acquisition sentence received from the data acquisition sentence generation means 25 into the contents of the program skeleton storage unit 26, and the generation that is the output of this system A program is generated and stored in the generated program storage unit 3.

  Next, the operation of the first embodiment will be described in detail with reference to the flowchart of FIG. In this embodiment, a specification expressed in the format shown in FIG. 2 is input, and a data processing program FIG. 12 for obtaining data from a database described in the PL / SQL language is output.

  First, specification input is performed by the specification input means 21 (step 051 in FIG. 5). In this step, the specification shown in FIG. 2 stored in the specification storage unit 1 is read into the system and transferred to the data conversion processing statement generation unit 23 and the data acquisition statement generation unit 25.

  Next, the data conversion processing statement generation means 23 generates data conversion processing (step 052 in FIG. 5). Details of this step will be described with reference to the flowchart of FIG.

  First, specification input is performed (step 061 in FIG. 6). In this step, the specification shown in FIG.

  Next, the processing from step 062 to step 067 in FIG. 6 is performed for all the definitions of variables included in the specification, that is, the 0221 row, the 0222 row, and the 0223 row in FIG.

  First, the variable definition on the line 0221 in FIG. 2 is processed. First, a data conversion process statement generation rule is selected (step 063 in FIG. 6). In this step, the data conversion processing statement generation rule shown in FIG. 3 and the variable name, variable type, corresponding item name, and corresponding item type in the line 0221 in FIG. Select a data conversion processing statement generation rule to be applied. In this case, the data conversion processing statement generation rule defined by the line 031 in FIG. 3 is selected. This is because the variable name '$ {1} product category' in the row 031 is the variable name in the row 0221 in Fig. 2 by considering '$ {1}' as 'selection'. 'And the corresponding item name' $ {2} product code 'in the row 031 corresponds to the corresponding item name in the row 0221 in Fig. 2 by regarding' $ {2} 'as' product master.' 'Product master. This is because it matches the product code '.

  Next, the process is branched depending on whether the data conversion process is selected (step 064 in FIG. 6). In this case, since the data conversion process statement generation rule defined in the line 031 in FIG. 3 is selected in step 063, it is determined that it has been selected, and the process proceeds to step 065.

  Next, data conversion process generation is performed (step 065 in FIG. 6). In this step, the data conversion processing statement specified in the data conversion processing statement generation rule defined in the line 031 in FIG. 3 selected in step 063 is generated. The data conversion process defined in line 031 is 'SUBSTRB ($ {2} product code, 1,3)', but in step 063, '$ {2}' is regarded as 'product master.' Therefore, the character string is 'SUBSTRB (product master. Product code, 1, 3)'. This is written into the data acquisition destination variable specification (data conversion processing column in the row 0421 in FIG. 4). The above is the processing for the variable definition in the row 0221 in FIG.

  Next, a process for variable definition in the row 0222 in FIG. 2 is performed. First, a data conversion process statement generation rule is selected (step 063 in FIG. 6). In this case, the data conversion processing statement generation rule is not selected. This is because there is no line having the same variable name or type name as shown in FIG.

  Next, the process is branched depending on whether the data conversion process is selected (step 064 in FIG. 6). In this case, since the data conversion process statement generation rule is not selected in step 063, it is determined that it has not been selected, and the process proceeds to step 066.

  Next, the corresponding item name is transferred to the data conversion process (step 066 in FIG. 6). In this step, the content of the corresponding item name existing in the original specification is written as the data conversion processing as it is. In the variable definition in the row 0422 in FIG. 4, the corresponding item name is “product master. Since the product name is 'data conversion processing' product master. “Product name” is written (data conversion processing column in the row 0422 in FIG. 4).

  The above is the processing for the variable definition in the row 0222 in FIG.

  Next, a process for defining variables in the line 0223 in FIG. 2 is performed. First, a data conversion process statement generation rule is selected (step 063 in FIG. 6).

  In this case, the data conversion process statement generation rule defined by the line 032 in FIG. 3 is selected. This is because the variable type 'char (8)' in line 032 matches the type 'char (8)' in line 0223, and the corresponding item type 'date' in line 032 is 0223. 'Product master specified as a corresponding item in the row. Product update date ', that is,' date 'which is the type of the item shown in the row 0213, and the corresponding item name' $ {1} 'in the row 032 is' product name master' . By considering “product update date”, the corresponding item name in the line 0223 is “product master. This is because it matches the product update date ′.

  Next, the process is branched depending on whether the data conversion process is selected (step 064 in FIG. 6). In this case, since the data conversion process statement generation rule defined in the line 032 in FIG. 3 is selected in Step 063, it is determined that it has been selected, and the process proceeds to Step 065.

Next, data conversion process generation is performed (step 065 in FIG. 6). In this step, the data conversion process statement specified in the data conversion process statement generation rule defined in the line 032 in FIG. 3 selected in step 063 is generated. The data conversion process defined in line 032 is' TO_CHAR ($ {1}, 'YYYYMMDD') '. In step 063,' $ {1} 'is' product master. Since it is regarded as a product update date ', the character string is' TO_CHAR (product master. Product update date,' YYYYMMDD ')'. This is written in the data acquisition destination variable specification (data conversion processing column in the row 0423 in FIG. 4).
The above is the processing for the variable definition in the row 0223 in FIG.

  Up to this point, the repetitive processing of performing the processing from step 062 to step 067 in FIG. 6 for all the definitions of the variables included in the data acquisition destination variable specification is completed.

  Finally, specification output is performed (step 068 in FIG. 6). In this step, the content of FIG. 4 which is the data acquisition destination variable specification in which the data conversion processing statement is generated by the above-described process is output to the cursor definition statement generating means 24.

  The details of the data conversion process generation are as described above.

  Next, the cursor definition statement generation means 24 generates a cursor definition statement (step 053 in FIG. 5). In this step, the cursor definition sentence having the contents shown in FIG. 9 is output. The details will be described with reference to the flowchart of FIG.

  First, specification input is performed (step 0701 in FIG. 7). In this step, the data acquisition destination variable specification shown in FIG.

  Next, as shown in Step 0702 of FIG. 7, a character string “CURSOR cur IS SELECT” is output. This corresponds to the row indicated by 0901 in FIG.

  Next, the steps between steps 0703 to 0705 in FIG. 7 are repeated for all the definitions of the variables included in the data acquisition destination variable specification, that is, the variables defined in the respective lines 0421, 0422, and 0423 in FIG.

  First, a SELECT phrase element is output for 0421 in FIG. 4 (step 0704 in FIG. 7). In this step, the content '<data conversion process> WORK_ <variable name>' is output. However, unless it is the end of the repetition, a comma symbol (',') is added at the end. Then, the data conversion process indicated by the data acquisition destination variable specification is inserted in the “<data conversion process>” portion, and the variable name indicated in the data acquisition destination variable specification is inserted in the <variable name> portion. . In the case of the row 0421 in FIG. 4, the data conversion process is “SUBSTRB (product master. Product code, 1, 3)” and the variable name is “selected product category”. Will be output.

  Next, a SELECT phrase element is output for 0422 in FIG. 4 (step 0704 in FIG. 7). In the case of 0422 in FIG. 4, the data conversion process is “product name” and the variable name is “V selected product name”. As a result, a line indicated by 0903 in FIG. 9 is output.

  Next, a SELECT phrase element is output for 0423 in FIG. 4 (step 0704 in FIG. 7). In the case of 0423 in FIG. 4, the data conversion process is 'TO_CHAR (product update date,' YYYYMMDD ')', and the variable name is 'V selected product update date'. Moreover, since it is the last of repetition, a comma symbol (',') is not added at the end. As a result of these, the row indicated by 0904 in FIG. 9 is output.

  The repetition from step 0703 to 0705 in FIG.

  Next, as shown in step 0706 of FIG. 7, a character string “FROM” is output. This corresponds to the row indicated by 0905 in FIG.

  Next, the table name is output (step 0707 in FIG. 7). In this step, the “product master” which is the table name shown in FIG. 4 is output. This corresponds to the row indicated by 0906 in FIG.

  Next, as shown in step 0708 of FIG. 7, a character string “WHERE” is output. This corresponds to the row indicated by 0907 in FIG.

  Next, the selection condition is output (step 0709 in FIG. 7). In this step, the selection condition indicated by 043 in FIG. 4 is output. This corresponds to the row indicated by 0908 in FIG.

  Finally, program output is performed (step 0710 in FIG. 7). In this step, the contents shown in FIG. 9 are transferred to the program composition means 27 as a cursor definition sentence.

  The details of the cursor definition statement generation are as described above.

  Next, a data acquisition sentence is generated (step 054 in FIG. 5). In this step, the data acquisition sentence having the contents shown in FIG. 10 is output. The details will be described with reference to the flowchart shown in FIG.

  First, specification input is performed (step 081 in FIG. 8). In this step, the data acquisition destination variable specification shown in FIG.

  Next, the steps between steps 082 to 084 in FIG. 8 are repeated for all the definitions of the variables included in the data acquisition destination variable specification, that is, the variables defined in the respective lines 0221, 0222, and 0223 in FIG.

  First, a data acquisition sentence is output for 0221 in FIG. 2 (083 in FIG. 8). In this step, the content '<variable name> (counter): = line.WORK_ <variable name>;' is output. However, the variable name indicated in the specification is inserted in the <variable name> part. In the case of 0221 in FIG. 2, since the variable name is “selected product category”, the line indicated by 1001 in FIG. 10 is output as a result.

  Next, a data acquisition sentence is output for 0222 in FIG. 2 (083 in FIG. 8). In the case of 0221 in FIG. 2, since the variable name is “selected product name”, as a result, a line indicated by 1002 in FIG. 10 is output.

  Next, a data acquisition sentence is output for 0223 in FIG. 2 (083 in FIG. 8). In the case of 0223 in FIG. 2, the variable name is “selected product update date”, and as a result, a line indicated by 1003 in FIG. 10 is output.

  The repetition from step 082 to step 084 in FIG.

  Finally, program output is performed (step 085 in FIG. 8). In this step, the contents shown in FIG. 10 are transferred to the program synthesis unit 27 as a data acquisition sentence.

  The details of the data acquisition statement generation are as described above.

Next, program synthesis is performed (step 055 in FIG. 5). In this step, the cursor statement definition shown in FIG. 9 is received from the cursor definition statement generator 24, the data acquisition statement shown in FIG. 10 is received from the data acquisition statement generator 25, and the contents of the program skeleton storage unit 26 in FIG. FIG. 12 shows a generated program that is inserted into '<< cursor definition sentence insertion location >>' (line indicated by 1102) and '<< data acquisition statement insertion location >>' (line indicated by 1109). Is output.
The operation of the first embodiment has been described above. In this description, the specification storage unit 1, the data conversion processing statement generation rule storage unit 22, the cursor definition statement generated by the cursor definition statement generation unit 24, and the data acquisition statement and program skeleton storage unit generated by the data acquisition statement generation unit 25. 26 and the generation program storage unit 3 generated by the system are described and explained according to the PL / SQL language, but programs of other programming languages can be generated with the same configuration.

  Next, the configuration of the second exemplary embodiment of the present invention will be described in detail with reference to the drawings.

  Referring to FIG. 13 showing the configuration of the second embodiment of the present invention, the data processing program automatic generation system 200 of this embodiment uses the data update program specification stored in the specification storage unit 100 as input information. , Specification input means 221, data conversion processing statement generation rule storage unit 222, data conversion processing statement generation unit 223, output processing statement generation unit 228, program skeleton storage unit 226, and program synthesis unit 227. The generated program is output to the generated program storage unit 300.

  The specification storage unit 100 holds a data update variable specification and a data update destination table specification as shown in FIG. 14, for example, as data update program specifications to be generated by this system.

  The specification input unit 221 inputs the data update program specification held in the specification storage unit 100 and passes it to the data conversion process statement generation unit 223.

  The data conversion processing statement generation rule storage unit 222 holds in advance a data conversion processing statement generation rule as shown in FIG. 15, for example, as a data conversion processing statement generation rule automatically generated by this system.

  The data conversion processing statement generation rule is composed of an item name indicating the name of an item to be applied, an item type indicating the type, a corresponding variable name to be applied, a corresponding variable type indicating the type, and a data conversion process to be generated. Is done.

  Here, the item name and the corresponding variable name may contain the description '$ {<numeric value}}' (where <numeric value> is an arbitrary number). This means that any character string can be entered in the numerical value>} ′ part. However, when there are a plurality of items having the same numerical value, it means the same character string.

  For example, referring to the line 151 in FIG. 15, if the item name is '$ {1} product code' and the corresponding variable name is '$ {2} product category, $ {2} product number', This means a data conversion processing statement generation rule for generating a data conversion processing statement of '$ {2} product category ||'-'|| $ {3} product number'.

  The data conversion process statement generation unit 223 receives the data update program specification from the specification input unit 221, generates a data conversion process statement based on the information stored in the data conversion process statement generation rule storage unit 222, and generates the data update program specification. To the output processing statement generation means 228.

  The output processing statement generation unit 228 receives the specification including the data conversion processing from the data conversion processing statement generation unit 223, generates an output processing statement, and transfers it to the program synthesis unit 227.

  The program skeleton storage unit 226 stores a template of a program to be output regardless of the data update program specification, and contents as shown in FIG. 21 are stored in advance. In this embodiment, a data processing program that updates the contents of the database using existing variables is targeted for generation, but in such a program, a portion other than an output processing statement that performs output to the database. Can always use common content. The program skeleton storage unit 226 holds the common part and indicates only the place to embed the output processing statement (“<< output processing statement insertion location >>” in FIG. 21).

  The program synthesis unit 227 inserts the output processing statement received from the output processing statement generation unit 228 into the contents of the program skeleton storage unit 226, and outputs the generation program that is the output of this system to the generation program storage unit 300.

  Next, the operation of the second exemplary embodiment of the present invention will be described in detail with reference to the flowchart of FIG. In this embodiment, the data update program specification expressed in the format shown in FIG. 14 is input, and the data processing program FIG. 22 for updating the data in the database described in the PL / SQL language is output.

  First, specification input is performed by the specification input means 221 (step 171 in FIG. 17). In this step, the data shown in FIG. 14 stored in the specification storage unit 100 is read into the system and transferred to the data conversion processing statement generation unit 223.

  Next, the data conversion processing statement generation means 223 generates data conversion processing (step 172 in FIG. 17). Details of this step will be described in detail with reference to the flowchart of FIG.

  First, specification input is performed (step 181 in FIG. 18). In this step, the specification shown in FIG.

  Next, the processing from step 182 to step 187 in FIG. 18 is performed for all the definitions of the variables included in the data update destination table specification, that is, the rows 1421 and 1422 in FIG.

  First, the variable definition on the line 1421 in FIG. 14 is processed. First, a data conversion process statement generation rule is selected (step 183 in FIG. 18). In this step, the data conversion processing statement generation rule shown in FIG. 15 and the table name, item name, type, and corresponding variable name in 1421 in FIG. Select as a conversion processing statement generation rule.

  In this case, the data conversion process statement generation rule defined by the line 151 in FIG. 15 is selected. This is because the item name '$ {1} product code' in 151 matches the item name 'product code' in 1421 by regarding '$ {1}' as an empty string ('). And 151, the corresponding variable name '$ {2} product category, $ {2} product number' is the corresponding item name in 1421 by selecting '$ {2}' as 'selected'. This is because it matches the selected item number.

  Next, the process branches depending on whether the data conversion process is selected (step 184 in FIG. 18). In this case, in step 183, since the data conversion processing statement generation rule defined in the line 151 in FIG. 15 is selected, it is determined that it has been selected, and the process proceeds to step 185.

  Next, data conversion process generation is performed (step 185 in FIG. 18). In this step, the data conversion process statement specified in the data conversion process statement generation rule defined in the line 151 in FIG. 15 selected in step 183 is generated. The data conversion process defined in line 151 is '$ {2} product category ||'-'|| $ {2} product number', but in step 183, '$ {2}' is selected. Since it is regarded as', it becomes a character string of 'selected product category ||'-'|| selected product number'. This is written into the data registration destination table specification (data conversion processing column in the row 1621 in FIG. 16).

  The above is the processing for the variable definition in the row 1421 in FIG.

  Next, the process for defining variables in the row 1422 in FIG. 14 is performed. First, a data conversion process statement generation rule is selected (step 183 in FIG. 18). In this case, the data conversion processing statement generation rule is not selected. This is because there is no line having the same variable name or type name as shown in FIG.

  Next, the process branches depending on whether the data conversion process is selected (step 184 in FIG. 18). In this case, since the data conversion process statement generation rule is not selected in step 183, it is determined that it has not been selected, and the process proceeds to step 186.

  Next, the corresponding variable name is transferred to the data conversion process (step 186 in FIG. 18). In this step, the content of the corresponding variable name existing in the original specification is written as the data conversion processing with the content as it is. In the variable definition in the row 1422 in FIG. 14, the corresponding variable name is “selected product name”, so it is written as the data conversion process “selected product name” (data conversion processing column in the row 1622 in FIG. 16).

  The above is the processing for the variable definition in the row 1422 in FIG.

  Up to this point, the repetitive processing of performing the processing from step 182 to step 187 in FIG. 18 for all the definitions of the variables included in the data update destination table specification is completed.

  Finally, specification output is performed (step 188 in FIG. 18). In this step, the contents shown in FIG. 16, which is the specification in which the data conversion process is generated by the above-described process, are output to the output process sentence generation unit 228.

  The details of the data conversion process generation are as described above.

  Next, output processing statement generation is performed by the output processing statement generation means 228 (step 173 in FIG. 17). In this step, the output processing statement having the contents shown in FIG. 20 is output. The details will be described with reference to the flowchart shown in FIG.

  First, specification input is performed (step 1901 in FIG. 19). In this step, the data registration destination table specification shown in FIG.

  Next, as shown in step 1902 of FIG. 19, a character string 'INSERT INTO' is output. This corresponds to the row indicated by 2001 in FIG.

  Next, the table name is output (step 1903 in FIG. 19). In this step, the “product master” which is the table name shown in FIG. 16 is output. This corresponds to the row indicated by 2002 in FIG.

  Next, as shown in step 1904 in FIG. 19, a character string '(' is output. This corresponds to a line indicated by 2003 in FIG.

  Next, the steps between steps 1905 and 1907 in FIG. 19 are repeated for all the definitions of the variables included in the data registration destination table specification, that is, the variables defined in the respective rows 1621 and 1622 in FIG.

  First, an item name is output for 1621 in FIG. 16 (1906 in FIG. 19). In this step, the item name in the data registration destination table specification is output. In addition, a comma symbol (',') is added at the end unless it is the end of the repetition. Here, since the item name is “product code” as indicated by 1621 in FIG. 16, the row indicated by 2004 in FIG. 20 is output as a result.

  Next, an item name is output for 1622 in FIG. 16 (1906 in FIG. 19). As shown by 1622 in FIG. 16, the item name is “product name”. Moreover, since it is the last of repetition, a comma symbol (',') is not added at the end. As a result, the line indicated by 2005 in FIG. 20 is output.

  The repetition from step 1905 to step 1907 in FIG.

  Next, as shown in Step 1908 of FIG. 19, a character string ') VALUES (' is output. This corresponds to the line indicated by 2006 in FIG.

  Next, the steps between steps 1909 to 1911 in FIG. 19 are repeated for all the definitions of the variables included in the data registration destination table specification, that is, the variables defined in the respective rows 1621 and 1622 in FIG.

  First, a data conversion process output is performed for 1621 in FIG. 16 (step 1910 in FIG. 19). In this step, the data conversion process in the data registration destination table specification is output. Also, when outputting the data conversion process, a character string '(counter)' that becomes a loop counter immediately after the character string corresponding to the variable name is used so that the output processing statement can be used in the loop. Is added. In addition, a comma symbol (',') is added at the end unless it is the end of the repetition. Here, as shown by 1621 in FIG. 16, the data conversion process is “selected product category ||”-“| selected product number”, but “selected product category” and “ If a character string '(counter)' is added immediately after the selected product number ', a character string of' selected product category (counter) || '-' || selected product number (counter) 'is obtained. Also, since it is not the end of the repetition, a comma symbol (',') is added at the end, and as a result, the line indicated by 2007 in FIG. 20 is output.

  Next, data conversion processing output is performed for 1622 in FIG. 16 (step 1910 in FIG. 19). As shown by 1622 in FIG. 16, when the data conversion process is “selected product name” and a character string “(counter)” is added immediately after “selected product name” which is a character string corresponding to a variable name, It becomes the character string of product name (counter) ′. Also, since it is the end of the repetition, the comma symbol (',') is not added. As a result, the line indicated by 2008 in FIG. 20 is output.

  The repetition from step 1909 to 1911 in FIG. 19 is as described above.

  Next, as shown in step 1912 of FIG. 19, a character string ');' is output. This corresponds to the row indicated by 2009 in FIG.

  Finally, program output is performed (step 1913 in FIG. 19). In this step, the contents shown in FIG. 20 are transferred to the program synthesis means 227 as an output processing statement.

  The details of the output processing statement generation are as described above.

  Next, program synthesis is performed (step 174 in FIG. 17). In this step, the output processing statement shown in FIG. 20 is received from the output processing statement generating means 228, and the contents of the program skeleton storage unit 226 are “<< output processing statement insertion location >>” (line indicated by 2105) in FIG. FIG. 22 which is a completed generation program is output.

  The operation of the second embodiment has been described above.

  As described above, according to the second embodiment of the present invention, the quality of a program can be stabilized in a project that requires development of a large number of data processing programs for updating database data.

  In addition, there is no problem even if the rules for implementing the data conversion processing for data conversion are changed during the project.

  Furthermore, it is possible to reduce the man-hours for implementing the data conversion process when data changes. This is because the data conversion process at the time of data update is automatically generated, and the user of this system does not need to describe the data conversion process.

It is a block diagram which shows the structure of the 1st Embodiment of this invention. It is a figure which shows the specification of the data acquisition program which should be produced | generated in 1st Embodiment. It is a figure which shows the specification of the data conversion process sentence production | generation rule in 1st Embodiment. It is a figure which shows the data acquisition origin table | surface specification in 1st Embodiment, data acquisition destination variable specification, and selection conditions. It is a flowchart which shows operation | movement of 1st Embodiment. It is a figure which shows the detail of the data conversion process production | generation in 1st Embodiment. It is a figure which shows the detail of the cursor definition sentence output operation | movement in 1st Embodiment. It is a flowchart explaining the detail of the data acquisition sentence production | generation operation | movement in 1st Embodiment. It is a figure which shows an example of the cursor definition sentence in 1st Embodiment. It is a figure which shows an example of the data acquisition sentence in 1st Embodiment. It is a figure which shows an example of the content of the program skeleton memory | storage part in 1st Embodiment. It is a figure which shows an example of the completed production | generation program in 1st Embodiment. It is a block diagram which shows the structure of the 2nd Embodiment of this invention. It is a figure which shows the specification of the data acquisition program which should be produced | generated in 2nd Embodiment. It is a figure which shows the specification of the data conversion process sentence production | generation rule in 2nd Embodiment. It is a figure which shows the data registration program specification in 2nd Embodiment, and a data registration destination table | surface specification. It is a flowchart which shows operation | movement of 2nd Embodiment. It is a figure which shows the detail of the data conversion process production | generation in 2nd Embodiment. It is a figure which shows the detail of the output process sentence production | generation operation | movement in 2nd Embodiment. It is a figure which shows an example of the output process sentence in 2nd Embodiment. It is a figure which shows an example of the content of the program skeleton memory | storage part in 2nd Embodiment. It is a figure which shows an example of the completed production | generation program in 2nd Embodiment.

Explanation of symbols

1,100 Specification Storage Unit 2,200 Data Processing Program Automatic Generation System 3,300 Generation Program Storage Unit 21,221 Specification Input Unit 22,222 Data Conversion Process Statement Generation Rule Storage Unit 23,223 Data Conversion Process Statement Generation Unit 24 Cursor Definition sentence generation means 25 Data acquisition sentence generation means 26,226 Program skeleton storage unit 27,227 Program synthesis means 228 Output processing sentence generation means

Claims (6)

Data acquisition program stored data in the variable acquires the variables, and type of the variables, and the data, and, specification input means for inputting a specification that includes a type of the data corresponding to the variable,
A data conversion processing statement including a condition relating to the variable, the variable type, the data, and the data type, and a data conversion process for converting the data into a predetermined format of the variable for the condition Data conversion processing statement generation rule storage means for storing a generation rule;
Data conversion processing statement generation means for generating a data conversion processing statement for the condition that matches the specifications based on the data conversion processing statement generation rules;
A cursor definition statement generating means for generating a cursor definition statement for defining a cursor based on the specification to which the data conversion process statement generated by the data conversion process statement generating means is added;
Data acquisition statement generation means for generating a data acquisition statement for acquiring the data from the database based on the specifications;
Program skeleton storage means for storing a program skeleton which is a template of the program;
The cursor definition statement received from the cursor definition statement generation unit and the data acquisition statement received from the data acquisition statement generation unit are inserted into the program skeleton, and the data acquisition program is generated and stored in the generation program storage unit. A data processing program automatic generation system comprising program synthesis means. Data acquisition program stored data in the variable acquires, enter the variables, and type of the variable, the data corresponding to the variable, and the specification including the type of the data,
A data conversion processing statement including a condition relating to the variable, the variable type, the data, and the data type, and a data conversion process for converting the data into a predetermined format of the variable for the condition Remember the production rules,
Based on the data conversion processing statement generation rules, generate a data conversion processing statement for the conditions that match the specifications,
Generate a cursor definition statement that defines a cursor based on the specification to which the data conversion processing statement is added,
A data acquisition statement for acquiring the data from the database is generated based on the specification,
An automatic data processing program generation method, wherein the cursor definition statement and the data acquisition statement are inserted into a program skeleton which is a program template to generate the data acquisition program. On the computer,
Data acquisition program stored data in the variable acquires, enter the variables, and type of the variable, the data corresponding to the variable, and the specification including the type of the data,
A data conversion processing statement including a condition relating to the variable, the variable type, the data, and the data type, and a data conversion process for converting the data into a predetermined format of the variable for the condition Remember the production rules,
Based on the data conversion processing statement generation rules, generate a data conversion processing statement for the conditions that match the specifications,
Generate a cursor definition statement that defines a cursor based on the specification to which the data conversion processing statement is added,
Generate a data acquisition statement for acquiring the data from the database using the cursor based on the specification,
A data processing program automatic generation program for realizing generation of the data acquisition program by inserting the cursor definition statement and the data acquisition statement into a program skeleton which is a program template. Data update program for updating the data in the contents of the variable, the data, and type of the data, and the variables, and, specification input means for inputting a specification including the type of the variables corresponding to the data,
Data conversion processing statement generation including the data, the data type, the variable, and a condition relating to the variable type, and a data conversion process for converting the variable into the predetermined format of the data for the condition Data conversion processing statement generation rule storage means for storing rules;
Data conversion processing statement generation means for generating a data conversion processing statement for the condition that matches the specifications based on the data conversion processing statement generation rules;
Output processing statement generating means for generating an output processing statement for outputting data based on the specification to which the data conversion processing statement generated by the data conversion processing statement generating means is added;
Program skeleton storage means for storing a program skeleton which is a template of the program;
A data processing program comprising: a program synthesis unit that inserts the output processing statement received from the output processing statement generation unit into the program skeleton, generates the data update program, and stores the generated data update program in a generation program storage unit Automatic generation system. The data update program for updating the data in the contents of the variable, enter the data, and type of the data, the variables corresponding to the data, and the specification including the type of the variable,
Data conversion processing statement generation including the data, the data type, the variable, and a condition relating to the variable type, and a data conversion process for converting the variable into the predetermined format of the data for the condition Remember the rules,
Based on the data conversion processing statement generation rules, generate a data conversion processing statement for the conditions that match the specifications,
Generate an output processing statement for outputting data based on the specification to which the data conversion processing statement is added,
A data processing program automatic generation method, wherein the output processing statement is inserted into a program skeleton which is a program template to generate the data update program. On the computer,
The data update program for updating the data in the contents of the variable, enter the data, and type of the data, the variables corresponding to the data, and the specification including the type of the variable,
Data conversion processing statement generation including the data, the data type, the variable, and a condition relating to the variable type, and a data conversion process for converting the variable into the predetermined format of the data for the condition Remember the rules,
Based on the data conversion processing statement generation rules, generate a data conversion processing statement for the conditions that match the specifications,
Generate an output processing statement for outputting data based on the specification to which the data conversion processing statement is added,
A data processing program automatic generation program for realizing the generation of the data update program by inserting the output processing statement into a program skeleton which is a program template.

Images