JPH04243493A - Automatic graph drawing system provided with learning function - Google Patents

Abstract

PURPOSE:To reduce input means for producing a graph, to be able to prepare a graph in a short period of time, and to reduce a burden of reproducing a graph. CONSTITUTION:The automatic graph drawing system provided with learning function refers to a column characteristic table 9, retrieval data 8, and preceding drawing information 10 to use the preceding drawing information, and if the preceding drawing information is not available, the system refers to the column characteristic table 9, retrieval data 8, and an intermediate table generating rule 11 to prepare an intermediate table. Further, the above system refers to a drawable graph type deciding rule 12 to determine an identifiable graph type for converting the intermediate table to a graph. Furthermore, the system refers to a drawing priority deciding rule to rearrange drawable graph types in the intermediate table into a priority of graph drawing. In accordance with a priority of graph drawing the intermediate table is converted to a graph and output to an input/output processing means. By the designated graph type desired by the user, a drawing priority discriminating rule is updated, and moreover, drawing information is stored as the preceding drawing information.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a high-speed automatic graph drawing method with a learning function, and more particularly to a method for automatically drawing data retrieved from a database in an information processing system.

0002

[Background Art] Conventional graph automatic drawing methods are systems that graph searched data, and when creating a graph, at least the graph type, number of items, correspondence between graph axes and data columns, etc. are specified in advance. Otherwise, it would not be possible to draw an appropriate graph.

There is also a method that has an automatic drawing function and automatically draws graphs.

0004

[Problems to be Solved by the Invention] When graphing data, in conventional systems, the type of graph to be displayed, the number of items, and the columns corresponding to the axes of the graph must be specified. Therefore, it was necessary to specify the graph type, number of items, etc. many times before arriving at a graph that effectively represents the data. In addition, it was necessary to have knowledge of both data and graphs in order to determine an appropriate graph.

[0005] The purpose of the present invention is to compensate for the above-mentioned drawbacks.
To provide an automatic graph drawing method that does not require specifying detailed information regarding graph drawing, can automatically display appropriate graphs one after another, and has a learning function to update the priority order of types of graphs that can be drawn. It is in.

A further object of the present invention is to provide an automatic graph drawing method that realizes high-speed automatic drawing by reusing previous drawing information, compared to conventional automatic graph drawing methods.

[0007]

[Means for Solving the Problems] The automatic graph drawing method with a learning function of the present invention is an automatic graph drawing method for an information processing system that converts data retrieved from a database into a graph and displays it. an input/output processing means that receives from a user a column characteristic table that describes column characteristics; an intermediate table generation means that creates an intermediate table by referring to a predetermined intermediate table generation rule; Based on the received search data and column characteristic table, if the previous drawing information can be reused, the previous drawing information is automatically used for drawing, and if the previous drawing information cannot be reused, the previous drawing information utilization means calls the intermediate table generation means; Drawable graph type determining means that receives the intermediate table created by the intermediate table generating means, compares it with a predetermined drawable graph type determination rule, and selects all the drawable graph types for the received intermediate table; a drawing priority determining means for determining the drawing priority of the graph type selected by the drawable graph type determining means, using a drawing priority determining rule in which the degree of optimality as a graph is described in advance; Create graph data with the highest priority determined by the determination means, automatically draw a graph using the input/output means, and when the graph is not the one the user wants, input/output the graph the user wants. A graph drawing means that inputs the information from the means, acquires final graph information, and sends it to the priority rule updating means, and adjusts the degree of optimization to the user's performance based on the final graph information received from the graph drawing means. For this purpose, the drawing priority determining rule is updated, and the drawing priority rule updating means is further configured to store the final graph information as the previous drawing information.

[0008]

Embodiments Examples of the present invention will be described with reference to the drawings.

FIG. 1 is a diagram showing the relationship between processing blocks and each table in an embodiment of the present invention.

Referring to FIG. 1, one embodiment of the present invention includes a previous drawing information utilization means 2 that refers to a column characteristic table 9, search data 8, and previous drawing information 10, and uses the previous drawing information 10; Create an intermediate table by referring to the column characteristic table 9, search data 8, and intermediate table generation rule 11. Graph the intermediate table by referring to the intermediate table generation means 3 and the drawable graph type determination rule 12. drawable graph type determination means 4 that determines distinguishable graph types for the drawing, and drawing priority determination that sorts the drawable graph types in the intermediate table in order of priority for graph drawing, with reference to the drawing priority order determination rule 13; means 5, a graph drawing means 6 for converting the intermediate table into a graph according to the priority order and outputting it to the input/output processing means 1; updating the drawing priority order determination rule 13 based on the specification of the graph type desired by the user; The priority rule updating means 7 stores the previous drawing information 10 as the previous drawing information 10.

Here, the column characteristic table 9, the intermediate table generation rule 11, the drawable graph type determination rule 12, and the drawing priority order determination rule 13 are rules and rules created from the database to be used.

Next, the concept and structure of the intermediate table, which is the core of one embodiment of the present invention, and the column characteristics will be explained using FIGS. 2 to 4.

[0013] A virtual information management table (hereinafter referred to as an intermediate table) is a virtual table introduced in order to easily handle complex input data, and is a table obtained by extracting a portion of search data. FIG. 3 shows an example of an intermediate table created from the example search data in FIG. 2. Extract 3 out of 6 columns in Figure 2, extract 3 items ``Tokyo, Kanagawa Prefecture, Osaka Prefecture'' from the ``Head Office Location'' column, and ``63, 62, 61, The intermediate table shown in Figure 3 is created as a result of extracting the five items ``60.59'' and extracting the column for the number of employees as numerical data.

The items in FIG. 2 in which the items in the "Head office location" column in FIG. 2 are written are called column items, and are used to represent the uniqueness of data between records. Similarly, "year"
The item in which the column item is written is called a line item, and is a secondary key used to further classify records distinguished by line item name.

The column of the number of employees, which corresponds to numerical data, is called a survey item, and is a column having data values retrieved by the row item name and column item name control keys.

The definition of the two axes in the graph will now be explained using FIG. 4.

[0017] In Figure 4, the axis along which the items are expanded is called the main axis, as shown in the item ``Fiscal Year'', and the item is expanded along the axis, as shown in the item ``Location of Head Office''. An axis that expands without being aligned with the axis is called an auxiliary axis.

In the intermediate table, row item names correspond to the main axis, and column item names correspond to the auxiliary axis.

Which item in which column of the search data 8 is to be associated with a row item/column item (referred to as axis allocation) is determined with reference to the intermediate table generation rule 11 and the column characteristics described below.

Column characteristics include (1) Judgment criteria for axis assignment of columns to the main axis and auxiliary axis (2)
) Used as a criterion for graph type selection. (1) is referred to when creating an intermediate table, and (2) is referred to when using a rule group, and represents the characteristics and properties expressed by the search data 8. For example, it can be defined as follows.

"Contrast": Having contradictory data values. "Region": Having data values representing a regional area or position.

"Time": Has a data value representing a time series arrangement.

[0023] "Statistical value": has a total value within a certain category or a value for each individual category.

By defining the column characteristics as described above, the characteristics can be applied to each piece of search data as shown below. An example is shown below.

[0025] Gender and deposits and withdrawals: “control” Place of birth and location: “region” Year of enrollment and survey: “time” Population and age: “statistics” In graphs, the “statistics” column usually contains numerical data, Columns with other properties correspond to the main axis and auxiliary axis.

Hereinafter, the intermediate table generation means 3, drawable graph type determination means 4, drawing priority order determination means 5, graph drawing means 6, and priority rule updating means 7 will be explained in order using the search data of FIG. Finally, the previous drawing information utilization means 2 will be explained.

The column characteristic table 9 referred to by the intermediate table generating means 3 is a correspondence table between columns and column characteristics, and consists of column names, column characteristics, and a conversion method from search data to graph data. FIG. 5 is an example of the column characteristic table 9, which is a column characteristic table for which the search data of FIG. 2 is compared.

[0028] Since the data in the "Head office location" column indicates a regional area, the data in the "Region" and "Year" columns represent a chronological arrangement, so the data in the "Time" and "Gender" columns Since they have contradictory values, the data in the columns ``control'' and ``number of employees'' and ``average age'' represent aggregate values within each category, so they are recorded as ``statistical values.''

In the column in which the characteristic "statistical value" is described, the numerical characteristic of the data is also recorded, and in this case, "positive number (value only positive)" corresponds to the numerical characteristic.

[0030] Also, a conversion method from search data to graph data is described, and since "number of employees" is summarized by key, the conversion method called "addition" is used, and "average age" is summarized by key. Since the average is taken, a conversion method called "average" is set.

The intermediate table generation rule 11 describes conditions for narrowing down search data to a range that can be graphed. Here, the range that can be graphed refers to the number of items that can be displayed correctly, as many items may not be displayed or may be difficult to view depending on the specifications of the graph drawing function. range,
Appropriate column characteristics are defined for the axes so that characteristics that have no meaning as a graph are not associated with the axes.

FIG. 6 is an example of the intermediate table generation rule 11. The main axis has 3 to 10 items, the column characteristics is any column, and the auxiliary axis has 1 to 5 items. In the following, it is described that the column characteristic corresponds to an arbitrary column, and the column characteristic is "statistical value" to the survey item, and the number of items corresponds to an arbitrary column.

When creating an intermediate table, a table called a master intermediate table is referred to. The master intermediate table has a field to transfer the column number and column name to be graphed from the search data 8, a field to extract and transfer column characteristics from the column characteristics table 9, and an item name, number of items, and axis assignment. It has an axis name field that can record the axis name. FIG. 8 is an example of a master intermediate table.

The procedure of the intermediate table generation means 3 is shown in FIG.
This will be explained using the flowchart in FIG.

[0035] The intermediate table generation means 3 first creates a master intermediate table in which information necessary for creating an intermediate table is stored. Step 701 to Step 7
19 are the steps for creating this master intermediate table and item name table.

First, enter the column name and column number (hereinafter referred to as
Column name information (referred to as column name information) is received from the previous drawing information utilization means 2 and temporarily stored in the input temporary storage section (step 701), and one piece of input column name information is read from this input temporary storage section (step 702).

[0037] If the column name information is not the end (step 70
3) Record the column name information obtained in step 702 in the column name and column number fields of the master intermediate table (step 704).

The column name field of the column characteristics table 9 is searched using the column name of the column name information obtained in step 702 (step 705), and if there is a record with a matching column name (step 706), the column with that column name is searched. properties, column properties table 9
and transferred to the column characteristic field of the master intermediate table (step 707).

Here, if the column characteristic is "statistical value" (
Step 708), since it is found from the column characteristic table 9 that this is a survey item that cannot be used as a main axis or auxiliary axis, "survey item" is recorded in the axis name field (step 709). Then, the process returns to step 702 without performing the steps 710 to 719 related to acquiring the item name.

If the column characteristic is not "statistical value", a pointer to the item name table is set in the item name field (step 710).

The item number counter is set to an initial value of 0 (step 711), and one data value (corresponding to the item name) of the column indicated by the column number of the column name information obtained in step 702 is obtained from the search data 8 ( step 712).

If the data value is not the end (step 7
13) Search whether the data value obtained in step 712 exists in the item name field of the item name table (
step 714), if not, step 712
The data values obtained in step 715 are recorded in the item name table.

Then, the value of the item name counter is incremented by 1 (step 716). When the data values for one row of search data are completed, the value of the item name counter is recorded in the number of items field of the master intermediate table (step 717).

[0044] Search for which conditions of intermediate table generation rule 11 the number of items and column characteristics on the master intermediate table apply to (step 718), and record the axis names that meet the conditions in the axis name field of the master intermediate table. (step 719). and step 702 to step 7
Step 19 is repeated until the column name information stored in the input temporary storage section is completed to create a master intermediate table.

FIG. 9 is a master intermediate table created assuming that column numbers #2, #3, #4, #5, and #6 of the search data 8 shown in FIG. 2 are columns to be graphed. The pointer in the item name field is a pointer to the item name table, as shown in Figure 9.
is an item name table, and the item names in the “Head Office Location” column are “Tokyo, Kanagawa Prefecture, Osaka Prefecture, Hiroshima Prefecture, and Okinawa Prefecture”, and the item names in the “Fiscal Year” column are “63 ,62,6
1, 60, 59”, and the item name of the separate column is “Male, Female”
There will be two pieces. Here, the corresponding item name table and the intermediate table will be connected by the address value written in the item name field in the master intermediate table, and the axis name field will contain the axis that meets the conditions of intermediate table generation rule 11. The name is written.

Next, an intermediate table is created by referring to the master intermediate table created up to step 719.

From the axis names recorded in the master intermediate table, a column that can be a main axis, a column that can be an auxiliary axis, and a column that can be a survey item are combined so that they do not overlap (step 720). One combination of these three columns is an intermediate table, and the combination (if there are several types of intermediate tables, a number (intermediate table O
N) is added and stored in the intermediate table storage section (step 721).

In the case of the master intermediate table in FIG. 9, the table in FIG.
Eight types of combinations are possible as shown in the figure below. Each of these eight types of combinations is an intermediate table, and is stored in an intermediate table storage unit as shown in FIG.

In the intermediate table storage section of FIG. 12, intermediate table numbers, axis names, and column numbers assigned to the axes are recorded.

FIG. 13 shows a block diagram of the drawable graph type determining means 4. As shown in FIG. 12, the drawable graph type determination means 4 refers to the drawable graph type determination rule 12.

FIG. 14 shows drawable graph type determination rule 1.
In this example, the characteristics of each graph type are represented by column characteristics. Furthermore, the drawable graph type determination rule 12 describes the minimum number of items that can be made into a graph and the number of items that are easy to see when displayed on the screen.

For example, graph No. 1 in FIG. Looking at column 3 of the line graph, the main axis has time characteristics or class characteristics as a condition. This means that line graphs are easy to express temporal trends. Also, graph NO. Looking at column 1 of the pie chart, if the main axis (inner division of the circle) is one item, it will not work as a pie chart, and if it is 9 or more items, it will become difficult to see, so the number of items is between 2 and 8 items. .

The column characteristics and number of items of the columns of the intermediate table are compared with the drawable graph type determination rule 12, and if the condition is met, the graph type is stored in the drawable graph type storage section.

FIG. 15 is an example of a drawable graph type storage section, which stores the results of the drawable graph type determination of the intermediate table shown in FIG. 11. This table has a drawable graph type record field for all graph types for each intermediate table, and the drawable graph types and intermediate table numbers are recorded by writing ○ and × in this record field.

Looking at FIG. 15, intermediate table NO. 2 and the intermediate table, it can be seen that the only graph type that can be drawn is a line graph.

Here, the procedure of the drawable graph type determining means 4 will be explained using the flowchart of FIG. 16.

The drawable graph type determining means 4 first sets the first intermediate table number (step 1501).
, one intermediate table with the intermediate table number is read out from the intermediate table storage section (step 1502). The intermediate table number is transferred to the drawable graph type storage section (step 1504), and the intermediate table number is incremented by 1 (step 1505).

Compare the conditions of drawable graph type determination rule 12 with the axis/column characteristics/number of items of the intermediate table read out in step 1502 (step 1506), and if the rules are met (step 1507), the The matched graph type of the drawable graph type determination rule 12 is recorded in the drawable graph type storage section (marked with ◯ and ×, step 1508).

Steps 1506 to 1508 are repeated until there are no drawable graph type determination rules 12 (step 1509). Once all drawable graph types have been determined for the current intermediate table, the process returns to step 1502 and similar processing is performed for another intermediate table. The process ends after the types of graphs that can be drawn are determined for all intermediate tables.

FIG. 17 shows a block diagram of the drawing priority determining means 5. As shown in the figure, drawing priority determination means 5
refers to drawing priority order determination rule 13.

FIG. 18 is an example of the drawing priority order determination rule 13. The characteristics of the graph are expressed in the same manner as the drawable graph type determination rule 12, and the column characteristics and number of items are further divided into fine sections, and scores are written according to the suitability of the graph.

For example, in the pie chart of FIG. 18, different rules exist depending on the characteristics of the main axis and the characteristics of the survey items. The higher the score, the more meaningful it is when graphed (this rule is often used). Such a set of graph type, axis, characteristic, number of items, and score is called a rule, and each rule is identified by a rule number.

This drawing priority order determination rule 13 is compared with the intermediate table, and the rule number, intermediate table number, and score when the conditions are met are stored in the drawing priority order storage section.

FIG. 19 is an example of a drawing priority storage section.

Looking at FIG. 19, intermediate table No. Intermediate table No. 1 satisfies the four conditions of rule No. 10, 2, 5, and 6, and is intermediate table No. 1. It can be seen that the intermediate table No. 2 had a condition with rule number "8".

Therefore, in this case, assuming that the drawing priority storage section is all as shown in FIG.
With axis assignment 2, rule NO. It turns out that drawing with graph type 8 is the most appropriate.

The procedure of the drawing priority determining means 5 will now be explained using the flowchart shown in FIG. First, an initial value is set in the intermediate table No. (step 1901).
, reads the intermediate table number and the drawable graph type from the drawable graph type storage section (step 1902). The intermediate table number of the intermediate table is transferred to the intermediate table number field of the drawing priority storage section (step 1904).
).

From all the rules of the drawing priority order determination rules 13, only the rules relating to graph types that can draw the current intermediate table are extracted (step 1905).

Compare the extracted drawing priority determination rule 12 and the number of items and column characteristics of the intermediate table for each axis (
step 1906).

If the condition exists (step 1907), the rule number and score of the drawing priority determination rule 13 with the condition are transferred to the priority storage section (step 1908).
, the information in the priority storage section is sorted by score (step 1909).

After comparing all the rules regarding drawable graph types (step 1910), step 190
Return to 2. Similar processing is performed from step 1902 to step 1910 for all pairs of intermediate table numbers and drawable graph types, and then ends.

The procedure of the graph drawing means 6 will be explained using the flowchart of FIG.

First, the drawing priority determination rule number with the highest score and one intermediate table number are read out from the priority storage section (step 2001).

[0074] Rule No. read in step 2001
The graph type of drawing priority determination rule 13 pointed to by (step 2003) and the intermediate table pointed to by intermediate table No. are acquired (step 2004).

The column assigned to the main axis of the intermediate table obtained in step 2004 is set as the primary key of search data 8 (step 2005), and the column assigned to the auxiliary axis is set as the secondary key of search data 8. settings (step 2006).

Referring to the conversion method from search data 8 to graph data set in column characteristic table 9, step 2
Graph data is generated from 005 and the key information set in step 2006 (step 2007).

Score 8 shown in the drawing priority storage section in FIG.
．． 0. Rule No. Drawing priority order determination rule 13 of No. 8 and No. If you take out the intermediate table in step 2, the main axis corresponds to the "Year" column and the auxiliary axis corresponds to the "Gender" column, and the number of "Year" items is 5 and the number of "Gender" items is 2. It is. The number of graph data is determined by a combination of the number of items, so it is 10.

[0078] Since "average age" is set in the survey item and "average" is set in the conversion method from search data 8 to graph data, the average of each search data classified according to the key specification is The values are calculated to generate graph data (step 2008).

Information on the axis name, item name, and number of items of the intermediate table obtained in step 2004 (step 2009)
, the graph data generated in step 2008 is set in the graph creation section (step 2010).

The graph creation section creates a graph using the data set in steps 2009 and 2010 (step 2011). The graph created in step 2010 is output to the input/output processing means 1 (step 20
12) Wait for user input (step 2013).

[0081] If the user wants to display a graph different from the one currently displayed, the user should give a signal to display a different graph (
If the graph is to be determined as the final graph, a final graph determination signal (hereinafter referred to as END) is input from the input/output processing means 1.

[0082] When NEXT is input, the graph with the next highest priority score after the currently displayed graph is selected.
It reads from the drawing priority storage section, performs steps 2001 to 2013 of the graph drawing means, and automatically displays a graph different from the previous one.

This procedure is repeated until END is input.

If the drawing priority information ends before END is input, return to the information with the highest priority and repeat steps 2001 to 2012 (
step 2015).

[0085] Then, when END is input, the process ends.

The procedure of the priority rule updating means 7 will be explained using the flowchart of FIG. 22.

Since the score of the drawing priority order determination rule 13 is initially the same for all rules, when drawing a graph for the first time, it is drawn in the order in which the priority order determination rule is set.

[0088] By executing this means, a score difference is added to the rules, and the priority order is determined as explained above.

The new score TN is determined by the function f TN=f(T), where the current score is T (step 21
01).

For example, if the function is TN=T+1, the drawing priority order determination rule will increase the score by one point once the final graph is determined.

This new score is transferred to the drawing priority order determination rule 13 (step 2102). After drawing the graph several times, the graph that has been finalized by the user the most times will be selected as the first priority.
It will be displayed first on the screen. It also has a reset function that resets the scores of all rules in the drawing priority order determination rules to the same value, making it adaptable to new users.

Furthermore, the drawing information selected for the final graph is stored in the previous drawing information 10 (step 2103).
).

FIG. 23 shows an example of the previous drawing information 10. Looking at FIG. 23, the previous drawing information 10 consists of drawing priority order determination rule number, main axis item name, auxiliary axis item name, investigation item item name, and investigation item conversion method.

Finally, the procedure of the previous drawing information utilization means 2 will be explained using the flowchart of FIG. First, the column name and column number to be graphed are received from the input/output processing means 1 and recorded in the storage section (step 2301).

Next, the main axis item names, auxiliary axis item names, and survey item item names are extracted from the previous drawing information supplement 10 and compared with the column names to be graphed received from the input/output processing means 1 (
Step 2302). If there is a column name that is the same as the main axis item name, auxiliary axis item name, and survey item item name extracted from the previous drawing information 10 (step 2303), the graph drawing means 6
Steps 2003 to 2013 are executed, and a graph is drawn based on the previous drawing information 10 (step 2304).

When END is input from the input/output processing means 1, the priority rule updating means 7 is called (step 230).
6) If NEXT is input, the processing from the intermediate table generation means 3 onward described so far is executed (step 2).
307).

[0097]

[Effects of the Invention] As explained above, the present invention introduces an intermediate table, drawable graph type determination rules, and drawing priority determination rules, and automatically selects the graph type, number of items, and item names suitable for search data. By displaying a graph using a method of setting the graph, the following effects can be brought about.

(1) Since graphs are automatically displayed, the number of input means for creating graphs is reduced.

(2) Since a graph suitable for the data is selected and displayed, no knowledge of graphing is required.

(3) Since the rule for selecting the optimal graph is provided with a learning function, a graph according to the user's request can be drawn in a short time, and the work of re-creating the graph is reduced.

Furthermore, if previous drawing information can be reused, an optimal graph can be quickly obtained without having to find the optimal graph using various rules.

In particular, when the search data is a search result from a database, it is very effective to perform automatic drawing once and then change the search conditions again and automatically draw the search result from the database.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing an embodiment of a high-speed graph automatic drawing method with a learning function according to the present invention.

FIG. 2 is a diagram showing an example of search data.

FIG. 3 is a diagram for explaining an intermediate table.

FIG. 4 is a diagram illustrating the relationship between an intermediate table and a graph.

FIG. 5 is a diagram showing an example of a column characteristic table.

FIG. 6 is a diagram illustrating an example of intermediate table generation rules 11;

FIG. 7 is a flowchart showing a part of the processing flow of the intermediate table generation means 3;

FIG. 8 is a flowchart showing another part of the process flow of the intermediate table generation means 3;

FIG. 9 is a diagram showing an example of a master intermediate table.

FIG. 10 is a diagram showing an example of an item name table.

FIG. 11 is a supplementary diagram for explaining the intermediate table generation means 3, and is a diagram showing an example of column combinations.

FIG. 12 is a diagram showing an example of an intermediate table.

FIG. 13 is a block diagram of drawable graph type determining means 4. FIG.

FIG. 14 is a diagram showing an example of a drawable graph type determination rule 12.

FIG. 15 is a diagram illustrating an example of a drawable graph type storage unit.

FIG. 16 is a flowchart showing the process flow of the drawable graph type determining means 4;

FIG. 17 is a block diagram of drawing priority determining means 5. FIG.

FIG. 18 is a diagram illustrating an example of drawing priority order determination rule 13.

FIG. 19 is a diagram illustrating an example of a drawing priority storage unit.

FIG. 20 is a diagram showing a flowchart showing the flow of processing by the drawing priority order determining means 5;

21 is a diagram showing a flowchart showing the flow of processing of the graph drawing means 6. FIG.

22 is a diagram showing a flowchart showing the flow of processing by the priority rule updating means 7. FIG.

FIG. 23 is a diagram showing an example of previous drawing information 10.

FIG. 24 is a flowchart showing the process flow of the previous drawing information utilization means 2;

[Explanation of symbols]

1 Input/output processing means 2 Previous drawing information utilization means 3 Intermediate table generation means 4 Drawable graph type judgment means 5 Drawing priority judgment means 6 Graph drawing means 7 Priority rule updating means 8 Search data 9 Column characteristic table 10 Previous drawing information 11 Intermediate table generation rule 12 Drawable graph type determination rule 13
Drawing priority determination rules

Claims (1)

[Claims] [Claim 1] An automatic graph drawing method for an information processing system that converts data retrieved from a database into a graph and displays it, the input/output method receiving from a user search data to be graphed and a column characteristics table that describes column characteristics. A processing means, an intermediate table generation means for creating an intermediate table with reference to predetermined intermediate table generation rules, and a previous drawing based on the search data and column characteristic table received from the input/output processing means. If the information can be reused, the previous drawing information is automatically drawn using the previous drawing information, and if the information is not reusable, the previous drawing information usage means calls the intermediate table generation means, and the intermediate table created by the intermediate table generation means is received and the previous drawing information is drawn automatically. A drawable graph type determination means that selects all drawable graph types for the received intermediate table by comparing them with the drawn drawable graph main determination rule that has been set, and a drawing priority determination method in which the degree of optimality as a graph is described in advance. A drawing priority determining means for determining the drawing priority of the graph type selected by the drawable graph type determining means, and graph data having the highest priority determined by the drawing priority determining means, using a rule. , a graph drawing means that automatically draws a graph using the input/output means, after drawing the optimal graph, inputs the graph desired by the user from the input/output processing means, and obtains final graph information; Based on the final graph information received from the graph drawing means, the drawing priority order determination rule is updated in order to adjust the degree of optimization to the user's track record, and the current drawing information is given priority to be stored as the previous drawing information. 1. A graph automatic drawing method with a learning function, comprising a rule updating means, and automatically drawing a graph and updating rules.