Data processing: software development – installation – and managem – Software program development tool – Code generation
Reexamination Certificate
2000-08-18
2004-02-24
Zhen, Wei (Department: 2122)
Data processing: software development, installation, and managem
Software program development tool
Code generation
C717S104000
Reexamination Certificate
active
06698010
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Technical Field of the Invention
The present invention relates to an automatic generation of a program, and more particularly to a technique of automatically generating a data processing program for processing data with reference to the data of a table of a database constructed on an information processing system, storing the processing result once more in the table of the database, and updating or deleting the data of the table of the database based on the processing result.
2. Description of the Prior Art
Techniques for automatically generating a data processing program has been developed.
For example, JP1-147621 A (1989) discloses a system and method for generating automatically such data processing programs. The disclosed system comprises: input means for inputting specifications concerning data layout wherein attributes such as type and digit of each data item included in files and documents are defined, and for inputting specifications concerning calculation formulas; and program generation means for generating the corresponding batch work program. Further, the automatic program generating method comprises the steps of: inputting information on execution order such as data input/output order of files and documents and calculation order, into the input means of the specifications information; and generating the information on a program structure of a program to be generated, from the execution order information, in the program generating means.
A block diagram of the conventional program generation system as disclosed in JP1-147621 A (1989) is shown in FIG.
41
. The specifications are inputted from a terminal into specifications input unit which further generates input/output relations, layout, generation formula and decision tables. Further, a data defining unit is generated from an input/output relation unit and a layout unit. A data editing unit is generated from the input/output relation unit and a generation formula unit. A program structure unit is generated from the input/output relation unit and a decision table unit. Finally, a program combining unit combines the data defining unit, the data editing unit, and the program structure unit.
Further, JP3-182932 A (1991) discloses a program automatic generating technique for the purpose of preventing errors and improving productivity. Concretely, this technique solves problems in program generation such as induction of user's errors, or low productivity due to an increase in description amounts. Here, the problems arise from the fact that the COBOL language is so different from the SQL that it is laborious to describe a program by embedding a program of the SQL language in a program of the COBOL language.
A block diagram of the program generation system as disclosed in JP3-182932 A (1991) is shown in
FIG. 42. A
processing specification is inputted into data analysis unit. Then, data analysis and procedure analysis are executed. Further, the output from the procedure analysis unit is inputted into a definition unit, so as to automatically generate the SQL declarative section and the SQL communication area unfolding statement.
Although various automatic generating techniques have been disclosed, there is not found any article which describes an automatic generating technique of a data processing program for referring to, updating, and deleting the data of a table of a database constructed on an information processing system by use of a cursor definition statement. Concretely, JP1-147621 A (1989) merely discloses an automatic generation of a program dealing with a usual file and document, and use of a database is not assumed there. Further, JP3-182932 (1991) does not disclose automatic generation of cursor definition statement.
Generally, in a program dealing with a usual file and document, data is obtained from an input file, calculation processing is performed, and the result is stored in a new file. Therefore, also in JP1-147621 A (1989), on the assumption that a new file or document is generated as the output processing, the data of the existing file is never deleted and changed. The case of a database system, however, is characterized in that update and delete of an existing table by the record unit can be executed safely, and therefore, in a data processing program using a database, according to the cursor definition statement indicating which part of which table should be processed, data is obtained from the table input, calculation processing is performed, and based on the result, as is often the case, a new table is created, the existing table is updated, or deleted.
In the case of manual generation of this data processing program with reference to a detailed design similarly to the conventional way, there is a problem that a lot of processes are required, an error caused by human hands cannot be prevented, and that consistency of the detailed design and the program cannot be guaranteed. In the case of developing a large scale business program, it is necessary to install not only the business requirements but also the processing in the case of occurrence of system failure and access failure to a database or a network, which is difficult for a programmer of little experience of a business program, thereby causing a problem of deteriorating the quality of the developed program and the productivity of development. Therefore, the automatic generating technique of this kind of data processing program becomes a very important theme.
SUMMARY OF THE INVENTION
An object of the present invention is to automatically generate a data processing program for referring to, updating, or deleting the data of a table of a database.
Another object of the present invention is to reduce a user's labor of describing specifications, by reducing the kind of information to be described in the specifications of the business requirements.
Further, another object of the present invention is to automatically generate various data processing programs from the specifications of the same business requirements.
The data processing program automatic generation system of the present invention for automatically generating a data processing program for referring to, updating, and deleting data of a table of a database, comprises: means for generating a cursor definition statement, a work variable definition statement, and an output processing statement, based on information obtained from specifications; and means for inserting the generated cursor definition statement, work variable definition statement, output processing statement, and program customize information within the specifications into each corresponding position of a program skeleton, including the program of a fixed portion regardless of the content of specifications and an inserting position of a piece of a program corresponding to a portion changeable according to the specifications of the data processing program,thereby completing the data processing program and outputting the same. More specifically, it comprises:
specification input means for inputting specifications including program name, input table item definition, select item definition, output table item definition, output table processing definition, select condition definition, and program customize information;
program skeleton customize information obtaining means for taking out the program name and the program customize information, as the information for customizing a program skeleton, from the specifications input by the specifications input means;
cursor definition information obtaining means for taking out the input table item definition, the select item definition, and the select condition definition, from the specifications input by the specifications input means;
output item processing information obtaining means for taking out the output table item definition and the output table processing definition, from the specifications input by the specifications input means;
cursor definition statement generating means for generating a cursor definition statement from the inform
Sato Akiyoshi
Yamanouchi Toru
Foley & Lardner
NEC Corporation
Zhen Wei
LandOfFree
System, method and computer program product for automatic... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System, method and computer program product for automatic..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System, method and computer program product for automatic... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3296325