JP3005201B2 - Database search system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database search system for searching a database.

[0002]

2. Description of the Related Art Conventionally, in a database search operation, a database search system for performing a search by inputting search condition data has been used. In such a database search system, an operator inputs search condition data and finds desired item data from records displayed on the display screen of the display device as having item data matching the search condition. , Was doing a database search.

[0003]

However, such a conventional database search system has the following disadvantages. That is, among the item data in the record obtained as the search result, the item data that matches the search condition data is
In spite of redundant data, it was displayed on the display screen. Therefore, it has been sometimes difficult for an operator to find desired item data in a record obtained as a search result. This was particularly noticeable when searching a database having a large number of items.

[0004] An object of the present invention is to provide a database search system capable of easily finding desired item data in a record obtained as a search result in view of the problems of the related art.

[0005]

The present invention has the following features to attain the object mentioned above. According to a first aspect of the present invention, there is provided a display unit for displaying an image, a database storage unit for storing a database including records having at least one item data, and Search condition data input means for inputting search condition data indicating conditions for extracting records, and database search means for extracting the record having the item data matching the search condition data from the database storage means. Controlling means for displaying an image of the item data corresponding to an item other than the item input as the search condition data in the item data in the record extracted by the database searching means on the display means as a search result (Corresponding to claim 1)

The display means is a CRT (Catho).
de Ray Tube), a liquid crystal display, etc., the database storage means is a hard disk or the like, the search condition data input means is a mouse, a keyboard, etc., and the database search means and the control means are a CPU.
(Central Processing Unit)
And so on. The search condition data may be data indicating a specific value or data indicating a certain range. Further, the database search means may extract a record having item data that partially matches the search condition data from the database storage means.

According to the first aspect of the present invention, an image is displayed by the display means. A database including records having at least one item data is stored by the database storage unit. Search condition data indicating conditions for extracting the record from the database storage unit is input by the search condition data input unit. The record having the item data matching the search condition data is extracted from the database storage unit by the database search unit. An image of the item data corresponding to an item other than the item input as the search condition data among the item data in the record extracted by the database search unit is displayed on the display unit as a search result by the control unit. Is done.

As described above, the item data corresponding to items other than the item input as the search condition data among the item data in the record obtained by the search is displayed, so that the item data in the record obtained as the search result is displayed. Desired item data can be easily found.

According to a second aspect of the present invention, a display means for displaying an image, a database storage means for storing a database comprising records having at least one item data, and Search condition data input means for inputting search condition data indicating conditions for extracting the record from the database storage means, and storing the record having the item data completely matching the search condition data in the database storage means A database search unit that extracts from the database search unit an image of the item data corresponding to an item other than the item input as the search condition data among the item data in the record extracted by the database search unit. Control means for displaying on the display means. To (corresponding to claim 2).

[0010] Here, the search condition data may be data indicating a specific value or data indicating a certain range. According to the second aspect of the present invention, the image is displayed by the display means. A database including records having at least one item data is stored by the database storage unit. Search condition data indicating conditions for extracting the record from the database storage unit is input by the search condition data input unit. The record having the item data that completely matches the search condition data is extracted from the database storage unit by the database search unit.
An image of the item data corresponding to an item other than the item input as the search condition data among the item data in the record extracted by the database search unit is displayed on the display unit as a search result by the control unit. Is done.

According to a third aspect of the present invention, in order to solve the above-described problem, the control means displays an image of the search condition data on the display means in addition to an image as a search result. Claim 1
Or the invention described in claim 2 (corresponding to claim 3).

According to the third aspect of the present invention, the control means displays an image of the search condition data on the display means in addition to the image as the search result. Also,
According to a fourth aspect of the present invention, in order to solve the above-described problem, the control unit further includes, in addition to an image as a search result,
An image of an item name corresponding to the item input as the search condition data is displayed on the display means, and an image of the search condition data is displayed on the display means in association with the image of the item name. That is, the invention of claim 1 or 2 is specified (corresponding to claim 4).

According to the fourth aspect of the present invention, in addition to the image as a search result, an image having an item name corresponding to the item input as the search condition data is displayed on the display means by the control means. At the same time, the image of the search condition data is displayed on the display means in association with the image of the item name.

According to a fifth aspect of the present invention, in order to solve the above-mentioned problems, a display means for displaying an image, a database storage means for storing a database comprising records having at least one item data, Search condition data input means for inputting search condition data indicating conditions for extracting the record from the database storage means, and extracting the record having the item data matching the search condition data from the database storage means Database search means, and an image of an item name of the item data of the record is displayed on the display means, an image of the search condition data is displayed on the display means in association with the image of the item name, The image of the item name corresponding to the item other than the item input as the search condition data is displayed in the above table. Means, and among the item data in the record extracted by the database search means, an image of the item data corresponding to an item other than the item input as the search condition data is displayed as a search result. Control means for displaying on the display means in association with an image (corresponding to claim 5).

According to the fifth aspect of the present invention, an image is displayed by the display means. A database including records having at least one item data is stored by the database storage unit. Search condition data indicating conditions for extracting the record from the database storage unit is input by the search condition data input unit. The record having the item data matching the search condition data is extracted from the database storage unit by the database search unit. An image of an item name of the item data included in the record is displayed on the display unit by the control unit, an image of the search condition data is displayed on the display unit in association with the image of the item name, and the search condition An image of an item name corresponding to an item other than the item input as data is displayed on the display means, and among the item data in the record extracted by the database search means, the item input as the search condition data An image of the item data corresponding to an item other than the item is displayed on the display unit as a search result in association with the image of the item name.

According to a sixth aspect of the present invention, in order to solve the above-mentioned problems, a display unit for displaying an image, a database storage unit for storing a database including records having at least one item data, Search condition data input means for inputting search condition data indicating conditions for extracting the record from the database storage means, and storing the record having the item data completely matching the search condition data in the database storage means Database search means for extracting the item name of the item data of the record, and displaying the image of the item name of the record on the display means, and displaying the image of the search condition data on the display means in association with the image of the item name. An image having an item name corresponding to an item other than the item input as the search condition data. And displaying the image of the item data corresponding to an item other than the item input as the search condition data among the item data in the record extracted by the database search unit as a search result. Control means for displaying on the display means in correspondence with the name image (corresponding to claim 6).

According to the sixth aspect of the present invention, an image is displayed by the display means. A database including records having at least one item data is stored by the database storage unit. Search condition data indicating conditions for extracting the record from the database storage unit is input by the search condition data input unit. The record having the item data that completely matches the search condition data is extracted from the database storage unit by the database search unit. An image of an item name of the item data included in the record is displayed on the display unit by the control unit, an image of the search condition data is displayed on the display unit in association with the image of the item name, and the search condition An image of an item name corresponding to an item other than the item input as data is displayed on the display means, and among the item data in the record extracted by the database search means, the item input as the search condition data An image of the item data corresponding to an item other than the item is displayed on the display unit as a search result in association with the image of the item name.

According to a seventh aspect of the present invention, in order to solve the above-mentioned problems, a display means for displaying an image, a database storage means for storing a database comprising records having at least one item data, Search condition data input means for inputting search condition data indicating conditions for extracting the record from the database storage means, and extracting the record having the item data matching the search condition data from the database storage means A table comprising at least one or more cells, wherein the number of rows is 2, and the number of columns is the same as the number of item data items in the record. A table comprising at least one or more cells displayed on the display means, wherein the number of rows is 2 or more and the number of columns is The display means displays an image of the second table, which is a number obtained by subtracting the number of search condition data from the number of item data included in the code, and displays the image of the item name of the item data included in the record. Means for displaying each of the cells constituting the one row of the first table displayed on the means, respectively, so that the image of the search condition data corresponds to the image of the item name displayed on the display means. Display in the image of the cell displayed in a row different from the row in which the image of the item name is displayed in the same column as the column in which the image of the item name is displayed, and the item data included in the record Displaying an image of an item name corresponding to an item other than the item input as the search condition data in the image of the cell constituting one row of the second table, respectively, Thus, among the item data in the extracted records, the image of the item data corresponding to items other than the item input as the search condition data constitutes another row of the second table as a search result. Control means for displaying each of the items corresponding to the image of the item name in the cell image (corresponding to claim 7).

According to the seventh aspect of the present invention, an image is displayed by the display means. A database including records having at least one item data is stored by the database storage unit. Search condition data indicating conditions for extracting the record from the database storage unit is input by the search condition data input unit. The record having the item data matching the search condition data is extracted from the database storage means. The control means displays the image of the first table having at least one or more cells, wherein the number of rows is 2 and the number of columns is the same as the number of item data items of the record. A table comprising at least one cell, wherein the number of rows is two or more, and the number of columns is a number obtained by subtracting the number of search condition data from the number of item data of the record. 2 is displayed on the display means, and the image of the item name of the item data included in the record is an image of the cell constituting one row of the first table displayed on the display means And the image of the search condition data is displayed in the same row as the column in which the image of the item name is displayed in association with the image of the item name displayed on the display means. Different from the displayed row Appears in the image of the cells displayed in the item data is a by the search condition image is the second item name corresponding to the item other than the input item of the data to which the record has
Corresponding to items other than the items input as the search condition data among the item data in the records extracted by the database search means, each being displayed in the image of the cell constituting one row of the table of FIG. The image of the item data is displayed as a search result in the image of the cell constituting another row of the second table in association with the image of the item name.

According to an eighth aspect of the present invention, in order to solve the above-mentioned problems, a display means for displaying an image, a database storage means for storing a database comprising records having at least one item data, and Search condition data input means for inputting search condition data indicating conditions for extracting the record from the database storage means, and storing the record having the item data completely matching the search condition data in the database storage means And a table comprising at least one cell, wherein the number of rows is 2
The image of the first table whose number of columns is the same as the number of item data of the record is displayed on the display means, and is a table including at least one or more cells, wherein the number of rows is 2. As described above, the image of the second table in which the number of columns is the number obtained by subtracting the number of the search condition data from the number of the item data of the record is displayed on the display unit, and the item of the item data of the record is displayed. An image of the name is displayed in each of the images of the cells constituting one row of the first table displayed on the display means, and the image of the search condition data is displayed on the display means. Corresponding to the image of the item name, the image of the item name is displayed in the same column as the image of the cell displayed in a different row from the row in which the image of the item name is displayed in the same column, The item that the record has The image of an item name corresponding to an item other than the item input as the search condition data is displayed in the image of the cell constituting one row of the second table. An image of the item data corresponding to an item other than the item input as the search condition data among the item data in the record extracted by the means is configured as another search row in the second table. Control means for displaying each of the items in the image of the cell in association with the image of the item name (corresponding to claim 8).

According to the eighth aspect of the present invention, an image is displayed by the display means. A database including records having at least one item data is stored by the database storage unit. Search condition data indicating conditions for extracting the record from the database storage unit is input by the search condition data input unit. The record having the item data that completely matches the search condition data is extracted from the database storage unit by the database search unit. The control means displays the image of the first table having at least one or more cells, wherein the number of rows is 2 and the number of columns is the same as the number of item data items of the record. A table comprising at least one cell, wherein the number of rows is two or more, and the number of columns is a number obtained by subtracting the number of search condition data from the number of item data of the record. 2 is displayed on the display means, and the image of the item name of the item data included in the record is an image of the cell constituting one row of the first table displayed on the display means Are displayed within
A row in which the image of the item name is displayed in the same column as the column in which the image of the item name is displayed in association with the image of the item name displayed on the display means, The image of the item name displayed in the image of the cell displayed in a different row and corresponding to the item data other than the item input as the search condition data in the item data of the record is the second item. Each of the item data in the record extracted by the database search means corresponding to an item other than the item input as the search condition data is displayed in the image of the cell constituting one row of the table. The image of the item data is displayed as a search result in the image of the cell constituting another row of the second table in association with the image of the item name.

According to a ninth invention of the present application, in order to solve the above-mentioned problem, when the plurality of search condition data are provided, the database search means may perform a search based on all AND conditions of the search condition data. The invention according to any one of claims 1 to 8 is specified by extracting the record from the database storage means (corresponding to claim 9).

According to the ninth aspect of the present invention, when the plurality of search condition data are found, the record is extracted from the database storage means based on all AND conditions of the search condition data by the database search means. Is done.

According to a tenth aspect of the present invention, in order to solve the above-mentioned problem, selection data input means for inputting selection data for selecting an image of the item data displayed as a search result on the display means. 10. The apparatus according to claim 1, further comprising: a search condition data weighting unit configured to use the item data based on the image selected by the selection data as the weighted search condition data. The present invention has been specified (corresponding to claim 10).

According to the tenth aspect of the present invention, selection data for selecting an image of the item data displayed as a search result on the display means is input by the selection data input means. The item data on which the image selected by the selection data is based is weighted by the search condition data weighting means as the search condition data.

[0026]

FIG. 1 is a block diagram showing an embodiment of the present invention.
10 through FIG.

[0027]

FIG. 1 shows a database search system 10 according to an embodiment of the present invention. This database search system 10 is a PC (Personal)
Computer) for searching the product database. Here, the PC product database includes manufacturer data, model number data, and CPU (Central Processing) of PCs sold in the market.
Unit) clock frequency data in megahertz (MHz), memory size data in megabytes (MB), HDD (Hard Disk Drive)
ve), storage capacity data in units of bytes (B), display screen size data in units of inches of display, CD-ROM (Compact Disk-Rea).
d Only Memory), which is a database composed of a set of records having item data of read speed magnification data, chassis type data, and expansion slot number data.

As shown in FIG. 1, the database search system 10 includes a mouse 11, a keyboard 12, a display device 13, and a computer body 20. Further, the computer main body 20 includes a mouse interface 21, a keyboard interface 22, a display device interface 23,
A storage device interface 25, a memory 26, and a control unit 27;
And a storage device 24 connected to the storage device 24. The mouse 11 is connected via a mouse interface 21.
The keyboard 12 is connected to the bus B1 via the keyboard interface 22, and the display device 13 is connected to the bus B1 via the display device interface.

The mouse 11 and the keyboard 12 are devices for an operator to input data and the like. The mouse 11 and the keyboard 12 correspond to search condition data input means and selection data input means.

The display device 13 is a device for displaying images for PC product database search, characters input from the keyboard 12, and the like. FIG. 2 shows an image in an initial state of the PC product database search. In FIG. 2, on a display screen 31 of the display device 13, a condition input area 33 which is an area for inputting search condition data, a table display area 36 which is an area for displaying search result data, , And the mouse cursor 32 are displayed. The condition input area 33 is an image of a table including a search item name display line 34 and a search item data input line 35. The search item name display row 34 is composed of search item name display cells for displaying respective item names of the PC product database to be searched. Search item data input line 35
Is composed of search item data input cells for inputting data as search conditions. Table display area 36
Is an image of a table including an item name display line 37 and an item data display line 38. The item name display line 37 is constituted by an item name display cell for displaying an item name of an item in which a search item data input cell is blank, that is, an item for which search condition data has not been input. The item data display line 38 is the A of all search condition data input in the search item data input line 35.
Each item data in a record obtained as a result of searching the PC product database according to the ND condition is constituted by an item data display cell for displaying each item data in association with an item name display cell for displaying the item name of the item data. I have.
This item data display line 38 is displayed in the same number as the number of records obtained as a result of the search. The item data display line 38 is not displayed when there is no record matching the search condition. This display device 13
Corresponds to the display means.

The computer body 20 is a device for executing a program and the like. Mouse interface 2
Reference numeral 1 denotes a device that receives data input by a user from the mouse 11 and transmits the data to the bus B1.

The keyboard interface 22 is a device for receiving data input by a user from the keyboard 12 and transmitting the data to the bus B1. The display device interface 23 is a device for displaying characters, images, and the like on the display device 13.

The storage device 24 is a hard disk device for storing a program processed by the control unit 27, a PC product database, a PC product database definition file, and the like. Here, the PC product database definition file is a file that holds definition data including the item names of the above-described PC product database. The storage device 24 corresponds to a database storage unit.

The storage device interface 25 is a device for writing data to the storage device 24 and reading data from the storage device 24. The memory 26 is a RAM
And the like, and are used for the operation of the control unit 27.

The control unit 27 is constituted by a CPU or the like, and issues a screen display instruction to the display device interface 23.
Further, the control unit 27 instructs the storage device interface 25 to write data to the storage device 24 and to read data from the storage device 24. Further, the control unit 2
7 receives input data from the mouse 11 via the mouse interface 21 and
Input data is received from the keyboard 12 through the input device 2.
Further, the control unit 27 performs processing of data such as characters input from the mouse 11 and the keyboard 12 and processing of screen data to be displayed on the display device 13. The control unit 27 corresponds to a database search unit, a control unit, and a search condition data weighting unit. <Description of Operation of Embodiment> Next, the contents of control realized by the control unit 27 executing a program stored in the storage device 24 will be described with reference to the flowcharts of FIGS.

When receiving the instruction data for starting the PC product database search operation from the mouse 11 or the keyboard 12, the control unit 27 starts the control shown in FIGS.

After the start, in the first step S001, the control unit 27 reads the PC product database definition file from the storage device 24. Then, the control unit 27 causes the display screen 31 of the display device 13 to display an initial image for searching the PC product database as shown in FIG. 2 based on the contents of the PC product database definition file.

In the next step S 002, the control unit 27 sets the condition input area 33 displayed on the display screen 31 of the display device 13.
When any one of the search item data input cells in the search item data input row 35 of FIG.
wait.

In the next step S003, the control unit 27 waits for search condition data to be input. In the next S004, the control unit 27 displays the content of the search condition data input in S003 in the search item data input cell clicked in S002.

In the next S005, the control unit 27 executes
The PC product database is searched according to the search condition data input in step 3, and a record matching the conditions is obtained. Then, the control unit 27 writes the record thus obtained in the memory 26.

In the next S006, the control unit 27 sets
An item name display row 37 including the same number of item name display cells as the items other than the item corresponding to the search item data input cell clicked in 2 is displayed on the display screen 31 of the display device 13. Further, the control unit 27 controls an item data display row 38 composed of the same number of item data display cells as the number of item name display cells.
Are displayed in the same number as the number of records obtained in S005.

In the next step S007, the control unit 27 sets
Item names other than the item corresponding to the search item data input cell clicked in 2 are displayed in the item name display cells displayed in S006. Further, the control unit 27
The item data of the item corresponding to the search item data input cell clicked in S002 is removed from each record obtained in 005. Then, the control unit 27 causes the content of each record obtained by this processing to be displayed on the item data display line 38, respectively.

In the next step S008, the control unit 27 sends the instruction data to end the search to the mouse 11 or the keyboard 1.
It is checked whether input has been made from step 2. Then, if the input has not been made, the process proceeds to S009, and if the input has been made, the process ends.

In step S009, the control unit 27 checks whether any of the search item data input cells or the item data display cells has been clicked by the mouse 11.
If none of the cells has been clicked, the process returns to step S008. If any cell has been clicked, the process returns to step S0.
Move to 10.

In the next step S010, the control unit 27 sets
It is checked whether the cell clicked at 9 is a search item data input cell or an item data display cell. If the clicked cell is a search item data input cell, the process proceeds to S011, and if it is an item data display cell, the process proceeds to S013.

In S011, the control unit 27 waits for search condition data to be input. In the next step S012, the control unit 27 causes the content of the data input in S011 to be displayed as new search condition data in the search item data input cell clicked in S009. Thereafter, the process proceeds to S014. On the other hand, if it is determined in S010 that the item data display cell is the clicked cell, the next S
At 013, the control unit 27 causes the content of the item data displayed in the item data display cell to be displayed as new search condition data in the search item data input cell corresponding to the item of the item data. Thereafter, the processing is S
Go to 014.

In S014, the control unit 27 searches the record stored in the memory 26 by using the data newly set as the search condition data in S012 or S013, and obtains a record that matches the condition. Then, the control unit 27
The record thus obtained is written in the memory 26.

In the next step S015, the control unit 27 sets the item name display row 37 including the same number of item name display cells as the items other than the item whose data is displayed in the search item data input cell.
Is displayed on the display screen 31 of the display device 13. Further, the control unit 27 sets an item data display row 38 including the same number of item data display cells as the number of item name display cells in S01.
The same number of records as the number obtained in step 4 are displayed.

In the next step S016, the control unit 27 causes the item names other than the item whose data is displayed in the search item data input cell to be displayed in the item name display cells displayed in S015. Further, the control unit 27 removes the item data of the item whose data is displayed in the search item data input cell from each record obtained in S014. Then, the control unit 27 causes the content of each record obtained by this processing to be displayed on the item data display line 38, respectively. afterwards,
The process returns to S008. <Operation procedure when the operator searches the database> Next, an example of the operation procedure and the display device 1 when the operator searches the PC product database.
FIG. 2 shows an example of an image displayed on the display screen 31 of FIG.
And FIG. 6 to FIG.

In the following work procedure example, the operator sets the item data value corresponding to the item name “CPU” to “15”.
0 ”and the item data value corresponding to the item name“ HDD ”is“
A record in which the value of the item data corresponding to “1.3G” and the item name “display” is “17” is searched.

First, when the operator inputs instruction data for starting the search of the PC product database from the mouse 11 or the keyboard 12, the initial screen for searching the PC product database as shown in FIG. Is displayed on the display screen 31.

Next, the operator operates the mouse 11 to move the mouse cursor 32 to a search item data input cell located immediately below the search item name display cell in which the item name "CPU" is displayed. (FIG. 6).

Next, the operator clicks the mouse 11. Then, the operator inputs “150” from the keyboard 12 as the first search condition data.
Then, an item name display row 37 including the same number of item name display cells as the number of items other than the item name “CPU” among the items included in the PC product database is displayed. Further, the item data display rows 38 each having the same number of item data display cells as the item name display cells are displayed by the same number as the number of records whose item data value corresponding to the item name “CPU” is “150”. Then, among the item names included in the PC product database, item names other than the item name “CPU” are displayed in the item name display line 3.
7 are displayed in respective item name display cells. Further, the contents of each item data corresponding to items other than the item name “CPU” in the record in which the value of the item data corresponding to the item name “CPU” is “150” are displayed in the item name display line 37. The respective item names are displayed in the respective item data display cells in the item data display row 38 (FIG. 7).

Next, the operator operates the mouse 11 to move the mouse cursor 32 to the search item name display cell in which the item name “HDD” in the search item name display row 34 of the condition input area 33 is displayed. The mouse is moved to the search item data input cell located immediately below and the mouse 11 is clicked. Then, the operator inputs “1.3G” from the keyboard 12 as further search condition data. Then, an item name display line 37 including the same number of item name display cells as the number of items other than the item name “CPU” and the item name “HDD” among the items included in the PC product database is displayed. Further, an item data display line 38 composed of the same number of item data display cells as the item name display cells has an item whose item data value corresponding to the item name “CPU” is “150” and whose item name corresponds to the item name “HDD”. Data value is "1.3G"
The same number of records as are displayed. And P
Item name "C" among item names included in C product database
Item names other than “PU” and item name “HDD” are displayed in respective item name display cells in the item name display row 37.
The value of the item data corresponding to the item name “CPU” is “15”.
Item data in a record in which the value of the item data corresponding to item ID “0” and “HDD” is “1.3G”, and corresponds to items other than the item name “CPU” and the item name “HDD” The content of each item data to be displayed is the item name display line 37.
Each item name is displayed in each item data display cell in the item data display row 38 corresponding to each item name displayed therein (FIG. 8).

Next, the operator operates the mouse 11 to display the mouse cursor 32 with the value of the display screen size "17" in inches of the item name "display" in the table display area 36. Is moved to the displayed item data display cell (FIG. 9).

Further, the operator clicks the mouse 11. Then, “17” is displayed in the search item data input cell located immediately below the search item name display cell in which the item name “display” in the search item name display row 34 is displayed. Then, an item name display line 37 including the same number of item name display cells as the items other than the item name “CPU”, the item name “HDD”, and the item name “display” among the items included in the PC product database is displayed. You. Further, in the item data display line 38 composed of the same number of item data display cells as the item name display cells, the item data value corresponding to the item name “CPU” is “150” and the item corresponding to the item name “HDD” is displayed. The data value is “1.3G”, and the item data value corresponding to the item name “display” is “1”.
The same number of records as the number of records 7 "are displayed. Among the item names included in the PC product database, item names other than the item name" CPU ", the item name" HDD ", and the item name" display "are displayed. Are displayed in the respective item name display cells in the item name display row 37. Further, the item name "CP"
The value of the item data corresponding to “U” is “150”, and the value of the item data corresponding to the item name “HDD” is “1.3”.
G ", and item data in a record in which the value of the item data corresponding to the item name" display "is" 17 ", the item name being" CPU ", the item name" HDD ", and the item name" display ". Item data corresponding to items other than "" is displayed in each item data display cell in the item data display line 38 in association with each item name displayed in the item name display line 37 (FIG. 10).

As described above, according to the present embodiment, only the item data other than the item data corresponding to the search condition among the item data in the record obtained as the search result is displayed. It is possible to easily find desired item data among the item data in the record.

[0058]

As described above, according to the present invention,
Since only item data other than the item data corresponding to the search condition among the item data in the record obtained as the search result are displayed, desired item data among the item data in the record obtained as the search result can be easily obtained. Can be found in

[Brief description of the drawings]

FIG. 1 is a block diagram showing a circuit configuration of a database search system according to a first embodiment of the present invention;

FIG. 2 is a view showing an example of an image displayed on the display device of FIG. 1;

FIG. 3 is a flowchart showing control processing executed by a control unit in FIG. 1;

FIG. 4 is a flowchart showing a control process executed by a control unit in FIG. 1;

FIG. 5 is a flowchart showing control processing executed by a control unit in FIG. 1;

FIG. 6 is a view showing an example of an image displayed on the display device of FIG. 1;

FIG. 7 is a view showing an example of an image displayed on the display device of FIG. 1;

FIG. 8 is a view showing an example of an image displayed on the display device of FIG. 1;

FIG. 9 is a view showing an example of an image displayed on the display device of FIG. 1;

FIG. 10 is a diagram showing an example of an image displayed on the display device of FIG. 1;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 Database search system 11 Mouse 12 Keyboard 13 Display device 20 Computer main body 24 Storage device 26 Memory 27 Control part

──────────────────────────────────────────────────の Continued on the front page (58) Field surveyed (Int.Cl. ⁷ , DB name) G06F 17/30 JICST file (JOIS)

Claims (10)

(57) [Claims] A display unit for displaying an image; a database storage unit for storing a database including records having at least one item data; and a search condition indicating a condition for extracting the record from the database storage unit. Search condition data input means for inputting data, database search means for extracting the record having the item data matching the search condition data from the database storage means, and the record extracted by the database search means And control means for displaying, on the display means, an image of the item data corresponding to only items other than the item input as the search condition data among the item data therein as a search result. Search system. Display means for displaying an image; database storage means for storing a database comprising records having at least one item data; and search conditions indicating conditions for extracting the records from the database storage means. Search condition data input means for inputting data; database search means for extracting the record having the item data which completely matches the search condition data from the database storage means; Control means for displaying an image of the item data corresponding to only items other than the item input as the search condition data among the item data in the record on the display unit as a search result, Database search system. Wherein said control means includes search result to claim 1 or 2, characterized in that an image before <br/> Symbol search condition data independently is intended to be displayed before Symbol display means Database search system described. 4. The control means displays an image of an item name corresponding to the item input as the search condition data on the display means independently of the search result, and 3. The database search system according to claim 1, wherein an image of data is displayed on the display unit in association with the image of the item name. 5. A display means for displaying an image, a database storage means for storing a database comprising records having at least one item data, and a search condition indicating a condition for extracting the record from the database storage means. Search condition data input means for inputting data; database search means for extracting the record having the item data matching the search condition data from the database storage means; an item name of the item data included in the record Is displayed on the display means, the image of the search condition data is displayed on the display means in association with the image of the item name, and the items corresponding to only the items other than the items input as the search condition data The name image is displayed on the display means, and the database search means The display means in which the image of the item data corresponding to only the item other than the item input as the search condition data among the item data in the record extracted in the record is associated with the image of the item name as a search result. And a control means for displaying the data on a database. 6. A display means for displaying an image, a database storage means for storing a database comprising records having at least one item data, and a search condition indicating a condition for extracting the record from the database storage means. Search condition data input means for inputting data; database search means for extracting the record having the item data that completely matches the search condition data from the database storage means; An image of an item name is displayed on the display unit, and an image of the search condition data is displayed on the display unit in association with the image of the item name, and only an item other than the item input as the search condition data is supported. An image of the item name to be displayed on the display means, and The display unit associates the image of the item data corresponding only to the item other than the item input as the search condition data in the item data in the record extracted by the search result with the image of the item name. And a control means for displaying the data on a database. 7. Display means for displaying an image, database storage means for storing a database comprising records having at least one item data, and retrieval conditions indicating conditions for extracting the records from the database storage means A search condition data input unit for inputting data; a database search unit for extracting the record having the item data matching the search condition data from the database storage unit; and a table including at least one cell. And displaying the image of the first table whose number of rows is 2 and whose number of columns is the same as the number of the item data included in the record on the display means, the table comprising at least one or more cells. Wherein the number of rows is 2 or more and the number of columns is based on the number of item data items of the record. The image of the second table, which is the number obtained by subtracting the number of items, is displayed on the display means, and the image of the item name of the item data of the record is displayed in the first table displayed on the display means. A column in which an image of the item name is displayed in the image of the cell constituting one row, and the image of the search condition data is associated with the image of the item name displayed on the display means. The item data that is displayed in the image of the cell that is displayed in a different row from the row in which the image of the item name is displayed in the same column as the item data that the record has and that is input as the search condition data wherein to each display image of the cell, the item data in the record extracted by the database search means constituting one row of items only table image of the second item names corresponding non An image of the item data of which corresponding to only items other than items entered the as search condition data as the search result to the second of the item name image in an image of the cells constituting the other row in the table A database search system comprising: control means for displaying each of them in correspondence with each other. 8. A display means for displaying an image, a database storage means for storing a database comprising records having at least one item data, and a search condition indicating a condition for extracting the record from the database storage means. A search condition data input unit for inputting data; a database search unit for extracting the record having the item data completely matching the search condition data from the database storage unit; and at least one or more cells. A table, wherein the number of rows is 2, and the number of columns is the same as the number of item data items of the record, the image of the first table is displayed on the display means, and at least one or more cells are displayed. The number of rows is 2 or more, and the number of columns is based on the number of item data items of the record. An image of the second table, which is a number obtained by subtracting the number of data, is displayed on the display means, and an image of the item name of the item data of the record is displayed on the first table displayed on the display means. The image of the search condition data is displayed in each of the images of the cells constituting one row, and the image of the item name is displayed in correspondence with the image of the item name displayed on the display means. Displayed in the image of the cell displayed in a different row from the row in which the image of the item name is displayed in the same column as the column, the item data of the record being input as the search condition data an image of the item name corresponding only to items other than items each are displayed in the image of the cells constituting one row of the second table, the entry in the record extracted by the database retrieval means The item name in the image of the cells constituting the other row of the second table image of the item data corresponding only to the items other than the input item as the search condition data among the over data as search results And a control means for displaying each of the images in accordance with the images. 9. The system according to claim 1, wherein said database search means extracts said record from said database storage means based on all AND conditions of said search condition data when said search condition data is plural. Item 9. The database search system according to any one of Items 1 to 8. 10. Selection data input means for inputting selection data for selecting an image of the item data displayed as a search result on the display means, and said selection data input means being used as a basis of an image selected by the selection data. The database search system according to any one of claims 1 to 9, further comprising a search condition data weighting unit that sets item data as the weighted search condition data.