JP2003186670A - Automatic generation device, automatic generation method and automatic generation program for database access component - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an automatic generation device, an automatic generation method and an automatic generation program for a database access component that achieves improvement in productivity and maintainability of program development. <P>SOLUTION: The automatic generation device is provided with an input device 30, with which a system developer inputs various data; a display device 20 that externally displays inputted data, data obtained by autocreation or the like; a repository 1, that stores schema definition information on a user database; a schema edition part 40, that stores the schema definition information inputted from a schema definition screen displayed on the display device 20 with the input device 30 in the repository 1; and a database access component creating part 10, that automatically generates a source program for a database access component 3 from the repository 1 and a template file 2 previously generated by the system developer. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic generation device, an automatic generation method and an automatic generation program for a database access component which operates in a function layer in a client / server system adopting a multi-layer architecture.

[0002]

2. Description of the Related Art In developing a client / server system, it is indispensable to implement a database access processing function in the system. Conventionally, a two-layer architecture in which a client application directly accesses a database has been adopted as an implementation form in the system. It had been. However, in recent years, in order to improve the system extensibility, a multi-layered architecture is mainly used in which the process of accessing the database is separated from the client as a component and the database access process operation is performed in the newly provided function layer. Is becoming.

[0003]

The database access component needs to be individually programmed for each table schema of the database, but if it is programmed individually, the productivity and efficiency of program development are not good. There was a problem.
Further, as a conventional technique for automatically generating this database access program, for example, Japanese Patent Laid-Open No. 5-289919
Although there is a generation method described in Japanese Patent Publication, even if this generation method can be well adapted to the old system architecture,
It cannot be applied to automatic generation of database access components in modern multi-tier architecture.

Therefore, an object of the present invention is to automatically generate a source program of a database access component in the development of a client / server system based on a multi-layer architecture, and to realize a database for improving productivity and maintainability of program development. An automatic generation device, an automatic generation method, and an automatic generation program for access components are provided.

[0005]

In order to achieve the above object, the data access component automatic generation device of the present invention is an input device for a system developer to input various data, input data, automatically generated data, and the like. Displaying externally, a repository storing schema definition information of a user database, and a schema edit storing schema definition information input by the input device from the schema definition screen displayed on the display device in the repository The main feature is that it includes a unit, the repository, and a database access component generation unit that automatically generates a source program of a database access component from a template file created in advance by a system developer.

Further, the data access component automatic generation method of the present invention includes a determination step of determining whether or not a temporary symbol is included in one record of the read template file, and a temporary symbol in the determination step. If it is determined that the table name or column name is included in the schema definition information in the repository, the replacement is performed by replacing the temporary symbol in the record with the character string corresponding to the temporary symbol. The main feature is that it has a process and an output process of outputting one record containing a character string after replacement as a source program of the data access component.

Further, the data access component automatic generation program of the present invention has a determination function of determining whether or not a computer includes a temporary symbol in one record of a read template file, and the determination function. If it is determined that the temporary symbol is included in the record, the table name or column name is acquired from the schema definition information in the repository, and the temporary symbol in the record is replaced with the character string corresponding to the temporary symbol. The main feature is to realize a replacement function for performing the above, and an output function for outputting one record including the replaced character string as a source program of the data access component as one record.

[0008]

BEST MODE FOR CARRYING OUT THE INVENTION An automatic generation apparatus for a database access component according to an embodiment of the present invention will be described below with reference to the drawings.

First, before describing the configuration of the automatic generation apparatus according to the present embodiment, an example of a multi-layer architecture of a client / server system having a database access component will be described with reference to FIG.
The architecture of the client / server system in this embodiment is composed of three layers, that is, a client (presentation) layer 110 of a user interface portion, a function layer 120 that performs a database access process, and a data layer 130 that manages a database. is there.

The client layer 110 includes a rich client 103 and a thin client 104. The rich client 103 manages applications other than browser-based applications, while the thin client 104 manages browser-based applications.

The function layer 120 has a database access component 3 and a business component 102. The database access component 3 is the user database 1 of the data layer 130.
01 is a component that performs processing operations of fetching, adding, updating, and deleting data stored in 01, that is, simply accessing data in the user database 101 exclusively. That is, the database access component 3 has no business rules. On the other hand, the business component 102 holds the business rule of the business application, and executes the calling process of the database access component 3 to access the database.

[0012] The business rule refers to a formula such as "tax amount = body price * 0.05" in the case where there is a commodity table having two columns of a body price and a tax amount. Such business rules are not universal and may change due to revision of laws. Generally, the business rules are implemented in the business component 102.

<Structure of Automatic Generating Device for Database Access Component> In the client / server system having the above structure, the rich client 103 or the thin client 104 of the client layer 110 is used.
Exchanges data with the user database 101 via the business component 102 and the database access component 3. The configuration of the automatic generation device of the database access component 3 in such a client / server system will be described with reference to FIG. In the following, in the present embodiment,
The automatic generation of the database access component 3 that accesses the product table in the user database 101 regarding the product code, product name, body price, and tax amount of an arbitrary product will be described as an example.

As shown in FIG. 1, the automatic generation device of the database access component 3 according to the present embodiment has an input device 3 for inputting various data by a system developer.
0, a display device 20 for externally displaying input data, automatically generated data, and the like, and the user database 101.
1. A repository 1 for storing schema definition information of the database, a database access component generator 10 for automatically generating a source program 3 of a database access component from the repository 1 and a template file 2 created in advance by a system developer, and the display. A schema editing unit 40 for storing the schema definition information input by the input device 30 in the repository 1 from the schema definition screen displayed on the device 20, and a schema definition statement generation for automatically generating the schema definition statement 5 from the repository 1. And a section 50 are provided. The schema definition statement 5 is created in DDL (Data Description Language).

The schema definition information of the user database 101 stored in the repository 1 is composed of table information 301 and column information 302, as shown in FIG. The table information 301 has data relating to the table ID and table name given to each table in the user database 101. Also, the column information 302 belongs to the table that is assigned to the table to which the column belongs, the sequence number that indicates which column in the table the column is, the column name that is assigned to the column, and the column. Data type of data,
It has the number of digits of data belonging to the column, each data related to the primary key in the table to which the column belongs, and attribute data other than the above data (for example, data related to the type of database).

In the present embodiment, as shown in FIG. 3 as an example, the table information 301 has, for example, a table ID "ABCDE" and a table name "product table". In the column information 302a whose column name is "product code" in the column information 302, which differs depending on the column, for example, the table ID is "ABCDE", the sequence number is "1", the column name is "product code", and the data is The type is "character type", the number of data digits is "8 digits", and the main key is "product code". Further, in the column information 302b whose column name is “product name”, for example, the table I
D is "ABCDE", sequence number is "2", column name is "product name", data type is "character type", number of digits is "20 digits",
The primary key is the "product code". Similarly, in the column information 302c in which the column name is "main price", for example, the table ID is "ABCDE", the sequence number is "3", the column name is "main price", the data type is "numerical value type", and the number of digits. Is "7 digits", the main key is "product code", and the column information 302d has a column name of "tax amount". For example, the table ID is "ABCDE", the sequence number is "4", the column name is "tax amount", The data type is "numeric type" and the number of digits is "6"
Digit "and the main key is" Product code ".

That is, in the product table accessed by the database access component automatically generated by the automatic generation device of the present embodiment, the primary key is the product code, and the product name, body price, and tax amount are items subordinate to the primary key. Has become.

The template file 2 created in advance by the system developer is a file in text format, and defines processing for four main methods (reference, addition, update, deletion) of the data access component. It is a thing. Hereinafter, these four types of main methods will be described.

First, the reference method specifies the data for the primary key of the table as an argument, searches the user database 101 for a record that matches the data specified as the argument, and returns the searched record group as a return value. Is to be returned as. Next, the additional method specifies the data of each column of the table as an argument,
One record of the specified data is additionally registered in the user database 101. The update method, like the add method, specifies the data in each column of the table in the argument, searches for the record that matches the primary key, and uses the data specified in the argument for that record. Update processing is performed. The delete method, like the reference method, specifies the data for the primary key of the table as an argument, and records the data having the data specified as the argument in the user database 101.
Is to be deleted from.

The description format of the template file 2 that defines the processing for the four main methods as described above differs depending on the programming language and the database access method. Is a tentative symbol. In the present embodiment, as an example, as shown in FIG.
As a temporary symbol in the template file, @key (40
The character strings 1) and @list (402) are used as an example. These temporary symbols are used by the data access component generation unit 10 to refer to the schema definition information of the repository 1 and replace it with a table name, a column name, or the like. Specifically, @key (401) is replaced with the column name of the primary key of the table, and @list (40
In 2), all the column names in the table are replaced with a character string that is connected with a comma. Also, @table
(403) is to be replaced with the table name of the table. As described above, in the case of the above-described product table, the data access component 3 automatically generated by operating the temporary symbol in this way, as described later,
ey (401) should be replaced with "product code", @list (402) should be replaced with the character string "product code, product name, body price, tax amount", and @table (403) should be replaced with "product table". Becomes

Based on the above schema definition information of the user database 101 and the template file 2,
The database access component generator 10 automatically generates the data access component 3 as shown in FIG. Here, FIG. 5A is an example of a database access component for accessing the product table, and FIG. 5B is a source program of the automatically generated database access component.
In this embodiment, the class name in the database access component that accesses the product table is “product_access class”.

<Data Access Component Automatic Generation Processing Procedure> The processing procedure of automatically generating the data access component 3 as shown in FIG. 5 in the database access component generation unit 10 will be described below with reference to FIG. FIG. 6 is a flowchart for explaining the automatic generation processing procedure of the data access component 3 by the data access component generation unit 10.

First, the data access component generator 10 reads one record of the template file 2 (step S01) and determines whether the read template file is EOF (End Of File) (step S02). ). As a result of the determination, if the read template file is EOF, this process ends.

On the other hand, in step S02, when the read template file is not EOF, the data access component generation unit 10 further determines whether or not the read record includes the temporary symbols 401 to 403 ( Step S03). Here, when it is determined that the temporary symbols 401 to 403 are included, the table information 301 and the column information 30 in the repository 1 are included.
2 is retrieved to acquire the table name and the column name, and the temporary character string is replaced (step S04). In step S04, if the included temporary symbol is @key (401), the primary key of the table (“product code” in this example)
If @list (402), all the column names in the table are replaced by a character string (in this example, "product code, product name, body price, tax amount"). If the included tentative symbol is @table (403), it is replaced with the table name (“product table” in this example) of the table. Then, the replaced character string is used as the source program 3 of the data access component 1
A record is output (step S05). If it is determined in step S03 that the temporary symbol is not included, one record is output as the read record as the source program 3 of the data access component (step S05).

After step S05 ends, step S01
Processing is performed again, and in the processing of step S02,
Each processing step is sequentially repeated according to FIG. 6 until it is determined that the read template file is EOF.

As described above, the database access component generator 10 has the above-mentioned four methods from the schema definition information stored in the repository 1 and the template file 2 without manual work by the system developer. The source program 3 of the data access component as shown in FIG. 5 is automatically generated.

In addition, as shown in FIG.
Schema definition document creation unit 70 for automatically creating the schema definition document 4 from the schema definition information stored in the repository 1
May be provided. By providing the schema definition creating unit 70, the definition of the table schema of the database is automatically created, the consistency between the source program and the document is ensured, and the efficiency of maintenance work when the table schema is changed is improved. This makes it possible to improve maintainability.

Further, as shown in FIG. 7, the known tool repository 6 is linked with a known tool so that the known technology (tool) can be used for the schema editing section 40 and the schema definition statement generating section 50. The repository 1
Other tool cooperation unit 60 may be provided for collectively tackling the above. In this case, for example, in the other tool cooperation unit 60, the unique format of the repository 6 of known tools is changed to C
Converting to the SV (Comma Separated Value) format, and then performing the process of re-converting to the format of the repository 1 of this automatic generation device, thereby tackling the repository 6 of known tools in the repository 1 collectively. Is possible. Incidentally, the method of collectively handling the repository 6 of known tools in the repository 1 is not limited to the above method.

Further, the automatic generation device and the automatic generation method capable of automatically generating the source program of the data access component have been described so far, but the means for facilitating the automatic generation processing is limited to the above automatic generation device. Instead of this, a program for performing the automatic generation processing of the present invention may be created, and the computer may be caused to execute the automatic generation processing operation based on this program.

[0030]

As described above, according to the present invention, the source program of the database access component in the development of the client / server system based on the multi-layer architecture is automatically generated to improve the productivity and maintainability of the program development. Can be improved. Also, by automatically creating the definition document of the table schema of the database, it is possible to ensure the consistency between the source program and the document, and to improve the efficiency of maintenance work when changing the table schema, that is, the maintainability. . Further, it is possible to ensure the easiness of cooperation with a plurality of known technologies that efficiently define the table schema.

[Brief description of drawings]

FIG. 1 is a schematic configuration diagram of a data access component generation device according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating an example of a multi-tiered architecture of a client / server system.

3 is a diagram showing an example of schema definition information stored in a repository shown in FIG.

FIG. 4 is a diagram showing an example of a configuration of a template file in FIG.

5 is a diagram showing an example of a configuration of a data access component in FIG. 1, FIG. 5 (a) is an example of a database access component for accessing a product table, and FIG. 5 (b) is an automatically generated database access. It is a figure for demonstrating the source program of a component.

FIG. 6 is a flowchart showing an automatic generation processing procedure in the data access component generation device of the present invention.

FIG. 7 is a schematic configuration diagram of a data access component generation device according to another embodiment of the present invention.

[Explanation of symbols]

1 ... Repository, 2 ... Template file, 3 ... Database access component (DB access component), 5 ... Schema definition statement (DDL statement), 10 ...
Database access component (DB access component) generation unit, 20 ... Display device, 30 ... Input device, 40 ... Schema editing unit, 50 ... Schema definition statement generation unit.

Claims (9)

[Claims] 1. An input device for a system developer to input various data, a display device for externally displaying input data, automatically generated data, etc., a repository for storing schema definition information of a user database, and the display. From the schema definition screen displayed on the device, a schema editing unit that stores the schema definition information input by the input device in the repository, a database access component of the repository and a template file created in advance by a system developer. An automatic database access component generation device comprising: a database access component generation unit that automatically generates a source program. 2. The database access component generation unit includes a determination function of determining whether or not a record for one template file that has been read includes a temporary symbol, and the determination function includes a temporary symbol. If it is determined that the table name or column name is obtained from the schema definition information in the repository, the replacement function that replaces the temporary symbol in the record with the character string corresponding to the temporary symbol, and the replacement process The database access component automatic generation device according to claim 1, further comprising: an output function of outputting one record including a subsequent character string as a source program of the data access component. 3. The database access component generation unit, when the determination function determines that no tentative symbol is included, outputs the one record read after the determination as the source of the data access component. 3. The database access component automatic generation device according to claim 1, further comprising a function of directly outputting one record as a program. 4. The schema definition document creating section for automatically creating a schema definition document from the schema definition information stored in the repository is further provided.
5. An automatic generation device for database access component according to any one of 3 to 3. 5. The other tool cooperation unit, which cooperates with a known tool to collectively work a repository of known tools on the repository, is further provided.
Automatic generation device of database access component according to any one of 6. A determination step of determining whether or not a tentative symbol is included in one record of the read template file, and a case of determining that the tentative symbol is included in the determination step, A replacement process that acquires the table name or column name from the schema definition information in the repository and replaces the temporary symbol in the record with the character string corresponding to the temporary symbol, and a replacement process that includes the replaced character string. An automatic generation method of a database access component, comprising: an output step of outputting one record as a source program of a data access component. 7. A step of outputting one read record as a source program of a data access component after the determining step when it is determined in the determining step that no temporary symbol is included. The method for automatically generating a database access component according to claim 6, wherein: 8. A determination function for determining whether or not a temporary symbol is included in one record of a template file read into a computer, and the determination function determines that the temporary symbol is included. In this case, the table name or column name is obtained from the schema definition information in the repository, and the replacement function that replaces the temporary symbol in the record with the character string corresponding to that temporary symbol, and the replacement character string An output function that outputs one record including one record as a source program of the data access component, and an automatic generation program of the database access component that realizes 9. When the determination function determines that no tentative symbol is included, after the determination, a function of outputting one read record as a source program of the data access component is provided. 9. The database access component automatic generation program according to claim 8, which is realized.