JPH05250416A - Registering and retrieving device for data base - Google Patents

Abstract

PURPOSE:To provide a device whose retrieval hitting rate is high by converting an inputted keyword and a keyword being immanent in registered data with a prescribed conversion rule, and replacing them with a representative word in a representative word dictionary. CONSTITUTION:The device is constituted of an input/output device 1 for inputting a retrieval keyword and registered data, and outputting the data retrieved actually to a screen, an input control means 2 for receiving an input from the input/output device 1, an output control means 3 for outputting the data to the input/output device 1, a keyword converting means 4 for converting the inputted keyword by five conversion rules, a representative word registering means 51 for defining and registering a representative word to each keyword to a representative word dictionary 6, a representative word determining means 52 for reading in the representative word dictionary 6 from an auxiliary storage device, and determining the representative word concerned, a data registering means 7 for registering the data to a data base 8, and a data retrieving means 9 for retrieving the data registered already.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database registration / retrieval device for storing the whereabouts of books.

[0002]

2. Description of the Related Art In order to collect and store documents such as books and papers and retrieve and extract desired documents from the vast amount of stored documents, the name of each document, author's name, date of issue, place of publication and document Document data is registered in an electronic computer together with various keywords indicating the contents of the above, a database is created, and the documents to be sought in these databases are searched for using the keywords input by the operator as the search keywords.

Such a conventional database registration / retrieval apparatus will be described with reference to the conventional database registration / retrieval apparatus shown in FIG.

When a plurality of keywords and document data for each document are newly registered in the database 8, the data that has been input by the operator from the input / output device 1 is
The data registration means 7 has written in the database 8 of the auxiliary storage device.

Further, when searching the document data already registered in the database 8 by a keyword, the keyword input by the operator from the input / output device 1 is directly passed to the data search means 9 and the database 8 of the auxiliary storage device is searched. I was searching.

[0006] However, in the above-mentioned conventional technique, in order to express the same meaning content, but to express differently for each individual, the keyword input by the operator (even if it is the same operator, depending on the time) is It may be in a different word, and although the document data you want to retrieve actually exists in the database 8, it is treated as there is no corresponding document data,
There was a problem that search omission occurred. For example, when searching for information about “United States”, keywords such as “U.S.A.”, “US”, and “Americ
When "a" and "3" are entered and the respective searches are performed, the respective search results should be the same, but the conventional method results in different results.

[0007]

According to the conventional technique described above, even when expressing the same meaning, the operator inputs different keywords (even if the same operator is used) for searching. Therefore, there is a problem that the search may be missed even though the information to be retrieved actually exists in the database.

An object of the present invention is to preliminarily consider a database management system in which data is registered as an integrated database that can be processed by a computer so that a plurality of users can share it, various information is converted into keywords, and retrieval is performed by using these keywords. It has a representative word dictionary in which possible keywords and their synonyms correspond to one representative word, and the keywords input by the operator during the registration / search process are converted according to a certain conversion rule and unified, and then converted into the representative word dictionary. It is an object of the present invention to provide a database registration / search device having a high search hit rate by registering document data and searching the database by replacing the defined representative word.

[0009]

To achieve the above object, in the first invention, data is registered as an integrated database that can be processed by a computer so that a plurality of users can share it, and various information is converted into keywords. , In the database management system that searches with this keyword, unification of minor differences in the keyword character string input by the operator and keyword conversion means for unifying characters that are apt to be mis-input by a certain conversion rule, and operator input A word that can be considered as a keyword and its synonym are unified by the keyword conversion means, collected as a keyword, a representative word registration means for defining and registering one representative word in a representative word dictionary, and the representative word registration means, The key word unified by the keyword conversion means is stored in the registered representative word dictionary. Representative word determining means for searching whether a word is defined and extracting a representative word corresponding to this keyword, and auxiliary memory already registered when the representative word is newly registered in the representative word dictionary by the representative word registering means. In order to make the newly registered representative word correspond to the data in the database of the device, all the keywords existing in the data are replaced with the representative word extracted by the representative word determination means, and the data registration means writes the data in the database of the auxiliary storage device. , A data search means for searching the data already registered in the database, replacing the keyword after conversion and unification with the representative word extracted by the representative word determining means, and searching the database of the auxiliary storage device as the search keyword Composed of and.

In a second invention, in the first invention, when a keyword entered by an operator includes a period, a space, a lowercase letter, a long sound, and a hyphen, the operators are unified by a predetermined conversion rule. And a keyword conversion means for correcting characters that are apt to be erroneously input.

According to a third aspect of the invention, in the first aspect of the invention, when the data is newly registered in the database of the auxiliary storage device, the operator input keyword contained in the data to be registered is extracted by the representative word determining means. It is composed of a data registration unit which replaces the representative word and writes it in the database.

[0012]

[Function] A representative word dictionary in which a plurality of synonyms as search keywords are defined corresponding to one representative word is created by the representative word registration means, and when the operator actually registers or searches data in the database, Periods, spaces, lowercase letters,
The long sound (-), hyphen (-), etc. are converted and unified by five conversion rules by the keyword conversion means. Whether or not the representative word is defined in the representative word dictionary by the converted and unified keyword is searched and extracted.

In the case of newly registering a document in the database, the data registration means searches for a keyword designated by the operator in the document data, and replaces it with the representative word extracted by the representative word determining means and registers it. When new information is added to the representative word dictionary (keyword / representative word), the newly added keyword specified by the operator and existing in all document data already registered in the database is defined in the representative word dictionary. Replace it with the representative word and register again.

When searching the document data already registered in the database, the database is searched using the representative word extracted by the representative word determining means as a search keyword.

[0015]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A process for collecting documents such as books and papers, registering them as a database, and searching by a keyword is an embodiment of the present invention, and the overall configuration will be described with reference to FIG.

Reference numeral 1 is an input / output device for inputting a keyword for search and data to be registered, and for actually outputting the searched data and search results on a screen. Reference numeral 2 is an input from the input / output device 1. Is an output control means for outputting data to the input / output device 1. Reference numeral 4 is a keyword conversion means for converting and unifying the inputted keywords by five conversion rules (details of the conversion rules will be described later). Reference numeral 5 is a representative word managing means for managing a representative word dictionary 6 for storing and defining a representative word for each keyword, which is stored in the auxiliary storage device. And a representative word registering means 51 for registering and defining the representative word in the representative word dictionary 6.
And a representative word determining means 52 for searching the representative word dictionary 6 for a representative word corresponding to the designated keyword and extracting the corresponding representative word. Reference numeral 7 is a data registration means for replacing each keyword contained in the document data with the representative word extracted by the representative word determining means 52 and then writing each document data in the database 8 of the auxiliary storage device. Reference numeral 9 finds the corresponding data in the database 8 with the search keyword, which is obtained by replacing the keyword input by the operator for searching by the keyword converting means 4 and replacing it with the representative word extracted by the representative word determining means 52. It is a data search means.

Next, five conversion rules will be described with reference to the keyword conversion rule table of FIG. 1 if the operator entered a keyword with a period 2
Indicates that there is a space in the keyword entered by the operator, 3 indicates that the keyword entered by the operator has lowercase letters, 4 indicates that the keyword entered by the operator has a long sound (-), and 5 indicates that the operator entered This is a conversion rule when a hyphen (-) is present in the keyword.

Among the five conversion rules, 1 to 3 minimize the difference in the notation of each operator and do not have to register the synonyms of the keywords in the representative word dictionary 6 due to the slight difference in the character strings. This is to prevent search omissions.

For example, as a keyword,
Operator A writes "U"
SA ", operator B" U. S. A. ", Operator C is" U SA ", operator D is" u. s.
a. ", The input of operator B is converted based on conversion rule 1, the input of operator C is based on conversion rule 2, and the input of operator D is based on conversion rule 1 and conversion rule 3. Same as input "US
It is unified to A ". By performing conversion with these three conversion rules, it is possible to prevent unnecessary representative word registration and omission of search due to simple difference in notation.

The conversion rules 4 and 5 are for minimizing the operator's input error. Generally, hyphen (-) and long sound (-) are easily mistaken for the same thing,
The operator often inputs the hyphen (-) and the long sound (-) without distinguishing them (unconsciously). When checking with the human eye, there is no problem because neither hyphen (-) nor long tone (-) changes. However, in the case of information retrieval processing by a computer, since it is all performed by an internal code, if the code number is different, it will be treated as if a completely different word was input.

For example, in the Japanese Industrial Standard (JIS) Kanji code table, hyphen (-) and chorus (-) are code number "0161" and code number "0128", respectively.
Therefore, to express Europe, "yo (hyphen) roppa" is expressed as a code number, "051
0,0161,0577,0535,0549 "and" Yaw (long sound) Loppa "is" 0510,012
8,0577,0535,0549 ". When the search process is executed with the search keyword" Yo (hyphen) Roppa "in the database 8 in which the data described in" Yo (long sound) Roppa "is registered, the search keyword "Yo
The result is that there is no data that corresponds to "(hyphen) Loppa". By correcting the hyphen (-) and the long sound (-) that were unintentionally input in this way based on conversion rules 4 and 5, , "Yo (hyphen) Roppa" and "Yo (long sound) Roppa" can be unified as "Yo (long sound) Roppa", so it is possible to prevent omission of search due to misleading hyphen (-) and long sound (-) input errors. You can

Next, the data registration processing in the database 8, the data retrieval processing in the database 8 and the registration processing in the representative word dictionary 6 described above, the flow of the registration / retrieval processing in FIGS. 2 and 3 and the representative in FIG. Word dictionary example 1, representative word dictionary example 2 in FIG.
The actual processing flow will be described with reference to.

First of all, an embodiment of a search process in the case where a keyword input by an operator is converted and unified by a conversion rule and then a corresponding representative word is defined in the representative word dictionary 6 will be described.

The operator inputs from the input / output device 1 using the word "U.S.A." as a search keyword as a keyword (S1). The input control means 2 that has received the keyword from the input / output device 1 passes the processing to the keyword conversion means 4. The keyword converting means 4 converts the keyword “U.S.A.” input according to the five conversion rules in the conversion rule table (FIG. 2). In the case of the inputted keyword "U.S.A.", it corresponds to "If a period exists, the period is taken and packed." In the conversion rule 1 of the keyword conversion rule table of FIG. 2 (S2), "US
A ”(S3). Other conversion rules (2-5)
Therefore, the converted keyword is passed to the representative word managing means 5 as “USA”.

The representative word management means 5 reads the representative word dictionary 6 whose definition is registered in the auxiliary storage device (S1).
2), the representative word determining means 51 causes the converted keyword "US"
It is searched whether or not "A" is defined in the representative word dictionary 6 (S1).
3). Since "USA" (D1) is defined as a representative word in the column "USA" (K1) of the representative word dictionary example 1 in FIG. 4, "America" is taken out as a representative word (S1).
4). The representative word determined in this way is passed as a search keyword to the data search means 9. The data search means 9 reads the database 8 in which information is registered from the auxiliary storage device (S16). Specifying the search processing designation of the database 8 (S17),
The representative word "America" is searched as a search keyword (S18). If the relevant document data exists, the relevant data is read and the output control means 3 is instructed to output the data to the input / output device 1 (S19). At this time, if there is no corresponding document data, the output control means 3 is instructed to display on the input / output device 1 that there is no corresponding information (S).
20).

Secondly, an embodiment of the retrieval process in the case where the corresponding representative word is not defined in the representative word dictionary 6 after conversion and unification of the keyword input by the operator according to the conversion rule is shown.

The operator inputs a word "United State of America" as a search keyword from the input / output device 1 as a keyword (S1).
The input control means 2 that has received the keyword from the input / output device 1 passes the processing to the keyword conversion means 4. The keyword conversion means 4 follows the five conversion rules in the conversion rule table (FIG. 2) to input the keyword “United Sta”.
te of America ”. Entered keyword "United State of Am
In the case of "erica", the conversion rule 2 of the keyword conversion rule table of FIG. 2 is "If there is a space, pad the space." (S4) and the conversion rule 3 is "If there is a lower case character, all are capitalized." Yes. ”(S6), so it is converted to“ UNITED STATE OF AMERICA ”(S5, S7). Other conversion rules (1, 4,
Since it does not correspond to 5), the keyword after conversion is "UNI
"TEDSTATE OF AMERICA" is passed to the representative word managing means 5.

The representative word managing means 5 reads the previously defined representative word dictionary 6 in the auxiliary storage device (S12),
The representative word determination means 52 sends the converted keyword “U
It is searched whether or not "NITED STATE OF AMERICA" is defined in the representative word dictionary 6 (S13). According to the representative word dictionary example 1 in FIG. 4, there is no corresponding word,
The keyword before conversion is not registered in the representative word dictionary 6 (S
21), the keyword before conversion (because it indicates the keyword entered by the operator, "UnitedStat"
e of America ") is set as a search keyword and is passed to the data search means 9 (S15). The data search means 9 reads the database 8 in which information is registered from the auxiliary storage device (S16). The search process of the database 8 is designated (S17), the database 8 is searched (S18), and if there is document data corresponding to the keyword before representative word conversion, the corresponding data is read and the output control means 3 is instructed. Then, the data is output to the input / output device 1 (S19). At this time, if there is no corresponding document data, the output control means 3 is instructed that there is no corresponding information,
It is displayed on the input / output device 1 (S20).

Thirdly, an embodiment of processing for newly registering a representative word and a keyword in the representative word dictionary 6 will be shown.

The operator inputs keywords and representative words to be registered in the representative word dictionary 6 from the input / output device 1. The input control means 2, which has received the keyword “yo (hyphen) lopper” and the representative word “Europe” from the input / output device 1, follows the five conversion rules in the conversion rule table (FIG. 2). -(Hyphen) Loppa "will be converted. Entered keyword "Yo (hyphen) Roppa"
In the case of, the conversion rule 3 of the keyword conversion rule table of FIG.
(S6) and the conversion rule 5 "Hyphen (-) after kana character is changed to long sound (-)." (S10) correspond to "yaw (long sound) rots (upper case)" from each condition.
It is converted to "P" (S7, S11). Since it does not correspond to the other conversion rules (1, 2, 4), "yaw (long sound) rotpa" is passed to the representative word management means 5 as a keyword corresponding to the representative word "Europe".

The representative word managing means 5 reads the previously defined representative word dictionary 6 in the auxiliary storage device (S12),
It is searched whether or not it is already registered in the representative word dictionary (S13). Since it is not registered in the representative word dictionary example 1 in FIG. 4 (S21), the processing is passed to the representative word dictionary registration means 51. The representative word registering means 51 registers the passed converted keyword "Europe" and the representative word "Europe" in the representative word dictionary 6 (S22). Once registered, the representative language dictionary 6,
It is updated as shown in the representative word dictionary example 2 of FIG. 5 (K3.
D3).

Since the keyword and the representative word are newly registered in the representative word dictionary 6, the newly registered representative word can be used when searching the document data already registered in the database 8. The database 8 is read by the database registration means 7 (S16). Since the registration process is designated (S17) and the representative word dictionary is updated (S23), all the keywords corresponding to the newly registered representative word existing in the database 8 are replaced with the representative word (S24), and the auxiliary storage device is stored. The data is written in the database 8 (S25).

Fourthly, an embodiment of processing for newly registering document data in the database 8 will be shown.

The operator inputs the document data to be registered in the database 8 and the keyword "US" to be used as a search keyword from the input / output device 1 (S1). The input control means 2 that has received the keyword from the input / output device 1 passes the processing to the keyword conversion means 4, and the keyword conversion means 4 follows the five conversion rules in the conversion rule table (FIG. 2) to input the input keyword “US”. Will be converted. In the case of the input keyword “US”, it does not correspond to the conversion rules (1 to 5) in the keyword conversion rule table of FIG.
After conversion, the keyword remains "US" and the representative word management means 5
Passed to.

The representative word management means 5 reads the previously defined representative word dictionary 6 in the auxiliary storage device (S12),
It is searched whether or not the passed keyword “US” after conversion is defined in the representative word dictionary 6 (S13). According to the representative word dictionary example 1 in FIG. 4, “America” (D2) is defined as a representative word in the “US” (K2) column of the representative word dictionary 6, so “America” is taken out (S14). ..

Next, the data registration means 7 uses the database 8
Is read (S16). Since the new data registration process is designated (S17) and the representative word dictionary 6 is not updated (S2)
3) All "US" in the newly registered document data is replaced with the representative word "US" (S26), and the data is written in the database 8 of the auxiliary storage device (S25).

The present embodiment has been described with reference to the example of database registration and data retrieval of document data, but as other examples, it can be realized by a company information retrieval system or a map information retrieval system.

[0038]

As described above, by collecting a plurality of information retrieval keywords and their synonymous keywords and providing a representative word dictionary that defines the synonyms of the synonymous words, the words normally used by oneself can be defined. Even if you enter it as a keyword,
Since it is converted into a representative word in the representative word dictionary, the search efficiency can be improved without using nerves for keyword selection.

Further, in the key operation when inputting a keyword, the period, the space, the lowercase letter, the long sound (-), the hyphen (-), etc., which are likely to cause an input error by the operator, are provided with the keyword converting means.
Even if an erroneous input is made, since the conversion means are unified, it is not necessary to use the nerve for the key operation, the efficiency of the input operation is improved, and the recognition difference due to the input difference at the time of retrieval is also eliminated.

Therefore, according to the present invention, it is possible to realize a database registration / search device having a high search hit rate.

[Brief description of drawings]

FIG. 1 is an overall configuration diagram of the present invention,

FIG. 2 is a keyword conversion rule table,

[Figure 3] Flow of registration / search processing,

FIG. 4 is a representative word dictionary example 1,

FIG. 5 is a representative word dictionary example 2,

FIG. 6 is a conventional database registration / search device.

[Explanation of symbols]

 1 ... Input / output device, 2 ... Input control means, 3 ... Output control means, 4 ... Keyword conversion means, 5 ... Representative word management means, 51 ... Representative word registration means, 52 ... Representative word determining means, 6 ... Representative word dictionary, 7 ... Data registering means, 8 ... Database, 9 ... Data searching means.

Claims (3)

[Claims] 1. A database of an auxiliary storage device storing various kinds of information data so that the data can be shared by a plurality of users is registered in the database so that it can be processed by a computer, various kinds of information are converted into keywords, and retrieval is performed by using these keywords. In the database management system, in order to unify the character strings input by the operator and correct the characters that are apt to be erroneously input, the keyword conversion means for converting and unifying the input keywords according to a certain conversion rule, and the keyword and the operator input Synonyms of the synonyms are unified by the keyword conversion means, and are summarized as keywords. 1
Representative word registering means for defining and registering in the representative word dictionary corresponding to one representative word, and whether the unified keyword defined by the keyword converting means is defined in the representative word dictionary registered and defined by the representative word registering means. A representative word determining means for searching for a representative word corresponding to the keyword, and a representative word registering means for storing the data in the database of the auxiliary storage device already registered when the representative word is newly registered in the representative word dictionary. In order to correspond to the newly registered representative word, all the keywords existing in the data are replaced with the representative word extracted by the representative word determination means, and the data registration means is written in the database of the auxiliary storage device and already registered in the database. In order to search the data of the above, the keyword after conversion and unification is placed in the representative word extracted by the representative word determining means. Instead, the registration and the database, characterized in that a data retrieval means for retrieving a database of auxiliary storage device as a search keyword
Search device. 2. In the keyword entered by the operator,
When there are periods, spaces, lowercase letters, long tones, and hyphens, it is possible to unify the input string of the operator by unifying the conversion according to the predetermined conversion rules, and the keyword conversion means for correcting the characters that are apt to be input incorrectly The database registration / retrieval device according to claim 1. 3. When data is newly registered in the database of the auxiliary storage device, operator-entered keywords existing in the data to be registered are replaced with representative words extracted by the representative word determining means, and data is written in the database. The database registration / retrieval device according to claim 1, further comprising means.