JP3042666B2 - Database information display device in database system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database information display device in a database system, and more particularly, to visualize each data constituting a database (hereinafter, referred to as "database information") in the database system. The present invention relates to a database information display device in a database system for displaying information.

[0002]

2. Description of the Related Art In recent years, as a database system, not only a database system constructed by each company to computerize its business but also a commercial database system accessible to ordinary computer users. Has become widespread.

In such a database system, as a display format of database information for constructing each database, a so-called card format in which each database information is displayed for each card on a single card displayed on a display screen, A so-called table format in which a plurality of pieces of database information are displayed on a table displayed on a display screen is known.

On the other hand, as a display format of a hierarchical structure of a file system, a tree format for displaying a tree shape on a display screen is known.

[0005]

However, in the database information display device of the conventional database system, the card format and the table format are not simultaneously linked with each other, so that the operator can select each format according to the desired display format. Since it is necessary to read and write each format, and change the display format to check each format, the operation is complicated and inefficient.

Although it is possible to perform display in a plurality of display formats on the same screen, it is not possible to cooperate the display in a plurality of display formats on the same screen. It is not easy to visually recognize the hierarchical structure of (i.e., naturally, the contents of the database information and its hierarchical structure cannot be visually recognized at the same time), and the workability in processing the database information is not good. There was a problem.

SUMMARY OF THE INVENTION The present invention has been made in view of such various problems of the prior art, and an object of the present invention is to make a card format, a table format, and a tree format cooperate with each other. In addition to simplifying the operation of the operator, efficient work can be performed, and the contents of the database information and its hierarchy can be displayed in multiple display formats on the same screen. It is intended to provide a database information display device in a database system capable of simultaneously viewing the structure and reading each database information in an easy-to-read format and writing in an easy-to-write format to improve workability. Things.

[0008]

To achieve the above object, a database information display device in a database system according to the present invention is a database information display device in a database system for displaying database information constituting a database. Storage means for storing a database comprising a plurality of pieces of database information each having at least one or more pieces of hierarchy information and row number information indicating a row in the hierarchy indicated by the hierarchy information; Display means capable of displaying the database information constituting the database in a card format, a table format and a tree format according to an arrangement order specified by the hierarchy information and the line number information, and The above display format displayed in the means, and An operator for performing a desired instruction on the database information, and an operator for selecting one of the display formats displayed on the display means by the operator and operating the desired instruction. The display in the display format selected by the user is changed in accordance with the operation, and the content stored in the storage unit is updated in response to the operation of the desired instruction. A change control means for detecting a corresponding portion from the hierarchy information and the line number information and changing the detected portion according to the operation.

[0009]

When the database information is changed in a certain display format, the storage contents of the database are changed in accordance with the change. Further, referring to the hierarchy information and the line number information, the database information corresponding to the other display format is changed. Is also changed.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, a database information display device in a database system according to the present invention will be described in detail with reference to the accompanying drawings.

FIG. 1 is a block diagram of a database information display device in a database system according to an embodiment of the present invention.

The database information display device in this database system is configured to control the overall operation using a central processing unit (CPU) 10. The CPU 10 includes, via a bus, a read-only memory (ROM) 12 that stores a predetermined program for controlling the entire operation, a program for executing a process shown in a flowchart described later, and the like;
A random access memory (RAM) as a working area in which a register or a flag for storing various data necessary for the execution of a program by the CPU 10 and an area for storing database information read from the magnetic disk 22 and the like described later are set. 14, a keyboard 16 provided with various controls for giving instructions related to the implementation of the present invention described later, a mouse 18 for performing appropriate operations similarly to the keyboard, and a card format or table format on the screen. A display device 20 such as a graphic display or a character display for displaying database information in a tree format or a tree format, and a magnetic disk 22 as an external storage device storing a database composed of database information to be displayed on the display device 20 It is connected.

In the database information display device of this database system, the database information stored on the magnetic disk 22 is read by the CPU 10 into the RA.
M14, and the database information thus stored in the RAM 14 is
Under the control of U10, it is displayed on the screen of the display device 20 as a card format, a table format, and a tree format.

Here, the display in the card format, the table format and the tree format on the screen of the display device 20 means the display modes shown in FIG. In FIG. 3, as an example, “electronic component master”
Database.

That is, in the card format, for each piece of database information constituting a database, a layer number indicating the layer of each piece of database information and data items 1 and 2 indicating the contents of the database information are stored on the card. Is displayed. In FIG. 2, the hierarchy number is “1”, the data item 1 (in this embodiment, “parts category” is indicated) is “resistance”, and the data item 2 (in this embodiment, “classification code”). ")." 200 "
Is shown.

In the table format, the above-mentioned hierarchy number and data item 1 and data item 2 indicating the contents of the database information are displayed on the table for a plurality of database information. At this time, each row of the table is displayed in a predetermined order with a one-to-one relationship with each database information. The display order of each row in this table format is the same as the display order of each row in the data structure table described later.

In the tree format, segments constituting the tree are displayed in the hierarchical order according to the hierarchical numbers displayed in the card format and the table format, thereby forming the tree. In other words, the segments indicated as data item 1 and data item 2 indicating the contents of each database information are arranged in a hierarchical order according to the hierarchical number.

Next, the data structure of database information constituting the database stored on the magnetic disk 22 will be described. In this embodiment, for easy understanding, the database of the “electronic component master” is shown as in FIG.

FIG. 3 shows a data structure of database information constituting the database stored on the magnetic disk 22. A table showing the data structure of this database information is hereinafter referred to as a "data structure table". Name.
Note that the configuration of the data structure table is configured in a format similar to a table format, which is one of the display formats displayed on the display device 20.

In this data structure table, a hierarchical number storage area referred to when displaying in a tree format,
It has a data item 1 storage area and a data item 2 storage area as areas for storing the contents of the database information, and shows the order of display in the table format and the tree format by the order of the rows of the data structure table. I have.

Incidentally, such an order may be stored in the data structure table, for example, a numerical value indicating a row as a row number. When a numerical value indicating a row is stored as a row number in the data structure table, the order of the rows in the data structure table may be any order.

The contents of the database information stored in the hierarchy number storage area, data item 1 storage area, and data item 2 storage area in each row of the data structure table include the hierarchy number, data, It is configured in a one-to-one correspondence with the contents of the database information indicated by the item 1 and the data item 2, and the hierarchy indicated by each segment in the tree format display, and the database information indicated by the data item 1 and the data item 2 And one-to-one correspondence.

Next, the hierarchy number stored in the hierarchy number storage area of the card structure table will be described. Note that, in order to facilitate the understanding of the following description, the rows of the data structure table
[K] (“k” is a numerical value indicating a row number), and the layer number of the k-th row is denoted by “L (C [k])”.

The above-mentioned hierarchy number is an integer of “0” or more in this embodiment, and is the root segment (the highest parent segment in the tree display). In this embodiment, the hierarchy number 0 (L (C [1]) = 0 is defined as the root segment), and indicates the connection of each segment. Therefore, if the layer number is 1, it is a child segment of the root segment. If it is hierarchical number 2, it is a grandchild segment of the root segment (a child segment of the above child segment).

Further, the above-mentioned hierarchy number is obtained by the following (1)
To (3) are determined based on the requirements.

(1) If k is 2 or more, "L (C
[K] ≧ 1 ”, and a segment other than the root segment always has a parent segment.

(2) “L (C [k + 1]) ≦ L (C
[K]) + 1 ”must always hold. That is,
Prohibit a parent segment from having a grandchild segment that does not go through a child segment.

(3) When k is an integer of 2 or more, L
The parent segment of (C [k]) is “L (C [k]) = L
(C [i]) + 1 ”and“ 1 ≦ i ≦ k−1 ”, the largest one among“ i ”is“ imax ”.
[Imax]. That is, the parent segment of each segment is the closest segment among the segments above the position of the segment among the segments having the layer number smaller by “1” than the layer number of the segment.

As described above, the data structure table includes information indicating the hierarchy number of the database information and information indicating the row number (as described above, in the present embodiment, the order of the row arrangement in the data structure table). ) And information indicating the contents of the data items are always stored.

In the above configuration, the display processing of the database information by the database information display device in the database system will be described with reference to the flowcharts shown in FIGS. It should be noted that a block diagram showing the flow of processing of the database information shown in FIG. 6 is also referred to.

First, when the power is turned on to the database information display device in the database system and the program is started, a predetermined initialization process is performed, and the database name is determined based on the operation of the keyboard 16 by the operator. It is in a state of waiting for the operation of the selection instruction.

At this time, a list of database names stored in the magnetic disk 22 is displayed on the display device 20 to prompt the operator to select a database name.

When one of the database names is selected by the operator, in step S402,
Processing of database selection will be performed, that is,
The database name selected by the operator is stored in the RAM 14 and is used as a reference for subsequent processing.

Upon completion of the process in step S402, the flow advances to step S404 to detect an operation of the keyboard 16 and the mouse 18 by the operator.

In step S404, when the operation of the keyboard 16 and the mouse 18 by the operator is detected, the process proceeds to step S406, and the operation of the keyboard 16 and the mouse 18 detected in step S404 is terminated. It is determined whether or not the instruction is.

If the determination result of step S406 is affirmative (YE
S), that is, when the operation detected in step S404 is an instruction to end the display processing of the database information, the processing based on this flowchart is ended as it is.

On the other hand, if the decision result in the step S406 is negative (NO), that is, if the operation detected in the step S404 is not an instruction to end the display processing of the database information, the process proceeds to a step S408, and the detection in the step S404 It is determined whether or not the operation of the keyboard 16 and the mouse 18 performed is an operation of selecting a display format to be displayed on the display device 20. As the display format, one to three types (all types) can be selected from three types of display formats: a card format, a table format, and a tree format.

The result of the determination in step S408 is positive, that is, the operation detected in step S404 is
If the operation is to select a display format for displaying on the RAM 14, the process proceeds to step S410, and the RAM 14
Is read from the magnetic disk 22 into a predetermined area of the RAM 14, and database information constituting the read database is displayed on the display device 20 in the display format selected in step S404. When the process in step S410 is completed, the process returns to step S404, and waits for the operation of the keyboard 16 and the mouse 18 by the operator.

On the other hand, if the decision result in the step S408 is negative, that is, if the operation detected in the step S404 is not a selection operation of the display format to be displayed on the display device 20, the process proceeds to a step S412, and the detection is performed in the step S404. It is determined whether the performed operation is an operation of selecting one of desired database information from a display screen of one of the display formats displayed in step S410.

The result of the determination in step S412 is affirmative, that is, the operation detected in step S404 is
If the operation is to select one of the desired database information from the display screen of one of the display formats displayed in 410, the process proceeds to step S414, and the selected database information is displayed on the display device 20. Is highlighted on the screen of the display format used at the time of selection. The selected database information is also highlighted on the screen of the display format not used at the time of selection displayed on the display device 20. This step S41
Upon completion of the four processes, the process returns to step S404 to wait for the operation of the keyboard 16 and the mouse 18 by the operator.

On the other hand, the result of the determination in step S412 is negative, that is, the operation detected in step S404 determines that one of the desired database information is displayed on the display screen of one of the display formats displayed in step S410. If the operation is not a selection operation, the operation detected in step S404 is an operation performed on the selected database information, and the process advances to step S416 to determine the type of operation by the operator.

According to the result of the determination in step S416, the operation by the operator changes the hierarchical structure (addition / deletion of a card in card format, addition / deletion / deletion of a row in table format)
Copy / move or move / segment in tree format
Copy / delete. ) Is instructed, the process proceeds to step S418, and the hierarchical structure on the screen of the display format selected in step S408 is updated.

Upon completion of the process in step S418, the flow advances to step S420 to update the database so as to reflect the hierarchical structure updated in step S418.

Upon completion of the process in step S420, the flow advances to step S422 to update the hierarchical structure of another display format on the screen according to the database updated in step S420. Then, when the process of step S422 is completed, the process returns to step S408, and waits for the operation of the keyboard 16 and the mouse 18 by the operator.

On the other hand, according to the determination result of step S 416, the operation by the operator is performed for data item 1 or data item 2
If addition, change, or deletion of the data content is instructed, the process proceeds to step S424, and the data content is updated on the screen of the display format selected in step S408.

When the processing in step S424 is completed, the flow advances to step S426, and the database is updated so as to reflect the data content updated in step S424.

Upon completion of the process in step S426, the flow advances to step S428 to update the data content of another display format on the screen according to the database updated in step S426. When the process in step S428 is completed, the process returns to step S408, and waits for the operation of the keyboard 16 and the mouse 18 by the operator.

Next, the details of the processing of the database information executed in the processing of steps S424 to S428 will be described with reference to the flowcharts shown in FIGS.

That is, FIG. 7 is a flowchart showing a process for adding database information to the database. First, in step S702, the data structure table starts from the position of the parent database information of the database information to be added. Searches the last database information among descendants of the parent database information.

When the process of step S702 is completed, the process proceeds to step S704, where empty database information is added immediately after the database information retrieved in step S702, and the position of the following database information is shifted backward by one.

Upon completion of the process in step S704, the flow advances to step S706 to set the layer number of the added database information as a value obtained by adding “1” to the layer number of the parent database information, and to store the database information in this database. Then, the flowchart showing the process for adding the. Is completed.

FIG. 8 is a flowchart showing a process for deleting database information from the database. First, in step S802, in the data structure table, the database information which is the ancestor of the database information to be deleted and the ancestor of the ancestor are displayed. A set of all database information that is a descendant of a certain database information is obtained.

Upon completion of the processing in step S802, the flow advances to step S804, where the data structure table is used to execute step S804.
802 is a flowchart showing a process of deleting all database information belonging to the set obtained in step 802, shifting the positions of the following database information forward by the number of deleted database information, and deleting database information from this database. finish.

FIG. 9 is a flowchart showing a process for copying / moving database information in the database information. First, in step S902, in the data structure table, database information which is an ancestor of the database information to be moved / copied is stored. And a set of all database information that is descendants of the ancestor database information.

Upon completion of the processing in step S902, the flow advances to step S904 to move / move in the data structure table.
Starting from the position of the database information that is the parent of the copy of the database information that is the ancestor of the database information to be moved / copied after the copy, the last database information is searched for in the database information that is the parent of the copy and its descendants. .

When the process of step S904 is completed, the process proceeds to step S906, in which all the database information belonging to the set obtained in step S902 are searched in the same order as the order in the data structure table in the last database information searched in step S904. Immediately after copying, the position of the following database information is shifted backward by the number of elements of the set obtained in step S902.

When the processing in step S906 is completed, the flow advances to step S908 to calculate the increment of the layer number, and then to step S910.

In step S910, the increment obtained in step S908 is added to the layer number of all the database information of the copy destination, and the flow advances to step S912.

In step S912, it is determined whether the type of processing is "copy" or "move".

If the result of the determination in step S912 is "move", the flow advances to step S914 to delete from the data structure table all database information belonging to the set determined in step S902, and Is shifted forward by the number of the deleted database information, and the process proceeds to step S916.

On the other hand, if the result of the determination in step S912 is "copy", the flow directly advances to step S916.

In step S916, step S902
Then, the data structure table created by the processing of step S9140 is output, and the flowchart showing the processing when copying / moving the database information in the database information ends.

FIG. 10A is a flowchart showing details of the coordination processing of three types of display formats, that is, a card format, a table format, and a tree format on the display screen of the display device 20. FIG. 2B is a block diagram illustrating a processing structure of the cooperation processing.

That is, in the coordination processing in this embodiment shown in FIG. 10, when an update of the database is instructed from one of the currently displayed screens, the screen display contents of all the currently displayed screens are displayed. Is deleted, the entire contents of the updated data structure table are displayed again on the displayed screen (step S1002).

As described above, after erasing the screen display contents for all the currently displayed screens, the entire contents of the updated data structure table may be displayed again for the displayed screens again. Instead, only the display part that is different from the current display may be deleted, and only the deleted display part may be displayed based on the updated data structure table.

Next, referring to FIGS. 11 to 22,
An operation example of the database information display device in the database system of the present invention will be described.

First, a case will be described in which a tree format and a table format are displayed on the screen of the display device 20 and a process of rewriting certain database information is performed.

First, the power is turned on to the database information display device in the database system, the program is started, and the initialization process is performed.

Then, a list of databases is displayed on the display device 20, and the selection is prompted.

Here, when the database "electronic component master" is selected with the mouse 18, the user is prompted to select a display format for displaying database information from a card format, a table format, and a tree format.

When the tree format is selected with the mouse 16 at this time, all the database information of the database “electronic component master” is read from the magnetic disk 22 into the RAM 14 and displayed on the screen of the display device 22 in the tree format (FIG. 11).

Further, when the table format is selected with the mouse 16, all the database information of the same "electronic component master" is displayed on the same screen of the display device 22 in the table format (FIG. 12).

Here, assuming that the database information “resistance” is processed in the tree format, the “resistance” in the tree format is selected by the mouse 16.

As a result, the color of the segment of the database information “resistance” in the tree format is changed and highlighted, and the color of the row of the database information “resistance” in the table format is changed and highlighted. .

Then, paying attention to the data item 1 in the table format, the character string “resistance”, which is the current storage content, is
When the character string is changed to “resistor” (FIG. 13), the storage of the database is also updated, and the character string “resistance” of the segment in the tree format corresponding to the data item 1 in the table format is referred to as “resistor”. It is changed to a character string (FIG. 14).

Next, a case in which a tree format and a table format are displayed on the screen of the display device 20 to perform a process of rearranging the hierarchical structure will be described.

First, the power is turned on to the database information display device in the database system, the program is started, and the initialization process is performed.

Then, a list of databases is displayed on the display device 20, and the selection is prompted.

Here, when the database "electronic component master" is selected with the mouse 18, the user is prompted to select a display format for displaying database information from a card format, a table format, and a tree format.

When the tree format is selected with the mouse 16 at this time, all the database information of the database “electronic component master” is read from the magnetic disk 22 into the RAM 14 and displayed on the screen of the display device 22 in the tree format (FIG. 11).

Further, when the table format is selected with the mouse 16, all the database information of the same “electronic component master” is displayed in the table format on the same screen of the display device 22 as the above (FIG. 12).

Here, assuming that the processing is performed by focusing on the database information “resistance” in the tree format, the “resistance” segment in the tree format is selected by the mouse 16. In the database information “resistance”, a plurality of pieces of database information are subordinate to a lower hierarchy as child segments.

Thus, the database information “resistance” in the tree format and the database information “variable resistor” and the database information “fixed resistor” subordinate to the database information “resistance” segment.
The color of the segment is changed and highlighted, and the database information “resistance” in the tabular form and the database information “variable resistor” and the database information “fixed resistor” following the row of the database information “resistance” are displayed. The color of the line is changed and highlighted.
5).

Then, using the keyboard 16 or the mouse 18, tree-type database information “resistance” is displayed.
Is performed for each segment of the lower hierarchy, the database information “resistance” and the segments of the lower hierarchy are deleted from the tree-shaped display.

As a result, the storage of the database is also updated. Based on the update of the database, the table information corresponding to the database information “resistance” and the lower hierarchy segment is changed from the tree display to the table display. (FIG. 16).

Further, a case will be described in which a tree format and a table format are displayed, a hierarchy is added, and information on data items of database information is written in a card format.

First, the power is turned on to the database information display device in the database system, the program is started, and the initialization process is performed.

Then, a list of databases is displayed on the display device 20, and the selection is prompted.

Here, when the database "electronic component master" is selected with the mouse 18, the user is prompted to select a display format for displaying database information from a card format, a table format, and a tree format.

When the tree format is selected with the mouse 16 at this time, all the database information of the database “electronic component master” is read from the magnetic disk 22 into the RAM 14 and displayed on the screen of the display device 22 in the tree format (FIG. 11).

Next, in the tree format, an instruction is given to add a segment of layer 3 below a segment of variable resistor of layer 2 (FIG. 17).

Then, the frame of the segment instructed to be added in the tree format is displayed, and the highlighted portion is displayed in a different color as the noted portion (FIG. 18). At this time, the contents of the segments corresponding to the data item 1 area and the data item 2 area of the data structure table are blank.

Further, when the table format is selected with the mouse 16, all the database information of the “electronic component master” including the segment added above is displayed on the same screen of the display device 22 in the table format. Also, at this time, the line corresponding to the segment added in the tree format is
The color is changed and highlighted as a point of interest. Also,
Data item 1 and data item 2 are blank (FIG.
9).

Next, when the card format is selected by the mouse 16, the card having the layer number of the layer 3 of the segment which is the current point of interest is displayed on the same screen of the display device 22 in the card format ( (FIG. 20). At this time, the storage contents corresponding to the data item 1 and the data item 2 are blank.

In the card format, "volume" is written as a character string, focusing on the column of data item 1. Next, paying attention to the data item 2 column, "31" is used as a character string.
"0" is written (FIG. 21).

As a result, the storage of the database is updated, and based on the updated database, the same character string is displayed on the corresponding row in the table format and the corresponding segment in the tree format (FIG. 22).

The names and data contents of the databases in the above-described embodiments are merely shown for explanation, and the database and the database according to the present invention are not limited to the above.
Of course, the database information display device in the system may be used for processing various databases.

[0098]

Since the present invention is configured as described above, it has the following effects.

In a database information display device in a database system for displaying database information constituting a database, at least one or more hierarchy information and line number information indicating a line in a hierarchy indicated by the hierarchy information are respectively stored. Storage means for storing a database composed of a plurality of pieces of database information, and database information constituting the database stored in the storage means according to an arrangement order specified by a card format, hierarchy information, and row number information. A display unit that can be displayed in a table format and a tree format display format, an operator for performing a desired instruction on the display format and database information displayed on the display device, and one of the display devices displayed by the operator Is selected and the desired instruction is operated. The display in the display format selected by the operator is changed in accordance with the operation, the content stored in the storage means is updated in accordance with the operation of the desired instruction, and the display in a format other than the display format selected by the operator is further performed. A change control unit that detects a corresponding portion in the format from the hierarchy information and the line number information and changes the detected portion according to an operation, so that when database information is changed in a certain display format, The storage contents of the database are changed in accordance with the change, and the display of the corresponding database information in another display format is also changed by referring to the hierarchy information and the line number information.

That is, according to the present invention, the card format, the table format, and the tree format are linked to each other, so that the change of the database information is instructed based on the operation of the operator in any of the display formats. And the change is reflected in other display formats, so that the operation can be simplified, and the display can be performed in a plurality of display formats on the same screen. Since the contents of the database information and the hierarchical structure thereof can be visually recognized at the same time, each database information can be read in an easy-to-read format, and can be written in an easy-to-write format, thereby greatly improving workability. .

[Brief description of the drawings]

FIG. 1 is a block diagram of a database information display device in a database system according to one embodiment of the present invention.

FIG. 2 is an explanatory diagram showing a card format, a table format, and a tree format as display formats on a display device.

FIG. 3 is a data structure table showing a data structure of database information.

FIG. 4 is a flowchart of a database information display process of a database information display device in a database system.

FIG. 5 is a flowchart of a database information display process of the database information display device in the database system.

FIG. 6 is a block diagram showing a flow of processing of database information of a database information display device in the database system.

FIG. 7 is a flowchart showing a process when adding database information to a database.

FIG. 8 is a flowchart showing a process when deleting database information from a database.

FIG. 9 is a flowchart showing processing when copying / moving database information in database information.

FIG. 10A is a view showing a display screen 3 of the display device 20;
It is a flowchart showing the details of the link processing of the card format, table format and tree format as the display format of the type,
(B) is a block diagram showing a processing structure of the cooperation processing.

FIG. 11 is an explanatory diagram showing a display mode on a display screen of a display device.

FIG. 12 is an explanatory diagram showing a display mode on a display screen of a display device.

FIG. 13 is an explanatory diagram showing a display mode on a display screen of a display device.

FIG. 14 is an explanatory diagram showing a display mode on a display screen of a display device.

FIG. 15 is an explanatory diagram showing a display mode on a display screen of a display device.

FIG. 16 is an explanatory diagram illustrating a display mode on a display screen of a display device.

FIG. 17 is an explanatory diagram showing a display mode on a display screen of a display device.

FIG. 18 is an explanatory diagram illustrating a display mode on a display screen of a display device.

FIG. 19 is an explanatory diagram illustrating a display mode on a display screen of a display device.

FIG. 20 is an explanatory diagram showing a display mode on a display screen of a display device.

FIG. 21 is an explanatory diagram illustrating a display mode on a display screen of a display device.

FIG. 22 is an explanatory diagram showing a display mode on a display screen of a display device.

[Explanation of symbols]

 Reference Signs List 10 CPU 12 ROM 14 RAM 16 Keyboard 18 Mouse 20 Display device 22 Magnetic disk

Claims (1)

(57) [Claims] 1. A database information display device in a database system for displaying database information constituting a database, comprising: at least one or more hierarchy information and line number information indicating a line in a hierarchy indicated by the hierarchy information. Storage means for storing a database composed of a plurality of pieces of database information, respectively; and specifying the database information constituting the database stored in the storage means by a card format, the hierarchy information, and the line number information. Display means capable of displaying in a table format and a tree format display format in accordance with the arrangement order to be performed; an operator for performing a desired instruction for the display format and the database information displayed on the display device; Any displayed on the display means by an operator When a desired instruction operation is performed by selecting a display format, the display in the display format selected by the operator is changed according to the operation, and the storage is performed according to the desired instruction operation. Updating the storage contents of the means, further detecting a corresponding location in a display format other than the display format selected by the operator from the hierarchical information and the line number information, and changing the detected location according to the operation A database information display device in a database system having change control means.