JPH04321142A - Filing device having reference table obtained with higher-lower hierarchical connection - Google Patents

Abstract

PURPOSE:To attain the diversification of the retrieving data, the facilitation of maintenance of each reference table, the reduction of the setting time of the reference table and the memory capacity, etc., by controlling the high-lower hierarchical relation of the reference tables and securing the contents set according to the data sorting for the title of each reference table. CONSTITUTION:A set table display means is provided to display a set table H1 consisting of item names in a data input state of a certain data base, together with an individual reference table production means which produces an individual reference table H2 to an optional item of the table H1, a control code production means which produces each table H2 and a control code H3a of a table H2 of a lower hierarchy and stores the control code in a hierarchical control table H3, and a data register means which registers the component data of the contents of each table H2 into a data buffer H5. When the contents of each table H2 are displayed, the contents of an individual reference table H7 registered in the buffer H5 are taken out and displayed on a screen by the code H3a of each table H2 or the control code of the individual reference table of a lower hierarchy.

Description

[Detailed description of the invention]

0001

[Industrial Application Field] This invention relates to improvements in personal computers, office computers, DPS (data processing systems), optical filing devices, and various other filing devices, and particularly relates to the improvement of filing devices having reference tables based on upper and lower hierarchical connections. In the system,
By controlling the hierarchical relationship between reference tables and changing the title of each reference table to match the data classification, you can diversify search data, simplify reference table maintenance, and save time and memory capacity for setting up reference tables. The present invention relates to a filing device that improves the efficiency of file operations by making it possible to save money and dramatically increase the amount of data handled in one reference table.

0002

2. Description of the Related Art Conventionally, in filing systems such as optical filing devices, reference tables have been used for searching, registering, and displaying databases. Further, lookup tables constructed by hierarchical combinations are also conventionally known.

[0003] This conventional lookup table based on upper and lower hierarchical joins is as follows:
It assumes that the hierarchical relationship is fixed from the beginning. Therefore, there is a restriction that the search data must continue from the higher-order data.

FIG. 14 is a diagram illustrating an example of the hierarchical structure of a conventional lookup table. In the figure, A is the upper reference table,
B indicates a middle-level reference table, and C indicates a low-level reference table. This figure 1
The reference table shown in FIG. 4 is composed of three levels: upper, middle, and lower.

It is assumed that university names are set in the upper reference table, high school names are set in the middle reference table, and junior high school names are set in the lower reference table. Assume that there are 20 data items in the upper reference table (A). In this case, also in the intermediate reference table (B),
I have to create 20 items of the same data.

However, suppose that there are 50 pieces of data in the intermediate reference table (B). Then, in the lower reference table (C), 20×50=1,000 items of the same data must be created corresponding to the top 20 items and the middle 50 items. In this way, it is necessary to create a large amount of data in a reference table configured by combining upper and lower hierarchies.

[0007]Furthermore, the lower reference table cannot be displayed alone, and there is a restriction that the search data must continue from the upper level data. Furthermore, the data in the lower reference table that each piece of data in the upper reference table has is not compatible.

Therefore, for each data in the upper reference table, the same number of lower reference tables having the same data must be set corresponding to the data in the upper reference table. For example, a lower-level reference table (in the case of this figure 14, it becomes a middle-level reference table)
However, in order to set a reference table (having the same data) further below it, it is necessary to set the number equal to the square of the data in the top-level reference table.

As a result, much of the data in the middle and lower reference tables is duplicated, and at the same time, a correspondingly large amount of memory capacity is required, resulting in waste. Furthermore, setting up multiple lower-level reference tables with the same data takes a lot of time and effort.

[0010] The above is the first problem with reference tables based on conventional upper and lower hierarchical joins. The data in the lower reference tables that each data in the reference table has are not compatible.

[0011] Furthermore, since the titles of lower-level reference tables are all search items, if an appropriate title is given at the stage when the number of lower-level reference tables is small, data classification will be easier when the number of lower-level reference tables increases. There are cases where it is difficult to judge.

FIG. 15 is a diagram illustrating another example of the hierarchical structure of a conventional lookup table. The symbols in the figure are the same as in FIG. 14.

The reference table shown in FIG. 15 also includes top, middle,
This is a case where it is composed of three lower layers. This figure 1
In case 5, the item names (titles) are all player names in the three reference tables of the upper, middle, and lower levels.

In a reference table with a hierarchical structure as shown in FIG.
If you specify the item name of the subordinate reference table (C),
Since the item names in the upper and middle reference tables (A, B) are also the same, it is unclear what criteria the item names were entered in. That is, in this case, the data actually entered into the upper reference table (A) is the country name, not the player name, and the data actually entered into the middle reference table (B) is: This is the team name, not the player name.

In this case, the title and data finally match in the lower reference table (C). Therefore, when creating a hierarchically structured reference table like the one shown in Figure 15, it is necessary to carefully consider the title of each reference table from the beginning, but in reality, a clear goal must be set at the time of creation. In many cases, there is no such thing, so sufficient consideration is not necessarily carried out, and there are often cases where deficiencies are noticed after completion.

[0016] The above is the second problem with the conventional reference table based on upper and lower hierarchical combinations, and the title of each reference table is
Since all of these items are search items, it will be difficult to understand the classification of data unless you consider them in detail when creating a reference table for each hierarchy.

[0017] Furthermore, for referencing conventional databases,
There were the following problems. This problem is also not unrelated to conventional reference tables based on upper and lower hierarchical joins. First, the space for displaying data is small. Further, due to restrictions on the number of input data due to specifications from the hardware configuration, there may be cases where it is not possible to input more data than necessary, or there are cases where it is not possible to display more input data than necessary.

FIG. 16 is a diagram illustrating an example of the use of a conventional reference table based on upper and lower hierarchical joins, in which (1) is data, (2) is a state in which a data table is used, and (3)
is a diagram showing the flow of data when using data. In the figure, D represents a window display section, E represents a hierarchy management table, F represents a data buffer, and G represents a work buffer.

FIG. 16 depicts an image when a data table is used in a database display. If there is too much data for a certain item (stop station), it cannot be displayed on one screen, but an individual reference table for that item has already been created.
Request (turn on) the display of the data table, and select Document No. and item no. The corresponding title number is searched from the hierarchy management table E using the search condition. Figure out the title number. Data is extracted from the data buffer F based on the data buffer F and inputted into the data table layout in the work buffer G.

[0020] Through such an operation, data based on the layout is displayed. Data that is not displayed within the frame of the data table will be displayed in the data table of the next page when the next page selection item is pressed.

[0021] Specifically, there is a database related to train operations, and as shown in Figure 16 (1), data on the starting station, terminal station, and stopping station of a certain train, such as ``Limited Express Odoriko No. 3'', is retrieved. In this case, since there is a large amount of data on stops, it may not be possible to display it on one screen.

[0022] Therefore, as shown in Fig. 16 (2), for "stop stations" that have a large amount of data, they are not displayed directly;
"Data table" and other necessary information such as start time and arrival time are displayed.

[0023] If you want to know the contents of the ``stop station'', select the ``data table'' item and a window D as shown in Figure 16 (3) will be displayed, displaying the contents. . In this case, from the hierarchy management table E, for example, document No. 7. Item No. Information such as No. 5 is sent to the data buffer F, and the data is transferred from the data buffer F to the work buffer G to display the layout. In addition, if you instruct it to turn off on Window D,
The screen returns to the screen shown in FIG. 16(2) again.

[0024] When using the above, there are various problems as follows. ■ If all data cannot be displayed, the title will have no meaning. ■ Even if you change the display format to display all the data for that title, you may sacrifice the display of data for other titles (because the space is constant).

[0025] Since the number of titles displayed on the screen is drastically reduced, there are cases where the function as a database is impaired. ■ It is necessary to display all the data by changing the format and scrolling the display screen, and also to return to the original screen by performing the same process.
There are disadvantages in that screen operations are troublesome and the operability is also reduced.

The above points (1) to (2) are the third problems with the conventional look-up tables based on upper and lower hierarchical joins, which are inconvenient for search operations and the like.

As described above as the first to third problems, the conventionally used lookup tables based on upper and lower hierarchical joins have many disadvantages.

[0028]

[Problems to be Solved by the Invention] The present invention solves these inconveniences in conventional filing devices.
To provide a filing device that simplifies the creation of a reference table, improves search ability using the reference table, increases the amount of database display on a screen with limited space, and makes it possible to add high value to titles. The purpose is to

[0029]

[Means for solving the problems] In this invention, firstly,
In a filing system that has a reference table by combining upper and lower hierarchies and has database search, registration, and display functions, a setting table display means for displaying a setting table consisting of item names when inputting data to a certain database, and the setting table. an individual reference table creation means for creating an individual reference table for any item in a table; a management code creation means for creating a management code for each individual reference table and individual reference tables in lower hierarchies and storing it in a hierarchy management table; data registration means for registering data constituting the contents of the individual reference table in a data buffer; According to the management code, the contents of the individual reference table registered in the data buffer are retrieved and displayed on the screen.

Second, in the first filing device, the management code of each individual reference table or individual reference table of a lower hierarchy indicates the upper or lower hierarchy such as item number, upper number, middle number, lower number, etc. Formation of a hierarchical relationship between a certain individual reference table and another individual reference table by changing the data that constitutes the content of the number, which consists of a number, title number, document number, etc., and indicates the hierarchical level of the management code. , or configured to make that change.

Thirdly, in the first filing device, in the display state of the individual reference table in the lower hierarchy, the individual reference table in the upper hierarchy is searched by the management code of the individual reference table in the lower hierarchy, and the data is stored in the individual reference table in the upper hierarchy. The content of the upper layer individual reference table registered in the buffer is taken out and displayed on the screen.

Fourthly, in the first filing device, a data list display means for displaying the data constituting the contents of the individual reference table in a list form, a display instruction means for instructing display of the data list; The system is configured to display a list of data when the number of data input to a certain item cannot be displayed within the displayable range.

[0033]

[Operation] In this invention, the hierarchical relationship of individual reference tables is controlled by management codes, and the title of each reference table is made to match the data classification. In addition, by displaying data that cannot be displayed on one screen in a data list, there is no need to change the data frame of the title that is the target of the data list, and this data list is only displayed temporarily. Therefore, the amount of data information displayed on the screen does not decrease.

[0034]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, embodiments of a filing device having a reference table based on upper and lower hierarchical combinations according to the present invention will be described in detail with reference to the drawings.

FIG. 1 is a functional block diagram showing an embodiment of the essential configuration of a filing device according to the present invention. In the figure, 1 is a CPU, 2 is a program memory, 3 is a hierarchical management table, 4 is a data buffer, 5 is a work buffer, and 6 is a system bus.

[0036] The functions of creating, calling, and updating individual reference tables regarding the filing device of the present invention will be sequentially described below.

FIG. 2 is a functional diagram illustrating the procedure for creating and calling up a new individual reference table in the filing device of the present invention. In the figure, H1 is the work screen (setting table) for the individual reference table, H1a is the selected item, H2 is the individual reference table, H3 and H3' are the hierarchical management tables, and H3a and H
3a' is the content of the management code, H4 is the title number.
The check section, H5, is a data buffer (4 in Figure 1).
5a is the data of the created individual reference table, H6 is the work screen at the time of calling, H6a is the list of individual reference tables, H7 is the individual reference table called from the data buffer H5, T1 to T
9 shows the procedure.

■When you select the mode for the newly created process setting table, this figure 2 will be displayed on the display screen.
An individual reference table work screen indicated by H1 is displayed at the upper left of the screen. The work screen H1 of this individual reference table is for item No. This is the case when "Address" of No. 3 is selected.

On this screen, the user points and selects the selection item H1a of the individual reference table, ie, one of the work items "new", "update", and "call", using the cursor. First, if you select "New" with the cursor indicated by the arrow, proceed to step T1, and proceed to step T1, as indicated by H2.
An individual reference table will be displayed.

[0040] On the screen of this individual reference table H2, a title name and N items of data are input. At that time, count the number of data items. In the case of FIG. 2, the title name is "Prefecture", and data of 1 to 10 prefecture names are input in sequence.

[0041] Thereafter, the process advances to step T2, and the set data contents are registered. In this registration of the set data contents, as shown by H3, the item number of a certain item indicated by the cursor in the hierarchy management table (3 in FIG. 1) is displayed. and document no. information is passed.

The management code of the hierarchy management table H3 is structured as shown by H3a on the right side. In other words, “Item N
o. ", "Top No.", "Medium No.", "Lower No.
．． ”, “Title No.”, and “Document No.”.

[0043] In step T3, "item N" of management code H3a is
o. " is "03" for "Address", and "Title No." of management code H3a is the title No. indicated by H4. The checking section (1 and 2 in FIG. 1) provides the latest value of the number of data managed in the hierarchy management table H3. FIG. 2 shows a state in which "1" is input as the first title created.

[0044] This "Title No." is input into the upper data of the "upper No." of the management code H3a, and the lower data is the data used when establishing a hierarchical relationship with other hierarchical management tables. Become.

In FIG. 2, "01" is input to the upper data of "upper No." and "00" is input to the lower data. That is, the individual reference table created here is a higher-level individual reference table. Therefore, "medium No." and "No.
The value of "Lower" is "0000".

The management code H3a of the individual reference table is created by the above procedure. Further, as shown in step T4, the data buffer H5 (4 in FIG. 1) contains the title number. "01", title name, N data, and information on the number of data are passed, and new individual reference table data is created as shown in H5a. Above procedure T1
~T4, a new individual reference table is created.

■Call Processing Next, the call process will be explained. When the setting table mode is selected, the individual reference table work screen H1 is displayed on the display screen at the upper left of FIG. 2, as in the case of creating a new item (2) above.

[0048] On this work screen H1, for example, item No.
Specifies the "company address" with "10" with the cursor, and selects the "call" work item in the work selection item H1a of the individual reference table.

[0049] When "Item No." and "Call" are selected, the process proceeds to step T5 shown below, and a certain item specified by the cursor is selected from the items in the hierarchy management table H3 (3 in FIG. 1). No. According to the information, the corresponding title No. is determined and passed to the list layout of the individual reference table (Figure 1
1, 2).

That is, as in step T6, the corresponding title number is determined based on the information in the management code H3a item of the hierarchy management table H3. As shown by H6a, data H5a of the corresponding individual reference table of data buffer H5 is determined.
, and display the list of individual reference tables (title display screen).

Select the individual reference table you wish to call from this list of individual reference tables H6a. In FIG. 2, in the list H6a of the individual reference table, title No. The case where "America" with "3" is selected is shown. List of individual reference tables H
In step 6a, when the individual reference table to be called is selected, the process proceeds to step T7, where a management code H3a' for the individual reference table is created in the hierarchical management table H3', similar to the new work described above.

Next, using the created management code H3a', as shown in step T8, the data of the corresponding individual reference table is extracted from the data buffer H5, and the process proceeds to step T9, where the extracted individual reference table H5 is displayed on the screen. Display above. In this case, the names of each state in "America" are displayed.

In FIG. 2, the management code H3 of the individual reference table
As is clear from a comparison between a and H3a', the difference from the management code of the same individual reference table used for another item is in item no. Title No. due to different. Only. Note that duplication prevention measures are taken to prevent the same individual reference table from being set for the same item, but since this point is basically the same as the conventional method, detailed explanation will be omitted.

■Update Processing Finally, update processing will be explained. The update process is
Perform this when updating the title name and data of the individual reference table.

[0055] Since this process is almost the same as the conventional technique, a summary thereof will be described here. FIG. 3 is a functional diagram illustrating the procedure for updating the individual reference table in the filing device of the present invention. The symbols in the figure are the same as in FIG. 2, H8 is the original reference table, H9 is the work buffer, H10 is the update data/additional data storage section, H11 is the work reference table/CRT display memory, and H12 and H12' are the update processing sections. , T11 to T17 indicate the procedure.

In steps T11 to T14, a backup of the individual reference table is created and displayed on the screen. That is, the original reference table H8 to be updated is created using the management code of the hierarchy management table H3 and the data of the individual reference table of the data buffer H5, and the work buffer H9 (5 in FIG. 1) is created.
Expand on top.

Next, in steps T15 and T16, data is updated and added, and each time it is written to the backup of the individual reference table. In FIG. 3, data to be updated or added is input into the update data/additional data storage section H10, sent to the work reference table/CRT display memory H11, and displayed on the screen.

In step T17, when registering the updated contents, the backup contents of the individual reference table are written into the data buffer H5 (4 in FIG. 1). Through the above processing, the individual reference table is updated.

[0059] In the filing device of the present invention, new creation, calling, and updating of individual reference tables are performed in accordance with the procedures described above with reference to FIGS. 2 and 3. That is, processing is performed for each independent individual reference table.

■ Creation of Hierarchical Relationship Next, the hierarchical relationship of the individual reference tables in the filing device of the present invention will be explained.

FIG. 4 is a functional diagram illustrating the procedure for creating a hierarchical relationship in the filing device of the present invention. The symbols in the figure are the same as in Figure 2, H3b and H3
c is the content of the management code of each lower hierarchy in the hierarchy management table H3,
H13 is the work screen for the individual reference table of the upper layer, and H13a
is the selected item, H14 is the individual reference table of the lower hierarchy, H14a is the selected item, H15 is the individual reference table of the next lower hierarchy, and T21 to T24 are the procedures.

[0062] When creating the hierarchical relationship of individual reference tables, first, the same operation as at the time of calling described in FIG. 2 is performed. That is, when the setting table mode is selected, an individual reference table work screen indicated by H1 at the upper left of FIG. 4 is displayed on the display screen.

[0063] On the work screen H1 of this individual reference table, item No. This is a case where No. 7 "Company Affiliation" is selected. When the cursor is used to instruct "call" the work selection item H1a of the individual reference table on this work screen H1, the process advances to step T21.

In step T21, the work screen H13 of the individual reference table in the upper layer is displayed in a window, and in this window, the selected item H of the individual reference table in the lower layer is displayed.
13a is displayed. In this case, the title of the upper individual reference table is "Bank Name" and its "Title No.
” is “27”, and “Sakura Bank” is selected from among them.

When any one of the selection items H13a of the individual reference table of this lower hierarchy is selected, the selection items H1a of new/call/update operations are displayed, as in FIG. 2 above.

[0066] Here, if any one item is selected from the selection items H1a of new/call/update operations, each operation is executed in the same procedure as in FIGS. 2 and 3 above.

For example, when creating a new item, the process advances to step T22, and the lower hierarchy individual reference table H14 and its selection item H14a are displayed. That is, the individual reference table H14 in the lower hierarchy displays the names of two or less branches from one head office.

[0068] In the individual reference table H14 of this lower hierarchy, title No. When "Shinagawa Branch" with "3" is selected and a lower level is selected in the selection item H14a, the process advances to step T23, and an individual reference table H15 for the next lower level is displayed. This lower-level individual reference table H15 is located at a lower level than the previous lower-level individual reference table H14, so the individual reference table H14 becomes a middle-level individual reference table.

In this case, the management code of the individual reference table H15 of the lowest hierarchy is the item No. H3b, as shown in H3b. is "7" of H1, and is the top No. The upper level data includes the title number of the individual reference table of the upper layer. '2
"1B" indicating "7" is entered, and the lower data is the data selected in the individual reference table of the upper layer (Sakura Bank "2")
Data No. "02" is entered.

[0070] Also, the middle No. In the upper level data, as the "Title No." of the lower layer individual reference table H14,
For example, "44" is entered, and "00" is entered in the lower order data. This FIG. 4 shows a case where there are two levels of hierarchy, so the corresponding hierarchy No. The upper level data (either middle number or lower number) includes the title number of the individual reference table of the lower hierarchy.
．． is entered, and "00" is entered in the lower data.

Note that in FIG. 4, it is assumed that there are up to three levels of hierarchy, so the middle level No. and the lower No. Although only one layer is shown in the figure, it is possible to have any number of layers, and when increasing the number of layers, the area of the corresponding management code section can be expanded.

■Change of lower hierarchy table The lower hierarchy table of the individual reference table in the filing device of the present invention is changed as follows.

FIG. 5 is a functional diagram showing the operation when an individual reference table designated by a certain item or an individual reference table of a lower layer in a hierarchical relationship with an individual reference table of a higher layer is changed. The symbols in the figure are the same as in FIG. 2, and H3d and H3e are the old management code and new management code of the lower hierarchy of the hierarchy management table H3,
H16 is the work screen for the individual reference table in the upper layer, H17 is the individual reference table in the lower layer, and H17a is the selected item.

For example, when an individual reference table for a certain lower hierarchy has already been created, the hierarchical relationship can be changed as follows. First, as in FIGS. 2 and 4, the setting table mode is selected and the individual reference table work screen is displayed on the display screen.

[0075] The work screen H1 of this individual reference table is
o. This is a case where "Company Affiliation" No. 7 is selected, and when the individual reference table H17 of the lower hierarchy to be changed is displayed, the selection item H17a of the new/call work is displayed. Then, select one of the tasks and execute the same procedure as in FIG. 2 above.

At this time, the management code of the individual reference table whose relationship is severed due to the change is discarded together with the management code of the individual reference table in the lower hierarchy that has a hierarchical relationship. For example, like the lower layer management code H3b in FIG. 4, the title number. The individual reference table for the 68 lower layers is titled No. If you want to change to the individual reference table for the lower hierarchy of 42, select item No. 7, "Precision" may be selected in the individual reference table H17 in the lower hierarchy of "Company Affiliation".

That is, in the individual reference table H17 of the lower layer you want to change, enter the title number. 42, "Precise" is selected, the old management code of the lower hierarchy shown by H3d in the upper right corner of Figure 5 is discarded, and a new hierarchical relationship is established instead, as shown by H3e in the lower right corner of Figure 5. A new management code for the individual reference table is created and registered in the hierarchical management table H3.

In this way, the lower layer management code (H3
a~H3e) Title No. By changing , it is possible to easily change the hierarchical relationship between the lower-level individual reference table and the higher-level individual reference table.

FIG. 6 is a functional diagram showing the operation when updating the hierarchical relationship as the upper hierarchical table is changed. The numerals in the figure are the same as those in FIG. 2, and H3f and H3g indicate the old management code and new management code of each hierarchy of the hierarchy management table H3.

As explained above in FIG. When a hierarchical relationship is established, the old management code H3f for each hierarchy shown on the left side of FIG. 6 is discarded, and a new management code H3g shown on the right side is created.

[0081] In this way, with the filing device of the present invention, it is possible to easily change the connection relationships of individual reference tables in each hierarchy, or to create new ones.

Next, a flowchart will be shown regarding the above-described processing. FIG. 7 is a flowchart showing the main processing flow of the individual reference table in the filing device of the present invention. In the figure, #1 to #4 indicate steps.

When a process is selected on the display screen of the reference table window, the content of the selected process is determined in step #1. If it is a new process, proceed to step #2 and perform the new process. This new process will be shown in detail in FIG. 8, FIG. 11, and FIG. 12, which will be described later.

[0084] Also, if it is an update process, step #3
Proceed to the update process. This update process will be shown in detail in FIG. 9, which will be described later. Further, if it is a call process, the process advances to step #4 and the call process is performed. Regarding this calling process, see Figures 10, 11, and 13 below.
Details are shown below.

First, new processing will be explained. Next, FIG. 8 is a flowchart showing the main process flow of the new process shown in FIG. In the figure,
#11 to #16 indicate steps.

When a new process is selected in the flow shown in FIG. 7, the flow shown in FIG. 8 starts.

[0087] In step #11, it is determined whether an instruction has been given to end the new process. When the instruction to end is given, the flow in FIG. 8 is ended. If the instruction is not to end, the process advances to step #12 and the title name and data are input. At this time, the number N of input data is counted up.

[0088] In step #13, it is determined whether the instruction is for registration, and if it is not registered, the process returns to the previous step #11.
Go back and perform the same process. If it is determined in step #13 that it is a registration instruction, the process advances to the next step #14, and the title number is set. Acquire and update.

[0089] In step #15, a hierarchy management table is registered. This process will be shown in detail in FIG. 11, which will be described later. Proceed to step #16 and register the data contents. This process will be shown in detail in FIG. 12, which will be described later. New processing is executed through the processing of steps #11 to #16 above.

Next, update processing will be explained. Next, FIG. 9 is a flowchart showing the main processing flow of the update process shown in FIG. 7. In the figure, #21~
#27 indicates a step.

When the update process is selected in the flow shown in FIG. 7, the flow shown in FIG. 9 starts. First, in step #21, the original data of the reference table is copied.

[0092] In the next step #22, it is determined whether an instruction to end the process has been given. If the instruction is to end, the process advances to step #27. If it is not an instruction to end, step #2
Proceed to step 3 to update and add data. The data is written into the work buffer (5 in Figure 1).

In step #24, it is determined whether the instruction is for registration. If it is determined that the instruction is for registration, the process proceeds to step #25, and the data in the work buffer is stored in the data buffer (4 in FIG. 1). write to.

[0094] If it is determined in step #24 that the data is not registered, the process advances to step #26, and it is determined whether or not the data in the work buffer is to be discarded. If the data is not to be discarded, the process returns to step #22 and the same process is performed.

[0095] If it is determined in step #26 that the data is to be discarded, or if the processing in step #25 is completed, the process advances to step #27. In step #27, the data in the work buffer is deleted, and the update processing in FIG. 9 is completed.

Finally, call processing will be described. Next, FIG. 10 is a flowchart showing the flow of the main processing of the call processing shown in FIG. In the figure, #31 to #34 indicate steps.

When the call process is selected in the flow shown in FIG. 7, the flow shown in FIG. 10 starts. In step #31, a list of reference tables is created and displayed. The process of creating and displaying this reference table list will be shown in detail in FIG. 13, which will be described later.

[0098] At step #32, the reference table to be called is selected. In step #33, it is determined whether or not a call has been instructed, and if the call is not performed, the flow of FIG. 10 is ended.

If there is a call instruction, the process advances to step #34 and a hierarchical reference table is registered. This hierarchical reference table registration process will be shown in detail in FIG. 11, which will be described later. The calling process is executed by the above steps #31 to #34.

[0100] The flow shown in FIGS. 7 to 10 above is as follows.
This is new, update, and call processing in the filing device of the present invention, and is executed under the control of the CPU 1 and program 2 shown in FIG.

[0101] Here, registration of the hierarchy management table shown in FIG. 8 (step #15) and FIG. 10 (step #34), registration of data contents shown in FIG. 8 (step #16), and The process of creating and displaying the reference table list in step #31) will be explained in detail.

FIG. 11 is a flowchart showing the detailed process flow for registering the hierarchy management table. In the figure, #41 to #46 indicate steps.

[0103] In registering the hierarchy management table, step #
41, item no. and document no. and step #
42, title no. get. Next step #4
3, the obtained item No. and document no. Based on the top No. Find the maximum value of.

[0104] At step #44, each of these No. Medium No. based on Find the maximum value of. At step #45, each of these No. Lower No. based on Find the maximum value of. In step #46, in the management code of the hierarchy management table,
Each No. Register. Registration of the hierarchy management table is executed through the above process.

FIG. 12 is a flowchart showing the detailed process flow for registering data contents. In the figure, #51 to #54 indicate steps.

[0106] In registering data contents, step #
51, title no. Obtain and register. In step #52, the number of data items and title name are registered. At this time, count the number of data items.

At step #53, the count value is compared with the number of data items, and if the number of data items is small, the process advances to the next step #54, the data is registered, and the count value is incremented by 1. Then, the process returns to step #53, and the same process is performed thereafter.

At step #53, when the count value matches the number of data items, the flow of FIG. 12 is ended. Registration of data contents is performed as described above.

FIG. 13 is a flowchart showing the detailed process flow for creating and displaying a reference table list. In the figure, #61 to #63 indicate steps.

[0110] In step #61, the corresponding item number is determined from the hierarchy management table. Find the data group corresponding to . In the next step #62, the title No. Create a list of reference tables by extracting title names based on from the data buffer.

[0111] In step #63, the created list is displayed on the screen. Through the above steps #61 to #63, the reference table list is created and displayed.

[0112]

According to the present invention, the hierarchical relationship between reference tables is controlled, and the title of each reference table is made to match the data classification.

[0113] As a result, firstly, since it is possible to freely combine upper and lower hierarchical relationships, it is possible to diversify search data, and the search data itself can be used flexibly and flexibly. be able to.

Second, since the independence of the reference table is increased, there are no restrictions on how the reference table can be used, making maintenance easier.

Thirdly, compared to the reference tables of upper and lower layers in the conventional technology, there is no need to set up multiple lookup tables with the same data, so it is possible to significantly reduce setup time and save memory capacity. At the same time, the validity of the data is also increased.

Fourth, since the title of a lower-level reference table can be used as data in a higher-level reference table, the amount of data handled by one reference table increases dramatically, and a lot of data can be stored in one By treating it as data, it becomes easier to classify and refer to the data.

[0117] Since a new search method with many effects as described above is obtained, the search function is significantly improved (
Effects corresponding to the inventions of claims 1 to 3).

In addition, data that cannot be displayed on the screen,
Fifth, since the data is displayed in a data list, there is no need to change the data display frame of the title that is the subject of the data list.

Sixth, since this data list is only displayed temporarily, the amount of data information displayed on the screen is not reduced, but rather increased (maintaining database functionality).

Seventh, since titles containing a large amount of data can be used in the database, there are virtually no restrictions on titles, increasing the value of the database.

Eighth, there is no need to change the format or scroll the display screen, and the number of operations of pointing devices, keyboards, etc. is greatly reduced (
Effects corresponding to the invention of claim 4), and many other excellent effects can be achieved.

[Brief explanation of drawings]

FIG. 1 is a functional block diagram showing an embodiment of the main configuration of a filing device of the present invention.

FIG. 2 is a functional diagram illustrating a procedure for creating and calling up a new individual reference table in the filing device of the present invention.

FIG. 3 is a functional diagram illustrating a procedure for updating an individual reference table in the filing device of the present invention.

FIG. 4 is a functional diagram illustrating a procedure for creating a hierarchical relationship in the filing device of the present invention.

FIG. 5 is a functional diagram showing operations when an individual reference table designated by a certain item or an individual reference table of a lower hierarchy in which an individual reference table of an upper hierarchy is changed in a hierarchical relationship.

FIG. 6 is a functional diagram showing the operation when updating hierarchical relationships in accordance with changes in the upper hierarchical table.

FIG. 7 is a flowchart showing the main processing flow of an individual reference table in the filing device of the present invention.

FIG. 8 is a flowchart showing the main process flow of the new process shown in FIG. 7;

FIG. 9 is a flowchart showing the main process flow of the update process shown in FIG. 7;

FIG. 10 is a flowchart showing the main process flow of the call process shown in FIG. 7;

FIG. 11 is a flowchart showing a detailed process flow for registering a hierarchy management table.

FIG. 12 is a flowchart showing a detailed process flow for registering data contents.

FIG. 13 is a flowchart showing a detailed process flow for creating and displaying a reference table list.

FIG. 14 is a diagram illustrating an example of a hierarchical structure of a conventional lookup table.

FIG. 15 is a diagram illustrating another example of the hierarchical structure of a conventional lookup table.

[Figure 16] Regarding the reference table using conventional upper and lower hierarchical joins,
It is a figure explaining the example of its use.

[Explanation of symbols]

1 CPU 2 Program memory 3 Hierarchy management table 4 Data buffer 5 Work buffer 6 System bus

Claims (4)

[Claims] [Claim 1] A settings table display that displays a settings table consisting of item names when inputting data to a certain database, in a filing system that has a reference table with a hierarchical combination and has database search, registration, and display functions. means, an individual reference table creation means for creating an individual reference table for any item in the setting table, and a management code for creating a management code for each individual reference table and the individual reference table of a lower hierarchy and storing it in a hierarchy management table. a creation means; a data registration means for registering data constituting the contents of each individual reference table in a data buffer;
and when displaying the contents of each individual reference table, the contents of the individual reference table registered in the data buffer are retrieved according to the management code of each individual reference table or the management code of an individual reference table in a lower hierarchy. A filing device characterized by displaying information on a screen. [Claim 2] In the filing device according to claim 1, the management code of each individual reference table or the individual reference table of a lower hierarchy is a number indicating upper or lower hierarchy such as an item number, a higher number, a middle number, a lower number, or a title. By changing the data constituting the numbers, which consist of numbers, document numbers, etc., and indicate the upper and lower hierarchies of the management code, it is possible to create a hierarchical relationship between a certain individual reference table and another individual reference table, or to A filing device characterized by making changes. 3. In the filing device according to claim 1, in the display state of the individual reference table in the lower hierarchy, the individual reference table in the upper hierarchy is searched based on the management code of the individual reference table in the lower hierarchy, and is registered in the data buffer. A filing device that extracts the contents of an upper layer individual reference table and displays the contents on a screen. 4. The filing device according to claim 1, further comprising data list display means for displaying data constituting the contents of the individual reference table in a list form, and display instruction means for instructing display of the data list. A filing device that displays a list of data when the number of data input to a certain item cannot be displayed within a displayable range.