JPH064580A - Data base processor - Google Patents

Abstract

PURPOSE:To simplify procedure for attribute setting by automatically setting item attribute in accordance with a key word registered in advance when it is included, and setting attribute of default when it is not included. CONSTITUTION:A first key word is read in from the storage area 22 of a table with correspondence of key word and item attribute by a table read-in means 12 with correspondence of key word and item attribute, and it is delivered to an item name analysis means 14. The item name analysis means 14 analyzes whether or not an item name includes the key word, and analyzes the next key word when no key word is included in the item name. When the item name includes the key word, analysis is completed at that stage. In other words, an item attribute setting means 15 reads in the item attribute in accordance with the key word from the table 12 with correspondence of key word and item attribute, and stores it in the area 23 of the item attribute for each item via a storage means 13 for the item attribute. When no key word to be included exists, the item attribute of default is read in, and it is stored in the storage means 13.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database processing apparatus suitable for design processing of database management by a computer system.

[0002]

2. Description of the Related Art Conventionally, when a database is designed by a computer system, when a new item is added, the item name is first input and then the attribute of the item is designated. For example, "name" is input as the item name and "character string" is specified as the attribute. Alternatively, "telephone number" is input as the item name and "date display" of "character string" is specified as the attribute. Further, "age" is input as the item name, and "integer" of "numerical value" is specified as the attribute.

When designing a database in this way, the attributes of items must be specified, so
As a conventional method, a default attribute is specified when a new item is added, and the default attribute is changed if necessary.

[0004]

However, the attribute of the item specifies the internal state of the data, and it is a difficult task for a layman in the database to set the attribute. For example, if the item name is "amount", it is common sense that the attribute of this item is "numerical value", and when designing for this item, it must be "numerical value". However, the default attribute is uniformly "character string".
If is set, this attribute must be changed to "numerical value".

As described above, the task of changing the attributes is difficult for a layman of the database to perceive.
It was a laborious task even if you were not an amateur.

Therefore, in view of the above points, an object of the present invention is to provide a database processing device in which the effort for setting attributes is simplified.

[0007]

In order to achieve such an object, the present invention comprises means for analyzing the character string contents of item names,
According to the analysis described above, when a keyword registered in advance is included, an item attribute corresponding to the keyword is set, and when none of the keywords is included, a default attribute is set. is there.

In addition, it is possible to provide a means for making an inquiry request for an item attribute that cannot be determined only by the keyword.

[0009]

According to the above configuration of the present invention, the content of the character string of the item name is analyzed, and if the keyword registered in advance is included, the item attribute corresponding to the keyword is automatically set, and the item name indicates the keyword. If not included, set the default attributes as they are.

Further, if there is an item attribute (such as setting of a formula) that cannot be determined only by the keyword, the operator is inquired to complete the attribute content before setting. For example, when the keyword "total" is added to the end of the character string of the item name, if you set an attribute expression that indicates the sum of the values of multiple items, ask the operator to specify multiple items to be summed. , Set the attribute expression based on its contents.

[0011]

In the first embodiment of the present invention, a data input device, a data storage device, and a control device are provided, and a storage area for item names, a correspondence table for keywords and item attributes is provided in the data storage device. And an item attribute storage area for each item, and an item name fetching means, a keyword-item attribute correspondence table reading means, an item attribute storing means, and an item name analyzing means. In the database design process by the system having the item attribute setting means, the item attribute is automatically set according to the content of the character string of the item name.

The second embodiment of the present invention has a data input device, a data display device, a data storage device, and a control device, and has a storage area for item names and a keyword in the data storage device. It has a storage area of a correspondence table of item attribute expressions, a storage area of item attribute expressions of each item, and a storage area of inquiry messages for detailed information of item attribute expressions,
In the control device, an item name fetching means, a keyword / item attribute expression correspondence table reading means, an item attribute expression storing means, an item name analyzing means, an item attribute expression detailed information inquiring means, and an input information analysis Means and an item attribute expression setting means, in the design process of the database by the system, the item attribute expression is automatically set according to the character string content of the item name, and further detailed information is required for the attribute expression. In this case, a complete item attribute expression is set by supplementing by inquiring to the operator.

Two embodiments of the present invention will be described in detail below with reference to the drawings.

First Embodiment FIG. 1 is a block diagram showing the first embodiment of the present invention. In the figure, 1 is a control device and 2 is a data storage device.

In this control device 1, 11 is an item name fetching means, 12 is a keyword / item attribute correspondence table reading means, 13 is an item attribute storing means, 14 is an item name analyzing means, and 15 is an item attribute setting means. is there.

Further, in the data storage device 2, 21 is an item name storage area, 22 is a storage area of a keyword-item attribute correspondence table, and 23 is an item attribute storage area of each item.

FIG. 2 is a flowchart showing a processing procedure for setting an attribute for one item name in this embodiment.

The operation of this embodiment will be described with reference to the flow chart shown in FIG.

First, the item name fetching means 11 reads the item name from the item name storage area 21 and passes it to the item name analyzing means 14 (step S21).

Next, the keyword / item attribute correspondence table reading means 12 reads the first keyword from the storage area 22 of the keyword / item attribute correspondence table and passes it to the item name analyzing means 14 (step S22).

The item name analysis means 14 analyzes whether or not the item name includes this keyword (step S23), and if not, analyzes the next keyword (step S25).

If the item name includes a keyword (step S23: Yes), the analysis ends at that point. That is, the item attribute setting means 15 reads the item attribute corresponding to the keyword from the keyword / item attribute correspondence table 12, and stores it in the item attribute storage area 23 of each item via the item attribute storage means 13 ( Step S
27).

When there is no keyword to be included in the analysis, the default item attribute is also read through the table 12 and stored through the item attribute storage means 13 (steps S25 → S26 → S27).

Here, for example, when the embodiment is executed for the item names shown in FIG. 3 by using the keyword item attribute correspondence table of FIG. 4, the item attributes shown in FIG. 5 are obtained.

In the table of FIG. 4, the description of the item attribute is in the form of "basic attribute (character or numerical value) / special attribute)", and the default item attribute is always at the end of the table.

Embodiment 2 FIG. 6 is a block diagram showing a second embodiment of the present invention. In the figure, 100 is a control device, 200 is a data storage device, 300 is an input device, and 400 is a display device.

In the control device 100, 111 is an item name fetching means, 112 is a keyword / item attribute expression correspondence table reading means, 113 is an item attribute expression storing means, 11
4 is an item name analysis means, 115 is an item attribute expression setting means, 1
Reference numeral 16 is a means for inquiring detailed information of the item attribute expression, 117
Is an inquiry message reading means, and 118 is an input information analyzing means.

Reference numeral 221 in the data storage device 200 indicates an item name storage area, 222 indicates a keyword / item attribute expression correspondence table storage area, 223 indicates an item attribute expression storage area of each item, and 224 indicates item attribute expression detailed information. Is an area for storing an inquiry message for.

FIG. 7 is a flow chart showing a processing procedure when setting an attribute expression for one item name using this embodiment.

Next, the processing procedure of this embodiment will be described according to the flow of FIG.

First, the item name fetching means 111 reads the item name from the item name storage area 221, and passes it to the item name analyzing means 114 (step S71).

Next, the keyword / item attribute expression correspondence table reading means 112 transfers the first keyword from the storage area 222 of the keyword / item attribute expression correspondence table to the read item name analysis means 114 (step S7).
2). The item name analysis unit 114 analyzes whether or not the item name includes this keyword (step S73), and if not, analyzes the next keyword. If there are no more keywords, the analysis ends (step S
74: Yes). If there is no keyword included in the analysis, the item attribute expression is not stored and the item attribute expression is not stored, and the process proceeds to the next item.

If the item name includes a keyword, the item attribute formula setting means 115 determines the item attribute formula (step S75). However, if the contents of the corresponding attribute formula are incomplete, for example, When the attribute expression is an attribute expression indicating the sum of the values of a plurality of items, the inquiring means 116 for the detailed information of the item attribute expression inquires the operator about a plurality of items to be summed, through the inquiry message reading means 117. The corresponding inquiry message is read from the inquiry message storage area 224 for the formula detailed information (step S77), this message is displayed on the display device 400 (step S78), and the operator inputs the detailed information (in this case, the input device 300). , Multiple items to be totaled) are specified (step S7)
9), it is analyzed whether the information input by the input information analysis means 118 is the detailed information of the item attribute expression, and if it is the detailed information of the attribute expression (step S80: No), this is added and the corresponding item attribute is added. The formula is determined (step S81) and stored in the item attribute formula storage area 223 of each item via the item attribute formula storage means 113 (step S82).

If there is no input information and the designation of detailed information is canceled (step S80: Yes),
If there is no item attribute expression, the item attribute expression is not stored and the next item is processed.

Here, for example, for the item names shown in FIG. 8, using the keyword item attribute expression correspondence table of FIG. 9 and the message table corresponding to the attribute expressions of FIG. The item attribute expression shown in FIG.

In the table of FIG. 9, "* total" in the keyword means that the last character of the item name is "total", and "total (item 1 + ... + item n)" of the item attribute expression.
Means that the sum of the values of item 1 to item n is the value of that item.

It should be noted that the above-described first and second embodiments are not only carried out independently, but also together (item attribute,
Of course, both item attribute expressions may be analyzed).

[0038]

As described above, according to the present invention, the character string content of an item name is analyzed, and if a keyword registered in advance is included, the item attribute corresponding to the keyword is automatically set, and the item name If does not include a keyword, the default attribute is set as it is. Furthermore, if there is an item attribute (such as a formula setting) that cannot be determined only by the keyword, the operator is inquired to complete the attribute content. Since it is configured after setting it, it is possible to set the item attribute of the database to some extent by simply entering the word that the content of the item name can be intuitively understood, and even an amateur of the database can easily set the attribute. Can be set.

[Brief description of drawings]

FIG. 1 is a block diagram showing a first embodiment of the present invention.

FIG. 2 is a flowchart showing a processing flow of the first exemplary embodiment of the present invention.

FIG. 3 is a diagram showing an example of an item name table used in the first embodiment of the present invention.

FIG. 4 is a diagram showing an example of a correspondence table of keywords and item attributes used in the first embodiment of the present invention.

FIG. 5 is a diagram showing an item attribute table obtained by the first embodiment of the present invention using the example of the tables of FIGS. 3 and 4.

FIG. 6 is a block diagram showing a second embodiment of the present invention.

FIG. 7 is a flowchart showing a flow of processing according to the second embodiment of the present invention.

FIG. 8 is a diagram showing an example of an item name table used in the second embodiment of the present invention.

FIG. 9 is a diagram showing an example of a correspondence table of keywords and item attributes used in the second embodiment of the present invention.

FIG. 10 is a diagram showing an example of an inquiry message table corresponding to item attribute expressions used in the second embodiment of the present invention.

FIG. 11 is a diagram showing an item attribute expression table obtained by the second embodiment of the present invention with reference to FIGS. 8 to 10.

[Explanation of symbols]

1 Control Device 2 Data Storage Device 11 Item Name Importing Means 12 Keyword / Item Attribute Correspondence Table Reading Means 13 Item Attribute Storage Means 14 Item Name Analyzing Means 15 Item Attribute Setting Means 21 Item Name Storage Area 22 Keywords and Item Attribute Storage Areas Storage area of correspondence table 23 Storage area of item attribute of each item 100 Control device 111 Item name fetching means 112 Corresponding table reading means of keyword and item attribute expression 113 Item attribute expression storing means 114 Item name analyzing means 115 Item attribute expression setting Means 116 means for inquiring additional information of item attribute expression 117 means for reading inquiry message 118 input information analyzing means 200 data storage means 221 storage area for item name 222 storage area for correspondence table of keyword and item attribute expression 223 item attribute of each item Storage area of inquiry message of Storage 224 attribute type details 300 input device 400 display device

Claims (2)

[Claims] 1. A means for analyzing a character string content of an item name, and if the analysis includes a keyword registered in advance, an item attribute corresponding to the keyword is set, and any keyword is included. A database processing apparatus, comprising: means for setting a default attribute if not present. 2. The database processing apparatus according to claim 1, further comprising means for making an inquiry request for an item attribute that cannot be determined only by the keyword.