JPH11232090A - Automatic data base generation system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To automatically generate a data base, a picture display file and a data base access program for a data base system based on the definition information of data. SOLUTION: This system has a data definition generating part 11 for generating data definition information based on input data, an input picture file generating part 14 and an analysis picture generating part 15 for automatically generating input picture and analysis picture HTML files, respectively, a DB registration program generating part 16 and a DB retrieval program generating part 17 for automatically generating CGI programs for data base registration and retrieval respectively, and a data base generating part 13 for automatically generating the data base. These respective generation parts 13-17 automatically generate respective files or the like based on the same data definition information.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic generation system for a database system, and more particularly to a screen display file, a database access program used in a database system for accessing a database through a display screen, and the efficiency of generating a database. To a device for achieving

[0002]

2. Description of the Related Art In an Internet or an intranet environment, a hypertext markup language (HTM) is used.
L: HyperText Makeup Langua
ge) to generate a text file and display it on the browser screen, or in response to a request from the browser, a Common Gateway Interface (CGI).
Activating an "ay Interface" program to execute some processing is becoming a de facto fact. For example, when conducting an electronic questionnaire and analysis of the results in an Internet environment, the browser must use HTM.
When the respondent inputs data from the input screen generated by loading the L file, the input data is registered in the database via the CGI. When an analyst sets search conditions from an analysis screen generated by loading an HTML file into a browser,
The database is searched via the CGI based on the search condition expression. Then, the search result is sent to the analyst. That is, in order to construct such an electronic questionnaire system, an HTML file for displaying a screen for inputting a questionnaire on a browser for the electronic questionnaire and an answer of the input questionnaire are registered in a database. Requires a CGI program to perform the operation. The CGI program here is SQL (Structured)
A command file that describes a database language such as Query Language) is generated. In order to analyze a questionnaire, an HTML file for displaying a screen for allowing an analyst to set search conditions on a browser and a CGI program for searching a database based on the set search conditions are usually provided. Required. This CGI program generates a command file describing a database language.

[0003] Generation of these files and the like, that is, system development, is performed as follows. This will be described with reference to the examples shown in FIGS. Although depending on the scale of the system to be developed, usually, a plurality of developers generate each file at the same time in parallel.

First, a database to be handled by this system must be designed. For this purpose, all the data to be handled are listed, and as shown in FIG. 22, the names (item names), types of texts and numbers, data lengths (number of columns), etc. of each data to be registered in the database are defined. I do. This data definition corresponds to creation of a database specification, that is, database design work.

[0005] Next, each developer designs a file or the like based on the data definition. In screen design work, data design and screen layout for each screen are determined based on the data definition. If the developer of the input screen file, the input screen file is generated in HTML, and if the developer of the analysis screen file, the analysis screen file is generated in HTML. Display examples of each screen are shown in FIGS.

[0006] Similarly, a database access program developer also designs data based on database specifications and generates a database registration program (CGI) or a database search program (CGI) based on the data design.

In addition, a database is generated in advance based on the contents of the database specifications.

As described above, conventionally, in the development work for generating each file and the database, each developer designs the data based on the data definition information, and obtains the HTML file or the data while maintaining the data consistency with the database. A CGI program was being generated.

In the electronic questionnaire system developed as described above, when a respondent inputs data according to each questionnaire item from a questionnaire input screen displayed by a browser, the browser enters a database registration program ( CGI) start request is issued. WW
The W (World Wide Web) server starts a database registration program (CGI) in response to the request. The activated database registration program (CGI) generates a command file describing a database creation language for data registration based on the input data. Then, as a result of the execution of this command file, the data entered by the respondent through the input screen is registered in the database, and the responses to the questionnaire are collected.

[0010] When the analyst sets search conditions from the analysis screen displayed by the browser, the browser issues a request to start a database search program (CGI). The WWW server starts a database search program (CGI) in response to the request. The activated database search program (CGI) generates a command file describing a database creation language for data search based on the set search condition expression.
Then, as a result of executing the command file, the database is searched based on the search condition formula set by the analyst through the analysis screen. Then, the search result is sent to the browser and displayed.

By the way, the generated HTML file is composed of a part which is almost common regardless of the data to be handled and a part which can be described only after the data to be handled is defined. It can be seen that the description part that depends on the data definition has a very close relationship with the contents of the data definition. For example, as shown in FIG. 23, the input items on the input screen, each item length, and the like are basically equal to the contents of the data definition. That is, the input screen file (H
In TML), it is basically necessary to provide input fields for all defined items in order to input registration data to a database. Further, as shown in FIG. 24, the condition setting items on the analysis screen, the lengths of the respective items, and the like are based on the specifications of the database generated based on the data definition. That is, the analysis screen file (HTML)
In, since defined items can be set as search conditions, it is basically necessary to provide input fields for all defined items. Therefore, it can be said that each item handled in each file has a substantially one-to-one relationship with the defined data item.

[0012]

However, conventionally, as described above, the construction of the database and the HTM
Since the design work of the screen (man-machine interface) by L is performed independently by hand, it is difficult to say that the production efficiency is high. That is, each developer has designed the data with the same contents based on the same data definition. In addition, since the development is performed manually, a human error may occur during the development, and data consistency between the database and each file may not be obtained. Further, if a change occurs in the definition of data during development even if it is not a human error, it takes a lot of time to make adjustments between design works.

SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and has as its object to provide a database and a screen used in a system in which access to the database occurs based on an input from the screen. An object of the present invention is to provide an automatic generation system of a database system capable of automatically generating a display file and a database access program based on data definition information.

[0014]

In order to achieve the above object, an automatic generation system for a database system according to a first aspect of the present invention comprises: a browser means for generating a display screen based on a screen display file; The screen display file, the database access program, and the database are generated for a database system having a server unit that starts a database access program in response to a request from the browser unit and controls database access. In an automatic generation system, data definition generation means for generating definition information of data to be registered in a database based on input data; database generation means for automatically generating the database based on data definition information generated by the data definition means; Data definition means File generation means for automatically generating the screen display file based on the generated data definition information, and program generation means for automatically generating the database access program based on the data definition information generated by the data definition means. is there.

In an automatic generation system for a database system according to a second invention, in the first invention, the file generation means automatically generates an input screen file of data to be registered in the database as the screen display file. It has an input screen file generation unit.

According to a third aspect of the present invention, in the automatic generation system for a database system according to the first or second aspect, the program generation means includes a database registration program for registering data in the database as the database access program. It has a database registration program generation unit for automatically generating a program.

According to a fourth aspect of the present invention, in the automatic generation system for a database system according to the first or second aspect, the file generating means sets a search condition of data registered in the database as the screen display file. And a search screen file generation unit for automatically generating a search screen file for performing the search.

According to a fifth aspect of the present invention, in the automatic generation system for a database system according to the fourth aspect, the program generation means is a data search for searching the database when a search condition is set from a search screen. And a data search program generation unit for automatically generating a database program as the database access program.

According to a sixth aspect of the present invention, in the automatic generation system for a database system according to the first aspect, the screen display file is described in a hypertext markup language.

According to a seventh aspect of the present invention, in the automatic generation system for a database system according to the first aspect, the database access program is a common gateway interface program.

[0021]

Preferred embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 shows a database, an HTML file and a C generated by the automatic generation system according to the present invention.
FIG. 1 is an overall configuration diagram showing an electronic questionnaire system that operates using a GI program. This electronic questionnaire system is a database system that can collect and hold the responses to the electronic questionnaire and analyze the contents of the questionnaire.
And a database server 3 having a database for storing responses to questionnaires from terminals 2 on the Internet, and an analysis terminal 4 for performing analysis based on the results of the questionnaire stored in the database. .
The questionnaire management terminal 1 includes an HTML file for an input screen and an analysis screen, which are formatted and displayed on a browser, and a W
A CGI program for database registration and search for starting the WW server and accessing the database is installed.

In this system, when a respondent inputs data from an input screen generated by loading the input screen HTML file into the browser of the terminal 2, the WWW server responds to the request of the browser by the WWW server. The program starts. The database registration CGI program is described in a predetermined database language, for example, SQL. By executing the database registration CGI program, input data is registered in the database. When the analyst sets search conditions from the analysis screen generated by loading the analysis screen HTML file into the browser of the analysis terminal 4, the database search is performed based on the search conditions set in response to the browser's request. For CGI
A program is generated. CG for this database search
The I program is described in a database language such as SQL, and the database is searched by executing this database language. And the search results are
It is sent to the analysis terminal 4. Although FIG. 1 shows a terminal for conducting a questionnaire, a terminal for managing a database, and a terminal for performing analysis separately, it is not always necessary to provide them separately.

In order to construct a system such as the electronic questionnaire system for accessing a database, searching, etc. based on an input from a screen displayed by a browser in an Internet environment, an HTML file is used as a screen display file. CGI programs and databases must be developed as files and database access programs. This embodiment is characterized in that these files and the like can be automatically generated.

FIG. 2 is a functional block diagram showing an embodiment of the automatic generation system of the database system according to the present invention. In the automatic generation system 10, the data definition generation unit 11 generates definition information of data to be registered in a database based on input data. The data definition information storage unit 12 stores the generated data definition information. The database generation unit 13 automatically generates a database based on the data definition information stored in the data definition information storage unit 12. The input screen file generation unit 14 automatically generates an input screen HTML file of data to be registered in the database based on the data definition information stored in the data definition information storage unit 12. The analysis screen file generation unit 15 generates an analysis screen HTML file for setting a search condition formula of data registered in the database in order to perform analysis based on the data definition information stored in the data definition information storage unit 12. Generate automatically. The database (DB) registration program generation unit 16 automatically generates a database (DB) registration CGI program for registering data in the database based on the data definition information stored in the data definition information storage unit 12. The database (DB) search program generation unit 17 executes a data search program for searching a database when a search condition expression is set from a search screen based on the data definition information stored in the data definition information storage unit 12. Generate automatically. The file change processing unit 18 generates the HTM
This is a means for customizing an L file and a CGI program by making changes. The automatic generation system 10 according to the present embodiment is incorporated in a database system. As the automatic generation system 10, hardware is configured by a computer equipped with a conventional general device such as a CPU, a memory, a disk device, a CRT, a mouse, and a keyboard. It can be realized by installing the software.

The present embodiment is characterized in that each of the above-mentioned files and the like is automatically generated. In particular, it is characterized in that these generating operations are automatically generated based on the same data definition information. . by this,
Errors caused by human errors in the data set at the time of each work, that is, the construction of the database and the generation of each file, and the length of each data are prevented from being caused by human error. No contradiction occurs.

Next, the operation of this embodiment will be described with reference to each flowchart. First, the overall flow in the present embodiment is shown in the flowchart of FIG.
In the present embodiment, data to be handled by the system is first defined, and then, based on the defined information, an input screen HTML file, an analysis screen HTML file, a database, a database registration CGI program, and a database search Generate a CGI program. However, HTML file for input screen, HTML for analysis screen
CGI for file, database and database registration
The program can be generated before the electronic questionnaire is performed when the data is defined. However, in order to generate a database search CGI program, further search conditions are required. It is automatically generated each time it is set. The generation processes other than the database search CGI program do not necessarily have to be executed in the order shown in FIG. 3, and the processes may be executed simultaneously and in parallel. Hereinafter, each generation process will be described.

FIG. 4 is a flowchart showing a data definition process executed in the data definition generation unit 11. As in the electronic questionnaire system exemplified in the present embodiment, the data to be handled often becomes the specification of the database and becomes the item of the input field of the input screen as it is in many cases. Therefore, the data definition processing here is also the data design of the input field of the input screen as it is. The data handled in the present embodiment is the same data as in FIG. The input screen is the same as the display example shown in FIG.

First, a template prepared in advance as shown in FIG. 5 is displayed on a CRT (not shown) on a screen (step 101), and the developer is made to input each item for all data used in the electronic questionnaire system. FIG. 6 shows an example in which data based on FIG. 22 is set on this template.
Shown in The data handled here will be described.

In the item, the name of a data item to be input is set. The character string set here is displayed as guidance for the input field. Of course, data may be separately defined for input screen display. In the data type, the type of data expected to be input is set. As shown in FIG. 22, "Japanese" is set to accept an input using kanji and the like, and "numeric" is set to accept only a number. The field length to be provided on the input screen is set as the number of columns.
In the selection, “Yes” is set when the type is set to menu selection in FIG. 23, that is, when it is desired to display a selection candidate on the menu and to make a selection from the selection. Once the above data is defined by the developer,
The data definition generation unit 11 stores this input data in the buffer having the structure shown in FIG. 7, that is, in the data definition information storage unit 12 (step 102). This storage process basically stores the input contents in a buffer as it is. However, in the data type (kata), as can be seen by comparing FIGS. 6 and 7, on the displayed template,
Enable developers to set data that is easy to set or understand the settings, and on the buffer,
The character string is converted into a character string that can be used as it is in HTML and SQL, and stored. In the buffer, the number of items is obtained. “Buf_a” is
This is the name of the buffer in the data definition information storage 12 that stores this definition. The types of attributes of each data such as data type and the values that can be set for each attribute such as "Japanese"
Various other things can be considered, but these are not the gist of the present invention.

The subsequent process shown in FIG. 4 is a process for creating a pop-up menu in a process when "Yes" is set in the selection column on the template. That is, the input data is checked one by one for the presence or absence of designation in the selection column (steps 103 and 10).
4, 105), when the selection is "Yes" (step 1)
06), a pop-up menu template (FIG. 8) prepared in advance is displayed on the screen, and the developer is made to input a selection candidate (step 107). Note that the item name in FIG. 8 is set and displayed as “sex”. According to this example, when “male” and “female” are set for “sex” with “selected”, they are stored in a buffer having the structure shown in FIG. 9 (step 108). "Buf_" in FIG.
b "is a buffer name. In this embodiment, the selection candidates are always made to be input by the developer. However, the selection candidates can be finitely and uniquely specified like" sex "in this example. For the item, the input process of the selection candidate can be omitted. For example, when the reserved word "sex" is designated as the item name, the system can extract the selection candidates from a predetermined database and automatically set them, thereby reducing the development work load of the developer.

FIG. 10 shows the input screen file generator 14.
6 is a flowchart showing a process of generating an input screen HTML file executed in step (a).

In this embodiment, a file and a program are finally completed by opening an empty file and writing a command line or the like therein. Therefore, in the input screen file generation process, first, an empty input screen file is opened, and the HTML header definition is output to the file (step 201). In the flowchart, the underlined description portion indicates a variable portion to which any value of the input data definition is substituted. For example, “title” underlined in step 201 includes b
The “electronic questionnaire” set in the variable “title” of uf_a is substituted. The same applies to other flowcharts. The input field part is defined in the part of the flow where the next item is repeated several times (step 20)
3-207). For this purpose, item data is sequentially fetched from the buffer buf_a in which the data definition information is stored (steps 202 and 203), and when “existence” is set in the selection of the fetched item data, buf
H for selection based on the setting contents of _a and buf_b
Output the TML input field definition (step 20)
5,206). On the other hand, when "Yes" is not set in the selection of the extracted item data, an HTML input field definition for no selection is output based on the setting contents of buf_a (steps 205 and 207). After performing this processing for all items (step 204), the HTML
An HTML definition to be set at the end of the file is output (step 208).

As a result of this processing, the input screen H generated
FIG. 11 shows an example of the TML file. FIG. 23 shows an example in which the HTML file is displayed by the browser.
In this process, a general-purpose HTML file that can be normally displayed so as to be applicable to all types is generated. Therefore, fine adjustment of color, font, character size, etc.
You can change this file later. The file change processing unit 18 is provided for this adjustment.
The developer has only to make a change to the automatically generated HTML file through the file change processing unit 18 so as to conform to the screen specification. It is also possible to add various temporary parameters to the file in advance, but human error may occur because the amount of description in the file will increase and the possibility of deletion will increase. Easier to do. Therefore, in the present embodiment, the description is about a template. Of course, what constitutes a standard is an arbitrary design matter.

FIG. 12 shows an analysis screen file generator 15.
6 is a flowchart showing a generation process of an analysis screen HTML file executed in step (a). Basically, it differs from the input screen file only in that a description that each item data (search data) is connected by and / or is added. Therefore, first, an empty analysis screen file is opened, and the HTML header definition is output to the file (step 301). The search field and the condition field are defined in the part of the flow that repeats the next several times (steps 303 to 306). For this purpose, item data is sequentially extracted from the buffer buf_a in which the data definition information is stored (steps 302 and 30).
3) Output the search field definition as shown in the flowchart (step 305). Subsequently, the condition field definition as shown in the flowchart is output (step 306). After this process is performed for all items (step 304), an HTML definition to be set at the end of the HTML file is output (step 307).

As a result of this processing, the analysis screen H generated
13 and 14 show examples of the TML file. This H
Figure 2 shows an example of a TML file displayed by a browser
4. In this process, an HTML file serving as a template is generated in the same manner as in the case of the input screen file.
In the case of making a change or the like, the developer only has to make a change to match the screen specification through the file change processing unit 18 to the automatically generated HTML file.

FIG. 15 is a flowchart showing a database generation process executed by the database generation unit 13. In this process, the database itself capable of registering each item data defined above is generated.

The database can be created by executing a database language for creating a database. Therefore, first, an empty file is opened, and the database language is output to the file in a predetermined order. That is, a command for generating a database is first output to the file (step 40).
1). Each item data is defined in the part of the flow that is repeated several times for the next item (steps 403 to 407). For this purpose, item data is sequentially extracted from the buffer buf_a storing the data definition information (steps 402 and 40).
3) If the type of the extracted item data is a text format such as Japanese, a definition statement specifying the format and the data length is output (steps 405 and 406). If the type of the extracted item data is a numeric format, a definition statement specifying the format and the data length is output (steps 405 and 407). This process is performed for all items (step 404).

FIG. 16 shows the contents of the database generation file generated as a result of this processing. By executing the command described in this file, a database for storing the responses to the electronic questionnaire is generated. In the present embodiment, there is no particular limitation on the timing and method for executing the command file for database generation.

FIG. 17 shows a database registration CG executed by the database registration program generator 16.
9 is a flowchart illustrating a process of generating an I program. In this process, a command for registering input data in a generated database is simply described in a file. Therefore, first, an empty file is opened, and a command for registering input data to the database is output to the file (step 501).

FIG. 18 shows the contents of the generated database registration CGI program as a result of this processing, and it can be seen that the database registration CGI program is described in a database creation language. The database registration CGI program is started each time a respondent inputs data from the input screen, and registers the input data sent from the browser on the terminal 2 used by the respondent in the database.

FIG. 19 shows a database search CG executed in the database search program generation unit 17.
9 is a flowchart illustrating a process of generating an I program. This process is different from the above-described processes, when the electronic questionnaire is running, and is executed when a search condition formula is set from the analysis screen. At that time, a database search CGI program is automatically generated. Become.

When a search condition formula is set from the analysis screen,
The database search program generation unit 17 opens an empty file in order to generate an analysis screen CGI program, and outputs a definition command for specifying a database to be searched in the file (step 60).
1). If “*” indicating that the search condition of each item data is not specified is set on the analysis screen,
Replace with “%” so that the QL can be understood (step 602).

The search condition for each item data is set in the part of the flow where the next item is repeated several times (steps 604 to 604).
08). Therefore, the item name (buf_a (N) .kou) is obtained from the buffer buf_a in which the data definition information is stored.
moku) (Steps 603 and 60)
4) If "%" is assigned to the search condition corresponding to the extracted item name, a command for no search condition is output (steps 606 and 607). on the other hand,
If a retrieval condition is set for the extracted item name, a command is generated and output by designating the retrieval condition (steps 606 and 608).

For example, FIG. 21 shows an example of a database search CGI program generated when the search conditions as shown in FIG. 20 are set from the analysis screen. As described above, when the search condition is set from the analysis screen, the database search CGI program can be automatically generated based on the data definition. When this program is executed, the database is searched, and the search result is sent to the analysis terminal 4, but this may be realized by general processing and is not the gist of the present invention.

It should be noted that, as described above, the files and programs that are automatically generated in the present embodiment are limited to the size of a template. Therefore, when a range is specified in the search condition, the processing may be changed to a process that can cope with the specification.

As described above, according to the present embodiment, an HTML file, a CGI program, and a database used in the electronic questionnaire system can be automatically generated. Since these files and the like are all automatically generated based on the same data definition information without human intervention, data inconsistency does not occur between the HTML file, the CGI program, and the database. In addition, since it is not necessary to independently perform the processes related to the data definition in each operation of generating a file or the like, it is possible to improve production efficiency.

In the present embodiment, the electronic questionnaire system is configured to incorporate an automatic generation system. However, among the HTML files, CGI programs, and databases that make the electronic questionnaire system function, other than the database search CGI program, it is sufficient that they exist on the electronic questionnaire system before the electronic questionnaire is implemented. It may be generated on a development machine or the like and ported to an electronic questionnaire system. That is, the database generation unit 13, the input screen file generation unit 14, the analysis screen file generation unit 15, and the database (DB) registration program generation unit 16 themselves need not be mounted in the electronic questionnaire system. . On the other hand, since the database search CGI program is generated every time a search condition is set from the analysis screen, the database search program generation unit 17 sets the data definition information storage unit 12
Along with the electronic questionnaire system.

In the present embodiment, an automatic generation system is used to support development of files and the like for the electronic questionnaire system. Although it depends on the number of items of the questionnaire, one input screen for the questionnaire usually needs to be set. Therefore, as in the present embodiment, the data items of the database and the data items on the input screen are one-to-one. became. However, depending on the type of data to be handled, a plurality of input screens may be required. In this case, the data definition information does not match the input field of one input screen, and is based on the specifications of the database.

The database system to which the automatic generation system shown in the present embodiment can be applied may be any system that retains and manages data using a database, and the type of data to be handled and the system scale are not limited. Absent.

Also, in the present embodiment, the browser H in the Internet or intranet environment is used.
A system is assumed in which a TML file is formatted and displayed, and a database can be accessed by executing a CGI program. That is, as a browser means for generating a display screen based on a screen display file, a browser for displaying an HTML file on the Internet is activated by a database access program in response to a request from the browser to control database access. The server means is assumed to be a WWW server that starts a CGI program, but the automatic generation system according to the present invention can be applied as long as it performs an operation equivalent to such a system.

[0052]

According to the present invention, a screen display file, a database access program, and a database used in a database system can be automatically generated. These files and the like are automatically generated based on the same data definition information without manual intervention, so that data inconsistency does not occur between the screen display file, the database access program, and the database. In addition, since it is not necessary to independently perform the processes related to the data definition in each operation of generating a file or the like, it is possible to improve production efficiency.

[Brief description of the drawings]

FIG. 1 is an overall configuration diagram showing an electronic questionnaire system that operates using a database, an HTML file, and a CGI program generated by an automatic generation system of a database system according to the present invention.

FIG. 2 is a functional block configuration diagram showing an embodiment of an automatic generation system of a database system according to the present invention.

FIG. 3 is a flowchart showing a processing procedure for automatically generating each file and the like in the present embodiment.

FIG. 4 is a flowchart illustrating a data definition process executed by a data definition generation unit according to the present embodiment.

FIG. 5 is a diagram showing a template used when performing data definition in the present embodiment.

FIG. 6 is a diagram illustrating an example when values are set in the template illustrated in FIG. 5;

7 is a diagram showing an example of the content of data definition information stored based on the input data shown in FIG.

FIG. 8 is a diagram showing a template used for generating a pop-up menu in the present embodiment.

9 is a diagram illustrating an example of the content of data definition information for a pop-up menu stored based on data input to the template illustrated in FIG. 8;

FIG. 10 is a flowchart illustrating a process of generating an input screen HTML file executed by the input screen file generation unit according to the present embodiment.

FIG. 11 is an input screen HTML according to the embodiment.
HT for input screen generated in file generation processing
FIG. 4 is a diagram illustrating an example of an ML file.

FIG. 12 is a flowchart illustrating a generation process of an analysis screen HTML file executed by the analysis screen file generation unit according to the present embodiment.

FIG. 13 is an HTML for an analysis screen according to the present embodiment.
HT for analysis screen generated in file generation processing
FIG. 4 is a diagram illustrating an example of an ML file.

FIG. 14 is an HTML for an analysis screen according to the present embodiment.
HT for analysis screen generated in file generation processing
FIG. 4 is a diagram illustrating an example of an ML file.

FIG. 15 is a flowchart illustrating a database generation process performed by the database generation unit according to the present embodiment.

FIG. 16 is a diagram showing an example of the contents of a database generation file generated in the database generation processing according to the present embodiment.

FIG. 17 is a flowchart illustrating a process of generating a database registration CGI program executed by the database registration program generation unit according to the present embodiment.

FIG. 18 is a diagram illustrating an example of a database registration CGI program generated in a process of generating a database registration CGI program according to the present embodiment.

FIG. 19 is a flowchart illustrating a process of generating a database search CGI program executed by a database search program generation unit according to the present embodiment.

FIG. 20 is a diagram showing a display example of an analysis screen in which search conditions are set in the present embodiment.

FIG. 21 is a diagram illustrating an example of a database search CGI program generated in a process of generating a database search CGI program according to the present embodiment.

FIG. 22 is a diagram showing an example of definition contents of each data registered in a database.

FIG. 23 is a diagram showing an example of an input screen of the electronic questionnaire system.

FIG. 24 is a diagram showing an example of an analysis screen of the electronic questionnaire system.

[Explanation of symbols]

1 questionnaire management terminal, 2 terminals, 3 database server, 4 analysis terminals, 10 database system automatic generation system, 11 data definition generation unit, 12
Data definition information storage unit, 13 Database generation unit, 1
4 Input screen file generation unit, 15 Analysis screen file generation unit, 16 Database (DB) registration program generation unit, 17 Database (DB) search program generation unit, 18 File change processing unit.

────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] March 19, 1999

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Claims

[Correction method] Change

[Correction contents]

[Claims]

3. The system according to claim 1, wherein the screen display file is described in a hypertext markup language.

4. The system according to claim 1, wherein the database access program is a common gateway interface program.

[Procedure amendment 2]

[Document name to be amended] Statement

[Correction target item name] 0014

[Correction method] Change

[Correction contents]

[0014]

In order to achieve the above object, an automatic generation system for a database system according to a first aspect of the present invention comprises: a browser means for generating a display screen based on a screen display file; The screen display file, the database access program, and the database are generated for a database system having a server unit that starts a database access program in response to a request from the browser unit and controls database access. In an automatic generation system, data definition generation means for generating definition information of data to be registered in a database based on input data; database generation means for automatically generating the database based on data definition information generated by the data definition means; Data definition means A file generating means for automatically generating the screen display file based on the form data definition information, and a program generation means for automatically generating the database access program on the basis of the data definition unit generated data definition information possess, The file generator
The column is the database as the screen display file.
Automatically generate input screen file for data to be registered in
An input screen file generation unit and the screen display file
Search condition of data registered in the database as
To automatically generate a search screen file for setting
A file generating unit for a search screen;
The means is as the database access program.
A database for registering data in the database
For database registration that automatically generates a software registration program
A search condition expression is set from the program generator and the search screen.
Data search to search the database at
Search program for the database access program
A data search program generator that automatically generates
Enter the items required to define a single data definition information.
Is not only registered in the database, but also checked.
The environment for searching is also automatically set .

[Procedure amendment 3]

[Document name to be amended] Statement

[Correction target item name] 0015

[Correction method] Change

[Correction contents]

The input data is used for a questionnaire.
Is an input item that is registered in the database.
Is the result of the questionnaire.
It is a thing.

[Procedure amendment 4]

[Document name to be amended] Statement

[Correction target item name] 0016

[Correction method] Deleted

[Procedure amendment 5]

[Document name to be amended] Statement

[Correction target item name] 0017

[Correction method] Deleted

[Procedure amendment 6]

[Document name to be amended] Statement

[Correction target item name] 0018

[Correction method] Deleted

[Procedure amendment 7]

[Document name to be amended] Statement

[Correction target item name] 0019

[Correction method] Change

[Correction contents]

[0019] In addition, the screen display file is one that has been described by the hypertext mark-up language.

[Procedure amendment 8]

[Document name to be amended] Statement

[Correction target item name] 0020

[Correction method] Change

[Correction contents]

Further, the program for the database access is assumed to be a common gateway interface program.

Claims (7)

[Claims] 1. A database comprising: browser means for generating a display screen based on a screen display file; and server means for controlling a database access by activating a database access program in response to a request from the browser means. An automatic generation system that generates the screen display file, the database access program, and the database for a system, wherein: a data definition generation unit configured to generate definition information of data to be registered in the database based on input data; Database generating means for automatically generating the database based on the data definition information generated by the means; file generating means for automatically generating the screen display file based on the data definition information generated by the data defining means; Automatic generation system of the database system, characterized in that it comprises a program generating means for automatically generating the program database access based on the generated data definition information. 2. The input screen file generation unit according to claim 1, wherein the file generation unit includes an input screen file generation unit that automatically generates an input screen file of data to be registered in the database as the screen display file. Automatic generation system for database system. 3. The program generating means according to claim 1, further comprising a database registering program generator for automatically generating a database registering program for registering data in the database as the database access program. Or an automatic generation system for the database system according to any one of the above. 4. A search screen file generation unit for automatically generating a search screen file for setting a search condition of data registered in the database as the screen display file, wherein the file generation unit includes: An automatic generation system for a database system according to claim 1 or 2, wherein: 5. A data search program generation unit for automatically generating a data search program for searching the database as the database access program when a search condition expression is set from a search screen. 5. The method according to claim 4, wherein
Automatic generation system of the described database system. 6. The system according to claim 1, wherein the screen display file is described in a hypertext markup language. 7. The system according to claim 1, wherein the database access program is a common gateway interface program.