JPS6284322A - Data inputting system for data base system - Google Patents

Abstract

PURPOSE:To make key inputting easy and prevent mistake of inputting by displaying a menu of words and phrases that can be inputted automatically for specified items. CONSTITUTION:When inputting data in tabulated form, a cursor is shifted to the place for inputting an item of the third record 'position', and in internal processing, it is judged that the item 'position' has a dictionary, and relevant words and phrases are read out and menu display is made in the lowermost part and a user selects relevant one. When there is no relevant words and phrases in the cursor display, next menu is displayed by designation of the next menu. It is also possible to input characters directly from a keyboard when there is no relevant words and phrases in the menu. In this case registration of words and phrases to the dictionary is made automatically.

Description

[Detailed Description of the Invention] [Field of Application of the Invention] The present invention relates to a data input method in a database system, and particularly to a data input method suitable for a database system configured on a personal computer. be.

[Background of the invention]

In conventional database systems, when entering data into a table, it is based on inputting data one after another from the keyboard. However, there are some data editing functions that have the ability to copy data between records, and you should use this. Although this alleviates the hassle of repeatedly inputting data, it requires searching for the same word or phrase among those that have already been input, and it is of course possible that the word or phrase that you want to input does not exist. Therefore, no essential solution has been reached.

Method A, which has already been adopted as a countermeasure for this problem, is to utilize a user dictionary found in Japanese language processing. This allows users to freely register words and phrases that are considered to be used frequently in the dictionary.
It is a dictionary that can be registered by dividing it into groups and adding a reading (key word) for each group to retrieve it.However, when inputting data into a database using this method, , it is not clear which items the user dictionary can be used for or not, and even if it is available, the pronunciation for accessing the dictionary is not specified, so much is left to the user's memory, making it difficult to use. No consideration was given to this. Related devices of this type include Japanese Patent Application Laid-open No. 147237/1983.

[Purpose of the invention]

An object of the present invention is to provide a means for facilitating data input in a relational database system that handles data as a set of tables in which columns are items and rows are records. [Summary of the Invention] As shown in Fig. column, record REC
In a relational database system in which data is stored in cells defined by rows and columns in a table TBL whose rows are CELL, and data is handled as a collection of cells CELL, inputting or updating data into the table TBL is usually done in the following way. , is performed by inputting characters from the keyboard.

However, in certain items in the table, such as affiliation, gender, place of birth, etc. in the table rBL in Figure 1, certain words (for example, general affairs, labor, men and women, etc.) are repeated. When used, it is tedious to manually key in the same words and phrases over and over again.

Therefore, in the present invention, predetermined words and phrases are grouped and registered as a dictionary, and the correspondence relationship with the dictionary is stored as one of the item attributes for each item in the table into which data is input. From this point, when inputting or updating the corresponding item in the table, it is determined whether or not to extract the word from the dictionary based on the above attributes.
If retrieval is possible, the words in the dictionary are automatically retrieved, and the user can enter data into cells in the database by simply selecting the desired words. It is something.

By making it possible to have a 1:n correspondence between groups of words in the dictionary and items in the table, it can be used commonly for inputting data to all tables in the database, and it is also possible to make effective use of registered words. .

[Embodiments of the invention]

Hereinafter, one embodiment of the present invention will be described with reference to the drawings.

Figure 2 is an example of inputting data in table format.
To enter data into the record item "Affiliation",
This shows the situation immediately after the cursor CR8R has been moved to that location. In internal processing, it is determined that the item "Affiliation" has a dictionary, the relevant words are read out, and a menu is displayed at the bottom of the screen.The user selects the relevant word from among these. By selecting (for example, entering the menu number), the cursor position CR
Data is displayed on 8R. If the corresponding word is not found in the menu display, the next menu will be displayed by specifying the next menu. If the corresponding word or phrase is not in the menu, you can also enter characters directly from the keyboard, and in this case the word will be automatically registered in the dictionary.

If the item at the cursor position in the table does not have a dictionary, the above words will not be displayed in the menu and will be entered directly from the keyboard.

FIG. 3 is a data configuration diagram necessary for realizing the present invention, including item attribute data FLDAT corresponding to each item in the table.
It consists of R, dictionary DICT, etc.

The item attribute data FLDATH includes dictionary specification information DIC.
There is a DAT, and the item consists of information on whether or not the item has a dictionary, and if so, information on which word group WGNO in the dictionary corresponds to.
The data in the dictionary DICT is group management table GM
It consists of NGT and a phrase table WRDT, and a pointer in the group management table GMNGT points to a corresponding location in the phrase table WRDT. In addition, since the group management table GMNGT also has a reading IDX, it can also be accessed using the reading IDX as in normal Japanese processing.The zero-word table WRDT is maintained by inputting new words and deleting them. In addition, when a word is selected, it is maintained by a learning function that moves the selected word to the beginning of the group.

FIG. 4 is an internal processing flow, showing processing when inputting or updating data on a table. In Sl, it is determined whether the item has a dictionary, and if it does not have a dictionary, the process ends. If you have, in S2,
Read the corresponding word from the dictionary, display the menu, and proceed to S3.
and waits for input from the user. If any of the menus is selected, the menu display is erased in steps 84 to S5, and
After maintenance of the word table (such as the first function), the code of the selected word is output in S6, and the process ends. If the next menu request or previous menu request is selected in S3, the next menu screen or the previous menu screen is displayed only when the phrase menu spans multiple screens. If word registration is selected in S3, input of the registered word is waited for at $7, the word is registered in the dictionary at S8, and the code of the word is output at 86, and the process ends. If you choose to delete a word with $5, wait for the word to be deleted in S9, and if one of the menus is selected,
Delete the selected word from the dictionary O Figure 5 shows the set of dictionary specification information in item attributes or
This is a processing flow at the time of reset.

In S11, it is determined whether there is dictionary specification information for the item, and if there is no dictionary specification information, in 812 to S14, the contents of the word groups that have already been registered are sequentially displayed, and the process waits for the user to select a word group. , S sets the selected word group to the dictionary specification information in the item attributes in 815
If yes in step 11, the content of the specified word group is displayed in steps 816 to S17, and instructions from the user are awaited. Instructions from the user include changing the word group used in the item, deleting the word group, and deleting 9 newly registered words in the word group. Changing a word group is the same as steps 812 to S15 above, and deleting a word group resets the dictionary designation information in the item attributes in 818. Register new words within a word group.

Words and phrases are deleted from 87 to S8 in FIG. and 89~S
Same as 10.

〔Effect of the invention〕

According to the present invention, when inputting or updating data to a table with items as columns and records as rows, a menu of words that can be entered automatically is displayed for a specific item, so you can use the keyboard to input data into or update a table. When inputting characters, it is possible to simplify manual labor and prevent input errors.0
Furthermore, compared to the case where the user consciously reads out the dictionary and inputs it, it not only saves the trouble of inputting the pronunciation to access the dictionary, but also eliminates the need to know the pronunciation in advance, reducing the burden on the user. 〇Also, since a menu of words that can be entered for each item is displayed, the words that can be used are limited, and it is possible to avoid incorrect use of similar words or subtle differences in expression format. It can be prevented.

This makes it possible to prevent data to be searched from being omitted from the search target or being interpreted as different data during a search process or the like.

[Brief explanation of drawings]

Fig. 1 is a configuration diagram showing an example of table data in a relational database system that handles data as a set of tables with columns as columns and rows as records. Fig. 2 shows an example of table data when using the data input method according to the present invention. FIG. 3 is a schematic diagram showing an example of an operation screen. FIG. 3 is a data configuration diagram necessary to realize the data input method according to the present invention. FIGS. O is a flowchart showing the processing procedure. Table FLDi in the relational database system. RECl... Record C.
R8R...Cursor MENU...Word menu FLDATRl...Item attribute data DI for item l
CT...Dictionary DICDAT...Dictionary specification information WGNO...Word group NO GMNGT...Word group management table W RD
'r... Word registration table WGNOi... Word registration areas 81 to 818 included in word group 1... End of each step of processing ゛□, 7. Patent Attorney Katsutoshi Ogawa

Claims (1)

[Claims] A relational database system that stores data in cells defined by rows and columns in a table where a collection of data consisting of multiple items is one record, items are columns, and records are rows, and the data is handled as a collection of cells. In,
A dictionary storage means for storing predetermined words and phrases corresponding to the items for items in the table in which only a plurality of specific words and phrases are used in duplicate as cell data in the item. , an attribute storage means for storing an attribute indicating whether or not the item has the dictionary; a determination means for determining whether or not to extract a haiku from the dictionary according to the item to which data is input; and the determination means 1. A data input method for a database system, comprising a storage means for extracting and storing a word or phrase from the dictionary in a cell in the database when it is determined that the word or phrase should be extracted.