JPH11296417A - Method and device for generating information management program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To make compatibility between items sure by decreasing an item definition load on a user. SOLUTION: A user is made to select a system output with output item specifications definition information as a guide (101), and a database item is automatically generated on the basis of the system output item (102). Then, a system input item is automatically generated on the basis of database item (104), the user is made to select a system input item (108) with input item specifications definition information as a guide, compatibility between items is verified (109) and contradiction is corrected (110), an input program is generated (120) based on the input item specifications definition information, the system input item and program parts, and an output program is generated (121) on the basis of the output item specifications definition information, the system output item and the program parts. In this way, it is possible to decrease a load on the user who defines items. Also it is possible to make the compatibility between the items sure.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method and an apparatus for generating an information management program, and more particularly, to an input / output for editing input data, storing the edited data in a database, extracting data from the database, editing and outputting the data. The present invention relates to an information management program generation method and apparatus for generating a program or a specification.

[0002]

2. Description of the Related Art One of the powerful methods for improving the productivity of program creation is a method of creating a new program using existing program components. For example, Japanese Patent Laying-Open No. 5-108319 discloses an information management program generation method for generating an input / output program by associating items defined by a user with program components. In this information management program generation method, the user defines three types of items: system input items, database items, and system output items.

[0003]

SUMMARY OF THE INVENTION The above-mentioned Japanese Patent Application Laid-Open No. 5-108 is disclosed.
The conventional technique disclosed in Japanese Patent Publication No. 319 has the following problem. The first problem is that end users without knowledge of the internal design cannot practically use this prior art, since the user must define the database items. The second problem is that the user must define all of the system input items, database items, and system output items. For example, an input / output program for an industrial plant such as a steelmaking plant has thousands of system input items. Therefore, their definition requires a great deal of effort. A third problem is that even if there is an omission or excess in an item defined by a user, an input / output program is generated as it is, and consistency between items cannot be maintained. In the related art, there is a related check definition component, which checks the consistency of values, but does not check the consistency between items.

Therefore, a first object of the present invention is to provide the first
~ To solve the third problem, as long as the user selects system input items and system output items that can be understood by the end user, even if the user does not define database items,
An object of the present invention is to provide an information management program generation method and apparatus for automatically generating an optimum database item and automatically generating a data input program and an output program. A second object of the present invention is to provide an information management program generating method and apparatus for automatically generating a system input item based on a system output item selected by a user in order to solve the third problem. To provide. Further, a third object of the present invention is to solve the third problem by ensuring consistency between items even when system input items are not automatically generated and selected by a user. An object of the present invention is to provide a method and an apparatus for generating an information management program.

[0005]

According to a first aspect of the present invention, there is provided an information processing apparatus for editing input data, storing the edited data in a database, and extracting, editing, and outputting data from the database. A method for generating a management program, comprising: a user based on output item specification definition information that defines a relationship between an item name of data that may be output, a storage location of the data, and a program component that edits and outputs the data. A system output item selecting step of selecting a system output item; a database generating step of generating a database item based on the output item specification definition information and the selected system output item; Defined the relationship between the item name of certain data, the storage location of the data, and the program parts that edit and store the data A system input item selecting step for allowing a user to select a system input item based on the input item specification definition information; and an input program based on the input item specification definition information, the selected system input item, and the program component. An information management program, comprising: an input program generating step of generating; and an output program generating step of generating an output program based on the output item specification definition information, the selected system output item, and a program component. Provides a generation method. In the information management program generating method according to the first aspect, since the database items are automatically generated based on the output item specification definition information and the selected system output items, the user does not need to define the database items. The first problem can be solved. Further, since the user is allowed to select a system input item using the input item specification definition information as a guide, the burden on the user to define the system input item is reduced, and the second problem can be solved. In addition, since the database items are automatically generated based on the system output items, consistency between the system output items and the database items can be ensured, and the third problem can be solved.

According to a second aspect, the present invention is an information management program generating device for editing input data, storing the edited data in a database, and generating an input / output program for extracting, editing, and outputting data from the database. Output item specification definition information storage means for storing output item specification definition information defining a relationship between an item name of data that may be output, a storage location of the data, and a program component that edits and outputs the data; Input item specification definition information storage means for storing input item specification definition information defining a relationship between an item name of data that may be input, a storage location of the data, and a program component for editing and storing the data; System output item selection means for allowing a user to select a system output item based on output item specification definition information; Database generation means for generating database items based on the definition information and the system output items; system input item selection means for allowing a user to select system input items based on the input item specification definition information; An output program generating means for generating an output program based on the item specification definition information, the selected system output item, and the program component; and the input item specification definition information, the selected system input item, and the program component. An information management program generation device comprising: an input program generation unit configured to generate an input program based on the input program generation means. In the information management program generation device according to the second aspect, the first
The information management program generation method according to the aspect described above can be suitably implemented.

In a third aspect, the present invention provides the information management program generating method having the above-described configuration, wherein the input item specification definition information corresponding to the item of the database is searched, and if only one item is found, the input item specification definition information is retrieved. A system input item automatic generation step of automatically generating a system input item based on the input item specification definition information corresponding to the item in the database, and if a plurality of input item specification definition information are found, the user is allowed to select one of the input item specification definition information. A system input item determination step of determining a system input item based on the information management program. In the information management program generating method according to the third aspect, since all or some of the system input items are automatically generated based on the database items and the input item specification definition information, the burden on the user to define the system input items is small. Thus, the second problem can be solved.

According to a fourth aspect of the present invention, in the information management program generating device having the above-mentioned configuration, the input item specification definition information corresponding to the item of the database is searched, and if only one item is found, the input item specification definition information is retrieved. A system input item automatic generation means for automatically generating a system input item based on the input item specification definition information corresponding to the item of the database, and when a plurality of input item specification definition information are found, the user is allowed to select one of the input item specification definition information. There is provided an information management program generating device, comprising: a system input item determining unit for determining a system input item based on the information. The information management program generation device according to the fourth aspect can suitably implement the information management program generation method according to the third aspect.

According to a fifth aspect of the present invention, in the information management program generating method having the above-mentioned configuration, the consistency verification for verifying the consistency between the items of the database and the system input items selected by the user. And an inconsistency correcting step for causing a user to correct the inconsistency when there is a contradiction. In the information management program generation method according to the fifth aspect, the consistency between the database item and the system input item is verified, and the contradiction is corrected by the user.
The consistency between items can be ensured, and the third problem can be solved.

According to a sixth aspect of the present invention, in the information management program generating device having the above-mentioned configuration, a consistency verification for verifying consistency between the items of the database and the system input items selected by the user. Means and an inconsistency correcting means for causing a user to correct the inconsistency when the consistency is inconsistent. The information management program generation device according to the sixth aspect can suitably implement the information management program generation method according to the fifth aspect.

According to a seventh aspect of the present invention, in the information management program generating method having the above configuration, the input item specification definition information includes information on data grouping,
In the information management, the system input item selecting step may select a plurality of data belonging to one group as an input unit, and the input program generating step may generate an input program for each of the input units. Provide a program generation method. In the information management program generation method according to the seventh aspect, since a plurality of data can be handled collectively, the burden on the user to select a system input item is reduced, and the second problem can be solved. In addition, it is possible to generate an input program for each screen or communication message in a system that receives a plurality of screens or a plurality of communication messages, or a system that receives both a screen and a communication message.

According to an eighth aspect of the present invention, in the information management program generation device having the above configuration, the input item specification definition information includes information on data grouping,
The system input item selection unit is a unit that can select a plurality of data belonging to one group as an input unit, and the input program generation unit is a unit that can generate an input program for each of the input units. An information management program generation device is provided. In the information management program generation device according to the eighth aspect,
The information management program generation method according to the aspect described above can be suitably implemented.

According to a ninth aspect, the present invention provides the information management program generating method having the above configuration, wherein the output item specification definition information includes information on data grouping,
The system output item selecting step is capable of selecting a plurality of data belonging to one group as an output unit, and the output program generating step can generate an output program for each output unit. Provide a program generation method. In the information management program generation method according to the ninth aspect, since a plurality of data can be handled collectively, the burden on the user to select a system output item is reduced, and the second problem can be solved. Further, it is possible to generate an output program for each screen or communication message in a system that receives a plurality of screens or a plurality of communication messages, a system that receives both a screen and a communication message, or the like.

According to a tenth aspect, the present invention provides the information management program generating device having the above-mentioned configuration, wherein said output item specification definition information includes information relating to data grouping, and said system output item selecting means comprises: An information management program generation device, wherein: a plurality of data belonging to a group can be selected as an output unit; and the output program generation unit can generate an output program for each output unit. I do. The information management program generation device according to the tenth aspect can suitably implement the information management program generation method according to the ninth aspect.

According to an eleventh aspect, in the information management program generating method according to the present invention, the input item specification definition information includes information on whether data is required or optional, and the system input item selecting step includes: An information management program generation method is provided, wherein essential data is automatically selected, and a user is allowed to select only optional data. In the information management program generation method according to the eleventh aspect, since the essential data is automatically selected, the burden on the user to select system input items is reduced, and the second problem can be solved.

In a twelfth aspect, in the information management program generating method according to the present invention, the output item specification definition information and the input item specification definition information include information on whether data is required or optional. The system output item selection step automatically selects essential data and allows the user to select only optional data, and the system input item selection step automatically selects essential data and selects optional data. There is provided an information management program generation method characterized by allowing a user to select only data. In the information management program generating method according to the twelfth aspect, since the essential data is automatically selected, the burden on the user to select the system output items and the system input items is reduced, and the second task is reduced.
Problem can be solved.

In a thirteenth aspect, the present invention provides the information management program generation device having the above-mentioned configuration, wherein said output item specification definition information and said input item specification definition information include information on whether data is required or optional. The system output item selecting means is a means for automatically selecting essential data and allowing the user to select only optional data, and the system input item selecting step automatically selects essential data. An information management program generating device is provided, which is a means for allowing a user to select only data of an option. In the information management program generation device according to the thirteenth aspect,
The information management program generation method according to the aspect described above can be suitably implemented.

According to a fourteenth aspect, the present invention provides a method for generating an information management program having the above configuration, wherein a specification part which is a fragment of a specification is used instead of the program part, and the output program generation step is performed instead of the output program generation step. There is provided an information management program generation method, comprising a specification output step of generating a specification. In the information management program generating method according to the fourteenth aspect, the first to third problems can be solved and a specification can be output.

According to a fifteenth aspect, the present invention relates to the information management program generating apparatus having the above-mentioned configuration, wherein a specification part which is a fragment of a specification is used in addition to or instead of the program part, and the output program There is provided an information management program generation device characterized by having specification output means for generating a specification in addition to or instead of the generation means. The information management program generation device according to the fifteenth aspect can suitably implement the information management program generation method according to the fourteenth aspect.

[0020]

Embodiments of the present invention will be described below with reference to the drawings. Note that the present invention is not limited by this.

FIG. 2 is a configuration diagram showing an information management program generation device according to one embodiment of the present invention. The information management program generation device (100) includes a computer (1) having a CPU (7) and a main storage (8), a display (2), a keyboard (3), a mouse (4),
The printer includes a printer (5) and an external storage device (6). The external storage device (6) stores input item specification definition information (113), output item specification definition information (114), and a program component library (115).
The input item specification definition information (113) includes an item name of data that may be input (referred to as an input item name), a program component for editing and storing the data, a database table for storing the data (referred to as a storage table), and It defines the relationship between item names (called DB item names) in the storage table. The output item specification definition information (114) includes an item name of data that may be output (referred to as an output item name), a storage table and a DB item name storing the data, and a program component that edits and outputs the data. Is defined. The program component library (115) defines a library of program components (called storage components) for editing and storing data and a library of program components (collection components) for editing and outputting data. The input item specification definition information (113) and the output item specification definition information (1)
14) and the program component library (115) are comprehensively defined in advance by an expert for each field of the program to be generated. The output item specification definition information (11
The set of storage table and DB item name defined in 4) is
It must be defined also in the input item specification definition information (113).

FIG. 3 shows input item specification definition information (113).
Is a first example. The input item name is input item name 1 (30
Only one of the "product numbers" in 1)
(302) is blank. Storage table (30
3) and the DB item name (304) are “product result table” and “p_no”. The storage component (305)
"COPY_STRING".

FIG. 4 shows input item specification definition information (113).
Is a second example. The input item name is input item name 1 (40
1) “manufacturing start time” and input item name 2 (402) “manufacturing end time”. Storage table (40
3) and the DB item name (404) are “accumulated result table” and “running_time”. Storage parts (40
5) is “ADD_INTERVAL”.

FIG. 5 shows input item specification definition information (113).
This is a third example. The input item name is input item name 1 (50
1, 511), and the input item name 2 (502, 512) is blank. Storage table (503, 513) and DB item name (504, 504)
514) is “product result table” and “p_weight”
And “accumulated result table” and “p_weight”. The storage components (505, 515) are “COPY_WE
IGHT "and" ADD_WEIGHT ".

In the examples of FIGS. 3 to 5, the input item name is 2
Up to three, but three or more may be defined. Also, the length may be variable with a list structure or the like.

FIG. 6 shows output item specification definition information (114).
Is a first example. The output item name (601) is “product coefficient”. The storage table and the DB item name are “product result table” and “p_no” of the storage table 1 (602) and the DB item name 1 (603), and the storage table 2
(604) and DB item name 2 (605), “product result table” and “p_weight”. The collection component (606) is “CALC_COEFF”.

FIG. 7 shows output item specification definition information (114).
Is a second example. The output item name (701) is “cumulative weight”. The storage table and the DB item name are a set of “accumulated result table” and “p_weight” of the storage table 1 (702) and the DB item name 1 (703), and the storage table 2 (704) and the DB item name 2 ( 7
05) is blank. The collection part (706)
"COPY_WEIGHT".

FIG. 8 shows output item specification definition information (114).
This is a third example. The output item name (801) is “product number”. The storage table and the DB item name are a set of “product result table” and “p_no” of the storage table 1 (802) and the DB item name 1 (803), and the storage table 2 (804) and the DB item name 2 ( 805)
Is blank. The collection part (806) is “COP
Y_STRING ".

In the examples shown in FIGS. 6 to 8, the number of storage table and DB item names is up to two, but three or more sets may be defined. Also, the length may be variable with a list structure or the like.

FIG. 9 shows a first example of a program component.
(901) program part "COPY_STRIN"
"G" is a program component for copying a character string.
(910) is a program component “COPY_STRIN”.
This is a data flow when “G” (901) is used as a storage component. Program part "COPY_STRING"
(901) stores the data (906) input from the input device and held in the input buffer (902) in the entry of the DB item name (907) of the storage table X (903). (920) indicates the program component “COP
This is a data flow when “Y_STRING” (901) is used as a collection component. The program part "COPY_
“STRING” (901) is stored in the storage table Y (90).
4) The data stored in the entry of the DB item name (908) is output as data (909) to an output buffer (905) for outputting from an output device.

FIG. 10 shows a second example of the program component. (1001) program part "CALC_COE"
"FF" is a program part for obtaining a product coefficient from a product number and weight. (1020) is the program component “C
This is a data flow when “ALC_COEFF” (1001) is used as a storage component. Program part "CAL
“C_COEFF” (1001) obtains a product coefficient from data (1005, 1006) input from the input device and held in the input buffer (902), and an entry of the DB item name (1004) of the storage table V (1012) To be stored. (1030) is the program component “CA
LC_COEFF ”(1001) as a collection component. Program part "CALC_CO
EFF ”(1001) is the storage table A (1008)
For obtaining the product coefficient from the data stored in the entry of the DB item name (1008) and the data stored in the entry of the DB item name (1009) of the storage table B (1011), and outputting the product coefficient from the output device. The data is output to the output buffer (905) as data (1007).

FIG. 11 shows a third example of the program component. (1101) program part "ADD_INTE
“RVAL” is a program component that calculates an elapsed time from two times and accumulates the elapsed time into an accumulated elapsed time value. (111
0) is the program component "ADD_INTERVAL"
It is a data flow when (1101) is used as a storage component. Program part "ADD_INTERVAL"
(1101) is data (1104, 110) input from the input device and held in the input buffer (902).
The elapsed time is obtained from 5) and accumulated in the data stored in the DB item name (1106) of the storage table (1103).

FIG. 12 shows a fourth example of the program component. (1201) program part "AVERAGE_
"WEIGHT" is a program component for calculating an average value of data of the same DB item name stored in a plurality of storage tables. (1210) is a program component “AVE”
This is a data flow when “RAGE_WEIGHT” (1201) is used as a collection component. Program part "A
“VERAGE_WEIGHT” (1201) calculates the average value of the data of the DB item names (1203) of the plurality of storage tables (1202) and outputs the average value to the output buffer (905) for outputting from the output device as data (1206).

In the above example, data is exchanged between the input device and the output device by using the input buffer (902) and the output buffer (905). The data may be transferred using parameters of a function of the communication program. In addition, exception processing such as value validity check when editing data and error message when check fails,
Performed in program parts. Processing commonly used between program components, such as error message display, may be called from within the program components as a common subroutine.

Further, complicated processing can be performed by adding the definition of component parameters to the input item specification definition information (113) and the output item specification definition information (114). For example, by giving a condition as a component parameter, it is possible to make a program component that totals and averages only data that meets the condition in FIG.

FIG. 1 is a flowchart showing a method for generating an information management program according to one embodiment of the present invention. In step (101), the user is asked to provide output item specification definition information (1
A system output item is selected based on 14). Details will be described later with reference to FIG. In step (102), the selected system output item and the output item specification definition information (1
14) to generate a database. Details will be described later with reference to FIG. In step (103),
Asks whether to automatically generate system input items,
If it is to be automatically generated, proceed to step (104); if not to be automatically generated (= selected by the user), step (108)
Proceed to.

In step (104), system input items are generated based on the input item specification definition information (113), the system output items, and the database. Here, when there are a plurality of candidates and the system input item cannot be uniquely determined, the process proceeds to step (105), and when all the system input items are determined, the process proceeds to step (120). Details will be described later with reference to FIG. In step (105), the user is caused to determine a system input item from among a plurality of candidates. Then, the process proceeds to step (120). Details will be described later with reference to FIG.

In step (108), the user is caused to select a system input item based on the input item specification definition information (113). Details will be described later with reference to FIG. In step (109), the consistency between the system input item and the system output item selected by the user is verified. If there is a contradiction, the process proceeds to step (110), and if there is no contradiction, the process proceeds to step (120). Details will be described later with reference to FIG. In step (110), a contradiction occurring between the system input item and the system output item is corrected.
If the system output item has been corrected, the process proceeds to step (116). If the system output item has not been corrected, the process proceeds to step (120). Details will be described later with reference to FIG. In step (116), the database is regenerated according to the corrected system output items. This database generation processing is performed in step 102
And will be described later with reference to FIG. Then, the process proceeds to step (120).

In step (120), an input program is generated based on the system input items, input item specification definition information (113), and program component library (115). Details will be described later with reference to FIG. Step (1
21), an output program is generated based on the system output items, the output item specification definition information (114), and the program component library (115). Details will be described later with reference to FIG.

The database generation step (10
2) a system input item automatic generation step (104)
Alternatively, it may be executed anywhere before performing the consistency verification step (109). Also, an input program generation step (120) and an output program generation step (1)
In 21), the order may be changed. Further, as a minimum configuration, when system input items are correctly given, generation or selection of system input items may not be performed. That is, steps (103, 104, 105,
108, 109, 110 and 116) may be omitted. This is a configuration that achieves the first object. Also,
When system input items are always automatically generated, it is not necessary to select system input items. In other words, steps (108, 109, 110 and 116 may be omitted. This is a configuration that achieves the first and second objects. Conversely, the user always selects system input items. In this case, it is not necessary to automatically generate system input items, that is, steps (104 and 105) may be omitted, which is a configuration that achieves the first and third objects. .

FIG. 13 is a flowchart showing details of the system output item selection step (101) in FIG. Before executing this system output item generation step (101), an empty system output item table (131)
0) is created in advance. In step (1301), the output item names defined in the output item specification definition information (114) are displayed in a list. In step (1302), the user is prompted to select whether or not to use one of the displayed output item names as a system output item. In step (1303), the step (1302) is repeated until the selection of adoption / non-employment is completed for all output item names, and when the selection is completed, the process proceeds to step (1304). In step (1304), the output item name selected to be adopted is registered in the system output item table (1310). Instead of the steps (1301, 1302, 1303), the user may read a file created in advance and select adoption / non-employment according to the contents.

FIG. 14 is a flowchart showing details of the database generation step (102, 116) in FIG. This database generation step (102, 1
An empty database (1490) is created before executing (16). In step (1401), one of the output item names registered in the system output item table (1310) is selected. In step (1402), output item specification definition information (114) that matches the selected output item name is searched. In step (1403), it is checked whether or not the storage table defined in the retrieved output item specification definition information (114) exists in the database (1490). If yes, go to step (1406). In step (1405), a storage table defined in the retrieved output item specification definition information (114) is created in the database (1490). Then, step (140)
Proceed to 6). In step (1406), it is checked whether the DB item name defined in the retrieved output item specification definition information (114) exists in the storage table,
If it does not exist, the process proceeds to step (1407). If it does exist, the process proceeds to step (1408). Step (14
07), the retrieved output item specification definition information (114)
Create a DB item with the DB item name defined in the storage table. Then, the process proceeds to step (1408). If a plurality of output item specification definition information (114) is retrieved in the step (1402), the steps (1403 to 1407) are repeated for all of them. In step (1408), the steps (1401 to 1407) are repeated for all output item names registered in the system output item table (1310).

FIG. 15 is a flowchart showing details of the system input item automatic generation step (104) in FIG. This system input item generation step (10
Before executing 4), an empty system input item table (1
590) and an input item candidate table (1591). In step (1501), one storage table is selected from the database (1490). In step (1502), one DB item name is selected from the selected storage tables. In step (1503), input item specification definition information (113) that matches the selected storage table and DB item name is searched. Input item specification definition information (1
13) is defined in advance so as to cover the storage table and DB item names appearing in the output item specification definition information (114), so that at least one or more input item specification definition information (11)
3) is searched. In step (1504), if there is a plurality of retrieved input item specification definition information (113), the process proceeds to step (1505).
Proceed to 6). In step (1505), the DB item name and the respective input item names of the plurality of input item specification definition information (113) searched for are registered in the input item candidate table (1591). Then, step (1)
Go to 507). In step (1506), the input item name of the retrieved input item specification definition information (113) is registered in the system input item table (1590). Then, the process proceeds to step (1507). Step (150
In 7), the steps (1502) to (1506) are repeated for all DB items in the storage table. In step (1508), the above steps (1501) to (1501) are executed for all the storage tables of the database (1490).
(1507) is repeated. If the input item candidate table (1591) is left empty, the step (12) in FIG.
0), and if not empty, to step (105) in FIG.

FIG. 16 is a flowchart showing details of the system input item determination step (105) in FIG. In step (1601), one of the DB item names registered in the input item candidate table (1591) is selected. In step (1602), a list of a plurality of input item names registered corresponding to the selected DB item name is displayed. In step (1603), the user is allowed to select one from a list of input item names. Step (1604)
Then, the selected input item name is registered in the system input item table (1590). In step (1605), the above-mentioned step (1601) is executed for all DB item names registered in the input item candidate table (1591).
To (1604) are repeated.

FIG. 17 is a flowchart showing details of the system input item selection step (108) in FIG. Before executing this system input item selection step (108), an empty system input item table (159)
0) is created in advance. In step (1701), input item names defined in the input item specification definition information (113) are displayed in a list. In step (1702), the user is caused to select adoption / non-employment for each of the displayed input item names. In step (1703), the above step (1702) is repeated until the selection of adoption / non-employment of all the displayed input item names is completed. When the selection is completed, the process proceeds to step (1704). In step (1704),
The name of the input item selected to be adopted is registered in the system input item table (1590). The step (17)
01, 1702, 1703), a user may read a file created in advance and select adoption / non-employment according to the contents.

FIG. 18 is a flowchart showing details of the consistency verification step (109) in FIG. Before executing the consistency verification step (109), an empty inconsistency DB item table (1890) is created. In step (1801), one storage table is selected from the database (1490). In step (1802), one DB item name is selected from the selected storage tables. In step (1803), input item specification definition information (113) that matches the selected storage table and DB item name is searched, and the input item name is obtained from the input item specification definition information (113). A search is made to see if the name is registered in the system input item table (1590). In step (1804), if the search result is “not found”, there is a shortage of system input items.
Go to 805). If the search result is "found", there is no shortage of system input items, and step (180)
Proceed to 6). In step (1805), the set of the selected storage table and the DB item name is stored in the inconsistent DB item table (18).
90). In step (1806), the above steps (1802) to (1805) are repeated for all the DB item names of the selected storage table. Step (1
In step 807), the steps (1801) to (1806) are repeated for all the storage tables. As described above, the consistency verification as to whether or not the system input items are insufficient can be performed. Then, the consistency verification as to whether or not the system input item names are redundant is similarly performed. In addition, since there is no actual harm even if the system input item name is redundant, it is not necessary to perform the consistency verification as to whether the system input item name is redundant.

FIG. 19 is a flowchart showing details of the contradiction correcting step (110) in FIG. In step (1901), the contradiction DB item table (189)
Select one of the pairs of the storage table and the DB item name registered in 0). In step (1902), output item specification definition information (114) that matches the selected storage table and DB item name is searched, and one or more output item specification definition information (114) is obtained from the obtained one or more output item specification definition information (114). An output item name is acquired, and one or more output item names registered in the system output item table (1310) are searched. In step (1903), input item specification definition information (113) that matches the selected storage table and DB item
And obtains one or more input item names from the obtained one or more input item specification definition information (113). In step (1904), the retrieved output item name and input item name are displayed, and the former is displayed in the system output item table (1).
310) or to add the latter (if there is more than one) to the system input item table (1590). In step (1905), the input item name is entered in the system input item table (159).
If the user selects to add to step (0), step (1)
If the user selects to delete the output item name from the system output item table (1310), the process proceeds to step (1907). In step (1906), the input item name is entered in the system input item table (159).
0). Then, the process proceeds to step (1908). In step (1907), the output item name is deleted from the system output item table (1310). In step (1908), the inconsistency DB item table (1890)
Steps (1901) to (1907) are repeated for all pairs of the storage table and the DB item name registered in. As described above, the inconsistency in which the system input items are insufficient is resolved. The inconsistency of extra system input is
The input item name is stored in the system input item table (159).
0) can be eliminated.

FIG. 20 is a flowchart showing details of the input program generation step (120) in FIG. In step (2001), one input item name is extracted from the system input item table (1590). In step (2002), input item specification definition information (113) that matches the extracted input item name is searched, and the name of the storage component is acquired from the input item specification definition information (113). In step (2003), the program part having the acquired name is extracted from the program part library (115), incorporated into an input program template (described later), and the input item name, storage table, and DB of the input item specification definition information (113) are obtained. Set the data input source and storage destination according to the item name. In step (2004),
Step (2001) for all input item names registered in the system input item table (1590)
To (2003) are repeated. As described above, an input program for inputting data can be generated.

FIG. 21 is a flowchart showing details of the output program generation step (121) of FIG. In step (2101), one output item name is extracted from the system output item table (1310). In step (2102), the output item specification definition information (113) that matches the extracted output item name is searched, and the name of the collection component is obtained from the output item specification definition information (114).
In step (2103), the program component having the acquired name is extracted from the program component library (115), incorporated into an output program template (described later), and the output item name, storage table, and DB of the output item specification definition information (114). Set the data storage source and output destination according to the item name. In step (2104),
Step (2101) for all output item names registered in the system output item table (1310)
To (2103) are repeated. As described above, an output program that outputs data can be generated.

FIG. 22 shows an example of an input program template. An input program can be generated by incorporating a program component between common pre-processing and common post-processing of input.

FIG. 23 shows an example of an output program template. An output program can be generated by incorporating a program component between common pre-processing and common post-processing of output.

-Other Embodiments- The input item specification definition information (113) is provided with an "input unit" column for grouping input items, and is used to specify a unit of data such as a screen, a window, and a communication message of the input device. It may be possible to express. Thereby, the system input item determination step (105), the system input item selection step (108) and the contradiction correction step (11) of FIG.
In 0), by grouping by input unit and presenting it to the user, selection by group unit becomes possible,
It is possible to reduce the burden of the user's selection work. In the input program generation step (120),
By generating an input program for each input unit,
An input program for each screen or communication message can be generated in a system that receives a plurality of screens or a plurality of communication messages, or a system that receives both a screen and a communication message. Similarly, an “output unit” column for grouping output items is provided in the output item specification definition information (114) so that data units such as screens, windows, and communication messages of an output device can be expressed. Good. As a result, in the system output item selection step (101) and the contradiction correction step (110) in FIG. 1, by grouping by output unit and presenting it to the user, selection by group unit becomes possible, and user selection is made. Work load can be reduced. In the output program generation step (121), an output program is generated for each output unit, so that a system that receives a plurality of screens or a plurality of communication messages, a system that receives both a screen and a communication message, etc. Output program can be generated.

The input item specification definition information (113) and the output item specification definition information (114) may be provided with a "discrimination" column for distinguishing whether the item is a required item or an optional item of the system. In this way, if the essential items are automatically selected and only the optional items are selected by the user, the burden of the user on the selecting operation can be reduced.

Also, in addition to or instead of the program parts, a specification part which is a fragment of the specification is prepared, and a specification in which a chapter of the specification or a fixed form document is described in addition to or instead of the program template is prepared. If a document template is prepared, a specification document can be generated in the same manner as in the above embodiment. In particular, it is useful for generating a specification of a program component.

[0055]

According to the information management program generating method and apparatus of the present invention, as long as the user selects system input items and system output items that can be understood by the end user, even if the user does not define the database items, It is possible to automatically generate an optimal database item and automatically generate a data input program and an output program. In addition, since the user is allowed to select a system input item using the input item specification definition information as a guide, the burden on the user to define the system input item can be reduced. In addition, database items are automatically generated based on system output items, system input items are automatically generated, and inconsistencies in system input items selected by the user are verified and corrected, ensuring consistency between items. it can.

[Brief description of the drawings]

FIG. 1 is a flowchart illustrating an information management program generation method according to an embodiment of the present invention.

FIG. 2 is a configuration diagram illustrating an information management program generation device according to an embodiment of the present invention.

FIG. 3 is a data structure diagram of a first example of input item specification definition information.

FIG. 4 is a data structure diagram of a second example of input item specification definition information.

FIG. 5 is a data structure diagram of a third example of input item specification definition information.

FIG. 6 is a data structure diagram of a first example of output item specification definition information.

FIG. 7 is a data structure diagram of a second example of output item specification definition information.

FIG. 8 is a data structure diagram of a third example of output item specification definition information.

FIG. 9 is an explanatory diagram of a first example of a program component.

FIG. 10 is an explanatory diagram of a second example of the program component.

FIG. 11 is an explanatory diagram of a third example of the program component.

FIG. 12 is an explanatory diagram of a fourth example of a program component.

FIG. 13 is a flowchart showing details of a system output item selection step.

FIG. 14 is a flowchart showing details of a database generation step.

FIG. 15 is a flowchart showing details of a system input item automatic generation step.

FIG. 16 is a flowchart showing details of a system input item determination step.

FIG. 17 is a flowchart showing details of a system input item selection step.

FIG. 18 is a flowchart showing details of a consistency verification step.

FIG. 19 is a flowchart showing details of a contradiction correcting step.

FIG. 20 is a flowchart showing details of an input program generation step.

FIG. 21 is a flowchart showing details of an output program generation step.

FIG. 22 is a view showing an example of an input program template;

FIG. 23 is an illustration of an output program template.

[Explanation of symbols]

1: computer main unit, 2: display device, 3: keyboard, 4: mouse, 5: printer, 6: external storage device,
7: CPU, 8: main storage device, 101: system output item selection step, 102: database generation step,
104: System input item automatic generation step, 105:
System input item determination step, 108: System input item selection step, 109: Consistency verification step, 11
0: contradiction correction step, 113: input item specification definition information, 114: output item specification definition information, 115: program component library, 116: database generation step, 120: input program generation step, 121: output program generation step.

Claims (15)

[Claims] 1. An information management program generating method for generating input / output programs for editing input data, storing the edited data in a database, extracting data from the database, editing and outputting the data, and may output the data. A system output item selecting step of allowing a user to select a system output item based on output item specification definition information that defines a relationship between a data item name, a storage location of the data, and a program component that edits and outputs the data; A database generation step of generating a database item based on the output item specification definition information and the selected system output item; an item name of data that may be input, a storage location of the data, and the data The user can edit and store the part based on the input item specification definition information that defines the relationship between the program parts. A system input item selecting step of selecting a stem input item; an input program generating step of generating an input program based on the input item specification definition information and the selected system input item and program component; An information management program generation method, comprising: an output program generation step of generating an output program based on definition information, the selected system output items, and program components. 2. An information management program generating apparatus for editing input data, storing the edited data in a database, and generating an input / output program for extracting, editing, and outputting the data from the database. Output item specification definition information storage means for storing output item specification definition information defining a relationship between a data item name, a storage location of the data, and a program component for editing and outputting the data; and data that may be input. Input item specification definition information storage means for storing input item specification definition information that defines the relationship between the item name of the item, the storage location of the data, and the program part that edits and stores the data; and based on the output item specification definition information. Output item selection means for allowing a user to select a system output item, the output item specification definition information, and the system Database generation means for generating database items based on input items; system input item selection means for allowing a user to select system input items based on the input item specification definition information; and An output program generating means for generating an output program based on the selected system output items and program components; and an input program based on the input item specification definition information and the selected system input items and program components. An information management program generating apparatus, comprising: an input program generating means for generating a program. 3. The information management program generation method according to claim 1, wherein input item specification definition information corresponding to the item of the database is searched, and if only one is found, a system input item is determined based on the input item specification definition information. Automatically generating a system input item, and searching for input item specification definition information corresponding to the item in the database, and when a plurality of input item specification definition information are found, the user is allowed to select one of the input item specification definition information, and the system is based on the selected item. A system input item determining step of determining an input item. 4. The information management program generation device according to claim 2, wherein the input item specification definition information corresponding to the item of the database is searched, and if only one is found, the system input item is determined based on the input item specification definition information. A system input item automatic generation means for automatically generating the input item specification definition information corresponding to the item of the database, and when a plurality of input item specification definition information are found, the user is allowed to select one of the input item specification definition information and the system is selected based on the selected item. An information management program generating apparatus, comprising: a system input item determining means for determining an input item. 5. The information management program generation method according to claim 1, wherein: a consistency verification step for verifying consistency between the database item and a system input item selected by the user; And an inconsistency correcting step for allowing a user to correct the inconsistency in the information management program. 6. The information management program generation device according to claim 2, wherein: a consistency verification unit that verifies consistency between the database item and a system input item selected by the user; And an inconsistency correcting means for causing a user to correct the inconsistency in the information management program. 7. The information management program generating method according to claim 1, wherein the input item specification definition information includes information on grouping of data, and the system input item selecting step includes the step of selecting one group. And a plurality of data belonging to the input unit can be selected as an input unit, and the input program generating step can generate an input program for each of the input units. 8. The information management program generation device according to claim 2, wherein the input item specification definition information includes information on data grouping, and the system input item selection unit includes one group. An information management program generation device, wherein the input program generation unit is a unit that can generate an input program for each of the input units. 9. The information management program generating method according to claim 1, wherein the output item specification definition information includes information on data grouping, and the system output item selecting step includes: An information management program generating method, wherein a plurality of data belonging to one group can be selected as an output unit, and the output program generating step can generate an output program for each output unit. 10. The information management program generation device according to claim 2, wherein the output item specification definition information includes information on data grouping, and the system output item selection unit includes: Information management program generation means for selecting a plurality of data belonging to one group as an output unit, wherein the output program generation means is a means capable of generating an output program for each of the output units. apparatus. 11. The information management program generation method according to claim 1,5, 7, or 9, wherein the input item specification definition information includes information on whether data is required or optional. An information management program generating method, wherein the system input item selecting step automatically selects essential data and allows the user to select only optional data. 12. The information management program generation method according to claim 1, wherein the output item specification definition information and the input item specification definition information require data as an option. The system output item selecting step automatically selects essential data and allows a user to select only optional data, and the system input item selecting step automatically includes essential data. An information management program generating method characterized in that a user selects only optional data beforehand. 13. The information management program generation device according to claim 2, wherein the output item specification definition information and the input item specification definition information are data required or optional. The system output item selecting means is a means for automatically selecting essential data and allowing a user to select only optional data, and wherein the system input item selecting step comprises the steps of: An information management program generating apparatus characterized in that the means is a means for automatically selecting and allowing a user to select only optional data. 14. The information management program generating method according to claim 1, claim 3, claim 5, claim 7, claim 9, claim 11, and claim 12, wherein a specification document is used instead of the program component. An information management program generation method characterized by using a specification part, which is a fragment of the above, and having a specification output step of generating a specification instead of the output program generation step. 15. The information management program generating apparatus according to claim 2, claim 4, claim 6, claim 8, claim 10, and claim 13, wherein the specification is provided in addition to or instead of said program component. An information management program generating apparatus, comprising: a specification part which is a fragment of a specification; and a specification output means for generating a specification in addition to or instead of the output program generating means.