JP2000194548A - Device and method for generating operation environment of software and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To securely achieve consistency between a data base in a system and an application program which uses it by automatically generating an on-line AP and a data base from one specification definition document. SOLUTION: An automatic generation part 2 is provided which generates a program and a data base according to an AP specification definition document 1 wherein flows of data needed for processes of a program run on the system are defined for each data and specification information regarding movement sources and destinations and process conditions is defined for each data needed for the processes of the program; and the program and data base are automatically generated according to the specification information and then one specification definition is only done in conformity with the data flow of a target program, so that the program and data base that the program uses can automatically be generated from the one piece of specification information.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a software operating environment generating apparatus and method, and a recording medium storing a program for realizing the software operating environment generating method, and more particularly to a program necessary for operating application software on a computer. This is suitable for use in an apparatus and a method for automatically generating a database and a database (these are called operating environments).

[0002]

2. Description of the Related Art Normally, in order to run software (application) on a computer, it is necessary to generate a program defining an algorithm of the software. Further, depending on the contents of the software, it may be necessary to generate a database for storing various data used by the program. Traditionally, these programs and databases
Often created by each developer separately.

In this case, a program is created based on a design specification for the program, and a database is created based on the design specification for the database. The design specification for a program defines, for example, an algorithm of what functions the program has and how to realize those functions. The design specification for the database is created by, for example, defining what items are required in a relational database (RDB) in a tabular format and what data is to be put in each item. is there.

Conventionally, these programs and databases have been created manually by a developer in accordance with their respective design specifications, but recently, with the aim of improving their work efficiency. Various automatic generation tools have been proposed. For example, a tool for automatically generating the source code of a program from a diagram notation that describes the branching of a program and the contents of data processing according to it, and a table in a relational database from data normalized for the database Tools have been proposed for automatically generating.

[0005]

However, the above-described tool for generating a program and the tool for generating a database have been provided independently of each other and completely independently of each other. Therefore, even when these automatic generation tools are used, a program and a database used by the same software are created separately. Therefore, inconsistencies and inconsistencies are included between the created program and the database, and the inconvenience that the application does not operate well as one application on the computer has often occurred.

In particular, for the convenience of the organization or operation of software development, the creation of a program and the creation of a database are often performed by separate developers. In this case, there is a problem that the possibility of inconsistency or inconsistency between the created database and the program using the database increases.

A tool for automatically generating a program and a database from one specification definition document is disclosed in Japanese Patent Application Laid-Open No. 10-40089 as a data migration program generation method. According to the method described in this publication, a relational database (table) used on an online system on which an application operates and a program for migrating data in the database from a host computer are generated from one specification definition document. are doing.

FIG. 6 is a schematic diagram for explaining the data migration program generation method described in the above publication. In FIG. 6, the migration specification definition document 101 enumerates and defines all the item names necessary for the relational database to be generated, and also fetches what data (Host data) of which file in the host computer. , Which defines transition information relating to From-To in which item of the table on the database is to be entered.

The automatic generation unit 102 firstly executes a data migration program 103 based on a predetermined method in accordance with From-To information and the like in the migration specification definition 101 described.
a or 103b is generated. At this time, one data migration program is generated from one migration specification definition document, and the two data migration programs 103a,
103b is generated from different migration specification definitions. Next, necessary information such as To information is extracted from the migration specification definition document 101, and a destination file of Host data, which is a table of a relational database, is designated.

Next, the automatic generation unit 102 uses the generated data migration program 103a or 103b to execute the host data 104a in the host computer.
Alternatively, 104b is moved to RDB data 105a or 105b in the relational database.
At this time, one data migration program 103a
The host data 104a is migrated to the RDB data 105a to generate one table, and the other data migration program 103b migrates the host data 104b to the RDB data 105b to generate another table.

However, the program generated by the data migration program generation method described in this publication is
It is not an application (online AP) running on the online system itself, but a data migration program for generating a database used for the online AP. It is a program that simply migrates data in the host computer to the database. is there. That is, even when the method described in this publication is used, the online APs 106a and 106b operating on the online system still need to be created separately from the database.

Since the database is used in the online AP, the contents of the database are
Depends on the contents of P. Therefore, it is necessary to generate the database in accordance with the design of the online AP.
Therefore, when describing the migration specification definition document 101, it is necessary to enumerate all items necessary for generating a database corresponding to the online APs 106a and 106b while being aware of them.

However, as described above, the online AP
Creators and database creators are often different.
Therefore, an online A created by another person
In practice, it has been extremely difficult to create a database by describing the migration specification definition document 101 so that inconsistencies and inconsistencies do not occur between the P106a and 106b.

A data migration program 103 generated by the data migration program generation method described in the above publication
In a and 103b, all Host data 104a and 104b described as items in the migration specification definition document 101 are unconditionally migrated to create a relational database table.

However, actually, the online AP 10
When 6a and 106b operate, the data used by the program changes according to the conditions of the running process. Therefore, in a so-called static conversion logic that is separated from the online system, such as unconditionally migrating the predetermined Host data and generating a database as described above, the generated database does not correspond to the actual process operation. There was also a problem that it became loose.

Further, in the data migration program generation method described in the above publication, one data migration program is generated from one migration specification definition document, and one relational database table is generated using the data migration program. Has become. Further, the host data is to be migrated only to one certain table, and the file of the host data and the table of the database have a ratio of 1: 1 or n:
1 relationship.

Therefore, when there are a plurality of databases to be used on the online system, it is necessary to describe the migration specification definition document 101 for each database and to generate different databases respectively, which is a cause of impairing work efficiency. Had become. Further, the data migration program generation method described in the above publication is for automatically generating a database from a migration specification definition document, and there has been no means for automatically generating an online AP from a specification definition document.

The present invention has been made in order to solve the above problems, and an application operating on an online system and a database used by the online AP can be automatically generated from one specification definition. By doing so, a first object is to ensure consistency between a database in a system and an application program that uses the database.

It is a second object of the present invention to be able to generate an appropriate database according to the process of an online AP process running on a system.
Further, the present invention aims to improve the efficiency of system maintenance work by enabling the creation of one online AP and a plurality of databases used by the online AP from the same specification definition. This is the purpose of 3.

[0020]

According to the present invention, there is provided a software operating environment generating apparatus for storing specification information on a source and a destination of data required for processing of a program operating on a system and processing conditions of the data. It is characterized by comprising a specification definition means for defining, and a program generation means for generating the program based on the specification information defined by the specification definition means.

According to another aspect of the present invention, there is provided specification definition means for defining specification information relating to a migration source and a migration destination of each data necessary for processing of a program running on the system and processing conditions of each data, A program generating unit configured to generate the program based on the specification information defined by the specification defining unit; and a program generating unit configured to execute the program based on information regarding a migration destination of the data among the specification information defined by the specification defining unit. Database generating means for generating a database used on the system.

Here, the program generation means extracts, for example, the specification information defined by the specification definition means, and analyzes the specification information extracted by the extraction means to obtain a data processing algorithm. An analysis unit; and a generation unit configured to generate the program based on a result of the analysis by the analysis unit. Further, the database generation means may include, for example, extraction means for extracting information on the data migration destination from the specification information defined by the specification definition means for each unit designated as the migration destination, Analyzing means for analyzing the information extracted for each unit by means and deleting duplicate information,
Generating means for generating the database using an analysis result by the analyzing means. In this case, a plurality of different databases may be defined as a unit to which the data is migrated.

In the software operating environment generating apparatus having the above configuration, the specification information defined by the specification defining means includes the type of the transfer source data (for example, data stored in a table or subroutine). May be further included. Further, the information on the data processing conditions may include at least information on data extraction conditions and processing conditions. Further, the information on the data processing conditions may further include information on conditions before data extraction and conditions after processing. Further, the information on the processing condition of the data may further include information on designation of initialization of the original data.

In the method for generating a software operating environment according to the present invention, there is provided a definition step for defining specification information on a source and a destination of each data required for processing of a program running on the system and processing conditions of each data. And a program generation step of generating the program based on the specification information defined in the definition step.

According to another aspect of the present invention, there is provided a definition step for defining specification information on a source and a destination of each data required for processing of a program running on the system and processing conditions of each data, A program generation step of generating the program based on the specification information defined in the above, and among the specification information defined in the definition step, based on information regarding a destination of the data, the program is executed on the system. Generating a database to be used.

Here, the program generating step includes:
For example, an extraction step of extracting the specification information defined in the definition step, an analysis step of analyzing the specification information extracted in the extraction step to obtain a data processing algorithm, and an analysis result of the analysis step. And a generating step of generating the program based on the program. Further, the database generation step includes, for example,
An extraction step of extracting information on the destination of the data from the specification information defined in the definition step for each unit designated as the destination, and extracting the information for each unit in the extraction step An analysis step of analyzing information to delete duplicate information, a first generation step of generating a program for generating the database using the analysis result of the analysis step, and a first generation step of And a second generation step of generating the database in accordance with the database generation program generated as described above.

Further, a computer-readable recording medium according to the present invention is characterized in that a program for causing a computer to function as each means according to any one of claims 1 to 4 is recorded. According to another aspect of the present invention, a program for causing a computer to execute the processing procedure of the software operating environment generating method according to any one of claims 11 to 14 is recorded.

[0028]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a schematic block diagram for explaining the configuration and operation of the software operating environment generation device according to the present embodiment.

In FIG. 1, the AP specification definition document 1 contains information on what data is used as data required by a program of an application (online APs 4a and 4b) operating on the online system 3 and information used by the program. In addition to information on From-To that defines information on where to transfer data in the database, information on processing conditions of the data is defined. The processing conditions include at least information on data extraction conditions and processing conditions.

In the conventional data migration program generation method shown in FIG. 6, the migration specification definition document 101 consciously considers the relational database to be generated and lists all necessary items. Only the migration information that indicates which data on the host computer is to be migrated to which table in the database and where is to be migrated.

On the other hand, the AP specification definition document 1 of the present embodiment reads out what data in the online system 3 under what conditions and considers only the application running on the online system 3 under what conditions. In this way, a series of processes such as where to process and move to where is defined for each piece of data used in the application. That is, the AP specification definition document 1 of the present embodiment
Is equivalent to a request definition that defines how to flow each data used in the programs of the online APs 4a and 4b.

FIG. 2 is a diagram showing an example of the AP specification definition document 1. As shown in FIG. 2, the AP specification definition document 1 of the present embodiment defines various information in a table format.
Define using Excel. In this case, the example of FIG. 2 shows the input screen of the AP specification definition document 1 itself. In each row of the table shown in FIG. 2, From-To for one piece of data and information about processing conditions are input.

In the online APs 4 a and 4 b operating on the online system 3, the From information about which data is to be extracted (read out) is “generation source (F
rom) ". The content defined in this column uniquely indicates the source of the data used in the online APs 4a and 4b, but the "source"
Is displayed because the content of this column becomes the original information when the databases 5a and 5b are generated later. In addition, To information indicating where the read data is to be transferred is defined in a column where “generation destination (To)” is displayed.
The reason why "generation destination" is displayed is that the content defined in this column also becomes the original information when the databases 5a and 5b are generated later.

The data as the "generation source" can be broadly classified into two types: data stored in a table and data generated by a program component such as a subroutine. The table refers to tables 6a and 6b storing various data existing on the online system 3, as shown in FIG. This table 6
When data is extracted from a and 6b, which item in which table to extract data from is defined by information such as a table name, an item name, and a unit. When extracting data generated by a program component, a target component name is defined instead of the information such as the table name, item name, and unit.

As described above, the data to be extracted in this embodiment is data that actually exists on the online system 3, and is not data that exists in another host computer or the like. Here, the data to be extracted is in table 6
Although an example in which the data is stored in a and 6b is shown, as long as the data can be uniquely specified, the data need not necessarily be stored in the table in an orderly manner. Also, depending on the contents of the application, the target to be extracted may be host data.

Tables 6a and 6 instead of program parts
In the case of extracting data from the area b, processing conditions such as the conditions under which the data is extracted and how the data is processed are further defined. The extraction condition here defines what condition data is to be extracted, for example, such as extracting the latest value from some data counted from a designated read start point. Also, the processing conditions are, for example, what kind of processing (for example, calculation of total value, calculation of average value,
(Maximum value selection, minimum value selection, etc.).

The data processing conditions defined in the present embodiment are determined according to the contents of the online APs 4a and 4b to be generated. A simple program may have at least the extraction conditions and processing conditions shown in FIG. 2, but a more complicated program may have the pre-extraction conditions, post-processing conditions, and initial data initial conditions shown in FIG. Preferably, at least one of the designations is further defined according to the contents of the program. Hereinafter, each of these processing conditions will be described.

As shown in FIG. 1, the programs automatically generated in this embodiment are the online APs 4a and 4b actually operating on the online system 3, and the offline APs 4a and 4b are separated from the online system as shown in FIG. Is not a data migration program. This online AP4
The data (data to be extracted) used in a and 4b dynamically changes in accordance with the condition of the running process, so that the same data need not be read in a certain state, that is, the database 5a. , 5b need not be transferred.

Therefore, in the present embodiment, in what state data is extracted or not to be extracted (external state around the extraction) is defined as "pre-extraction condition". . In the example of FIG. 3, a condition indicating a predetermined state with respect to certain data and each piece of information specified when the condition is not satisfied indicating an operation when the condition is not satisfied are defined.

The conditions such as whether the result of processing the data according to the processing conditions shown in FIG. 2 is correct, whether the data can be used normally in the subsequent data processing, and the operation according to the conditions are described. "Post-processing conditions"
Is defined as Similarly to the pre-extraction condition, the post-processing condition defines a condition indicating a predetermined state of the processed data and non-satisfied designation information indicating an operation when the condition is not satisfied. Has become.

Further, depending on the contents of the online APs 4a and 4b, the data once extracted may not be necessary any more. For example, when performing a process of sequentially calculating the total value of a plurality of data given within a certain period for each period, if the total value of a certain period is obtained and output, the value is set to “0”.
Must be initialized for the next period.
Thus, in the column of “original data initialization designation”, conditions for performing such initialization are defined.

As described above, in this embodiment, in addition to the From-To information of data, information of processing conditions including extraction conditions, processing conditions, pre-extraction conditions, post-processing conditions, original data initialization designation, and the like. Is defined. This is because the online AP 4a, which actually operates on the online system 3,
Regarding the processing of 4b, it is determined whether or not to read out certain data according to a defined condition, and if it is read out, it is appropriately processed, and further, the validity of the processing result is determined. This is equivalent to defining the program flow itself in 4b on a table. In other words, this corresponds to defining the specifications of the online APs 4a and 4b in a table format.

The automatic generation unit 2 shown in FIG. 1 uses the online APs 4a, 4a based on the contents of the AP specification definition 1 described.
b and the databases (tables) 5a and 5 used by it
b is automatically generated. Each of the two databases 5a and 5b generated here is, for example, a set of data that should belong to the same group. FIG. 1 shows a state in which two online APs and two databases are generated, but the automatic generation unit 2 according to the present embodiment.
Generates one online AP and N (N = 1, 2,...) Databases (tables) from one AP specification document. It is also possible to extract table items to be generated from a plurality of AP specification definition documents and generate N (N = 1, 2,...) Databases (tables) collectively.

For example, two online APs 4a and 4b
In some cases, data AE of the same group belonging to one database (table) 5a may be used mutually. In this case, items required for the database 5a cannot be created unless the two AP specification definitions 1a and 1b defined for the online APs 4a and 4b are combined. For example, one of the online APs 4a uses data A, B, and C,
Assuming that data D and E are used in P4b, the automatic generation unit 2 sends two AP specification definitions 1a and 1b to A to
The item of E is extracted to generate one database 5a.

Further, if the other online AP 4b also uses data of X, Y, and Z belonging to a group different from the data of the above-mentioned A to E, the automatic generation unit 2 generates the AP specification definition 1b for the online AP 4b. X, Y, Z items are extracted from the other database 5b.
Is also generated at the same time.

The flow of the process performed by the automatic generation unit 2 will be described below with reference to FIG. First, on-line APs 4a and 4b are generated by analyzing the information in accordance with the described information in the AP specification definition document 1, that is, From-To information of data and information of processing conditions. Here, one online AP 4a is created from one AP specification definition 1a, and the other online AP 4b is created from the other AP specification definition 1b.

As described above, in the present embodiment, the conditions under which the online APs 4a and 4b can be actually generated
Since it is created in the P specification definition 1, by analyzing the contents of the AP specification definition 1, the online A
The algorithm of the data processing in P4a, 4b can be easily grasped, and those programs can be automatically generated. Therefore, by changing the definition information of the AP specification definition document 1 in various ways, it is possible to easily generate an online AP under various conditions.

Next, the automatic generation unit 2 executes the AP specification definition 1
The tables of the databases 5a and 5b are generated based on the To information described in (1), that is, the information on the data migration destination. More specifically, first, the To information is analyzed to create a table generation program. Then, using the created table generation program, A
Necessary information is extracted from the P specification definition document 1, and a data transfer destination frame called a table of the databases 5a and 5b is generated.

Further, the previously generated online AP 4
a, 4b are the tables 6 in the online system 3
Data on a, 6b is read out according to predetermined conditions, processed as needed, and
Move to the table. As described above, the data transfer is performed by the online A generated based on the AP specification definition document 1.
Since the transfer is performed by P4a and P4b, the data to be migrated dynamically fluctuates according to the conditions defined in the AP specification definition document 1.

FIG. 4 is a block diagram showing a specific configuration of the automatic generation unit 2 and a flow of data. In FIG. 4, solid arrows indicate the flow of processing, and dotted arrows indicate the flow of data. A block 10 surrounded by a large square in the automatic generation unit 2 indicates an automatic generation unit of a database, and the other blocks indicate an automatic generation unit of an online AP.

The AP specification definition unit 11 shown in FIG. 4 is an AP specification definition document 1 as exemplified in FIGS. 2 and 3, that is, a specification definition document 1 focusing on the data flow of an online AP.
Is input on a sheet of MS-Excel, for example. The format conversion unit 12 executes an Excel based on information of a predetermined conversion rule 13.
By converting the AP specification definition document 1 described in the l format into a format in which subsequent processing can be easily performed, a format-converted AP specification definition document 1 'is generated.

When automatically generating an online AP, the information extracting unit 14 extracts necessary information from the AP specification definition 1 '. This extraction processing is performed based on the information of the predetermined extraction rule 15. When an online AP is generated, basically all the information described in the AP specification definition document 1 'is extracted. The information of the extraction result 16 obtained as described above is provided to the information analysis unit 17.

The information analysis unit 17 determines what the data flow described in the AP specification definition document 1 is based on the From-To information and the processing conditions of each data included in the extraction result 16, that is, Analyze the specifications of the online AP. The information of the analysis result 18 is
This is given to the AP source automatic generation unit 19. The AP source automatic generation unit 19 generates an online AP source code (AP source) 20 based on the information of the given analysis result 18.
Generate Further, the compiler & linker 21 generates an AP execution module 22 by executing compilation and linking of the generated AP source 20.

On the other hand, when automatically generating a table in the database, necessary information is extracted from the AP specification definition document 1 'by the information extraction unit 24 based on the information of the predetermined extraction rule 25. When the database is generated, basically, To information indicating a data transfer destination is extracted from each information described in the AP specification definition document 1 '. The information of the extraction result 26 is stored in the information analysis unit 2
7 given.

The information analysis unit 27 analyzes whether or not there is a duplicate item based on the To information of each data included in the extraction result 26, and performs a process of narrowing down to only necessary information. . The information of the analysis result 28 is stored in the table registration AP.
It is provided to the automatic generation unit 29. The table registration AP automatic generation unit 29 generates a program (AP) 30 for automatically generating a database table based on the information of the analysis result 28 given. Further, the table registration unit 31 generates the database (RDB) 32 by executing the generated table generation program 30.

The AP execution module 22 of the online AP generated as described above executes a task 23 defined in the online AP as needed, thereby obtaining a table (not shown in FIG. 4) (table 6a in FIG. 1). , 6b) is read out according to the conditions defined in the AP specification definition document 1, processed as necessary, and transferred to a table in the database 32. When necessary, data is read from the database 32 and set as a processing target of the task 23.

Next, the processing contents of the database automatic generation unit 10 shown in FIG. 4 will be described with reference to a specific example shown in FIG. FIG. 5 shows two online APs that perform a predetermined process (for example, a process for preparing a process plan in the blast furnaces X and Y) for the two blast furnaces X and Y in the iron making process.
It is assumed that the system uses two databases having table names of blast furnaces A and B, respectively.

As shown in FIG. 5, first, an AP focusing on the data flow of an online AP to be created
The specification definition (data flow definition) 1 is input on, for example, a sheet of MS-Excel of Microsoft Corporation.
Here, two AP specification definitions 1 are created by defining the data extraction source, transfer destination, processing conditions, and the like for each online AP for the blast furnace X and the blast furnace Y.

Since the AP specification definition document 1 entered here only defines what the data flow of the online AP is, the form of the database required for the processing of the online AP should be determined. Things are not yet visible at this stage. In other words,
The user can define the AP specification definition document 1 with no consciousness of a database at all and only with what kind of data flow is desired to be created as an online AP.

The format conversion unit 12 converts the format of these two AP specification definitions 1 into an AP specification definition 1 ′. Then, necessary information is extracted by the information extracting unit 24 from each of the format-converted files. At the time of this extraction, only the To information of the data (information on the table of the blast furnace A and the table of the blast furnace B to which the data is to be transferred) is to be extracted. Further, the extraction of the To information is performed so as to be divided for each destination table as shown in FIG.

That is, as described in the AP specification definition document 1, the online AP for the blast furnace X and the online AP for the blast furnace Y both have data (ITEM_A, ITEM_B, ITEM_C) belonging to the table of the blast furnace A. And data belonging to the table of blast furnace B (ITEM_X, ITEM_Y, ITEM_
Z). Therefore, the format-converted A
The blast furnace A is included in each file of the P specification definition 1 '.
And the items related to the table of the blast furnace B are mixed. When the necessary information is extracted by the information extraction unit 24, the extraction is performed such that the item related to the blast furnace A and the item related to the blast furnace B are separated from each other.

Next, the information analysis unit 27 performs a predetermined analysis on the extraction result 26 for each table. Here, the sorting process is performed using the item name as a key for each table, and when the same item is duplicated, the process is performed to reduce the number to one, so that the analysis result 28 shown in FIG. Get the information. The information of the analysis result 28 is given to the table registration AP automatic generation unit 29, and a program 30 for automatically generating a database table relating to the blast furnace A and the blast furnace B is generated. Further, the table registration unit 31 executes the generated table generation program 30 to generate a database (RDB) 32.

As described above in detail, according to the present embodiment, it is only necessary to define the specification information on the extraction source and migration destination of each data used in the online AP and the processing conditions of the data in the form of a table. Online APs can be automatically generated. Here, the object to be generated is not the data migration program separated from the online system as shown in FIG. 6, but the application that actually runs on the online system.

Conventionally, some automatic program generation tools have been proposed. These tools automatically generate a source code from an if-then diagram notation, or are combined with several program parts to form one large program. This is merely a program that generates a program or a program that can be visually generated using a GUI or the like, and does not automatically generate a program from specification definition information as in the present embodiment.

Therefore, according to the software operating environment generating apparatus of the present embodiment, the online AP itself can be generated by a very simple operation.
Also, if you want to change the contents of the program, such as upgrading the version of the application, the upgraded application is automatically generated just by modifying the specification definition information, not the program itself. Maintenance including the above can be performed efficiently.

Further, according to the software operating environment generating apparatus of the present embodiment, not only the online AP but also the database table used in the online AP can be automatically generated from the same AP specification definition. . At that time, a plurality of tables can be simultaneously generated from one definition information. That is, as long as the data flow is defined in consideration of the online AP to be created, even if the database used in the online AP is completely unknown, the online AP and its definition can be obtained from the one definition. Online A
The database used by P can be automatically generated.

Thus, an online AP and a database operating on the online system can be generated extremely easily, and the efficiency of system development can be significantly improved. In addition, since the online AP and the database are generated from the same AP specification definition, it is possible to ensure that they are consistent and consistent with each other, and to improve the efficiency of system maintenance work. Can be.

Further, in the present embodiment, when defining the AP specification definition document, it is sufficient to define only information on data necessary for the online AP while being aware of the online AP. There is no need to perform such a troublesome operation as listing all necessary items. Therefore, the work itself when defining the AP specification definition document can be easily performed.

The data to be transferred to the database table automatically generated from the AP specification definition defined in this way fluctuates according to the processing conditions defined in the AP specification definition. Since the data is not assumed fixed data, it is possible to generate an appropriate database according to the movement of the process of the application actually running on the system.

Note that the software operating environment generating apparatus according to the present embodiment described above uses the computer CP.
It is composed of a U or MPU, a RAM, a ROM, and the like, and can be realized by operating a program stored in the RAM or the ROM. Therefore, the present invention can be realized by recording a program that causes a computer to perform the above functions on a recording medium such as a CD-ROM, and reading the program into the computer. In addition to the CD-ROM, a floppy (registered trademark) disk, a hard disk, a magnetic tape, a magneto-optical disk, a nonvolatile memory card, and the like can be used as the recording medium.

The functions of the above-described embodiments are realized when the computer executes the supplied program, and the OS (operating system) or other application software running on the computer. When the functions of the above-described embodiment are realized in cooperation with the computer, or when all or a part of the processing of the supplied program is performed by a function expansion board or a function expansion unit of a computer, the functions of the above-described embodiment are realized. Such a program is also included in the embodiment of the present invention.

The shapes and structures of the respective parts shown in the above embodiments are merely examples of the embodiment for carrying out the present invention, and the technical scope of the present invention is limited by these. It must not be interpreted in a way. That is, the present invention can be embodied in various forms without departing from the spirit or main features thereof.

[0073]

As described above, the present invention defines the specification information on the source and destination of each data required for processing of the program running on the system and the processing conditions of each data, and based on the definition information, The program is generated automatically, so the target program can be created simply by defining the source and destination of the data and the processing conditions of the data in a form that matches the data flow, taking into account the program to be generated. Can be generated automatically. Therefore, it is possible to generate a program of an application running on the online system by a very simple operation.

According to another feature of the present invention, specification information on a source and a destination of each data necessary for processing of a program running on the system and processing conditions of each data is defined, and the definition information is defined. In addition to automatically generating a program based on the data, and automatically generating a database to be used on the system based on the definition information on the data migration destination, As long as the flow is defined, the program and the database can be automatically generated from the one definition without knowing what the database used in the program is.

As a result, an application program running on an online system and a database used by the application program can be generated very easily, and the efficiency of system development can be significantly improved. Also,
It is possible to guarantee that the program and the database are consistent and consistent with each other, and it is also possible to increase the efficiency of system maintenance work.

Further, according to the present invention, when inputting the definition information, if the information relating to the data required by the program is defined by considering the target program, the database to be used is assumed in advance and the necessary items are defined. Is unnecessary, and the operation itself when inputting the definition information can be easily performed. In addition, by generating a database based on the definition information created according to the data flow of the program, it is possible to generate an appropriate database according to the movement of the process of the application actually running on the system.

[Brief description of the drawings]

FIG. 1 is a schematic block diagram illustrating the configuration and operation of a software operating environment generation device according to an embodiment.

FIG. 2 is a diagram illustrating an example of an AP specification definition document according to the embodiment;

FIG. 3 is a diagram illustrating an example of an AP specification definition document according to the embodiment;

FIG. 4 is a block diagram showing a specific configuration of an automatic generation unit and a data flow.

FIG. 5 is a diagram for specifically explaining the processing contents of an automatic database generation unit;

FIG. 6 is a schematic block diagram for explaining a conventional data migration program generation method.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 AP specification definition document 1a, 1b AP specification definition document 2 Automatic generation part 3 Online system 4a, 4b Online AP 5a, 5b Database 6a, 6b Table 11 AP specification definition part 14 Information extraction part 17 Information analysis part 19 AP source automatic generation Part 21 compiler & linker 24 information extraction part 27 information analysis part 29 table registration AP automatic generation part 31 table registration part 32 database

Claims (16)

[Claims] 1. A specification definition means for defining specification information on a source and a destination of each data required for processing of a program running on a system and processing conditions of each data, and a definition by the specification definition means. And a program generating means for generating the program based on the generated specification information. 2. A specification defining means for defining specification information on a source and a destination of each data required for processing of a program running on a system and processing conditions of each data, and the specification definition means. A program generating means for generating the program based on the specified specification information; and a database used by the program on the system based on information on a migration destination of the data among the specification information defined by the specification defining means. And a database generation unit for generating a software operating environment. 3. The program generating means includes: an extracting means for extracting specification information defined by the specification defining means; and an analyzing means for analyzing the specification information extracted by the extracting means to obtain a data processing algorithm. 3. The software operating environment generation device according to claim 1, further comprising: a generation unit configured to generate the program based on a result of the analysis by the analysis unit. 4. The extraction means for extracting, from the specification information defined by the specification definition means, information on a migration destination of the data for each unit designated as the migration destination, An analysis means for analyzing the information extracted for each unit by the extraction means to delete duplicate information, and a generation means for generating the database using an analysis result by the analysis means. Item 3. An operating environment generating device for software according to item 2. 5. The software operating environment generating apparatus according to claim 4, wherein a plurality of different databases can be defined as a unit to which the data is migrated. 6. The specification according to claim 1, wherein the specification information defined by the specification definition unit further includes information on a type of the data of the migration source.
An operating environment generation device for software according to the section. 7. The software operating environment generating apparatus according to claim 6, wherein the information on the type of the data of the migration source is a type of data stored in a table or data obtained by a subroutine. . 8. The software operating environment according to claim 1, wherein the information on the data processing condition includes at least information on a data extraction condition and a processing condition. Generator. 9. The software operating environment generating apparatus according to claim 8, wherein the information on the processing conditions of the data further includes information on conditions before data extraction and conditions after processing. 10. The software operating environment generation apparatus according to claim 8, wherein the information on the data processing condition further includes information on designation of initialization of the original data. 11. A definition step for defining specification information on a source and a destination of each data required for processing of a program running on the system and processing conditions of each data, and a specification defined in the definition step. A program generating step of generating the program based on the information. 12. A definition step for defining specification information relating to a source and a destination of each data required for processing of a program running on the system and processing conditions of each data, and a specification defined in the definition step. A program generating step of generating the program based on the information; and a database used by the program on the system based on information on a migration destination of the data among the specification information defined in the defining step. A software operating environment generating method, comprising a database generating step. 13. The program generating step includes: an extracting step of extracting specification information defined by the defining step; an analyzing step of analyzing the specification information extracted in the extracting step to obtain a data processing algorithm. 13. The software operating environment generating method according to claim 11, further comprising a generating step of generating the program based on an analysis result in the analyzing step. 14. The database generating step includes: extracting information on a destination of the data from the specification information defined in the defining step for each unit designated as the destination; An analysis step of analyzing information extracted for each unit in the extraction step to delete duplicate information, and a first program for generating a program for generating the database using the analysis result in the analysis step A generating step; and a second generating the database according to the database generating program generated in the first generating step.
13. A generating step of:
Software operating environment generation method described in 1. 15. A computer-readable recording medium on which a program for causing a computer to function as each of the means according to claim 1 is recorded. 16. A computer-readable recording medium on which a program for causing a computer to execute the processing procedure of the software operating environment generation method according to claim 11 is recorded.