Data retrieval condition setting method

• US 5,781,898 A
• Filed: 09/30/1997
• Issued: 07/14/1998
• Est. Priority Date: 06/29/1994
• Status: Expired due to Fees

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Fukatsu, Junko, Kato, Hiromi
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/941,108
• Time in Patent Office: 287 Days
• Field of Search: 707/4, 707/5, 707/2
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

When an operator inputs a unit retrieval condition and a logic symbol, a condition input section stores them in a condition storage section. A condition display section displays them alternately one after another on a display device. When the operator inputs specific information for specifying the logic symbol among the displayed logic symbols for which a priority-given retrieval based on the unit retrieval conditions displayed ahead and behind the logic symbol should be performed, a condition operating section raises the priority order of the logic symbol in the condition storage section in accordance with the specific information. The condition display section performs a specific distinguishing display on the logic symbol, indicated by the accepted specific information, and the unit retrieval conditions displayed ahead and behind the logic symbol to distinguish them from other unit retrieval conditions and logic symbols. When the operator operates an execution key, a condition building section logically builds a data retrieval condition for retrieving data from a database, from the input unit retrieval conditions, the logic symbols and the specific information.

Claims

1. A method of setting a data retrieval condition for retrieving data from a database, said method comprising the steps of:

displaying unit retrieval conditions separated by logic symbols which logically associate said unit retrieval conditions with each other, on a display device;

receiving specific information for specifying one of said logic symbols based on which priority-given retrieval is executed;

highlighting with color or display density the logic symbol indicated by said received specific information and the unit retrieval conditions displayed adjacent to said logic symbol from other unit retrieval conditions or other logic symbols; and

logically building said data retrieval condition based on said unit retrieval conditions, said logic symbols and said specific information.

2. The method according to claim 1, wherein, after highlighting, if specific information for said logic symbol which is positioned in a range of the highlighting and based on which data priority-given retrieval is executed with further priority is further received, said logic symbol indicated by said further received specific information and unit retrieval conditions displayed adjacently to said logic symbol are highlighted with color or display density in a manner distinguishable from the already highlighted display.

3. The method according to claim 1, wherein the highlighting is accomplished by setting a background color of said unit retrieval condition and said logic symbol different from a background color of other unit retrieval conditions and logic symbols.

4. The method according to claim 1, wherein the highlighting is accomplished by setting a density of a background color of said unit retrieval condition and said logic symbol different from a density of a background color of other unit retrieval conditions and logic symbols.

5. The method according to claim 1, wherein said specific information is input by specifying a particular logic symbol by a cursor displayed on said display device in response to a movement of an input device for executing an input.

6. The method according to claim 1, wherein a data retrieval condition for retrieving data from said database is logically built up in such a manner that a retrieval based on said logic symbol indicated by said specific information and unit retrieval conditions displayed adjacently to that logic symbol is performed with a higher level of priority, and a further retrieval is executed based on another logic symbol, another unit retrieval condition and data obtained by execution of said priority-given retrieval.

7. A method of setting a data retrieval condition for retrieving data from a database, said method comprising the steps of:

alternately displaying unit retrieval conditions and logic symbols for logically associating said unit retrieval conditions with each other on a display device, with first letters of each of said unit retrieval conditions and logic symbols put side by side, said input unit retrieval conditions and logic symbols are displayed line after line on said display device, with display positions of heads of said input unit retrieval conditions and logic symbols being aligned in a same column; and

receiving specific information for specifying ones of said logic symbols based on which priority-given retrieval is executed;

shifting display positions of all of said logic symbol which are indicated by said received specific information and unit retrieval conditions adjacent to said indicated logic symbols on said display device, wherein a display column of heads of said unit retrieval condition and said logic symbol which are subjected to said distinctive display is shifted by a given amount; and

logically building said data retrieval condition based on said unit retrieval conditions, said logic symbols and said specific information.