JP2837810B2 - Data search method using operation buttons for computer processing - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for storing corresponding data by associating operation buttons displayed on a display device for instructing processing to be executed by a computer with data stored in the storage device. The present invention relates to a data search method using a computer processing operation button to be taken out from an apparatus.

[0002]

2. Description of the Related Art Conventionally, generally, when arbitrarily extracting data from data stored in a storage device of a computer, a value such as a name or an amount is designated, and the designated value and the value of a target field of the data are designated. , And a method of obtaining a storage address of data that matches a value of a target field in an index table created in advance has been widely used.

[0003] This will be described with reference to the data shown in FIG. 2 in a case where a search is performed by designating the values (names) of a plurality of target fields in the data. That is, for example, in this data, the value (name) of field 1 is "Tokyo"
And the value in field 2 is "Shibuya store" or "Shinjuku store"
When the value of the field 3 is to retrieve the data of "product A" or "product B", a list of the values of the field 1 ("Tokyo", "Kanagawa", etc.) is first displayed, and then the value of the field to be searched (for example, Select "Tokyo") or directly enter the value of this field (for example, "Tokyo") to specify a single field, and perform such operations for the number of fields required, that is, for the fields Specify "Shibuya store" or "Shinjuku store" for 2
An operation of designating “product A” or “product B” for field 3 was repeatedly performed.

[0004] All of them execute processing for searching for corresponding data based on a designated value.

[0005]

However, in the execution of processing for searching data based on the value of a designated field as in the above-mentioned conventional example, the field value is directly input to the display device as well as the input of the field value. Even if you display a value and select it, you must eventually specify the value of the field and compare it with the value of the target field in the data or index table to find the corresponding data. As the number of digits and the number of digits of the value increase, there is a problem that the operation of the user becomes troublesome, it becomes difficult for the developer to create the processing procedure, and the processing time increases.

In view of the above, the present invention displays operation buttons on a display device, retrieves corresponding data from a storage device by simply selecting an arbitrary one of the displayed operation buttons, and reduces the processing time. It is an object of the present invention to provide a system capable of greatly shortening.

[0007]

To solve the above object, according to an aspect of the data search method by a computer processing operation button according to the present invention, the storage device any of the data including a plurality of fields stored in In a unit of an individual button directly corresponding to an individual value of a field and selected using an input device, a plurality of button groups as a set and the plurality of button groups are associated with each field of the data and controlled. and, the data operation buttons including a plurality of button classes arranged in parallel
Automatically set on the basis of each button of the individual button
The display order in the class and the individual button of the data
A link table for identifying the data by automatically associating the individual values of the corresponding fields with each data and automatically setting the link table in the storage device, and among the operation buttons displayed in parallel on the display device, Display of individual buttons selected in an arbitrary order and number by the input device in each of the button classes.
The data stored in the storage device is extracted by identifying corresponding data based on the ranking and the link table.

[0008]

According to the present invention constructed as described above, the operation buttons are displayed on the display device, and any individual button among the operation buttons is selected by the input device, whereby the value of the designated field can be changed. Without comparing the value of the target field, the corresponding data is efficiently identified based on the position of the selected individual button and the link table, and the data stored in the storage device is quickly extracted, It can be used for various processes to be executed by a computer.

[0009]

Embodiments of the present invention will be described below with reference to the drawings. As shown in FIG. 1, a system for carrying out the present invention includes a display 1 as a display device for displaying operation buttons, and a display (display device) 1
Input device 2 such as a keyboard, a mouse, a touch panel, or a pen for selecting and instructing the operation buttons displayed on the screen
And a storage device 3 including a memory or a disk for storing data to be processed and operation buttons as a button class, a button group, and an individual button, and controlling these devices. And a computer (central processing unit) 4 for executing processing corresponding to the selection instruction.

FIG. 2 shows an example of the structure and values of data stored in the storage device 3. Each data 1, data 2,...
, And of these fields, for example, field 1 includes “Tokyo” and “
Kanagawa ”, Field 2 has“ Shibuya Store ”and“ Shinjuku Store ”, and Field 3 has“ Product A ”and“ Product B ”
However, in field 4, "100" and "350"
Are respectively stored.

[0011] All data values exist for the number of data items for each field constituting the data, and the values are arranged in the same order as the number of fields throughout all the data. Here, the following description is based on the assumption that each data is composed of four fields (field 1 to field 4) and that there are ten data (data 1 to data 10).

FIG. 3 shows the state of FIG. 2 stored in the storage device 3.
In accordance with the data shown in (1), an operation button composed of a button group, which is a set of individual buttons, and a button class that supervises the button group is set and stored, and a part of the operation button is displayed on the display device. 1 shows the state displayed.

In this embodiment, the button class "district" shown in FIG. 3A corresponds to the field 1 of the data shown in FIG. 2, and one button corresponds to this button class "district". A group "Kanto" is set, and the button group "Kanto" is represented as a set of individual buttons such as "Tokyo" and "Kanagawa" based on the value of the field 1.

Similarly, the button class shown in FIG.
“Store” corresponds to field 2 of the data shown in FIG. 2, and for this button class “store”, a total of four button groups for each prefecture in field 1 “
"Tokyo", "Kanagawa", "Saitama", and "Chiba" are set, and one of the button groups "Tokyo" is based on the value of field 2, "Shibuya store", "Shinjuku store" Etc. are represented as a set of individual buttons.

Further, a button class shown in FIG.
The item “product” corresponds to the field 3 of the data shown in FIG. 2, and one button group “large classification” is set for this button class “product”, and the button group “large” is set. “Classification” is represented as a set of individual buttons such as “Product A” and “Product B” based on the value of field 3.

These buttons are stored in the storage device 3 as buttons.
The data is stored in an array format, updated as the data is updated, and displayed on the display device 1 as operation buttons as needed.

Next, the process of creating the link table shown in FIG. 4 by associating the data shown in FIG. 2 with the operation buttons shown in FIG. 3 will be described. Here, the selection positions of the individual buttons in each button class are counted from the top in the order of 01, 02..., And are linked in the order of “district”, “store”, and “product”, and the button selection pattern corresponding to each data ( (Each two digits).

First, data 1 is replaced with data NO. 001, the position of the individual button that matches the value “Tokyo” of field 1 of this data 1 (data No. 001)
Search from class “District” and button group “Kanto”. This is the first button (01). Similarly, the position of the individual button that matches the value 1 of field 2 of data 1 “Shibuya store” is searched from the button class “store” and the button group “Tokyo”. This is also the first button (01). Furthermore, the position of the individual button that matches the value of the product 1 in field 3 of the data 1 is searched from the button class “product” and the button group “major category”. This is also the first button (01).

Data 1 is an operation button "Tokyo (0
1) Since "," Shibuya Store (01) ", and" Product A (01) "may be the corresponding data, the button selection pattern of Data 1 is" 010101 ".

Similarly, data 2 includes operation buttons “Tokyo (01)”, “Shinjuku store (02)”, and “Product A (01)”
Is selected as the corresponding data when is selected, so that the button selection pattern of data 2 is “010201”.

In the data 6, in the field 1
The individual button of the button group "Kanto" that matches "Kanagawa" is the second button (02) from the top. Then, although not shown, the individual buttons of the button group "Kanagawa" of the button class "Store" are sequentially called "Yokohama store"
, "Kawasaki store"…, the individual button of this button class that matches the value of field 2 of data 6 "Yokohama store" is the first button (01), and the button selection pattern of this data 6 is " 020101 ". Similarly, the button selection pattern of data 7 is “02020”.
1 ".

In this manner, the button selection pattern corresponding to the value of each individual field of all data is set, and the data NO. A link table in which the link table is associated with the button selection pattern is created, and this is stored in the storage device 3.

The method of expressing the selection position of the individual button is not limited to the numerical value in the decimal system as described above, but may be any value as long as the selection position can be uniquely specified by a value in a binary system or another method.

For example, when the selected position of the individual button is represented by a code in the 36-ary system, the code is set to "0", "
1 ", ...," 9 "," A "," B ", ...," Z "are represented by numbers and alphabetic codes.In this case, for example, if the code is" K ", the 20th Become.

When a code is expressed by the 256-ary system, the code is expressed by connecting hexadecimal byte codes of X "00" to X "FF". In this case, for example, if the code is X "F0", it is the 240th.

When there is no individual button that matches the value of the field, a character indicating that there is no selected position in the corresponding button selection pattern is used, for example,
Expressed as "&&”. In this case, the processing is performed by adding an individual button later, or the processing is performed on the assumption that there is no button.

Next, referring to FIG. 2 to FIG.
2 will be described based on the operation buttons shown in FIG. 4 and the link table shown in FIG. 4, but this can be performed by an operation almost reverse to the creation of the link table.

That is, the operation buttons as shown in FIG. 3 are displayed on the display device 1, and the input device 2 is used, for example, as shown by a thick frame in FIG.
Then, replace "Tokyo" with the button class "Store" in the same figure (b).
Then, "Ikebukuro store" is selected, and in the button class "Product" in FIG.

Then, when the selection positions of these individual buttons are represented by the above-mentioned button selection pattern, they become "010302" as shown in FIG. 4D, and the corresponding button in the link table shown in FIG. Data NO. To identify the relevant data. That is, in the case of this selection, the corresponding data is the data NO. 003 (data 3).

If there is a button class for which an individual button has not been selected, a character indicating that there is no selection is used in the digit of the button selection pattern.
Expressed as "**". In this case, the pattern comparison of the digit becomes unnecessary, and the value of the corresponding field may be anything.

After the link table as shown in FIG. 4 is set, if an update such as addition, change or correction, or deletion of data occurs, the link table is updated as necessary. To do.

That is, when data is added, a button selection pattern is newly formed and the data No. of the added data is set. Together with the link table. If the data is changed or modified, the corresponding data No.
Is re-formed and replaced with the previous button selection pattern. If the data is deleted, the data NO. Is invalidated by replacing the button selection pattern with “000000”. As described above, when the data is updated, the content is updated to the data No. The link table can be updated by reflecting it in the button selection pattern corresponding to.

Although FIGS. 3 and 4 show an example in which individual buttons are selected one by one for each button class, a plurality of individual buttons can be selected in an arbitrary button class.

For example, as shown by a bold frame in FIG. 5, the button class “store” in FIG. 5B includes “Shibuya store” and “Shinjuku store” and the button class “C” in FIG. In Products
When “product A” and “product C” are selected, a plurality of button selection patterns corresponding to these selections, that is, in this example, “010101”, “010201”, “01”
The four button selection patterns of “0103 ″ and“ 010203 ”are formed.

Then, in the link table shown in FIG. 4, data N having these button selection patterns are stored.
O. Is searched for, so that the data NO. 001
(Data 1) indicates "010101" and Data No. 00
2 (data 2) each has “010201”, and the button selection patterns “010103” and “010103”
203 ", there is no data No. 203", so that the corresponding data can be identified as these two cases.

As described above, the value (name) of the data search field in the present embodiment is specified by inputting the individual button of the corresponding value in each button class (operation button) displayed on the display device 1. It is only necessary to arbitrarily select via 2.

In the above embodiment, the button selection pattern has been described as being formed by linking the button classes "district", "store", and "commodity" in this order. However, the position of the selected individual button and the link are selected. In the table, as long as consistency is maintained in the connection order of the button classes when forming the button selection pattern, they can be formed in any order depending on the operation and processing.

The order of the individual buttons in each button class is in the order of data input, the order of selection of individual buttons, and the order based on the value of the corresponding field (ascending order or descending order).
For example, in the same manner as described above, they can be displayed in an arbitrary order depending on the operation and processing. That is, the user can more easily and easily operate the data search processing instruction by updating the order as necessary or switching between a plurality of different arrangements and displaying the same. .

FIG. 6 shows FIG. 2 stored in the storage device 3.
Button class corresponding to field 4 of data shown in
Prepare "money", set one button group "rank" for this button class "money", and set this button group "rank" to "less than 100 million yen", "1"
An example is shown in which the values of the field 4 can be ranked and identified by expressing them as a set of individual buttons of “up to 300 million yen” and “300 million yen or more”.

Here, as in the case of FIG. 3, the positions of the individual buttons are counted as 01, 02...
If a button class is used as a component of a button selection pattern (represented by two digits), other button
The corresponding data can be identified based on the position of the selected individual button as in the case of the class.

For example, assuming that the button selection pattern is formed by linking "amount" after "district", "store" and "commodity" shown in FIG. 4, the button selection pattern corresponding to data 1 in FIG. Indicates that the value of field 4 is "100" (unit: million yen), which is the button class shown in FIG.
The second "100-300 million yen" of the individual button in "Amount"
"01010102" (the last two digits are
"02"). In the case of data 2, similarly, the value of field 4 is “350”, which corresponds to the third “more than 300 million yen” of the individual button in the same button class, so that “01020103” (the last 2 Digit is "0"
3 ").

By setting the link table in this way, by selecting the individual button of the button class "money", it becomes possible to identify the corresponding data to which the condition relating to the money is added.

As described above, the link table shown in FIG. A method of identifying relevant data using a link table that directly associates a button selection pattern with a button selection pattern has been described. However, the amount of data is large but the frequency of data update is low. Depending on the characteristics of data and processing, it may be better to set and use another link table depending on the characteristics of data and processing, such as when the frequency is high, and particularly when high-speed response is required.

FIG. 7 shows an optimum link table used in such a case. This link table uses a unique button selection pattern as an index and corresponds to an individual button selection pattern. Data NO. As many as exist.

In this case, by arranging the button selection patterns in a predetermined order and using them in advance, the binary
By searching for a button selection pattern that matches the button selection position, it is possible to more efficiently and quickly identify the corresponding data.

[0046]

Since the present invention has the above configuration,
By selecting an arbitrary individual button among the operation buttons displayed on the display device, it is possible to specify the data search, thereby simplifying the operation of the user.

Moreover, the corresponding data can be identified based on the position of the selected individual button and the link table without directly comparing the value of the designated field with the value of the target field. This saves the developer the trouble of creating the processing procedure, and also allows the data to be extracted at high speed and the processing time to be shortened.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an outline of a system for implementing the present invention.

FIG. 2 is a view showing an example of the configuration of data and data values stored in a storage device.

FIG. 3 is a diagram showing an example of a button class, a button group, and an individual button corresponding to each field of data, and a description for displaying and selecting the button on a display device.

FIG. 4 is a diagram showing an example of a link table between operation buttons and data.

FIG. 5 is a diagram showing an example of a state in which a plurality of individual buttons are selected in an arbitrary button class.

FIG. 6 is a diagram showing an example of a button class, a button group, and an individual button when a data field value is a money amount (numerical value).

FIG. 7 is a diagram showing an example of another link table of operation buttons and data in an index format.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Marking device 2 Input device 3 Storage device 4 Computer (central processing unit)

────────────────────────────────────────────────── ─── Continuation of the front page (56) References JP-A-1-211028 (JP, A) JP-A-4-216169 (JP, A) JP-A-53-51028 (JP, A) JP-A-5-51028 81275 (JP, A) JP-A-63-155326 (JP, A) JP-A-2-230371 (JP, A) Ryosuke Hotaka, Illustrated Computer Series "Introduction to Databases", pp. 73-78, Ohmsha, Microsoft's Excel User's Guide, pp. 419-422, December 25, 1978, Microsoft Corporation, February 1, 1994, first edition, first edition issued (58) Fields investigated (Int. Cl. ⁶ , DB name) G06F 17 / 30 G06F 3/02 320

Claims (1)

(57) [Claims] An individual button selected directly using an input device in direct correspondence with an individual value of an arbitrary field of each data composed of a plurality of fields stored in a storage device is set as a unit. A plurality of button groups and a plurality of button groups arranged in parallel by integrating a plurality of button groups and the plurality of button groups in correspondence with each field of the data.
Based on the above data, the operation buttons composed of classes
Each button class of the individual buttons , dynamically set
The display order and a link table that identifies the data in association with individual values for each data <br/> field corresponding to the individual by the button of the data at the inner in the storage device itself
The display order in each button class of the individual buttons selected in an arbitrary order and number by the input device among the operation buttons dynamically set and displayed in parallel on the display device and the link A data retrieval method using operation buttons for computer processing, wherein the data stored in the storage device is extracted by identifying corresponding data based on a table.