JP2003256856A - Graph display method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically generate and display a graph by improving analyzing efficiency, and realizing the assignment of an attribute set suitable for analysis when displaying a graph. <P>SOLUTION: A graph display device is provided with: an input functioning part 5 for acquiring necessary information from a data base 2, a correspondence chart 3, and an application frequency chart 4; an attribute set assignment functioning part 6 for assigning an attribute set to an attribute data area; an application frequency update functioning part 7 for updating the application frequency of each attribute set classification in each attribute data area after displaying a graph; and an output functioning part 8 for outputting a graph. Then, on the basis of information acquired by abstracting the attribute set as the classification of the attribute set in accordance with the object of analysis, the classification of the attribute set assigned to the attribute data area defined for each graph classification each time a graph is displayed is stored in the application frequency chart, and when a graph is newly displayed, the attribute set belonging to the attribute set classification whose application frequency is high is preferentially assigned to the attribute data area of the graph. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph display method, and more particularly, to a graph capable of displaying a graph by automatically assigning an attribute set to be displayed in the graph to an attribute data area in the graph. Regarding display method.

[0002]

2. Description of the Related Art Generally, the conventional graphic display is
In order to represent the data stored in the database in a graph, specify the graph type, assign the attribute set to each attribute data area defined in the graph, and set the various drawing attributes of the graph such as color and font. It is necessary to do. Here, the attribute set is a collection of attributes which are actual analysis elements for the purpose of classification of analysis data, and this attribute set is assigned to the attribute data area (classification item axis or series) of the graph. As a result, the graph display data is determined. Basically, these operations are performed by the operator, but there is also known a technology that allows the operator to save the trouble of operation by using a default value prepared in advance.

[0003]

The assignment of the attribute set to the attribute data area at the time of displaying the graph is characterized by the type of the graph or the operator's preference. Nevertheless, in the above-described conventional technique, the operator is required to perform the assignment of the attribute set to the attribute data area each time a graph is created, and therefore the operator has to perform a lot of time-consuming and troublesome work. There is a problem. Further, there is a technique for preparing a default attribute set assignment state to save the operator's labor, but with this conventional technique, it is difficult to realize the assignment of the attribute set for displaying a graph suitable for the purpose of analysis. There is a problem.

An object of the present invention is to solve the above-mentioned problems of the prior art and to decide the allocation of the attribute set to the attribute data area based on the allocation information of the attribute set of the graph displayed in the past. An object of the present invention is to provide a graph display method that enables the assignment of attribute sets to be omitted by the operator to improve the analysis efficiency and to assign the attribute sets suitable for analysis.

[0005]

According to the present invention, the above-mentioned object is to allocate to an attribute data area for each graph type created and accumulated in advance in a graph creating method for displaying data specified by an operator as a graph. From the application frequency table of the attribute set type, an attribute set type having a high application frequency to each attribute data area for each graph type is acquired, and using the correspondence table between the attribute set and the attribute set type, the acquired attribute having a high application frequency is acquired. This is achieved by assigning the attribute set belonging to the set type to the attribute data area in the corresponding graph. In the above, the application frequency table of the attribute set type is
When the graph display is executed, it is created for each attribute data area defined for each graph type that can exist based on the adoption frequency of the attribute set type assigned to the attribute data area.

[0006]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of a graph display method according to the present invention will be described in detail below with reference to the drawings.

FIG. 1 is a block diagram showing a configuration example of a graph display device for displaying a graph according to an embodiment of the present invention, and FIG. 2 shows an example of data stored in a database and a list of attribute sets created from this data. It is a figure explaining an example. In FIG. 1, 1 is a data processing function unit, 2 is a database, 3 is a correspondence table, 4 is an application frequency table, 5 is an input function unit, 6 is an attribute set allocation function unit, 7 is an application frequency update function unit, and 8 is It is an output function unit.

As shown in FIG. 1, a graph display device according to an embodiment of the present invention holds a data processing function unit 1 and data necessary for generating a graph connected to the data processing function unit 1. A database 2, a correspondence table 3 for associating an attribute set that is an actual analysis element with an attribute set type defined as an abstraction of the attribute set, and an attribute set type assigned to each attribute data area for each graph type. It is composed of the application frequency table 4 to be stored. Then, the data processing function unit 1 includes an input function unit 5 that acquires necessary information from the database 2, the correspondence table 3 and the application frequency table 4, and an attribute set assignment function unit 6 that assigns an attribute set to the attribute data area. An application frequency updating function unit 7 for updating the application frequency of the attribute set type in each attribute data area after displaying the graph, and an output function unit 8 for outputting the graph. Although not shown, the input function unit 5 is connected to an input device such as a keyboard and a mouse for inputting by which an operator operates, and the output function unit 8 is connected to a display device. Has been done.

Although the embodiment of the present invention extracts the data necessary for generating the graph from the database 2, the present invention extracts the data necessary for generating the graph from other than the database. May be.
Further, the correspondence table 3 and the application frequency table 4 may be replaced with a form having equivalent information.

An example of data stored in the database 2 is shown in FIG. 2 (a), which holds a column name 25 and a plurality of records 26. In the case of the example shown, the column names are
"Year", "Half year" indicating either the first half or the second half, "Store name", "Product name", "Area" indicating the district name, "Gender" of the product purchaser described in the product name column, "Evaluation",
"Sales".

An example of the attribute set list created from the data stored in the database 2 is shown in FIG.
The attribute set list holds the attribute set name 9. The attribute set is a collection of attributes that are actual analysis elements, for the purpose of classifying analysis data.
The way of grouping and the attribute set name can be arbitrarily determined. In the example shown in FIG. 2B, the attribute set is created from the data stored in the database 2 as shown in FIG. A record value corresponding to the column selected in the data on the database is adopted as the attribute, and the attribute set is represented by a set of columns. For example,
The attribute set “period” is collected in the column “year” and the column “half-year”, and is a set of attributes that can be created by combining the record values in each column. That is, it means that the first half of 2012 and the second half of 2012 are attributes.

In the illustrated example, the other attribute sets are associated with one column without grouping the columns. Since any name can be added to the attribute set name, the attribute set name in the column “evaluation” is used as the “analysis numerical item”. By associating these attribute sets with the attribute data areas of the graph, the attributes are displayed in the associated attribute data areas. At that time, any attribute in the attribute set may be selected as a display target.

FIG. 3 is a view for explaining an example in which a bar graph is displayed using the store attribute set and the product attribute set. Figure 3
In the example shown in (1), branch A and branch B in the set shown as the store attribute set 10 and food A, food B, and clothing A in the set shown as the product attribute set 11 are displayed, and the store attribute set is displayed in a graph. It is an example showing a display state of the bar graph 12 when a product attribute set is assigned to a series of graphs on a classification item axis. Here, the data value of the bar graph 12 is acquired from the database 2 based on the attribute information to be displayed, and is the sales amount here.

FIG. 4 is a diagram showing an example of a correspondence table necessary for associating the character string of the attribute set name 9 described with reference to FIG. 2B with the attribute set type. This correspondence table is composed of the attribute set type 13 and the attribute set name 14 belonging to it. The attribute set type 13 is an attribute set abstracted and defined in advance. Attribute set is attribute set type 1
By abstracting as 3, it is possible to extract not the attribute set itself, but the nature of the target attribute set. By using the attribute set type and associating the attribute data area with the attribute set, Attribute set assignment that incorporates the properties of sets can be realized. In the example shown in FIG. 4, the year attribute set and the period attribute set play the same role in the transition of the time axis in the case of analyzing the year attribute set and the period attribute set, and the same attribute data It is assumed that allocation to the area will be performed.

FIG. 5 is a view for explaining an example of an application frequency table of assigned attribute set types to the attribute data area for each graph type. In the example shown in FIG. 5, the graph type 15 and the attribute data area 16, the attribute set type 17 assigned to the attribute data area 16 and the application frequency 18 are shown. The graph type 15 corresponds to all graph types that can be created by the graph creating device. Further, each of the areas A to D of the attribute data area 16 is defined individually for each graph type,
The position and shape differ depending on the form of the graph. The attribute set type 17 corresponds to the element of the attribute set type 13 described with reference to FIG. 4, and is a unit for counting the application frequency. The application frequency 18 is the number of times the attribute set type 17 is assigned to the corresponding attribute data area when the graph is created.

FIG. 6 is a diagram for explaining an example of the display position of the attribute data area in the bar graph. This example is graph 1
9 is an example in which there are two attribute data areas, and each attribute data area is the classification item axis 20 and the series 21 of the graph, respectively.

FIG. 7 shows an attribute set belonging to the attribute set type having the highest frequency of application to each attribute data region belonging to the attribute set list of FIG. 2 with respect to the attribute data region defined by the bar graph 19 described with reference to FIG. It is a figure explaining the example which performed the allocation and displayed the bar graph. In this figure, in order to acquire the attribute set belonging to the attribute set type having the highest application frequency, the correspondence table described with reference to FIG. 4 and the application frequency table described with reference to FIG. 5 are used. In the area A shown in FIG. 6, it can be seen from the application frequency table shown in FIG. 5 that the attribute set type “place” is frequently used, and the attribute of “area” in the attribute set list 9 shown in FIG. The set is assigned to the item data 23 on the horizontal axis. Similarly, in the area B shown in FIG. 6, it is found that the attribute set type “time series” is frequently used, and the attribute set “period” in the attribute set list 9 shown in FIG. Assigned to data 24.

FIG. 8 is a flow chart for explaining the processing operation executed by the attribute set allocation function unit 6 in the graph display device shown in FIG. 1. Next, this will be described. In this processing, the attribute set list shown in FIG. 2B, the correspondence table shown in FIG. 4 and the application frequency table shown in FIG. 5 are used. Prior to the start of the processing operation described here, the operator inputs the range of data to be graphed in the database 2 from the input device and, if necessary, specifies the type of graph to be created.

(1) First, the leading attribute set name is extracted from the attribute set list shown in FIG. 2B, and then the attribute set type corresponding to the attribute set name is acquired using the correspondence table shown in FIG. (Steps 100 and 101).

(2) Assignment to the attribute data area for each graph type shown in FIG. 5 The first attribute data area defined in the application frequency table of the attribute set type, in this case, area A is acquired (step 102).

(3) The attribute set type having the highest application frequency for the attribute data area acquired in the process of step 102,
It is determined whether or not the attribute set type acquired in the process of step 101 matches. If they match, the attribute set acquired in step 101 is assigned to the attribute data area acquired in the process of step 102 (steps 103, 10).
4).

(4) After that, it is determined whether or not the next attribute set name can be extracted from the attribute set list shown in FIG. 2B. If the next attribute set name cannot be extracted, the process is terminated and the attribute can be extracted. In this case, the next attribute set name is extracted and the process returns to step 101 to determine whether the attribute set type is the most frequently assigned attribute set type of each attribute data area. Repeat for all set attributes in the list (steps 105, 10)
6).

(5) When it is determined in step 103 that the attribute set type having the highest application frequency for the attribute data area obtained in the process of step 102 does not match the attribute set type obtained in the process of step 101 Then, it is determined whether or not the next attribute data area defined in the application frequency table of the assigned attribute set type to the attribute data area for each graph type shown in FIG. 5 can be acquired (step 107).

(6) If it is determined in step 107 that the next attribute data area can be acquired, the next attribute data area defined in the application frequency table is acquired, and the process returns to step 103. To continue the processing, and if the next attribute data area cannot be acquired, the processing proceeds from step 105 to continue the processing (step 1
08).

With the above-described processing, a graph having an optimum shape is created and displayed for the data in the database 2 designated by the operator. The operator looks at this displayed graph and, if it is convincing, decides to adopt the created graph. When the operator views the displayed graph and requests to change the graph type or the attribute set type assigned to the attribute data area, he / she operates the operation buttons and the like provided in the display screen with the mouse. Can be changed.

FIG. 9 is a flow chart for explaining the processing operation for updating the application frequency table connected to the data processing function section. Next, regarding this, the correspondence table shown in FIG. 4 and FIG.
The application frequency table shown in FIG. This process
This is a process of updating the application frequency table 4 after the attribute set assignment function unit 6 in the data processing function unit shown in FIG. 1 has performed the attribute set assignment, and the graph displayed in the process of FIG. 8 has been approved by the operator. Sometimes executed.

(1) First, a graph in which the leading attribute data area defined in the displayed graph type is extracted from the application frequency table shown in FIG. 5 and the attribute set name assigned to the extracted attribute data area is displayed (Steps 109 and 110).

(2) Next, using the correspondence table shown in FIG. 4, the attribute set type corresponding to the acquired attribute set name is acquired,
1 is added to the application frequency of the attribute set type of the extracted attribute data area (steps 111 and 112).

(3) It is judged from the application frequency table shown in FIG. 5 whether or not the next attribute data area defined in the displayed graph type can be fetched. Step 1
Returning to the processing from step 10, the processing is repeatedly executed for all the attribute data areas defined in the graph type displayed from the application frequency table shown in FIG. 5, and when the processing is executed for all the attribute data areas, the application frequency table The update process ends (steps 113 and 114).

Each processing according to the above-described embodiment of the present invention can be configured as a processing program, and the processing program is HD, DAT, FD, MO, DVD-.
It can be provided by being stored in a recording medium such as a ROM or a CD-ROM.

According to the above-described embodiment of the present invention, the attribute set allocation to the attribute data area can be determined based on the attribute set allocation information of the graph displayed in the past, and the attribute set allocation designation from the operator can be designated. Can be omitted and the graph can be displayed, and the graph can be displayed efficiently. Further, according to the embodiment of the present invention, it is possible to realize attribute set assignment suitable for analysis and improve analysis efficiency.

[0032]

As described above, according to the present invention, it is possible to improve the analysis efficiency in the graph display and to allocate the attribute set suitable for the analysis.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration example of a graph display device for displaying a graph according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating an example of data stored in a database and an example of an attribute set list created from this data.

FIG. 3 is a diagram illustrating an example in which a bar graph is displayed using a store attribute set and a product attribute set.

FIG. 4 is a diagram showing an example of a correspondence table necessary for associating a character string of an attribute set name described with reference to FIG. 2B and an attribute set type.

FIG. 5 is a diagram illustrating an example of an application frequency table of assigned attribute set types to an attribute data area for each graph type.

FIG. 6 is a diagram illustrating an example of display positions of attribute data areas in a bar graph.

7 is a bar graph in which an attribute set belonging to an attribute set type having the highest application frequency to each attribute data region belonging to the attribute set list is assigned to the attribute data region defined in the bar graph described with reference to FIG. It is a figure explaining the example which displayed.

FIG. 8 is a flowchart illustrating a processing operation executed by an attribute set allocation function unit.

FIG. 9 is a flowchart illustrating a processing operation for updating an application frequency table.

[Explanation of symbols]

1 Data processing function section 2 database 3 correspondence table 4 Application frequency table 5 Input function section 6 Attribute set allocation function unit 7 Application frequency update function section 8 Output function section

Claims (3)

[Claims] 1. A graph creating method for displaying data specified by an operator as a graph, wherein each graph type is selected from an application frequency table of an assigned attribute set type assigned to an attribute data area for each graph type created and stored in advance. An attribute set type having a high frequency of application to the attribute data area is acquired, and using the correspondence table of the attribute set and the attribute set type, the attribute set belonging to the acquired attribute set type having a high frequency of application is displayed in the corresponding graph. Graph display method characterized by allocating to the attribute data area of. 2. The application frequency table of the attribute set type is such that, when a graph is displayed, the attribute set type assigned to the attribute data area for each attribute data area defined for each graph type can be used as the adoption frequency. The graph display method according to claim 1, wherein the graph display method is created by accumulating. 3. A graph display processing program for displaying data specified by an operator as a graph, wherein an application frequency table of allocation attribute set types assigned to an attribute data area for each graph type created and stored in advance. Belongs to the acquired attribute set type with high application frequency by using a processing program for acquiring the attribute set type with high application frequency for each graph type for each graph type and the correspondence table of the attribute set and the attribute set type A processing program for allocating the attribute set to the attribute data area in the corresponding graph, and the attribute set type assigned to the attribute data area for each attribute data area defined for each graph type when a graph is displayed And a processing program for updating the application frequency table of the attribute set type by accumulating as an adoption frequency. Rough display processing program.