JP2000099532A - Data display system and storage medium storing program realizing the system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To display information showing an attribute and a feature on an item before a user selects the item, to reduce that the user selects the unneces sary item and to display the selection history of the user in a simpler display form as much as possible. SOLUTION: The respective items of a screen 101 displaying the items by tree structure are displayed by the item of a 'processing place' 102 and the items constituting the 'processing place', for example. The 'processing place' is composed of a 'main pump', a 'crane', sedimentation equipment' and a 'gate'. Rectangles just after the respective items show selection history by a user. As a color painting out the rectangles is darker, lapse time from previous selection is shorter. The item without the rectangle is not selected by the user at all or is not selected for a prescribed period after previous selection. A star mark given to the respective items are added when a system is matched with the condition of 'fault history exists'. A cloud mark 106 is added when the system is matched with the different condition the condition of 'work instruction information exists' for example.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data display system, and more particularly, to a data display system for graphically displaying a relationship between information in a database.

[0002]

2. Description of the Related Art Conventionally, in order to support information retrieval of a database, information of a system such as a keyword thesaurus and information classification items is displayed on a display in a tree structure. I have.

The above-described method is for the user to select a target from the displayed information and perform a search. In this case, it is rare that one item is selected and the search is terminated. Usually, you have to select a number of items to get to the information you are looking for.

[0004] As a conventional technique relating to the above-mentioned information retrieval support, for example, a technique described in Japanese Patent Application Laid-Open No. Hei 6-230914 is known. This conventional technique accumulates history information in which a user selects an item, and changes the display mode (display color, font, etc.) according to the number of times the item is selected as the history information.

[0005]

The prior art described above is
Since the screen does not display the conditions that help the user select the item, such as the attribute of the item originally provided in the item or the related information between the item and another item, the user is required to Unnecessary items may be selected before reaching the item (2), and there is a problem that it is not possible to reduce the user's labor.

Further, the above-mentioned prior art has a problem that even if the display mode of the item selected by the user is changed, if the type of display mode is too large, it may be difficult for the user to understand. are doing.

SUMMARY OF THE INVENTION An object of the present invention is to solve the above-mentioned problems of the prior art, and to display information representing attributes, characteristics, and the like of an item before the user selects the item, thereby enabling the user to make unnecessary items. It is an object of the present invention to provide a data display method which can reduce the selection of the data.

Another object of the present invention is to provide a data display method which enables a user's selection history to be specified in a display form as simple as possible.

[0009]

According to the present invention, there is provided a data display method for displaying the relationship between information registered in a database in a diagram, and a search condition for storing a database search condition set by a user. A storage unit,
A history management unit that manages the history of the information search of the user; and a display unit that searches the database using the database search conditions set by the user and displays a relationship between the resulting information. This is achieved by having an area for displaying the status of the match for the search condition set by the user corresponding to the character string.

[0010] Further, the object is to display the relationship between the information of the search results in a tree structure, and to display in the area for displaying the status of the match with a display form corresponding to the search condition and its display form. This is achieved by being the color given to the display form.

Further, the object is to provide an area corresponding to the character string of the displayed information, the area indicating an access status according to an elapsed time since the user last accessed the corresponding information in the database. This is achieved by displaying a display form with a display color that changes according to the elapsed time.

According to the present invention, when displaying information in a tree structure by adding and displaying information for identifying a search result based on a condition set in advance by a user before displaying the information in a tree structure, In addition, the user can easily select necessary items, and for each displayed information, a display form in which the color depth is changed according to the elapsed time from the last time selected by the user is added. So that it is possible to know the status of past access to the information.

[0013]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an embodiment of a data display system according to the present invention will be described in detail with reference to the drawings.

FIG. 1 is a diagram showing a screen display example displayed by the data display method according to one embodiment of the present invention.
An example of this screen display will be described.

In FIG. 1, reference numeral 101 denotes a screen for displaying items in a tree structure. Each item displayed in the tree structure constitutes, for example, a title of an item "processing site" 102 and a "processing site". Items and are displayed. In the example shown in FIG. 1, the “treatment plant” includes a “main pump”, a “crane”, a “sand set-up facility”, and a “gate”, and the “crane” includes a “container lifting crane”, This indicates that the system is composed of a "main pump lifting crane" and a "sand lift pump lifting crane". further,
"Sedimentation equipment" includes submersible sand pumps and cyclones
It is shown that it is comprised from.

The user can retrieve detailed information on the displayed item by selecting the item with a mouse or the like from the DB. That is, the display of the tree structure as shown in FIG. 1 can be used to support the DB search.

In the above description, the rectangle immediately after the title of each item indicates the selection history by the user. And
It is assumed that the darker the color that fills this rectangle, the shorter the elapsed time from the previous selection. For example, by comparing the rectangle 103, the rectangle 104, and the rectangle 107, the item “treatment plant” is the item most recently selected by the user, and then the item “crane” and the item “crane for lifting the sand pump”. Indicates that the elapsed time since the user last selected is long. An item without a rectangle indicates that the item has not been selected by the user at all, or has not been selected for a certain period of time since the previous selection.

Further, the star shape given after each item is added when, for example, a condition such as “there is a failure history” is satisfied.
Reference numeral 5 indicates that "failure history information exists" for "crane". In addition, the cloud shape 106 given after each item indicates another condition, for example, “there is work instruction information”.
It is added when the condition is met,
The cloud 106 in the illustrated example indicates that “work instruction information exists” for “crane”.

FIG. 2 is a block diagram showing a system configuration of a data display system according to an embodiment of the present invention, FIG. 3 is a diagram for explaining a configuration example of a display condition management table in FIG. 2, and FIG. FIG. 5 illustrates a configuration example of a management table.
FIG. 3 is a view for explaining a configuration example of a related information management table in FIG. 2;
6 illustrates a configuration example of the user access management table in FIG. 2, FIG. 7 illustrates a configuration example of the period display color correspondence table in FIG. 2, and FIG. 8 illustrates information for displaying items. is there. 2, reference numeral 201 denotes a keyboard; 202, a display control unit; 203, an input control unit; 204, a database (DB) access unit; 205, a tree structure display unit;
Is a DB, 208 is a display condition management table, 209 is an item information management table, 210 is a related information management table, 211 is a user access management table, 212 is a period display color correspondence table, and 213 is a display.

As shown in FIG. 2, a data display system according to an embodiment of the present invention includes a keyboard 201.
, A display 213, a DB 207, and a display control unit 202 that controls display according to the present invention. The display control unit 202 includes an input control unit 203 that receives information from the keyboard 201 and an input control unit 203
And a tree structure display unit 205 for displaying a tree structure on the display 213. In the embodiment of the present invention configured as described above, the input control unit 203 controls the user's instruction content from the keyboard 201, and in the case of an instruction to display the database storage content in a tree structure, the input control unit 203 An instruction to display the structure is passed to the DB access unit 204. DB access unit 2
04 searches the DB 207 according to the user's instruction, and passes the search result to the tree structure display unit 205. The tree structure display unit 205 displays the search results (display form,
Display color, etc.), and the items are displayed on the display 213 in a tree structure.

The DB 207 stores a D which is set in advance by the user.
Display condition management table 208 for storing conditions such as B search, and item information management table 20 for storing titles, attribute values, and the like of each item
9. A related information management table 210 for storing related information between items and information related to the items, a user access management table 211 for storing last access date and time information for each item and user, A period display color correspondence table 212 for performing correspondence with colors to be displayed according to the period is stored.

As shown in FIG. 3, the display condition management table 208 displays a condition column 301 for storing DB search conditions set by the user in advance, and an item that satisfies the condition column 301. And a display color string 303 for setting a color for displaying the display form. For example, line 304
In the case where “failure history” is set in the related type column of the related information management table as a condition, that is, if “failure history” is present, the star is displayed in red and added after the item title. Is set.

As shown in FIG. 4, the item information management table 209 includes a self-item identifier column 401 for storing item identification information of a corresponding item, and a parent item for storing item identification information of a higher (parent) item of the corresponding item. An identifier column 402, a job type column 403 for identifying a process to be processed, and an item title column 40 for storing an item title used when displaying the corresponding item on the screen.
4 and a display sequence 405 for storing display sequence information for the parent item.

In the example shown in FIG.
Is a row storing information on the item “processing plant” 102 shown in FIG. Since “processing place” has no parent item in the highest rank, ie, the item “processing place”, “NULL” is stored in the column value of the parent item identifier column 402. A row 407 is a row storing information of the item “crane” illustrated in FIG. Since the parent item of “crane” is “processing plant”, the same value as the column value of the own item identifier column 401 of “processing plant” in row 406 is stored in the parent item identifier column 402 of row 407. . As described with reference to FIG. 1, “crane” is the second item after “main pump” among items having the item “treatment plant” as a parent. Order "2"
Is stored.

The job type column 403 in the item information management table 209 is provided so that the tree structure displayed for each operator and each job can be changed. For example, when acquiring item information, it is possible to display a tree structure consisting of only the target business by using the business type column value.

The related information management table 210 shown in FIG. 5 is a table for managing a file storing information related to an item and the association with the item. As shown in FIG. 5, the related information management table 210 stores the related item identifier information (the value of the own item identifier column 401 of the item information management table 209 that specifies the related item). Row 50
1. Related type column 502 for storing related type information, file name column 503 for storing related file names, and registered date and time column 50 for storing date and time information when the related is registered
4 and a registrant column 50 storing the names of registrants related to the registrant
5 and the like.

In the example shown in FIG.
Stores “1002” as the value of the related-source identifier column 501. From this, it is found from the item information management table 209 shown in FIG. It is understood that the file "C: \ failure history \ crane failure 1.doc" which describes the failure history is associated with "."

The user access management table 211 shown in FIG.
Is a table that manages, for each logged-in user and an item accessed by the user (it is not considered to have been accessed only when the title of the item is displayed), information of the last access. The user access management table 211 is
As shown in FIG. 6, a user name column 601 for storing the name of the user who has made access, an item identifier column 602 for specifying the accessed item, and a last time for storing date and time information of the last access. Access date and time information column 60
3 and the like.

As shown in FIG. 7, the period display color correspondence table 212 stores a period column 701 since the last access in which values of the period since the previous access are stored, and a display color corresponding thereto. It is composed of stored display color strings 702 and the like. For example, the access status of the item within one week since the last access is displayed in black on the line 703, and the access status of the item within the range of three months to three years after the last access is displayed on the line 704. The access status of the item in the case is displayed in white. Also row 7
05 indicates that the access status of an item exceeding three years since the last access is not displayed.

The item display information shown in FIG. 8 is created by collecting information on display target items from the item condition management table 209, the related information management table 210, and the user access management table 211. Yes. The display item information is information created by the DB access unit 204 accessing the DB 207 and passed to the tree structure display unit 205. The tree structure display unit 205 uses the display item information to display, on the display 213, the title of the item, the access status, and the additional display object corresponding to the condition defined in the display condition management table 208 in a tree structure. As shown in FIG. 8, the display item information includes a self item identifier 801 for specifying an item, a parent item identifier 802 for specifying a parent item, a display order 803, an item title 804 to be displayed, and last access date / time information 80.
5. Association type information array 806 storing association types in an array
Etc.

FIG. 9 is a flowchart for explaining the processing operation of the DB access unit 204. Hereinafter, referring to the flow shown in FIG. 9, the DB access unit 204 of the embodiment of the present invention configured as described above will be described. The processing operation will be described.

(1) The DB access unit 204 first obtains the name of the user who has logged in, and then obtains the job type of the job to be executed. Here, the task type is selected in order to realize different display hierarchies when displaying with different display item contents or tree structures depending on the task (steps 901 and 902).

(2) Next, it is determined whether the process to be executed is to access an item or to display a tree structure (step 903).

(3) If the access process to the item is selected in step 903, that is, if the item in the display as described with reference to FIG. 1 is selected, the login user sets the access target table to In order to detect whether or not the user has accessed before, the user access management table 211 is searched to determine whether a row corresponding to the user access management table 211 exists, and the search to the user access management table 211 is performed. The result is determined (steps 914 and 915).

(3) If it is determined in step 915 that the corresponding row does not exist in the user access management table,
It is determined that the login user accesses the item to be accessed for the first time, and a new row is added to the user access table (step 916).

(4) If it is determined in step 915 that the corresponding row exists in the user access management table, the column value of the previous access date / time information column 603 of the corresponding row is changed to the current date / time (step 917). .

(5) After the update processing of the user access management table 211 by the processing of step 916 or 917 is completed, the item access processing is actually performed (step 918).

(6) In step 903, when the process of displaying the items in the tree structure is selected, that is, when the user instructs to perform the display as shown in FIG. 1,
First, the first item at the start of display when displaying in a tree structure is acquired, and then, for each item to be displayed following the parent-child relationship from the first item, each column value of the item information management table 209 is acquired (step 904). , 905).

(7) Display item information as shown in FIG. 8 is created for the above-mentioned display items. This processing is performed in detail by the processing of steps 907 to 912 described below (step 906).

(8) First, the related source identifier column 501 of the related information management table 210 is searched by the item identifier of the display item to be currently processed, and it is determined whether or not a row corresponding to the related information management table 210 exists. Judge (steps 907, 90
8).

(9) If it is determined in step 908 that the corresponding row exists in the related information management table 210, the column value of the related type column 502 is obtained for all the rows of the related information management table 210 that satisfy the condition. (Step 909).

(10) After the processing of step 909, or
If it is determined in step 908 that the corresponding row does not exist in the related information management table 210, the user access management table 211 is searched using the user name column 601 and the item identifier column 602 as keys (step 910). .

(11) As a result of the search in step 910, it is determined whether or not a corresponding row exists in the user access management table 211, and if a corresponding row exists, the last access date / time information The value of 603 is obtained.
If the corresponding row exists, nothing is performed (steps 911 and 912).

(12) The display item information as shown in FIG. 8 created by the processing of steps 907 to 912 is
The processing is passed to the tree structure display processing unit 205 and the processing ends (step 913).

FIG. 10 is a flowchart for explaining the processing operation of the tree structure display processing unit 205. Hereinafter, referring to the flow shown in FIG. 10, the tree structure display processing according to the embodiment of the present invention will be described. The processing operation of the processing unit 205 will be described.

(1) First, the tree structure display processing unit 205
The timing at which the self-processing unit 205 is used is determined, and the process to be executed is divided into a process at the time of system startup, a process when a change occurs in the display condition management table 208, and a tree structure display process (step A01). ).

(2) In step A01, if it is time to perform processing at the time of system startup or processing when a change has occurred in the display condition management table 208, all rows of the display condition management table 208 are acquired, These are developed on the memory, and all the rows of the period display color correspondence table 212 are acquired, and these are developed on the memory. These processes are performed in order to suppress the DB access to these tables by preliminarily developing the display condition management table 208 and the period display color correspondence table 212 on the memory, which are relatively small changes. (Steps A05 and A06).

(2) In step A01, if it is time to display an item in a tree structure, the display item information as shown in FIG. The first key and the display order are sorted as the second key (step A07).

(3) Next, it is determined whether or not the display item information that has been sorted in the process of step A07 has been accessed before. Obtain the elapsed time from access to the present (steps A08, A0
9).

(4) The access status to be displayed is determined based on the period display color correspondence table 212, and is added after the item title to be displayed (step A10).

(5) After the processing in step A10, or
If it is determined in step A08 that there is no previously accessed item, it is next determined whether or not display conditions are set. If display conditions are set, whether or not the display conditions are met is determined. (Step A11, A1
2).

(6) If it is determined in step A12 that the display condition is satisfied, the contents of the display form 302 are added to the item title with the corresponding display color 303 (step A1).
3).

(7) After the processing in step A13, or
If it is determined in step A12 that the display condition does not match, the process proceeds to the next display condition, and the processing from step A11 is repeated (step A14).

(8) If it is determined in step A11 that the display condition is not set, that is, after the processing for all the display conditions is completed, it is determined whether or not the next display item exists, and the next display item is determined. If exists, go to the next item,
Returning to step A08, the same processing is repeated for the next display item (steps A15 and A16).

(9) When it is determined in step A15 that the next display item does not exist, that is, when the addition of the item titles to be displayed for all the display items is completed,
Using the corrected display item information as shown in FIG.
Display in a tree structure for each display item (step A
17).

According to the above-described embodiment of the present invention, before the user selects an item, information indicating attributes, characteristics, and the like of the item is displayed. Therefore, the user can immediately change the information element when displaying the data. It is possible to determine whether or not the user's setting conditions are satisfied, and to perform a search by narrowing down target items, thereby suppressing access to unnecessary items. Also, according to the embodiment of the present invention described above,
By letting the user select the business type,
It is also possible to define a tree structure for business operations.

Further, according to the above-described embodiment of the present invention, the color indicating the access status can be sequentially reduced as the storage of the items accessed by the user becomes weaker. Can be intuitively recognized.

In the above-described embodiment of the present invention, the program for performing the DB search in the DB access unit and the display control program in the tree structure display unit are FD, CD
The data can be stored in a recording medium such as a ROM or a DVD, thereby realizing the data display method according to the embodiment of the present invention.

[0059]

As described above, according to the present invention, the operator can narrow down items to be accessed at the stage of displaying the items on the screen, so that the target items can be easily selected and unnecessary items can be selected. Access to items can be suppressed.

Further, according to the present invention, a user can intuitively recognize when a previously accessed item has been accessed and can prevent a user from accessing an unnecessary item. it can.

[Brief description of the drawings]

FIG. 1 is a diagram showing a screen display example displayed by a data display method according to an embodiment of the present invention.

FIG. 2 is a block diagram showing a system configuration of a data display method according to an embodiment of the present invention.

FIG. 3 is a diagram illustrating a configuration example of a display condition management table in FIG. 2;

FIG. 4 is a diagram illustrating a configuration example of an item information management table in FIG. 2;

FIG. 5 is a diagram illustrating a configuration example of a related information management table in FIG. 2;

FIG. 6 is a diagram illustrating a configuration example of a user access management table in FIG. 2;

FIG. 7 is a diagram illustrating a configuration example of a period display color correspondence table in FIG. 2;

FIG. 8 is a diagram illustrating information for displaying items.

FIG. 9 is a flowchart illustrating a processing operation of a DB access unit.

FIG. 10 is a flowchart illustrating a processing operation of a tree structure display processing unit.

[Explanation of symbols]

 201 keyboard 202 display control unit 203 input control unit 204 database (DB) access unit 205 tree structure display unit 207 DB 208 display condition management table 209 item information management table 210 related information management table 211 user access management table 212 period display color correspondence table 213 Display

Claims (5)

[Claims] 1. A data display method for graphically displaying a relationship between information registered in a database, a search condition storage unit storing a database search condition set by a user, and managing a history of information search of the user. A history management unit, and a display unit for searching a database based on the database search conditions set by the user and displaying a relation between information obtained as a result, and setting by the user in accordance with a character string of the displayed information. A data display method having an area for displaying a status of a match with respect to a specified search condition. 2. The data display method according to claim 1, wherein the relationship between the information is displayed in a tree structure. 3. The data display method according to claim 1, wherein the display in the area displaying the matching status is a display form corresponding to a search condition and a color given to the display form. . 4. An area indicating an access status according to an elapsed time since the user last accessed the corresponding information in the database is provided in correspondence with the character string of the displayed information. 4. The data display method according to claim 1, wherein a display form to which a display color that changes in accordance with the display form is displayed. 5. A program for storing a program for searching a database based on database search conditions set by a user and a program for controlling display of mutual information of search results, and executing these programs. A recording medium that realizes the data display method according to any one of the above.