JPH08249345A - Item setting method for data base and information retrieval device for its actualization - Google Patents

Abstract

PURPOSE: To provide an item setting method for data base which can determine item names more surely and the information retrieval device for actualizing the method by retrieving and displaying similar item names without increasing the number of item names unnecessarily when item names are set at the time of the generation of a new data base or when ordinary retrieval is performed. CONSTITUTION: A dictionary of synonyms including relative words and homonyms is stored, and when an item name is inputted (S1103), synonyms of the item name are retrieved from the dictionary and displayed (S1104) and a desired item name is selected out of the displayed synonyms, so that the selected item name is registered (S1106). Further, retrieval from the data base is performed according to the retrieval item name and the retrieval result is displayed. When the retrieval result is displayed, information in a lower layer is displayed for plural retrieval results that can not be discriminated. For retrieval item names, the inputted item name and the displayed synonyms are registered hierarchically and the retrieval results are displayed hierarchically so that they can be discriminated.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database item setting method for setting items when newly creating and searching database data, and an information search apparatus for realizing the method.

[0002]

2. Description of the Related Art A database is a system which is shared by a plurality of users via a network or the like and is used for integrated management of data necessary for operation, and is a set of data. Item names are added to each data in the database, and when creating a new database, items, in both table format and card type,
It is necessary to design the format and attributes.

When a new database is created using a card type user interface, fields corresponding to items such as zip code, address, name, age, date of birth, company name, etc. are arranged on the card. And set. After the database is created as above,
When searching data, a text-based database search language is used as a condition setting method. As a simple database search, in many cases, a method of searching a record stored in the database using a card type user interface is used.

FIG. 17 shows a conventional layout example of a card type database. FIG. 17 shows the business card database 201, which is the layout of the panel window of the card type database. Reference numerals 202 to 206 represent database items, and reference numerals 207 to 211 represent data corresponding to the item names. When creating a new database, a panel window showing the new layout 301 is displayed as in the example of FIG. Here, reference numerals 302 and 303 indicate item names, and 304 indicates that item names are to be determined. Reference numerals 307 and 3
Reference numeral 08 denotes a field into which data corresponding to reference numerals 302 and 303 is input or output. When newly setting the item name of reference numeral 304, if you want to confirm the item name that has not been decided and has already been entered,
The existing data 309 is displayed by designating a part or all of the field for entering the item name, that is, the reference numeral 304 with an input device such as a mouse, and the item name displayed there is confirmed and selected from them. Or, set an item name that is not there, and create a layout.

Usually, when data is searched after the database is completed, the condition item of the record to be searched is input to the search screen or the search window created in advance and the search is performed. 19 and 20 are diagrams illustrating a window for inputting search conditions. Hereinafter, the window for inputting search conditions is called a search panel. Reference numeral 50
Reference numeral 1 denotes a database search panel. Reference numeral 502 represents a field of the search condition item.
Although the required item name is input in reference numeral 503 (here, “name” is input), if it is not known in advance, a list of existing item names is displayed as indicated by reference numeral 601 in FIG. Display and select from there. When an item name is selected and search OK of reference numeral 501 is pressed, as shown in the field of reference numeral 505 of FIG. 19, data 504 corresponding to the search item designated by reference numeral 503 is displayed.
Is displayed. When one or more or all of the search results are required, the required number is designated with a mouse or the like, and when the layout display 507 is further pressed, data is output on the layout as shown in FIG.

[0006] In addition, the database may be used individually or may be shared by several users via a network. In either case, the database may be newly created or searched. If you do, you need to set the items. When the database is shared by several users, each person can freely set items and create the database.

[0007]

However, in the past, since many existing item names are displayed without being classified, the list of items when setting items in a new layout and the search of the search panel are performed. In case of checking the already entered item name when the condition item is not decided beforehand, it is possible to check the existing data by specifying part or all of the field to enter the item name with an input device such as a mouse. It was difficult.

Further, when several users share a database, each person can create a database in which items are freely set, so that similar items may occur when a new layout item is newly set. There is a nature. For example, some people set "name" and others set "N".
If "ame" is set and another person sets "name", desired data may not be obtained depending on which item is selected when searching for them.

Further, when the search is performed after inputting the search condition items, when the name is searched, for example, "Aoki" of the same surname
However, there may be a drawback that even if there are two people, only one person is displayed, or if two people are displayed, it is difficult to distinguish which company Aoki is. The present invention, by setting the item name when creating a new database, or when performing a normal search, by searching and displaying a similar item name without increasing the item name more than necessary,
(EN) Provided are a database item setting method capable of more surely determining an item name, and an information search device which realizes the method.

Further, at the time of searching, effective searching can be performed by using existing data such as similar words, related words, and homophones for searching, and further, it is displayed like a list and selected for searching. (EN) Provided are an item setting method of a database and an information search device which realizes the method, which is a simpler operation by displaying a hierarchical structure.

[0011]

In order to solve this problem, a database item setting method of the present invention is a database item setting method for setting items when newly creating and searching database data. , Similar words including related words and homophones are stored as a dictionary, and when an item name is input, a similar word of the item name is retrieved from the dictionary and displayed, and a desired item is displayed from the displayed similar words. It is characterized in that the selected item name is registered by selecting the name.

The database item setting method of the present invention is a database item setting method for setting items when searching a database, and stores similar words including related words and homophones as a dictionary. When a name is input, a similar word of the item name is searched from the dictionary and displayed, and the input item name and the displayed similar word are registered as search item names.

Here, the database is further searched based on the search item name, and the search result is displayed. Further, in the display of the search results, information of a lower hierarchy is displayed for a plurality of search results which cannot be identified. Further, as the search item name, the input item name and the displayed similar word are hierarchically registered and further, a database is searched based on the search item name, and the search result is hierarchicalized. Correspondingly distinguishably displayed.

The information retrieval apparatus of the present invention is an information retrieval apparatus for retrieving data from a stored database, and a similar word storage means for storing a similar word including a related word and a homophone as a dictionary, and an item name. When the user inputs, the similar word display means for searching and displaying the similar word of the item name from the dictionary, and the desired item name is selected from the displayed similar words to newly select the selected item name. A database creating means for creating a database by registering as an item name of data is provided.

Further, the information retrieval device of the present invention is an information retrieval device for retrieving data from a stored database, and a similar word storage means for storing a similar word including a related word and a homophone as a dictionary, and an item name. When the user inputs, the similar word display means for searching and displaying the similar word of the item name from the dictionary and the desired item name is selected from the displayed similar words to search the selected item name. A database search means for registering as an item name and searching a database is provided.

The information retrieval device of the present invention is an information retrieval device for retrieving data from a stored database, and a similar word storage means for storing similar words including related words and homophones as a dictionary, and item names. In the case of inputting, a similar word display means for searching and displaying a similar word of the item name from the dictionary, and registering the input item name and the displayed similar word as a search item name, Database search means for searching a database.

Here, search result display means is further provided for displaying the search results and displaying information of a lower hierarchy for a plurality of unidentifiable search results. Further, the database search means, as the search item name, hierarchically registered the input item name and the displayed similar words, and searches the database based on the search item name,
Search result display means for displaying search results in a distinguishable manner corresponding to the hierarchization is further provided.

[0018]

Embodiments of the present invention will be described below in detail with reference to the accompanying drawings. First Embodiment <Configuration Example of Information Retrieval Device> FIG. 1 is a block diagram showing a configuration example of the information retrieval device of the present embodiment.

Reference numeral 101 denotes a mouse (M) 10 which is an input means.
Input device including 1a and keyboard (KB) 101b, 1
Reference numeral 02 is a central processing unit (CPU), 103 is a main storage device which is an internal storage means, and comprises a ROM for storing fixed programs and fixed parameters, and a RAM for loading the programs from a secondary storage device as necessary. 104 is C
Display device such as RT. A large-capacity secondary storage device 105 stores a system program 105a, database data 105d, a dictionary 105e including similar words, related words, homophones, a setting program 105b, and a search program 105c. It should be noted that in the secondary storage device, H
D, FD, CD-ROM, MO, etc. may be included. 106
Is a printer (PRT) which is an output device, and 107 is a network interface for connecting the present search device to the network through a line 108 so that several users or more can share and use the search device. Reference numeral 109 is a bus for exchanging signals input / output and controlled by the central processing unit 102 with each component.

<Operation Example of Information Retrieval Device> (Creation of Items on New Layout Panel) FIG. 2 shows a display example of the new layout, and FIG. 3 shows a display example of the initial setting panel.
FIG. 4 shows a flowchart of a processing procedure for creating an item on the new layout panel according to this embodiment. Before the process shown in FIG. 4 is started, the initial setting panel 402 is used to set "search for a similar item in a new layout" like 403a.

When the item creation of the new layout panel is started, the panel 301 of the new layout shown in FIG. 2 is displayed in step S1101 of FIG. Next, the process proceeds to step S1102, and if the similar item display has been initialized in advance as described above, step S1103.
Proceeding to, the input operation of the item name (reference numeral 401 in FIG. 2) desired to be set in the layout is performed. If the similar item display is not initialized, the flow advances to step S1107 to input the desired item name. In the new layout 301 of this embodiment shown in FIG. 2, for example, in step S1103 of FIG. 4, “telephone number” is input to 304 of FIG.

Then, in the next step S1104, a similar word of the input setting item "telephone number" is displayed. That is, as indicated by reference numeral 309 in FIG.
Four similar words “Tel No.” and “Telephone” are displayed. When the four displayed numbers are confirmed and it is determined that "telephone" is better than "telephone number", that is, in the display in step S1105 (reference numeral 309)
Since there is an appropriate item name in step S11, step S11
In step 06, the item name "telephone" is selected using the mouse 101a of the input device 101. Similarly, when the "telephone number" is good, the displayed item name is selected using the mouse in step S1106. In addition, selection with the mouse is
You can move the mouse cursor over the item name and double-click.

If the similar item display has not been initialized in step S1102, or in step S1105.
If there is no suitable item name in the current display, the process proceeds to step S1107, the desired item name is input, and the process proceeds to step S1108. Step S1108
Then, it is confirmed whether or not all the items required for the new layout have been created. If all the items have not been created yet, the process returns to step S1102 to determine another item name. In step S1108, if all necessary items have been created, the new layout panel item creation ends.

In the present embodiment, the range displayed in step S1104 is a dictionary of similar words, but a related word, a homophone, or a special dictionary created in advance may be used. As described above, according to the above item creation example,
When creating a new layout panel item, it is not necessary to check all the already registered item names, all that is necessary is to check the related item names, which makes the operation easier.

(Creation of Items on Search Panel) FIG. 5 shows an example 501 of the search panel of this embodiment. Further, FIG. 6 shows a flowchart of a processing procedure for creating an item on the search panel according to the present embodiment. This embodiment will be described below with reference to the search panel of FIG. 5 and the processing flowchart of FIG. When the process shown in FIG. 6 is started, the item name is input in step S1201. The search item is performed by inputting the item to be searched in the item input field 503 on the right side of the search condition item 502 shown in FIG. Here, the item name input in this embodiment is not limited to a reliable item name, but may be an item name that is similar to some extent. In the embodiment shown in FIG. 5, "name" is being entered.

Next, in step S1202, it is determined whether the similar item search button 701 has been pressed. If the similar item search button 701 has not been pressed, step S12
Proceed to 06. If the similar item search button 701 is pressed, the process advances to step S1203 to display the similar words of the setting item. For example, as shown in the field 503 of FIG. 5, “name” and “Name” are displayed in addition to “name”.

Next, in step S1204, it is checked whether or not there are appropriate items in the displayed items. If there is no suitable item, the process advances to step S1206 to set the item name input in step S1201 as an item on the search panel, and the item setting on the search panel ends. If there is an appropriate item in the display in step S1204, the flow advances to step S1205 to select the item considered appropriate in the display, and the item setting on the search panel ends.

As described above, according to the item creation example of the search panel, when setting the search panel to be searched in the database from now on, even if the input item name is not correct, the item name which is similar to the input item is input. Then, as shown in FIG. 5, similar item names are displayed in the field 503, and if there is an appropriate item name on the displayed screen, it can be selected and the item name can be set.

(Example 1 of Search Using Similar Words) FIG. 7 shows an example 501 of a search panel for explaining the present embodiment. A flowchart of the processing procedure of this example is shown in FIG. Below, FIG.
This embodiment will be described with reference to the search panel and the processing flowchart of FIG. When the search process including the similar words shown in FIG. 8 is started, the item name is input as the item setting of the search panel in step S1301. A search item is performed by inputting an item to be searched in the item input field 503 on the right side of the search condition item 502 shown in FIG. Here, also in the case of the present embodiment, the item name to be input may be a certain item name that is not similar to a certain item name and is similar to the item name. In the example of FIG. 7, “name” is entered.

Next, the process proceeds to step S1302. here,
It is determined whether the similar item search button 701 shown in FIG. 7 has been pressed. If the search button 701 has not been pressed, that is, if similar items have not been selected, the processing ends.
When the selection of the similar item is instructed by pressing the similar item search button 701, the process advances to step S1303 to display the similar word of the setting item as shown in the field 503 of FIG.

Next, when the similar word search button 801 is pressed in step S1304, the search result 504 is obtained and displayed as shown in the search result field 505 of FIG. 7 in the process of step S1305. This search result is displayed in the item input field 5 on the right side of the search condition item 502.
Similar to "Name" in 03, "Name", "Name"
The search for is also performed as a similar word search, and all search results are sorted and displayed.

As described above, according to the search example using the similar words, the general item name is input from the database to the search panel to be searched, and the similar item name is displayed in advance. The target database can be accessed by performing a search for similar item names. (Example of hierarchical search) In this example, the contents of the database are hierarchically structured, and if the same search result is obtained when searching the database, the next level of the search result is further displayed if necessary. This is an embodiment in which search results can be distinguished.

FIG. 9 shows an example 501 of a search panel for explaining this embodiment. A flowchart of the processing procedure of this embodiment is shown in FIG. The present embodiment will be described below with reference to the search panel of FIG. 9 and the processing flowchart of FIG. When the search process shown in FIG. 10 is started, the item name is input to the input field 503 as the search condition item 502 of the search panel 501 in step S1401. Next, proceeding to step S1402, a search is performed and the search result is displayed as the search result 504 in the search result field 505 of FIG.

Therefore, as shown in FIG. 9, when there are a plurality of "Aoki", the process proceeds to step S1403, and when one of the desired search results is selected, at the next step S1404,
If the same other item does not exist in the selected item, the search ends. If it exists, the process proceeds to step S1405,
The contents of other items with the same name are displayed as a hierarchical structure. In this embodiment, the address of the next layer is displayed in the field 901 for "Aoki", and the process ends.

In the present embodiment, the display of two layers is explained, but
Further, it is of course possible to have a display function of the following layers. Also,
In order to display the hierarchical structure, priorities may be set in advance at the time of initial layout. As explained above,
According to this hierarchical search example, when the same search result that is indistinguishable is obtained when the database is searched in a hierarchical structure, the contents of the database are further added to the next search result as needed. By displaying as a hierarchy, the search results can be distinguished.

(Example 2 of Retrieval Using Similar Words) In this example, when a search item name is input when searching a database, a similar word is searched for by a similar item even if the item name is not certain, This is an embodiment in which the search item of is displayed in the next hierarchy so that it is possible to distinguish whether the search result is for the input search item or for a similar item. .

FIG. 11 shows an example of the search panel 501 for explaining this embodiment. Further, FIG. 12 shows a flowchart of the processing procedure of the embodiment. This embodiment will be described below with reference to the search panel of FIG. 11 and the processing flowchart of FIG. When the search process shown in FIG. 12 is started, search condition items 502 on the search panel 501 are searched in step S1501.
Then, the search item name is input in the input field 503. In the case of FIG. 11, “name” is entered.

Next, in step S1502, if a similar item is not selected, the process proceeds to step S1509 and step S1509.
The search result is displayed for the item input in 1501 and the process ends. When a similar item is selected, a similar item search button 701 shown in FIG. 11 is pressed to display a similar word display field (see FIG. 1) as shown in step S1503.
A similar word of the setting item is displayed in 1001) of 1. In next step S1504, similar word search button 8 shown in FIG.
When 01 is pressed, in step S1505, if there is no similar word result, the process advances to step S1507 to display the search result in the search result field 505 as the result 504, and the process ends.

If it is determined in step S1505 that there is a result using a similar word, the process advances to step S1506. In step S1506, the search result corresponding to the similar item 1001 of the search condition item 502 is displayed as a hierarchy 1002 on the right side of the search result in FIG. As described above, according to the search example using this similar word, a search item similar to the input search item name can be searched, and the search result is similar to that corresponding to the input search item. Can be distinguished from search items.

(Example of Retrieval by Related Words) In this example, when it is desired to search by the related word search item when searching the database, the related word is searched and displayed with respect to the input item name of the search, and the related word item name is displayed. It is an embodiment in which a database can be searched. FIG. 13 shows an example of the search panel 501 for explaining the present embodiment. FIG. 14 shows a flowchart of the processing procedure of the embodiment. This embodiment will be described below with reference to the search panel of FIG. 13 and the processing flowchart of FIG.

When the search process shown in FIG. 14 is started, search condition item 5 on the search panel 501 is searched in step S1701.
As 02, the search item name is input to the input field 1602. Here, enter "soccer". Next, in step S1702, when the search including the related word is not performed,
The process advances to step S1706, the search result is displayed for the input "soccer", and the process ends.

When performing a related word search, the related word search button 1601 is pressed, and the flow advances to step S1703 after step S1702 to display a related word display field 1603.
Display related words in. In this example, "football"
And "Kickball" are displayed. Next step S1704
When the search OK button 506 is pressed in step S170,
The search result including the related word in 5 is output as the result 1604 to the search result field 505 in FIG. 13, and the search is terminated.

As described above, according to the search example using the related word, the search can be performed by including the related word of the input search condition item as the search condition item. (Example of search by homophone) In this example, if you want to search by the search item of the homophone when searching the database, search the homonym for the input search item name and display it, and then display the related word of the homophone. This is an embodiment in which a related word (or a similar word) that can be searched and is searched for is distinguished from the homonym and displayed in a hierarchical structure.

FIG. 15 shows an example of the search panel 501 for explaining this embodiment. 16 is a flowchart of the processing procedure of the embodiment. This embodiment will be described below with reference to the search panel of FIG. 15 and the processing flowchart of FIG. When the search process shown in FIG. 16 is started, a search item name is input in step S1901. In FIG.
“Name” was entered in the input field 503 to the right of the search condition item 502. Next, in step S1902, the word to be searched is input. In FIG. 15, “Aoki” is entered in the input field 1802 of the word to be searched. Then step S
In 1903, when the homonym is not searched, the process ends.

When searching for a homophone, a homophone search button 1801 is pressed to search for a homophone, and in step S1904, the result 1803 is output and displayed as the result 1803 in the search result 505. In the next step S1905, it is determined whether or not the related word of the homophone is searched, and when the related word of the homophone is not searched, the process proceeds to step S1907, only the search result of the homophone is output, and the process ends. Step S1905
In the case of searching for a related word of a homophone, by pressing a search OK button 506 of a homophone related word search 1805 of FIG. 15, a field of the related word other than the homophone word field 1803 is displayed in the search result field. Display in a hierarchical structure in 1804, and the process ends.

As described above, according to this homophone search example, a homonym can be obtained by inputting a condition name to be searched under the input item, and further, as a search result, a hierarchy can be obtained. Related words related to the search condition name entered in the structure (same-similar words with the same reading halfway) can be searched from the database. It should be noted that the above-described embodiments are limited examples for realizing the present invention, and combinations of these embodiments are possible, and other examples within the technical scope of the present invention are also possible. Further, the present invention may be applied to a system including a plurality of devices or an apparatus including one device. Further, it goes without saying that the present invention can be applied to the case where it is achieved by supplying a program to a system or an apparatus.

[0047]

According to the present invention, when setting an item name when a new database is created, or when performing a normal search, a similar word, a related word, a homonym, etc. are directly input without inputting the item. Is used to search, and the already set items are displayed, and by setting the items that are considered appropriate for the search or new layout, the similar item names can be displayed without increasing the item names more than necessary. The item name can be more surely determined by searching for and displaying.

Further, at the time of searching, effective searching can be performed by using existing data such as similar words, related words, and homophones for searching, and further, it is displayed like a list and selected for searching. In this case, displaying in a hierarchical structure makes the operation easier.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration example of an information search device according to an embodiment.

FIG. 2 is a diagram showing a display example of a new layout.

FIG. 3 is a diagram showing an initial setting panel.

FIG. 4 is a flowchart showing a procedure for creating items on a new layout panel according to this embodiment.

FIG. 5 is a diagram showing a search panel when setting a search panel according to the present embodiment.

FIG. 6 is a flowchart showing a search panel setting process according to the present embodiment.

FIG. 7 is a diagram showing a search panel at the time of searching for a similar word according to the present embodiment.

FIG. 8 is a flowchart showing a similar word search process of the present embodiment.

FIG. 9 is a diagram showing a search panel at the time of hierarchical search according to the present embodiment.

FIG. 10 is a flowchart showing a hierarchical search process of this embodiment.

FIG. 11 is a diagram showing a search panel during another similar word search according to the present embodiment.

FIG. 12 is a flowchart showing another similar word search process of the present embodiment.

FIG. 13 is a diagram showing a search panel when a related word is searched for according to the present embodiment.

FIG. 14 is a flowchart showing a related word search process of this embodiment.

FIG. 15 is a diagram showing a search panel when a homophone is searched for according to the present embodiment.

FIG. 16 is a diagram showing a flowchart showing homophone search processing of the present embodiment.

FIG. 17 is a diagram showing a conventional example of a layout of a card type database.

FIG. 18 is a diagram showing a panel window showing a layout when a new database is created.

FIG. 19 is a diagram showing a conventional window for inputting search conditions.

FIG. 20 is a diagram showing a conventional window for inputting search conditions.

[Explanation of symbols]

101 input device 101a mouse (M) 101b keyboard (KB) 102 central processing unit (CPU) 103 main storage device (RAM, ROM) 104 display device (CRT) 105 secondary storage device (HD, FD, MO, CD-) RO
M) 105a system program 105b setting program 105c search program 105d data 105e dictionary (similar words, related words, synonyms) 106 output device (PRT) 107 network interface 108 communication line

Claims (10)

[Claims] 1. A database item setting method for setting items when newly creating and searching database data, wherein similar words including related words and homophones are stored as a dictionary, and an item name is input. In this case, a similar word of the item name is searched from the dictionary and displayed, and a desired item name is selected from the displayed similar words to register the selected item name. Item setting method. 2. A database item setting method for setting an item when a database is searched, wherein similar words including related words and homophones are stored as a dictionary, and when the item name is input, the item name is stored. Is searched from the dictionary and displayed, and the input item name and the displayed similar word are registered as search item names. 3. The database item setting method according to claim 2, further comprising searching the database based on the search item name and displaying the search result. 4. The database item setting method according to claim 2, wherein in the display of the search results, information of a lower hierarchy is displayed for a plurality of unidentifiable search results. 5. The search item name is registered by hierarchically registering the input item name and the displayed similar word, and further searching a database based on the search item name, and searching the search result. 3. The database item setting method according to claim 2, wherein the items are displayed in a distinguishable manner corresponding to hierarchization. 6. An information retrieval device for retrieving data from a stored database, a similar word storage means for storing a similar word including a related word, a homophone, etc. as a dictionary, and an item name when the item name is input. By registering the selected item name as an item name of the new data by selecting a desired item name from the displayed similar words, a similar word display means for retrieving and displaying a similar word of the name from the dictionary. An information retrieval device comprising a database creating means for creating a database. 7. An information retrieval device for retrieving data from a stored database, a similar word storage means for storing a similar word including a related word and a homophone as a dictionary, and an item name when the item name is input. A similar word display means for searching and displaying a similar word of a name from the dictionary, and a desired item name is selected from the displayed similar words to register the selected item name as a search item name, and a database An information retrieval apparatus comprising: a database retrieval means for retrieving. 8. An information retrieval device for retrieving data from a stored database, a similar word storage means for storing a similar word including a related word, a homophone, etc. as a dictionary, and an item name when the item name is input. A similar word display means for searching and displaying a similar word of a name from the dictionary, and a database searching means for searching the database by registering the input item name and the displayed similar word as search item names. An information search device comprising: 9. The information search device according to claim 8, further comprising search result display means for displaying the search result and displaying information of a lower hierarchy for a plurality of unidentifiable search results. 10. The database search means hierarchically registers the input item name and the displayed similar word as the search item name, and searches the database based on the search item name. The search result display means for displaying the search result in a distinguishable manner corresponding to the hierarchical structure.
Information retrieval device described.