JP2002117056A - Method and system for data search and display, and data search engine equipped with data search and display method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method which can actualize a user-oriented data search making it possible to visually recognize logical relation in GUI form and a display of its result. SOLUTION: This data search and display method which displays a graphical user interface on a terminal when a database is searched for data has at least >=1 comparative operation cells for inputting comparative operation conditions and at least >=1 logical operation frames surround the comparative operation cell in a previously specified field in a picture for making the search.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a data search and display method and a data search and display system for displaying, on a terminal, a graphical user interface for searching data in a database.

[0002]

2. Description of the Related Art Conventionally, in data retrieval, FIG.
As shown in FIG. 3, there are several typical display examples of data search. FIG. 11 shows a data search and display method in which a search item, a comparison operator, and a search keyword (hereinafter, an input item) are input into a pre-designated input box, and a logical operation between them is performed to search for data. In this case, the maximum number of searchable items is predetermined (because the number of input fields is predetermined), and it is difficult to execute data search based on a complicated logical relationship between items. There are some problems.

The display example shown in FIG. 12 is a data search and display method usually used in a search engine on the Internet. To do this, enter multiple search keywords in the input field, specify the logical relationship between them,
This is a method for performing a data search. This is advantageous in that an arbitrary number of search keywords can be specified and data search can be executed as compared with the data search and display method of FIG. 11, but processing time is wasted because data search using item names cannot be executed. However, there is a problem that it is difficult to describe a complicated logical relationship between search keywords.

Therefore, a display example shown in FIG. 13 has been devised. This is a display method that should be called a composite type of the display examples shown in FIGS. Enter one or more input items in a pre-specified input field on the search screen, and select or enter a logical expression for that input item or a term substituted from a logical expression such as "and" or "or" By doing it. For example, the search item of the input item 1 is “name”, the search keyword is “Ichiro Suzuki”, the search item of the input item 2 is “age”, the search keyword is “25”, and the search item of the input item 3 is This is a case where the user specifies and inputs “address” and “Shibuya-ku” as the search keyword, and searches for a search that satisfies the logical relationship of input item 1, input item 2, and input item 3. That is, this is a method of directly specifying a logical relationship between input items by using a logical expression. In this case, FIG.
1. It is possible to describe a complicated logical relationship which is a problem in FIG.

[0005]

However, in the above method, as the number of input items increases, the logical relationship between the input items becomes more complicated, the setting of the search conditions becomes more complicated, and the user is required to make a search. You have to set very difficult conditions. In view of the above problems, the present inventors have developed a graphical user interface (GU).
I: Graphical User Interface
e) A method has been devised that enables a data search and a result display to reduce the burden on the user by visually recognizing a logical relationship between input items using a format. Here GU
I is a graphic-based user interface, in which files, programs, commands, etc. are graphically represented on the screen (icons, command buttons, etc.).
(The latest network terminology dictionary, 2nd edition, P. 184-
P. 185 by Peter Dyson).

[0006]

According to a first aspect of the present invention, there is provided a data search and display method for displaying a graphical user interface for searching data in a database on a terminal. This is a data search and display method having at least one or more comparison operation cells for inputting comparison operation conditions in a search field specified in advance.

A second aspect of the present invention is a data search and display method in which the comparison operation cell includes a column for selecting and / or inputting a search item, a comparison operator, and a keyword.

A third aspect of the present invention is a data search and display method for executing a comparison operation based on the search item, the comparison operator, and the keyword by selecting a predetermined execution button of the comparison operation cell. It is.

According to a fourth aspect of the present invention, there is provided a data search and display method further comprising at least one or more logical operation frames in the search field.

The invention of claim 5 is a data search and display method in which the logical operation frame can surround the comparison operation cell and / or another logical operation frame.

A sixth aspect of the present invention is a data search and display method in which the comparison operation cell and / or the logical operation frame appears in the search field by selecting a predetermined command button in the screen. .

The invention according to claim 7 is a data search and display method in which the comparison operation cell and / or the logical operation frame can be moved in the search field by drag and drop.

An eighth aspect of the present invention is a data search and display method for executing a logical operation on an execution result of the comparison operation cell by surrounding the comparison operation cell with the logical operation frame.

According to a ninth aspect of the present invention, there is provided a data search and display method for executing a logical operation on an execution result of the logical operation frame by surrounding the logical operation frame with another logical operation frame.

According to a tenth aspect of the present invention, there is provided a data search engine for performing the data search and display method according to any one of the first to ninth aspects on a terminal.

An invention according to claim 11 is a data search and display system for displaying a graphical user interface for searching data in a database on a terminal,
At least one field for inputting a comparison operation condition in a predetermined search field in a screen for executing a search
This is a data search and display system having the above comparison operation cells.

A twelfth aspect of the present invention is a data search and display system in which the comparison operation cell includes a column for selecting and / or inputting a search item, a comparison operator, and a keyword.

The invention of claim 13 is a data search and display system for executing a comparison operation based on the search item, the comparison operator, and the keyword by selecting a predetermined execution button of the comparison operation cell. It is.

According to a fourteenth aspect of the present invention, there is provided a data search and display system further including at least one or more logical operation frames in the search field.

The invention according to claim 15 is a data search and display system in which the logical operation frame can surround the comparison operation cell and / or another logical operation frame.

The invention according to claim 16 is a data search and display system in which the comparison operation cell and / or the logical operation frame appear in the search field by a predetermined method in the screen.

The invention according to claim 17 is a data search and display system in which the comparison operation cell and / or the logical operation frame can be moved in the search field by drag and drop.

The invention according to claim 18 is a data search and display system for executing a logical operation on an execution result of the comparison operation cell by surrounding the comparison operation cell with the logical operation frame.

The invention according to claim 19 is a data search and display system for executing a logical operation on an execution result of the logical operation frame by surrounding the logical operation frame with another logical operation frame.

According to the twentieth aspect of the present invention, there is provided the terminal device according to the eleventh aspect,
A data search engine for performing the data search and display system according to any one of Claims 1 to 19.

[0026]

BEST MODE FOR CARRYING OUT THE INVENTION

Embodiment 1 An embodiment of the present invention will be described in detail with reference to the drawings. FIG. 1 is an example of a system configuration diagram of a data search and display method according to the present invention.

The server 1 is a means that has data to be searched in the database 2, receives a data search request from the client terminal 6, and executes a comparison operation and a logical operation. The server 1 includes a database 2, a comparison operation unit 3,
(To be described later) and a logical operation means 4 (to be described later).
Connected through. Although not shown, it is a matter of course that the apparatus has at least means for storing data such as a memory or a cache and means for transmitting and receiving data to and from the client terminal 6. Further, even if the network 5 is an open network such as the Internet, a LAN (Local Area Network)
or a closed network such as (ork).

The comparison operation means 3 is means for performing a comparison operation between the comparison operation condition data received from the client terminal 6 and the data registered in the database 2. Here, the method of the comparison operation is a known method. "
= ”,“ <> ”,“ <”,“> ”,“ ≦ ”,“ ≧ ”, or other comparison operators (relational operators) or other means.
The data of the physical address or the logical address indicating the storage position (i.e., address) of the data resulting from the comparison operation in the database 2 and the number of hits are transmitted to the storage means (not shown) in the server 1.

The logical operation means 4 is a storage means (not shown)
From the data string of the physical address or the logical address, the number of hits to be searched, and the logical expression input to the search screen from the client terminal 6,
Means for performing a logical operation on the received data string. The logical expression used in the logical operation is NOT
At least a formula, an AND formula, an OR formula, an XOR formula, an EQV formula, an IMP formula, or a formula combining these can be used.

The client terminal 6 is a standard computer, and has a display unit 7 (described later) and an input unit 8 (described later).
have. It goes without saying that a personal computer, a workstation or the like may be used. Although not shown, the server 1 has a means for transmitting and receiving data between the server 1 and the client terminal 6. In this embodiment, when data transmission and reception occurs between the server 1 and the client terminal 6, The use of the means for transmitting and receiving the data is, of course, not specified, but is obvious.

The display means 7 is a means for displaying data, screens and the like which are normally provided in the client terminal 6, and indicates, for example, a display device. In this embodiment, the display device is used.

The input means 8 is provided as a standard part of the client terminal 6 and is a means for executing input to the screen displayed on the display means 7, and indicates, for example, a keyboard, a mouse, a touch panel and the like. . In the present embodiment, a keyboard and a mouse are used.

An example of the process of the data search and display method of the present invention will be described below with reference to the flowcharts of FIGS. 2 and 3 and FIG.
8 will be described in detail based on the screen example of FIG.

The client terminal 6 performing the data search,
The connection is established from the client terminal 6 to the server 1. This connection establishment is for establishing transmission and reception of data between the client terminal 6 and the server 1, and is performed by a known method. After establishing a connection,
The comparison operation unit 3 of the server 1 may execute user authentication for the client terminal 6. That is, a process for identifying whether the user is a legitimate user for the present data search and display method and a data search engine (hereinafter, system) provided with the data search and display method may be added.

After the connection is established, or when the authentication is executed, after the authentication is approved, the comparison operation means 3 transmits a search screen to the client terminal 6.

On the search screen, a search field 31 for displaying a comparison operation cell (to be described later) or a logical operation frame (to be described later), a comparison operation condition setting button 20 for setting comparison operation conditions, and clearing all conditions of the comparison operation are cleared. A comparison operation condition clear button 21, which is a logical expression for setting conditions for performing a narrowing search by a logical operation, “NOT”, “AND”,
A logical operation condition setting button 22 for setting logical conditions such as "OR", "XOR", "EQV", and "IMP"; a logical operation condition setting clear button 23 for clearing all logical operation conditions; A display button 24 for adjusting and performing “all display”, “display enlargement”, “display reduction”, etc., a condition list button 30 such as a “condition list” for displaying a list of keywords of comparison operation search conditions, a display method on a screen From a logical expression display to a collective expression display such as “∩”, “∪”, “⊃”, “⊂”, etc., a collective expression display button 25 such as “set expression display”, and a print button for executing printing of a search field 26. Message field 2 where various instructions from search engine are displayed
7. A search result display column 28 in which the number of hits and the hit ratio are displayed as search results under the setting conditions of the comparison operation cell (described later) and the logical operation frame (described later) selected by the client terminal 5 on the screen. And a display switching button 29 for performing a result list display and a result detail display as a result display method. FIG. 4 shows an example of the search screen.

The client terminal 6, which has received the search screen from the server 1, displays the search screen on the display means 7 and executes the comparison calculation setting (S100). Before executing S100, the user may adjust the size of the search screen by, for example, clicking the display button 24 in the search screen according to his / her preference.

When the user clicks on the button for setting the conditions for the comparison operation in the search screen and selects the button, the comparison operation cell 40 for setting the conditions for the comparison operation is displayed in the search field 31.
Will be displayed within The comparison operation cell 40 includes an item (search item) to be searched, that is, a search item column 41 such as a name and a telephone number, a comparison operator, that is, a prefix match, a perfect match, and “≦”.
A comparison operator field 42 for selecting / inputting an inequality sign such as “≧”;
For more details about the item, that is, if the item is a name,
A keyword column 43 for selecting / inputting keywords for setting conditions such as Yamada and Sato, a comparison operation result column 45 corresponding to the search item and the keyword, a comparison operation execution button 46 for executing a search, a corresponding data list and corresponding data details, etc. Is displayed. FIG. 5 shows an example in which the comparison operation cell 40 is activated in the search field 31. As a matter of course, the comparison operation cell 40 can be moved to an arbitrary position in the search field 31 by selecting it with an input means such as a mouse or the like.
The size of 0 can be changed.

When the comparison operation cell 40 is activated (S20)
0), the user inputs a search item column 41 (S210), a comparison operator column 42 (S220), and a keyword column 43 (S230) in the comparison operation cell from the input unit 8 of the client terminal 6.
Respectively. After the input, by clicking the comparison operation execution button 46 of the comparison operation cell 40, the search item, the comparison operator, and the keyword (hereinafter, comparison operation condition) are transmitted from the client terminal 6 to the comparison operation means 3 of the server 1. You.

The comparison operation condition received by the comparison operation means 3 is transmitted to the database 2, and the comparison operation is executed in the database 2 based on the comparison operation condition (S110).
After completion of the comparison operation search, the comparison operation result sequence (the result of the comparison operation is a bit sequence in the order of the physical address or the logical address), the number of comparison operation results, and the ratio of comparison operation results are compared with the comparison operation means 3. Is transmitted to a storage means (not shown) provided in the server 1 and the client terminal 6.

When executing a plurality of comparison operations (S120), S100 may be repeated. That is, the comparison operation condition is transmitted from the client terminal 6 to the server 1 each time, the comparison operation is executed, and the comparison operation result sequence is stored in the storage unit (not shown). In this embodiment, it is assumed that the comparison operation is performed twice. FIG. 6 shows the state of the search screen at that time. The comparison operation cells 40 are displayed in the search field 31 by the number of times of execution of the comparison operation. That is, in this embodiment, two comparison operation cells 40 are displayed in the search field 31.

The number of comparison operation results and the ratio of comparison operation result are received by the client terminal 6, and the number of comparison operation results and the comparison operation result are temporarily stored in storage means (not shown) provided in the client terminal 6. Store the ratio. Here, the storage means refers to a means used when storing known data such as a memory or a cache. At the same time, the number of comparison operation results and the ratio of comparison operation result are transmitted from the storage means (not shown) to the display means 7, and each is displayed in the comparison operation result column 45 of the comparison operation cell 40. If the user wants to know the detailed information of the comparison operation result, the user can know the detailed information by clicking the comparison operation detail button 47 via the input means 8.

If another comparison operation is not performed in S120, a logical operation is performed (S130). In order to execute the logical operation, the logical operation frame 50 is activated in the search field 31 by clicking the button of the logical expression to be used among the logical operation condition setting buttons 22 in the search screen (S300). In this embodiment, an AND expression is executed.

The logical operation frame 50 includes a frame name 51 indicating a selected logical expression such as “AND frame”, a logical operation result field 52 for displaying the number of hits and the ratio of hits as a result of the logical operation under the setting conditions of the frame, A logical operation execution button 53 for executing a logical operation, a logical operation detail display button 54 for displaying a list of applicable data, details of applicable data, and the like.
have. FIG. 7 shows an example in which the logical operation frame 50 is activated.

In order to determine the range of the logical operation, the logical operation frame 50 is dragged and dropped, and the comparison operation cell 40 to be subjected to the logical operation is moved to the logical operation frame 50.
(S310). FIG. 8 shows an example of a search screen when the comparison operation cell 40 is surrounded by the logical operation frame 50.

By selecting the logical operation execution button 53 of the specified logical operation frame 50 in S310, the logical operation is executed on the comparison operation result sequence of the comparison operation cell 40 in the logical operation frame 50. In this embodiment, the logical operation is executed by selecting the logical operation execution button 53. However, the logical operation may be automatically executed when the comparison operation cell 40 is surrounded by the logical operation frame 50. It goes without saying that it is good. That is, a code (hereinafter referred to as a comparison operation cell specifying code) for specifying the corresponding comparison operation cell 40 (comparison operation cell 40 surrounded by the logical operation frame 50) and a logical operation condition (logical expression) of the logical operation frame are stored in the server. 1 is sent.

The logical operation means 4 which has received the comparison operation cell specifying code and the logical operation condition is specified by the comparison operation cell specifying code stored in the storage means (not shown) in the server 1 at the time of the comparison operation. A comparison operation result sequence of the comparison operation cell 40 is extracted, and a logical operation is performed between the comparison operation result sequences (S14).
0). If another logical operation is to be executed (S15
0), S130 may be re-executed. That is, the specific code,
The logical operation condition is transmitted to the server 1 to execute the logical operation. The corresponding number of logical operation results (the number of logical operation results) and the ratio of logical operation results corresponding to the result of the logical operation between the comparison operation result sequences executed in S140 are transmitted from the logical operation means 4 to the client terminal 6. At the same time, a result sequence (logical operation result sequence) of the physical address or the logical address of the logical operation result is stored in a storage unit (not shown) in the server 1.

When the number of logical operation results and the ratio of logical operation results are received by the client terminal 6, they are transmitted to the display means 7, and the logical operation result column 5 of the logical operation frame 50 is received.
2, the corresponding number of logical operation results and the ratio of corresponding logical operation results are displayed (S160).

When the user requests the client terminal 6 to display the detailed result of the logical operation, that is, the logical operation detail display button 5
When 4 is clicked, a code for specifying the logical operation frame (logical operation frame specifying code) is transmitted to the server 1.

The logical operation means 4 having received the logical operation frame specifying code extracts the logical operation result sequence corresponding to the logical operation frame specifying code from the storage means (not shown) in the server 1, and converts the logical operation result sequence. The data is transmitted to the database 2 and the search result detailed data corresponding to the corresponding physical address or logical address in the logical operation result string is extracted in the database 2. Thereafter, the detailed result is transmitted from the logical operation means 4 to the client terminal 6 as detailed search result data.

To execute another search (S17)
0), another search may be executed by selecting the comparison operation condition setting clear button 21 and the logical operation condition setting clear button 23.

[0052]

Embodiment 2 Another embodiment of the present invention will be described in detail with reference to the drawings. FIG. 14 is an example of a system configuration diagram of the data search and display method of the present invention. This embodiment is Embodiment 1.
Unlike this, an example in which the logical operation means 16 is provided in the client terminal 15 will be described.

The server 11 is a means that has data to be searched in the database 12, receives a data search request from the client terminal 15, and executes a comparison operation. The server 11 includes a database 12, a comparison operation unit 1,
3 (described later), and is connected to a client terminal 15 (described later) via the network 14. Although not shown, it is a matter of course that the apparatus has at least means for storing data such as a memory or a cache and means for transmitting and receiving data to and from the client terminal 15. Further, even if the network 14 is an open network such as the Internet,
A closed network such as AN (Local Area Network) may be used.

The comparison operation means 13 is a client terminal 1
5 and the comparison operation condition data received from the database 5
Means for performing a comparison operation with the data registered in. Here, the comparison operation method uses a known method such as “=”, “<>”, “<”, “>”, “≦”, “≧”, etc. Alternatively, other means may be used. The data of the physical address or the logical address indicating the storage position (that is, the address) of the data resulting from the comparison operation in the database 12 and the number of hits are transmitted to the client terminal 15 together.

The client terminal 15 is a standard computer, and has at least logical operation means 16 (described later),
It has display means 17 (described later) and input means 18 (described later). It goes without saying that a personal computer, a workstation or the like may be used. Although not shown, the server 11 has means for transmitting and receiving data between the server 11 and the client terminal 15.
Also in this embodiment, the server 11 and the client terminal 1
When transmission / reception of data occurs between the nodes 5, the use of the means for transmitting / receiving the data is not specified, but it goes without saying.

The logical operation means 16 receives from the comparison operation means 13 of the server 11 the data string of the physical address or the logical address, the number of hits, and the logical expression input to the search screen for executing the logical search. A means for executing a logical operation on the received data sequence and transmitting the result to the server 11. The logical expressions used in the logical operation include a NOT expression, an AND expression, an OR expression, an XOR expression,
At least an EQV formula, an IMP formula, or a combination thereof can be used.

The display means 17 is a means for displaying data, screens, and the like which are provided as standard on the client terminal 15, and indicates, for example, a display device. In this embodiment, the display device is used.

The input means 18 is provided as standard equipment in the client terminal 15 and is a means for executing an input to the screen displayed on the display means 17, and indicates, for example, a keyboard, a mouse, a touch panel and the like. . In the present embodiment, a keyboard and a mouse are used.

An example of the process of the data search and display method of the present invention will now be described with reference to the flowcharts of FIGS. 2 and 3 and FIG.
8 will be described in detail based on the screen example of FIG.

Client terminal 15 for performing data search
Executes connection establishment from the client terminal 15 to the server 11. This connection is established by the client terminal 15
And establishment of data transmission / reception with the server 11 by a known method.
After the connection is established, the comparison operation unit 13 of the server 11 may execute user authentication for the client terminal 15. That is, a process for identifying whether the user is a legitimate user for the present data search and display method and a data search engine (hereinafter, system) provided with the data search and display method may be added.

When the authentication is executed after the connection is established, after the authentication is approved, the comparison operation means 13 transmits a search screen to the client terminal 15.

The client terminal 15 that has received the search screen from the server 11 displays the search screen on the display unit 17 and executes the comparison calculation setting (S100). Before executing S100, the user may adjust the size of the search screen by, for example, clicking the display button 24 in the search screen according to his / her preference.

When the user clicks a button or the like for setting the conditions for the comparison operation in the search screen and selects it, the comparison operation cell 40 for setting the conditions for the comparison operation is displayed in the search field 31.
Will be displayed within

When the comparison operation cell 40 is activated (S20)
0), the user inputs a search item column 41 (S210), a comparison operator column 42 (S220), and a keyword column 43 (S23) in the comparison operation cell from the input unit 18 of the client terminal 15.
0). After the input, the comparison operation cell 4
By clicking the comparison operation execution button 46 of 0, the search item, the comparison operator, and the keyword (hereinafter, comparison operation conditions) are transmitted from the client terminal 15 to the comparison operation means 13 of the server 11.

The comparison operation condition received by the comparison operation means 13 is transmitted to the database 12, and the comparison operation is executed in the database 12 based on the comparison operation condition (S11).
0). After the completion of the comparison operation search, the comparison operation result sequence, the number of comparison operation result hits, and the comparison operation result hit ratio are transmitted from the comparison operation means 13 to the client terminal 15.

When a plurality of comparison operations are performed (S120), S100 may be repeated. In this embodiment, it is assumed that the comparison operation is performed twice. FIG. 6 shows the state of the search screen at that time. The comparison operation cells 40 are displayed in the search field 31 by the number of times of execution of the comparison operation. That is, in this embodiment, two comparison operation cells 40 are displayed in the search field 31.

The comparison operation result sequence, the number of comparison operation results, and the ratio of comparison operation results are received by the logical operation means 16 of the client terminal 15 and temporarily stored in a storage means (not shown) provided in the client terminal 15. The comparison operation result column, the number of comparison operation results, and the ratio of comparison operation results are stored. Here, the storage means refers to a means used when storing known data such as a memory or a cache. At the same time, the logical operation means 16 transmits the comparison operation result applicable number and the comparison operation result applicable ratio to the display means 17, and displays each in the comparison operation result column 45 of the comparison operation cell 40.
If the user wants to know the detailed information of the comparison operation result, the user can know the detailed information by clicking the comparison operation detail button 47 via the input means 18.

If another comparison operation is not performed in S120, a logical operation is performed (S130). To execute the logical operation, the logical operation frame 50 is clicked on the logical operation condition setting button on the search screen to cause the logical operation frame 50 to be displayed in the search field 31.
(S300). In the present embodiment, A
Assume that the ND expression is executed.

In order to determine the range of the logical operation, the logical operation frame 50 is dragged and dropped, and the comparison operation cell 40 to be subjected to the logical operation is moved to the logical operation frame 50.
(S310). FIG. 8 shows an example of a search screen when the comparison operation cell 40 is surrounded by the logical operation frame 50.

By selecting the logical operation execution button 53 of the specified logical operation frame 50 in S310, the logical operation is executed on the comparison operation result sequence of the comparison operation cell 40 in the logical operation frame 50. In this embodiment, the logical operation is executed by selecting the logical operation execution button 53. However, the logical operation may be automatically executed when the comparison operation cell 40 is surrounded by the logical operation frame 50. It goes without saying that it is good. That is, the comparison operation result sequence corresponding to the comparison operation cell 40 stored in the storage unit (not shown) of the client terminal 15 is transmitted to the logical operation unit 16, and the logical operation unit 16 performs the logic operation between the comparison operation result sequences. An operation is performed (S140). If another logical operation is to be executed (S150), S130 may be executed again. The result of the logical operation is transmitted to the display means 17, and
The number of hits and the ratio of hits are displayed in the logical operation result column 52 of the logical operation frame 50 (S160).

When the user requests from the client terminal 15 to display the detailed result of the logical operation,
That is, when the logical operation detail display button 54 of the logical operation frame 50 is clicked, the logical operation result sequence is transmitted from the logical operation means 16 to the comparison operation means 13 of the server 11. When the comparison operation means 13 receives the logical operation result sequence,
The logical operation result sequence is transmitted to the database 12, and the search result detailed data corresponding to the corresponding physical address or logical address in the logical operation result sequence is extracted from the database 12. After that, the comparison operation means 13 transmits the detailed search result data to the client terminal 15.

The logical operation means 16 of the client terminal 15
Receives the detailed search result data, and the logical operation means 16 transmits the detailed search result data to the display means 17. The display means 17 displays the detailed data.

To execute another search (S17)
0), the comparison operation cell 40 and the logical operation frame 50 may be deleted from the search field by selecting the comparison operation condition setting clear button 21 and the logical operation condition setting clear button 23, and another search may be executed. Needless to say, a button may be provided to erase all the comparison operation cells 40 and the logical operation frame 50 in the search field 31 and return to the default state.

When it is desired to add another logical expression to the existing logical expression, the logical operation condition setting button 22 is clicked, and the logical operation frame 50 activated in the search field 31 is moved to the corresponding comparative operation cell 40. This can be done by dragging and dropping and enclosing as described above.
Then, a hierarchical structure of a plurality of logical operation frames 50 is formed. 9 and 10 show examples. Equation 1 shows the logical equation in the case of FIG. 9, and Equation 2 shows the logical equation in the case of FIG.

[Equation 1] (A AND B) XOR C

[Equation 2] (A AND B) AND (C OR D)

Since the logical operation frame 50 can be dragged and dropped to an arbitrary position, it is naturally possible to surround an arbitrary number of comparison operation cells 40 and execute a logical operation between them.

The search result of the selected comparison operation cell 40 or logical operation frame 50 is simultaneously displayed in the search result display column 28 of the search screen. This means that the same numerical value as that in the comparison operation result column 45 of the selected comparison operation cell 40 or the logical operation result column 52 of the logical operation frame 50 is displayed.

When the user wants to print the search field 31, the user can click the print button 26 to execute printing by a known method.

The detailed results such as the applicable data list and the applicable data details are displayed in the comparison operation detail display button 4 in the cell or frame.
7. Displayed by selecting the logical operation detail display button 54. Further, the detailed result of the cell or frame selected in the search screen can also be displayed by selecting the display switching button 29 for performing the corresponding list display and the corresponding detailed display in the search screen.

Comparison operation cell 40 unnecessary for user
Alternatively, the logical operation frame 50 selects the comparison operation cell 40 or the logical operation frame 50 to be deleted, and in the case of the comparison operation cell 40, the comparison operation condition clear button 21 is pressed.
In the case of the logical operation frame 50, by clicking the logical operation condition clear button 23, the selected comparison operation cell 40 or logical operation frame 50 can be deleted from the search field 31.

When the user wants to change the logical structure in the currently used search field 31 to a set expression,
The display can be switched to the collective display by selecting the collective display button 25. This is search field 31
Can be realized by replacing the logical structure in the expression with a logical expression, and converting the logical expression into a set expression by a known method. That is, taking the case shown in FIG. 10 as an example, FIG. 10 is converted into the above-described Expression 2 when expressed by a logical expression. That is, Expression 2 is converted to a set expression (the converted set expression is shown in Expression 3), which is displayed in the message field 27 or displayed as a pop-up message or the like.

[Equation 3] (A∩B) ∩ (C∪D)

In carrying out the present invention, a storage medium storing a software program for realizing the functions of the present embodiment is supplied to the system, and the computer of the system reads and executes the program stored in the storage medium. Of course, it is realized by.

In this case, the program itself read from the storage medium implements the functions of the above-described embodiment, and the recording medium storing the program naturally constitutes the present invention.

Examples of a storage medium for supplying the program include a floppy (registered trademark) disk, hard disk, optical disk, magneto-optical disk, magnetic tape,
A non-volatile memory card or the like can be used.

When the computer executes the readout program, not only the functions of the above-described embodiment are realized, but also the operating system and the like running on the computer are executed based on the instructions of the program. It goes without saying that a part or all of the processing is performed, and the functions of the above-described embodiments are realized by the processing.

Further, after the program read from the storage medium is written into the non-volatile or volatile storage means 9 provided in the function expansion board inserted into the computer or the function expansion unit connected to the computer, the program is read out. Based on the instructions of the program, the arithmetic processing device or the like provided in the function expansion board or the function expansion unit may perform part or all of the actual processing, and the processing may realize the functions of the above-described embodiments. Of course.

[0086]

According to the present invention, a user can visually recognize information when setting data search conditions or when browsing search results for the set conditions. In addition, data retrieval with a complex logical structure can be visually recognized as a logical relationship by dragging and dropping instead of entering a conventional logical expression.
A user-oriented data retrieval and display method can be realized. That is, in a complex condition search process that requires trial and error, target information is extracted by individually grasping a search (comparison operation) applicable condition for each condition item and a search (logical operation) applicable condition between condition items. It is possible to provide a function for quickly and efficiently finding an appropriate conditional expression (comparison operation expression for each item and a logical operation expression between items).

[Brief description of the drawings]

FIG. 1 is a diagram showing an example of a system configuration diagram of the present invention.

FIG. 2 is a first sheet of a flowchart showing an example of a process flow of the present invention.

FIG. 3 is a second flowchart illustrating an example of the process flow of the present invention.

FIG. 4 is a diagram illustrating an example of a search screen.

FIG. 5 is a diagram showing an example in which there is one comparison operation cell on a search screen.

FIG. 6 is a diagram showing an example in which a search screen has two comparison operation cells.

FIG. 7 is a diagram illustrating an example in which a logical operation frame is present on a search screen.

FIG. 8 is a diagram showing an example in which a comparison operation cell is surrounded by a logical operation frame.

FIG. 9 is a diagram illustrating an example in which a logical operation frame is surrounded by the logical operation frames.

FIG. 10 is a diagram illustrating another example of surrounding a logical operation frame with a logical operation frame.

FIG. 11 is a diagram showing an example of a conventional search screen.

FIG. 12 is a diagram showing an example of a conventional search screen.

FIG. 13 is a diagram showing an example of a conventional search screen.

FIG. 14 is a diagram showing another example of the system configuration diagram of the present invention.

[Explanation of symbols]

 1: server 2: database 3: comparison operation means 4: logical operation means 5: network 6: client terminal 7: display means 8: input means 11: server 12: database 13: comparison operation means 14: network 15: client terminal 16 : Logical operation means 17: Display means 18: Input means

Claims (20)

[Claims] 1. A data search and display method for displaying a graphical user interface at the time of data search of a database on a terminal, wherein a comparison operation condition is set in a predetermined search field in a screen for executing a search. Characterized by having at least one or more comparison operation cells for inputting the data. 2. The data search and display method according to claim 1, wherein the comparison operation cell includes a column for selecting and / or inputting a search item, a comparison operator, and a keyword. 3. A comparison operation is performed based on the search item, the comparison operator, and the keyword by selecting a predetermined execution button of the comparison operation cell. The data search and display method according to claim 2. 4. The data search and display method according to claim 1, further comprising at least one or more logical operation frames in the search field. 5. The data search and display method according to claim 1, wherein the logical operation frame can surround the comparison operation cell and / or another logical operation frame. 6. The comparison operation cell and / or the logical operation frame appear in the search field according to a predetermined method in the screen.
The data search and display method according to any one of claims 1 to 5. 7. The data search and display method according to claim 1, wherein the comparison operation cell and / or the logical operation frame can be moved in the search field by drag and drop. 8. A logical operation is performed on the execution result of the comparison operation cell by surrounding the comparison operation cell with the logical operation frame. How to search and display data. 9. A logical operation is performed on an execution result of the logical operation frame by surrounding the logical operation frame with another logical operation frame.
The data search and display method according to any one of claims 1 to 5. 10. A data search engine for performing a data search and display method according to any one of claims 1 to 9 on a terminal. 11. A data search and display system for displaying a graphical user interface for searching data in a database on a terminal, wherein a comparison operation is performed in a predetermined search field in a screen for executing a search. A data search and display system comprising at least one comparison operation cell for inputting a condition. 12. The data search and display system according to claim 11, wherein the comparison operation cell includes a column for selecting and / or inputting a search item, a comparison operator, and a keyword. 13. A comparison operation is performed based on the search item, the comparison operator, and the keyword by selecting a predetermined execution button of the comparison operation cell. The data search and display system according to claim 12. 14. The method according to claim 14, wherein at least one of
12. The data search and display system according to claim 11, further comprising the above logical operation frame. 15. The data search and display system according to claim 11, wherein the logical operation frame can surround the comparison operation cell and / or another logical operation frame. 16. The method according to claim 11, wherein the comparison operation cell and / or the logical operation frame appear in the search field by a predetermined method in the screen. The described data search and display system. 17. The data search and display system according to claim 11, wherein the comparison operation cell and / or the logical operation frame can be moved in the search field by drag and drop. 18. A logic operation is performed on the execution result of the comparison operation cell by surrounding the comparison operation cell with the logic operation frame. Data retrieval and display system. 19. The logic operation according to claim 11, wherein the logic operation frame is surrounded by another logic operation frame to execute a logic operation on the execution result of the logic operation frame. The described data search and display system. 20. A data search engine which causes a terminal to execute the data search and display system according to any one of claims 11 to 19.