JPH05303591A - Data base retrieval processing system - Google Patents

Abstract

PURPOSE:To improve the operability of the data base retrieval processing system which retrieves a data base. CONSTITUTION:The data base system which is so constituted that when a retrieval key is inputted, data indicated by the retrieval key is read out of the data base is provided with a file means 22 which controls a list of retrieval keys being setting object for retrieval key items, provided for corresponding to the retrieval key items, a display control means 23 which displays the retrieval key list of the file means 22 indicating a retrieval key item on a display screen when the retrieval key item is selected, and a selecting means 24 which selects one or plural retrieval keys in the retrieval key list displayed by the display control means 23 through interaction with a pointer means pointing the display screen; and the data base is retrieved by using the retrieval key selected by the selecting means 24.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database search processing method for executing a database search, and more particularly to a database search processing method capable of improving operability.

When searching a database, it is necessary to enter a search key. In order to operate the database efficiently, it is necessary to construct a structure that can execute the input of this search key with good operability.

[0003]

2. Description of the Related Art Conventionally, when searching a database, a method of inputting search keys using a keyboard has been adopted. In other words, when reading data with a key value of "○○○○ Co., Ltd." from the data managed by the database, use the keyboard to
I entered this search key "○○○○ Co., Ltd.".

[0004]

However, according to such a conventional technique, when the search key has the same meaning but is different from the one registered in the database, the database is searched. There was a problem that I could not. For example, in the case of the above-mentioned example, if "○○○○ Co., Ltd." is input from the keyboard, the database cannot be searched.

Further, according to such a conventional technique, there is a problem that the database cannot be efficiently used when the user is not accustomed to the keyboard operation.
The present invention has been made in view of such circumstances, and an object of the present invention is to provide a new database search processing method capable of improving operability.

[0006]

FIG. 1 illustrates the principle configuration of the present invention. In the figure, reference numeral 1 is a data storage device constituting the database system of the present invention, which manages a database, and 2 is a data processing device constituting the database system of the present invention, which is managed by the data storage device 1. Those that execute access processing to the database, 3
Is a man-machine interface device which constitutes the database system of the present invention, and which executes interactive processing with a user, 4 is a man-machine interface device 3
It is a pointer means such as a mouse provided in the above, and executes the selection process by pointing to the display screen of the man-machine interface device 3.

The data processing device 2 includes an input / output control means 20, an item display control means 21, and a file means 22.
A display control means 23, a selection means 24, a selection mode setting means 25, and an access means 26.

The input / output control means 20 executes interface processing with the man-machine interface device 3. The item display control means 21 displays the search key item of the database on the display screen of the man-machine interface device 3. The file means 22 is provided for each search key item and manages a list of search keys to be set in the search key item. The display control means 23 displays a list of search keys managed by the file means 22 on the display screen of the man-machine interface device 3. The selecting means 24 selects the search key of the database by interacting with the pointer means 4 of the man-machine interface device 3. The selection mode setting means 25 is a man-machine
By interacting with the interface device 3, the selection means 24
Set the operation mode of the selection process executed by. The access unit 26 accesses the database of the data storage device 1.

[0009]

In the present invention, the selection mode setting means 25 sets the operation mode of the selection processing executed by the selection means 24 to either the interactive selection mode or the automatic selection mode by interacting with the man-machine interface device 3. To do. On the other hand, the item display control means 21 displays the search key item of the database on the display screen of the man-machine interface device 3.

In this way, when the search key item is displayed on the display screen and one of the displayed search key items is selected by the pointer means 4, the display control means 23 The search key list of the file means 22 indicated by the selected search key item is displayed on the display screen. Then, in response to the display processing of the search key list, the selecting means 24 selects and selects one or a plurality of search keys selected by the pointer means 4 when the selection mode is set to the interactive selection mode. When the mode is set to the automatic selection mode, the first search key in the displayed search key list is selected.

When the search key is selected by the selection means 24, the access means 26 searches the database of the data storage device 1 using the selected search key, and the search result is used as the man-machine interface device 3. Display on the display screen of.

As described above, according to the present invention, the list of the search keys is displayed on the display screen, and the search key used for the search is selected from the displayed search keys by the pointer means 4. Therefore, the user can easily and accurately input the search key for searching the database with good operability.

[0013]

The present invention will be described in detail below with reference to examples. As described with reference to FIG. 1, in the present invention, the list of search keys is displayed on the display screen, and the search key used for the search is selected from the displayed search keys according to the pointer means 4. It takes a configuration.

That is, a search key input screen for database search as shown in FIG. 2 is displayed on the display screen of the man-machine interface device 3, and search key items (data name 1, data) in this input screen are displayed. First name ...
.., when any one of the keywords 4) is pointed by the pointer means 4, it is set to the pointed search key item (keyword 2 is assumed in this figure) as shown in FIG. A list of search keys that are present is displayed on another screen, and one or more of the search keys (outside company, company, ..., Report) in this search key list screen are pointed by the pointer means 4. Then, as shown in FIG. 4, a process of setting the pointed search key (design document is assumed in this figure) to the corresponding search key item on the input screen is executed.

FIG. 5 shows an embodiment of the system configuration of the present invention adopted to realize this processing. 30 in the figure
Is a screen format file included in the data processing device 1, 31 is a trigger file included in the data processing device 1, 32 is a trigger program expanded in the data processing device 1, 33 is a trigger file editor expanded in the data processing device 1. ..

The screen format file 30 manages the screen format information of the search key list display screen, and has a configuration for managing the screen format information corresponding to the search key items. For example, when the search key items are displayed according to the input screen described in FIG. 2, the screen format information is managed for each search key item such as data name 1, data name 2, ..., Keyword 4. FIG. 6 illustrates an example of screen format information managed by the screen format file 30.

The trigger file 31 includes a plurality of trigger files 31-i (i = 1 to 1) in units of search key items.
n), the specific search key value of the search key list displayed on the display screen is managed.
The file name of each trigger file 31-i is the trigger file 31-i of which search key item by being registered in the trigger file name entry field (in FIG. 6) of the screen format information of the screen format file 30. Will be managed. FIG. 7 illustrates an example of management data managed by the trigger file 31-i.

The trigger program 32 is a man-machine
By interacting with the interface device 3, processing for setting a search key is executed. On the other hand, the trigger file editor 33 edits the management data of the trigger file 31-i by interacting with the man-machine interface device 3.

Next, the processing executed by the trigger program 32 will be described, and then the processing executed by the trigger file editor 33 will be described. The trigger program 32, when displaying the input screen as shown in FIG. 2 on the display screen of the man-machine interface device 3, selects one of the search key items to be displayed by the pointer means 4. Then, the screen format information of the screen format file 30 associated with the selected search key item is specified, and the trigger file 31 indicated by the trigger file name registered in the specified screen format information is specified.
-Specify management data for i. At this time, the search key registered in the entry field of the selected search key item is saved in the undo buffer a (not shown). Then, according to the specified screen format information, the list of search key values managed by the specified trigger file 31-i is displayed on the display screen to display the list of search keys as shown in FIG. It will be displayed on a separate screen as the trigger display screen.

FIG. 8 shows an example of the trigger display screen to be displayed on this separate screen. As shown in this figure, the trigger display screen has a "set" button, an "OR set" button, a "clear" button, and an "undo" button for executing the process of selecting the search key to be displayed. Be prepared and trigger file editor 33
It has a configuration with a "setting" button for calling.

When one of the search keys displayed by the pointer means 4 is selected while the trigger display screen is displayed, the trigger program 32 inverts the display of the selected search key. Subsequently, when the "set" button is selected by the pointer means 4, as shown in the process flow of FIG. 9, first, in step 1, the data in the undo buffer a is saved in the undo buffer b (not shown), Next, in step 2, after saving the selected search key in the undo buffer a, finally,
In step 3, the selected search key is registered in the entry field of the search key item of the calling source.

Further, even when the "OR set" button is selected instead of the "set" button, the trigger program 32 executes the same process as the process flow of FIG. Register the retrieved search key in the entry field of the caller's search key item (in this case,
A plurality of search keys that specify a logical sum search will be registered).

On the other hand, when the "clear" button is selected instead of the "set" button, the trigger program 32
As shown in the processing flow of FIG. 10, first, in step 1, the data in the undo buffer a is saved in the undo buffer b, and then in step 2, the selected search key is stored in the undo buffer a. After saving, finally, in step 3, NULL is registered in the entry field of the search key item of the calling source to execute the process of clearing the search key that is erroneously input.

On the other hand, when the "undo" button is selected instead of the "set" button, the trigger program 32
As shown in the processing flow of FIG. 11, first, in step 1, the data in the undo buffer a is saved in the undo buffer b, and then in step 2, the selected search key is stored in the undo buffer a. After saving, lastly, in step 3, the search key stored in the undo buffer b is registered in the entry field of the search key item of the calling source, thereby inputting the search key previously input. Perform processing. When the "undo" button is continuously selected, the data stored in the undo buffer a and the data stored in the undo buffer b are exchanged,
Processing for registering the replaced search key of the undo buffer b in the entry field of the search key item of the calling source is executed.

In this way, the present invention adopts a configuration in which the list of search keys is displayed on the display screen, and the search key used for the search is selected according to the pointer means 4 from the displayed search keys. Since the configuration is adopted, the user can easily and accurately input the search key for searching the database with good operability.

Next, the processing executed by the trigger file editor 33 will be described. Here, this trigger file editor 33 will be called when the "setting" button on the trigger display screen is selected by the pointer means 4.

When called by selecting the "Set" button on the trigger display screen, the trigger file editor 33 first instructs the trigger program 32 in step 1 as shown in the processing flow of FIG. Issue an instruction to stop the process, then in step 2, specify the trigger file name pointed to by the trigger display screen that is the calling source, and then in step 3, set the trigger file as shown in FIG. A screen is displayed, and subsequently, in step 4, the search key of the trigger file 31-i pointed to by the specified file name is edited by interacting with the user via this trigger file setting screen. Finally, in step 5, control is returned to the trigger program 32.

In this way, it is possible to edit the key values of the search key list displayed on the display screen according to the trigger file editor 33. Although the embodiment configuration of the basic function of the present invention has been disclosed above, various configurations for enhancing the basic function can be added.

For example, the trigger program 32 has a configuration in which three types of "defalut", "init", and "tool" can be registered in the entry field of the screen format information shown in FIG. When "is registered, processing is performed such that the series of processing described above is executed, and" i
When "nit" is registered, the head search key of the specified trigger file 31-i is processed so that it is immediately registered in the entry field of the search key item of the calling source, and "t
When "ool" is registered, it is possible to adopt a configuration in which processing is performed so as to activate the user tools such as the document creation tool and the spreadsheet tool that are allocated.

Further, in order to deal with data that changes daily such as date,
For example, by setting an environment variable for displaying today's date as shown in FIG.
As shown in (b), it is possible to adopt a configuration in which today's date is displayed on the display screen.

[0031]

As described above, according to the present invention,
When searching the database, a structure is adopted in which a list of search keys is displayed on the display screen, and the search key used for the search is selected from the displayed search keys using a mouse or the like. Therefore, the user can easily and accurately input the search key for searching the database with good operability.

[Brief description of drawings]

FIG. 1 is a principle configuration diagram of the present invention.

FIG. 2 is an explanatory diagram of processing of the present invention.

FIG. 3 is an explanatory diagram of processing of the present invention.

FIG. 4 is an explanatory diagram of processing of the present invention.

FIG. 5 is an example of the system configuration of the present invention.

FIG. 6 is an explanatory diagram of management data of a screen format file.

FIG. 7 is an explanatory diagram of management data of a trigger file.

FIG. 8 is an explanatory diagram of a trigger display screen.

FIG. 9 is a processing flow of a trigger program.

FIG. 10 is a processing flow of a trigger program.

FIG. 11 is a processing flow of a trigger program.

FIG. 12 is a processing flow of a trigger file editor.

FIG. 13 is an explanatory diagram of a trigger file setting screen.

FIG. 14 is an explanatory diagram of processing of the present invention.

[Explanation of symbols]

 1 data storage device 2 data processing device 3 man-machine interface device 4 pointer means 20 input / output control means 21 item display control means 22 file means 23 display control means 24 selection means 25 selection mode setting means 26 access means

Claims (2)

[Claims] 1. A database system having a structure in which when a search key is input, the data pointed to by the search key is read out from a database, the search target item is provided in correspondence with the search key item, and is set in the search key item. File means to manage the list of search keys (2
2), when a search key item is selected, display control means (23) for displaying the search key list of the file means (22) pointed to by the search key item on the display screen, and a pointer pointing to the display screen. And a selecting means (24) for selecting one or a plurality of search keys in the search key list displayed by the display control means (23) by interacting with the means (4). The database search processing method is characterized in that the database is searched using the search key selected in (1). 2. The database search processing method according to claim 1, wherein two selection modes, an interactive selection mode and an automatic selection mode, are prepared as selection modes executed by the selection means (24). , When the selection mode is set to the interactive selection mode, by interacting with the pointer means (4) pointing to the display screen, one or more of the search key list displayed by the display control means (23) is displayed. When the search key is selected, on the other hand, when the automatic selection mode is set, processing is performed such that the first search key in the search key list displayed by the display control means (23) is selected. Database search processing method.