JPH09167163A - System for generating table of relational database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily associate a detail table and a master table and to improve operability for generating the tables. SOLUTION: A view design means 11 designs the view of a table to be finally generated and a string designation means 12 designates the string to which same data is repetitively inputted among the strings of the designed view. An ID addition means 13 automatically adds ID to the designated string. A detail table/master table design means 14 combines the strings of the view of the table by using added ID, designs the detail table and the master table. A view generation means 15 generates the view of the table from the designed detail table and the master table.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a relational database table generation method, and more particularly to a relational database table generation method for automatically generating a table by a user interface.

Conventionally, in this kind of relational database table creating method, a view of a table to be finally created is designed on a desk, and a detail table and a master table are created based on the designed view. At this time, in order to make the data capacity of the entire table as small as possible, a detail table is defined to associate a unique number (hereinafter abbreviated as ID) with the column that is repeatedly input, and the detail table is defined using that ID. The table was associated with the master table.

Therefore, in the conventional relational database table creation method, at the stage of creating the detail table so as to be associated with the master table, it is necessary to design in advance so that the column names and data types of the table match. It was

Next, a conventional relational database table creating method will be described in detail with reference to FIGS. 6 and 7.

First, a view 71 of a table to be finally generated is designed on a desk, an operator considers a column to which the same data is repeatedly input based on the designed view 71, and a master is displayed on the table design screen 70. The table 72 is designed (step S201). In the example of FIG. 7, the columns in which the same data is repeatedly input are “ID_1” and “I
The name is "D_2".

Next, the "ID_
The detail tables 73 and 74 having the same names and the same data types as "1" and "ID_2" are designed (steps S202 and S203).

Subsequently, the columns of the master table 72 and the detail tables 73 and 74 are associated (step S204). Specifically, the operator drags the mouse to “ID_1” of the detail table 73 and “ID_2” of the detail table 74 to the “ID_1” and “ID_2” columns of the master table 72, respectively.
When dropped, a line showing the association is displayed and associated.

Finally, the table view 71 is generated (step S205).

As described above, in the conventional relational database table creating method, the detail tables 73 and 74 associated with the master table 72 are associated with the table.
In order to design the same, it is necessary to define the same name and data type in the corresponding columns, but it is troublesome because the operator has to remember when defining this or need to refer to the master table 72 again. It was hanging.

[0010]

In the above-mentioned conventional relational database table creating method, the detail table 7 is used in order to associate it with the master table 72 when creating the detail tables 73 and 74.
Since it is necessary to use the same name and data type for the corresponding columns in 3 and 74 and the master table 72, there is a problem in that the name and data type must be determined in advance when designing the table. The reason is that the detail tables 73 and 74 and the master table 72 need to be associated by using the same names for corresponding columns.

An object of the present invention is to make it possible to easily associate a detail table with a master table,
It is to provide a table creation method for a relational database that improves the operability for creating a table.

As a prior art document, Japanese Unexamined Patent Publication No.
Although there is Japanese Patent No. 238573, the purpose of the "concatenated database search device" disclosed in this publication is to define concatenated information of a plurality of databases and to perform a search process at the same time. It is premised on the table generation method for minimizing the total data capacity, and the premise and the configuration are different.

[0013]

A relational database table creation method according to the present invention includes a view designing means for designing a view of a table to be finally created and a view column designed by the view designing means. A column designating unit that designates a column to which the same data is repeatedly input, an ID adding unit that automatically adds an ID to the column designated by this column specifying unit, and an ID that is added by this ID adding unit. A detail table / master table design means for designing a detail table and a master table by combining the columns of the view of the table and a view of the table from the detail table / master table designed by this detail table / master table design means Having a view generating means for generating And butterflies.

[0014]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described in detail with reference to the drawings.

[0015]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a block diagram showing the structure of database access software to which a relational database table creation method according to an embodiment of the present invention is applied. This database access software includes a table / view design function 1 for generating a table or a view of the relational database 2, a data input function 3 for inputting data to the table of the relational database 2, and a table in the relational database 2 as necessary. And a data access function 4 for searching and displaying the data of FIG.

The table / view designing function 1 includes a view designing unit 11, a column designating unit 12, and an ID adding unit 13.
And the detail table / master table design means 14
And a view generation unit 15.

The view design means 11 is a means for designing a view of a table to be finally generated by a user interface.

The column designating unit 12 is a unit for designating a column to which the same data is repeatedly input among the columns of the view designed by the view designing unit 11. This makes it possible to specify the column to which the ID is added in order to reduce the capacity of the entire table.

The ID adding means 13 is means for automatically adding an ID for associating the detail table and the master table to the column designated by the column designating means 12 without an operator's operation.

The detail table / master table design means 14 is means for automatically designing the detail table and the master table by combining the view columns of the table using the ID added by the ID adding means 13.

The view generating means 15 is means for generating a view of the table from the detail table and the master table designed by the detail table / master table designing means 14.

Referring to FIG. 2, the processing procedure of the relational database table creating method according to the present embodiment includes a view designing step S101 and a column specifying step S102.
And an ID addition step S103, a detail table generation step S104, and a master table generation step S105.

Referring to FIG. 3, view design step S
More detailed processing procedure of 101 is the column name input step S1.
11, a data type input step S112, and a column input end determination step S113.

Referring to FIG. 4, an ID adding step S1
03, the detail table generation step S104 and the master table generation step S105, the counter initialization step S121, column name and data type automatic input step S122, column name and data type automatic input step S123, detail Table generation step S124, designated column presence / absence determination step S125, counter increment step S126
And column name and data type automatic input step S127,
It includes a column name and data type automatic input step S128, a repetition end determination step S129, and a master table generation step S130.

FIG. 5 is a state transition diagram of the screen showing the sequential steps of table creation by the table creation method of the relational database of this embodiment.

Next, the method of creating the table of the relational database of the present embodiment thus constructed will be specifically described with reference to FIG.

First, the view design means 11 designs the view 51 of the table to be finally generated on the table design screen 50 by the operator inputting the columns (name and data type) of the view 51 (step S10).
1). Specifically, the view designing unit 11 inputs a column name (step S111) and a data type (step S111).
112), when the input of the column is completed (step S11)
3), end the process. Specifically, in the view 51 to be finally generated, the columns of “transaction No.”, “company name” and “person in charge” are input.

Next, the column designating means 12 designates a column in the view 51 on which the same data is repeatedly input on the table design screen 50 (step S102). Here, the "Transaction No." column is a unique number, but if the "Transaction No." is different, the "Company Name" and "Person in Charge" may have the same data entered in the same column. To do.
Therefore, if it is specified that the same data is repeatedly input to the columns of “company name” and “person in charge”, the designated column is highlighted.

At this time, the ID adding means 13 adds an ID for associating the detail tables 52 and 53 and the master table 51 in order to the designated column (step S103). Specifically, "ID_1" and "ID_2" are added.

Next, the detail table / master table design means 14 designs the detail tables 52 and 53 including the designated columns and the master table 51.

More specifically, the detail table / master table design means 14 initializes the counter n to 1 (step S121), and the column name and data of the column designated when the same data is repeatedly input by the column designation means 12. The type is automatically input as the column name and data type of the detail table (step S122), and the column name and data type of the table are automatically input by the column name and data type "ID" of "ID_n" (step S123). ), And the detail table 52 is generated (step S124). Specifically, the detail table 52 is designed by automatically adding the ID “ID_1” to the “company name” column designated as the column to which the same data is repeatedly input.

Next, the detail table / master table designing means 14 judges whether or not there is another designated column when the same data is repeatedly input by the column designating means 12 (step S125), and the presence is determined. Because
The counter n is incremented by 1 (step S12
6), control is returned to step S122, and step S12
The detail table 53 is generated by repeating steps 2 to 124. Specifically, in the column of "Person in charge", "ID
An ID named "_2" is automatically added, and the detail table 53 is designed.

Subsequently, the detail table / master table designing means 14 judges whether or not there is another designated column when the same data is repeatedly input by the column designating means 12 (step S125), and the presence is determined. Therefore, unspecified column names and data types are automatically input as the column names and data types of the master table (step S127), and the column names of "ID_n" and the column names of the data type "ID" The data type is automatically input (step S128), and it is determined whether or not the n-th repetition is completed (step S129). If not completed, the control is returned to step S128, and step S12 is executed.
8 is repeated n times to generate the master table 51 (step S130). Specifically, the master table 51 including “transaction No.” is generated.

Finally, the view generation means 15 combines the designated column and ID to create a view 51 of the table.
Is generated.

[0035]

As described above, the first effect of the present invention is that the view design means can create a view of a table to be finally created on the table design screen.

The second effect is that the column designating means can designate the column to which the same data is repeatedly input in the view of the table to be finally generated, whereby the detail table and the master table can be associated with each other. That is.

A third effect is that since the ID is automatically added to the column used by the ID adding means, the detail table and the master table can be automatically associated with each other.

The fourth effect is that since the table name and association are set, the view generating means can automatically generate a view of the table.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a functional configuration of database access software to which a relational database table creation method according to an embodiment of the present invention is applied.

FIG. 2 is a flowchart showing a processing procedure of a relational database table creation method according to the present embodiment.

3 is a flowchart showing a more detailed processing procedure of a view design step in FIG.

FIG. 4 is a flowchart showing a more detailed processing procedure of an ID addition step, a detail table generation step, and a master table generation step in FIG.

FIG. 5 is a state transition diagram of a screen showing the processing steps of the relational database table creation method of the present embodiment.

FIG. 6 is a flowchart showing a processing procedure of a conventional relational database table creation method.

FIG. 7 is a screen state transition diagram showing processing steps of a conventional relational database table creation method.

[Explanation of symbols]

 1 table view design function 2 relational database 3 data input function 4 data access function 11 view design means 12 column designating means 13 detail table / master table designing means 14 ID adding means 15 view generating means 50 table designing screen 51 master table 52, 53 Detail Table S101 View Design Step S102 Column Designation Step S103 ID Addition Step S104 Detail Table Generation Step S105 Master Table Generation Step S111 Column Name Input Step S112 Data Type Input Step S113 Column Input End Determination Step S121 Counter Initial Setting Step S122 Column Name and Data type automatic input step S123 Column name and data type automatic input step S124 Detail table Generation step S125 column specified presence judgment step S126 the counter increment step S127 column names and data types autofill step S128 column names and data types autofill step S129 repeat end determination step S130 master table generation step

Claims (2)

[Claims] 1. A view design means for designing a view of a table to be finally generated, and a column designating means for designating a column to which the same data is repeatedly input among the columns of the view designed by this view designing means. , A detail table and a master by combining an ID adding means for automatically adding an ID to a column specified by this column specifying means, and a view row of the table using the ID added by this ID adding means Detail table designing table
A table creating method for a relational database, comprising: a master table designing unit; and a view creating unit that creates a view of the table from the detail table and the master table designed by the detail table / master table designing unit. 2. The detail table / master table designing unit automatically inputs the column name and data type of the column designated by the column designating unit as the column name and data type of the detail table, and the column of the detail table. When the column name and data type of the table are automatically input by the ID added by the ID adding means to the name and data type to generate the detail table, and the column specified by the column specifying means does not exist, A column name and data type not specified are automatically entered as the column name and data type of the master table, and the column name and data of the table are identified by the ID added by the ID adding means to the column name and data type of the master table. The relational database table according to claim 1, wherein a type is automatically input to generate a master table. Creation method.