JP2000276386A - Method and device for generating program utilizing relation of relational data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce working load in the manual preparation of a program and to prevent the generation of problem due to a description miss in the program by utilizing related information between tables and automatically generating the program for applying data operation processing to plural tables. SOLUTION: In the program generation system, related information between tables is managed by tool repository 104. The related information is provided with two sorts of information, i.e., depending information and non-depending information. Program patterns are utilized for the generation of a program and these program patterns are prepared in each program language to be used, in each of reference and updating processing patterns and in each of depending and non-depending related sorts. When a master table and a slave table are specified at the time of generating the program, a pattern corresponding to the sort of relation between the tables concerned is acquired and table definition information such as table names and column names are padded to generate the program.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for generating a database operation program when working using a database design or development support tool, and more particularly to a method for managing relational information between tables in a relational database and a program. The present invention relates to a program generation method using a pattern.

[0002]

2. Description of the Related Art Conventional automatic generation of a program for accessing a relational database is disclosed in
As described in Japanese Patent Application Laid-Open No. 161914, a program for individually adding, modifying, deleting, and referencing data for each table is generated from table definition information managed by a tool.

[0003]

However, the conventional method has the following problems. With the conventional database design and development tools, it was possible to manage the related information between tables such as identification keys and reference keys and generate database definition statements, but to add, update, delete, and reference data to the database When generating a program for performing the operation processing, it is necessary to generate a program for performing a data operation for each table unit. When creating a program for manipulating data in a plurality of tables, it is necessary to generate a program for each table, and to manually describe the calls and call order.

According to the present invention, a program for performing data manipulation processing on a plurality of tables is automatically generated by using information related to tables, thereby reducing the work load at the time of manually creating a program, and Solve the problem of writing errors. In addition, since the generated program is a program that summarizes related processes when data is manipulated, the problem of load on program calling is improved.

[0005]

According to the present invention, table definition information of a database and related information of each table are stored in a repository in advance. The repository is a database and a management system for managing design data defined by work on the tool. The repository can be created using a database management system, or can be created as a file such as spreadsheet software. The repository has two types of table-related information: a dependency relationship and a non-dependency relationship. Dependencies are
If there is no record of the relation source table (hereinafter, referred to as a parent table), it indicates a relation in which no record of the relation destination table (hereinafter, referred to as a child table) cannot exist. The non-dependency indicates a relationship in which a record in the child table can exist without a record in the parent table. By specifying the parent table name and child table name when generating the program,
Generate a program corresponding to the type of association.

The program pattern is a file serving as a template of a generation program, and describes a template of program processing using a programming language to be used. The program pattern is referred to and updated (for example, added, modified, and deleted) for each DBMS (database management system), for each type of association between tables such as dependent and non-dependent.
Are prepared according to the type of the process. When the program pattern is dependent and referenced, the program processing searches the parent table, and searches the child table using the obtained record as a search condition. In the program processing independent and referencing, the parent table and the child table are joined using the identification key item of the parent table, and information is obtained in a format in which the record of the parent table is added to the record of the child table. In the case of dependency and update, the program processing added a record to the parent table at the time of addition, then added a record to the child table, and modified and deleted the record of the child table at the time of modification and deletion Later, modify and delete the parent table. The program processing in the case of non-dependency and updating is the same processing as in the case of dependency and updating. At the time of program generation, a program is generated by embedding table definition information such as the table name and column name of the parent table and the table name and column name of the child table in the program pattern.

[0007]

Embodiments of the present invention will now be described in detail with reference to the drawings, in which a program is generated.

FIG. 1 is a functional block diagram showing a method of generating a data operation program (101) according to the present invention. In FIG. 1, an input device (102) is used when defining a program to be generated and when generating a program.
The display device (103) displays items such as table names when defining a program or generating a program. The repository (104) holds a table definition information holding area (30) holding information such as table names and column names in a table format.
0), a table related information holding area (400) that holds related information between tables in a table format, and a program definition information holding area (400) that holds a parent table, a child table, and the like related to a generated program in a table format. 600) and a pattern file (800) serving as a model of the program. The pattern file (800) is prepared for each program language and for each reference / update process.

FIG. 2 shows the relationship between tables in a dependency relationship and a non-dependency relationship. The type of association between the order table (201) and the order detail table (202) is the order table (20
This is a dependency relationship (204) in which 1) is a parent table and the order details table (202) is a child table. If there is no record in the order table (201), no record in the order detail table (202) can exist. . Also,
The type of association between the employee table (203) and the order table (201) is a non-dependency (205) using the employee table (203) as a parent table and the order table (201) as a child table. Even if the record of ()) does not exist, the order record can exist.

FIG. 3 shows a table definition information holding area (300) in the repository (104).
(301) and table TABLE_COLUMN (302).

FIG. 4 shows a table-related information holding area (400) in the repository (104).
ON (401) and a table RELATION_KIND (402) for managing the type of association between tables as codes
Holding.

FIG. 5 is a flowchart showing a process for registering program definition information. The table TAB of the table definition information holding area (300) on the display device (103).
The table name stored in the LE (301) and the table RELEATION (4) in the table-related information holding area (400).
The table names corresponding to the parent table and the child table are displayed based on the related information between the tables stored in 01). Also, the program language of the program to be generated and the type of data operation such as reference and update are displayed. From the contents displayed on the display device (103), selection of a parent table name (501), selection of a child table name (502), selection of a program language (503), and type of processing for operating data referred to / updated. Selection (504) becomes possible, and information on the definition of a program to be generated in the input device (102) is input. With this input information, the programming language, related information between tables, and processing are determined,
A program pattern is internally selected (505), and information of the program definition is stored in a program definition information holding area (6).
00) is stored (506) in the table PROGRAM_LST (601).

FIG. 6 shows a program definition information holding area (600) in the repository (104), and a table PROGRAM_LST (6) for managing the registered contents of the program definition.
01).

FIG. 7 is a flowchart showing the program generation processing (101). The user can create a table PROGRAM_LST in the program definition information holding area (600).
The program definition information generated from the program definition information stored in (601) is selected (701). Based on the selected program definition information, the table TABLE (3) stored in the table definition information holding area (300) is stored.
01) and the table name and column name of the parent table from the table TABLE_COLUMN (302) (702).
Then, similarly, the child table is obtained (703).
Further, a pattern file is obtained (704), the table names and column names of the parent table and child table are embedded in the pattern (705), and the program source (10
5) is generated.

Hereinafter, a specific description will be given of a case in which COBOL is used as a program language in generating a program, and a program of processing for referencing data to a table on which the type of association between tables depends is described. In the input device (102), an order receiving table (201) is selected as a parent table and an order receiving detail table (202) is selected as a child table, and the programming language is COBO.
L, the type of the process for operating data is selected and registered. At the time of registration, a dependency relationship between the tables called dependencies stored in the table RELEATION (401) of the table related information holding area (400) is acquired, and the pattern file has a program language of COBOL and a type of processing for operating data. Is referred to and the pattern file in which the type of association between the tables depends is defined in the program definition information holding area (6).
00) in the table PROGRAM_LST (601). In the program generation, when the above-described program definition is selected from the program definition information, the order table (201) stored in the table TABLE (301) and the table TABLE_COLUMN (302) of the table definition information holding area (600) and the order details Table (202)
Then, the table name and column name are acquired, and the acquired table name and column name are embedded in the pattern file (805).

FIG. 8 shows a flowchart in the case where the programming language is COBOL, the type of processing for operating data is reference, and the type of association between tables is a processing described in a dependent pattern file. I have.
The processing contents of this pattern file are as follows. The order table (201) of the parent table is searched, and 1
The first record is acquired (801). With the acquired parent table record as a condition, the corresponding child table order detail table (202) is searched, the first record is acquired (802), and all records are acquired (803).
Repeat until This process is repeated until all records of the parent table are obtained (804). A part of a program (90) for referring to the data of the order table (201) and the order detail (202) table generated in FIG.
1) is shown.

The programming language can be a language other than COBOL in the same manner, and the data manipulation processing and the update processing can be performed in the same manner as the reference processing.

[0018]

According to the present invention, by generating a program for operating data of a plurality of tables by using related information, a user must generate a database operation program for each table and manually describe the calling and calling order thereof. As a result, there is no manual description error.
In addition, since the program operates not on a table basis but on data in a plurality of tables in which related processes are put together, the load on calling the program is reduced, and the execution performance is improved.

[Brief description of the drawings]

FIG. 1 is a configuration diagram showing functions of the present invention.

FIG. 2 is a diagram showing a table related to the present invention.

FIG. 3 is a diagram showing a data configuration of a table definition information holding area according to the present invention.

FIG. 4 is a diagram showing a data configuration of a table related information holding area of the present invention.

FIG. 5 is a flowchart of a program definition information registration process according to the present invention.

FIG. 6 is a diagram showing a data configuration of a program definition information holding area according to the present invention.

FIG. 7 is a flowchart of a program generation process according to the present invention.

FIG. 8 is a view showing an outline of processing of a pattern file according to the present invention. (Program language: COBOL Processing: Reference Table related type: Dependent)

FIG. 9 is a diagram showing an example of a generation program source according to the present invention.
(Program language: COBOL processing: Reference table related type: Dependent)

[Explanation of symbols]

101: Program generation processing, 102: Input device, 103: Display device, 104: Repository, 105: Program source, 201:
Table "Orders", 202 ... Table "Order Details",
203: table "employee", 204: dependency (parent table: "order" child table: "order details"), 20
5 ... Independent relationship (parent table: "Employee" child table:
"Order"), 300 ... table definition information holding area, 30
1 ... Table TABLE, 302 ... Table TABLE_COLUM
N, 400: table related information holding area; 401: table R
ELATION, 402 ... table RELEATION_KIN
D, 500: Program definition processing, 501: Selection of target parent table, 502: Selection of target child table,
503: Selection of programming language, 504: Selection of type of data operation, 505: Selection of program pattern,
506: Registration of program definition, 600: Program definition information holding area, 601: Table PROGRAM_LS
T, 700: Program generation processing, 701: Selection of program definition, 702: Acquisition of target parent table, 70
3: Acquisition of target child table, 704: Acquisition of program pattern, 705: Embedding in program pattern, 800: Pattern file, 801: Acquisition of first parent table record, 802: Acquisition of first child table record, 803 … Get all child table records, 8
04: Acquisition of all parent table records, 805: Example of pattern file, (Program language: COBOL processing: Reference table related type: Dependent), 901: Example of generated program source, (Program language: COBOL)
Processing: Referencing Table related type: Dependent).

Claims (4)

[Claims] In a method for generating a program used for supporting database design work or developing, a program for operating data stored in a plurality of relational databases having a relation by inputting related information between tables is generated. A program generation method. 2. A program generating apparatus for supporting database design work or development support, comprising: means for inputting related information between tables when creating a program for operating data stored in a relational database; In the repository that manages the relationship between the tables and a pattern that is a template of the program, and a unit that acquires a program pattern corresponding to the type of the relationship between the tables. A program generating apparatus for generating a program adapted to a program. 3. The program generation device according to claim 2, wherein the related information between the tables is a dependency relationship and a non-dependency relationship. 4. The program generating apparatus according to claim 3, wherein a pattern serving as a model of the program is prepared for each dependent or non-dependent, and for each processing of reference or update.