JP2000293351A - Field influence display device and program recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the effectiveness of an analyzing function by generating a display figure for the degree of influence from a rate calculated by a calculating means and the degrees of influence that respective property values of condition fields have and displaying the display figure on a display screen. SOLUTION: An influence degree calculating means 10 calculates the degree of influence of the property values of condition fields on result fields. Further, the calculating means 11 calculates the rate of records having the property values by the property values of the condition fields while including or excluding a deficit value as specified. Then a generating means 13 generates the display figure of the degrees of influence from the rate calculated by the calculating means 11 and the degrees of influence of the respective property values of the condition fields to be displayed. The display figure is displayed on the display screen of a terminal 3 by a display means 14.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a field influence display device for displaying the influence of attribute values of fields constituting a tabular database on a result field, and a program record storing a program for realizing the device. Media.

With the recent development of computer systems and high-density and low-priced storage devices, means for storing and using data in data warehouses and the like has become popular, and large-scale data has been analyzed. It has become. For example,
Relationship between time and sales at retail stores nationwide in the POS system that has permeated the distribution industry, relationship between customer attributes and financial products to be purchased in financial institutions, and relationship between process attributes and yield in the manufacturing industry Is raised.

In order to effectively utilize such large-scale data, it is required to accurately grasp characteristics of the data and knowledge obtained from the data. Using statistical tools and OLAP (Online Analytical Processing) tools, you can visually grasp the overall statistical values and distribution of data, but that alone will give you specific knowledge to utilize the data. Therefore, it is desired to provide a function for obtaining knowledge beyond ordinary statistical information such as general statistical values and data distribution.

[0004]

2. Description of the Related Art A tabular database is a set of records composed of a plurality of fields including one or more condition fields and one or more result fields.

In the prior art, when indicating the relationship between the result field and the condition field of this tabular database,
For each type of value in the result field, the number and percentage of records that take that value are displayed for each attribute value in the condition field.

On the other hand, as a method of calculating the degree of influence of a condition field on a result field based on a conditional probability, there are methods such as PCF (Per-Category Feature importance) and CCF (Cross-Category Feature importance). . By using this PCF method, the degree of influence of each condition field can be obtained, and this CCF method (Journal of Artificial Intelligence Vol.10 No.5 September 1995 pp.798-8)
05 "Introduced in" Weather Forecast by Memory-Based Inference ") can be used to obtain the degree of influence of each attribute value of each condition field.

In the prior art, when the degree of influence is obtained by using the PCF method or the CCF method, processing is performed so that those numerical values are displayed as they are.

[0008]

However, according to such a conventional technique, the user can analyze the data by looking at the characteristics of the data, which is limited to ordinary statistical information. There has been a problem that the degree of influence of each attribute value of each condition field cannot be handled in the same way as other statistics.

Against this background, the present applicant has disclosed in Japanese Patent Application No. 10-352216 an invention for displaying the degree of influence of each condition field obtained by the PCF method.

[0010] The present invention has been made in view of the above circumstances, and a new method for displaying the degree of influence of each attribute value of each field constituting a tabular database to be obtained by a CCF method or the like on a result field has. It is an object of the present invention to provide a simple field influence display device and a new program recording medium storing a program for realizing the device.

[0011]

FIG. 1 shows the principle configuration of the present invention.

In the figure, reference numeral 1 denotes a field influence degree display device equipped with the present invention, which displays the influence degree of the attribute value of the condition field constituting the tabular database on the result field, and 2 denotes the field influence degree A tabular database to be processed by the display device 1, which is a set of records composed of a plurality of fields including a condition field and a result field, and 3 is a terminal provided in the field influence degree display device 1. Thus, it is a means for interacting with the user.

The field influence display device 1 of the present invention comprises:
Influence degree calculating means 10, calculating means 11, narrowing means 12
, Creation means 13, display means 14, and identification means 15
, Determination means 16, search means 17, detailed information display means 18, and change means 19.

The influence calculating means 10 calculates the influence of each attribute value of each condition field on the result field by using a method such as the CCF method. Calculation means 11
Calculates, for each attribute value of each condition field, the percentage of records that take that attribute value while including or excluding missing values according to the designation. The narrowing means 12 narrows a condition field to be displayed.

The creating means 13 creates a display graphic of the degree of influence from the ratio calculated by the calculating means 11 and the degree of influence of each attribute value of the condition field to be displayed. The display unit 14 displays the display graphic created by the creation unit 13 on the display screen of the terminal 3.

The specifying means 15 specifies, for each attribute value of the condition field to be displayed, a result field value characterizing the attribute value. The determining means 16 determines a result field value to be displayed. The search unit 17 determines the determination unit 1
A condition field and an attribute value having the characteristic of the result field value determined in step 6 are searched.

The detailed information display means 18 displays, when a graphic part of the display graphic displayed by the display means 14 is selected, information on the graphic part on a display screen.
The changing means 19 responds to a user operation by displaying the display means 1.
The drawing mode of the display graphic to be displayed is changed.

Here, the functions of the field influence display device 1 of the present invention are specifically realized by a program, which is stored in a floppy disk or the like, or is stored in a disk such as a server. The present invention is realized by being stored and then installed in the field influence display device 1 and operating on the memory.

In the field influence display device 1 of the present invention configured as described above, the influence degree calculation means 10
Using a technique such as a technique, the degree of influence of each attribute value of each condition field on the result field is calculated, and the calculating unit 11 includes or excludes missing values according to the specification,
For each attribute value of each condition field, the percentage of records taking that attribute value is calculated.

On the other hand, the narrowing-down means 12 includes the influence degree calculating means 1
The magnitude of the degree of influence of each condition field is calculated from the degree of influence obtained by 0 and the ratio obtained by the calculation means 11, and the condition fields to be displayed are narrowed down or specified according to the magnitude. The condition fields to be displayed are narrowed down by, for example, narrowing down the condition fields to be displayed according to the size, with the condition field being a condition field within the limit of the number of attribute values.

Receiving these processes, the creation means 13
From the ratio calculated by the calculating unit 11 and the degree of influence of each attribute value of the condition field to be displayed, a graphic for displaying the degree of influence is created. For example, a three-dimensional array composed of a three-dimensional array of figures whose lengths are divided according to the ratios calculated by the calculating means 11 and whose heights correspond to the degree of influence of attribute values having those ratios. Of a graphic having a color or density corresponding to the degree of influence of an attribute value having the ratio, wherein the length is divided according to the ratio calculated by the calculation means 11 A two-dimensional display graphic composed of an array is created.

In response to the display graphics created by the creation means 13, the display means 14 displays the created display graphics on the display screen of the terminal 3 so that the condition fields constituting the tabular database 2 can be displayed. Displays the degree of influence of the attribute value on the result field.

When this processing configuration is adopted, the identifying means 15
Is calculated from the ratio of each record to the result field value of all records and the ratio of each record of the attribute field of the condition field to be displayed to each result field value
For each attribute value of the condition field to be displayed, a result field value characterizing the attribute value is specified. Then, the determining means 16 determines a result field value to be displayed.

In response to this, the search means 17 searches for a condition field and an attribute value characterized by the result field value determined by the determination means 16 in accordance with the specification result of the specification means 15, Reference numeral 14 indicates the condition field and the attribute value to be displayed by displaying only the degree of influence of the condition field and the attribute value searched by the search unit 17 or by explicitly displaying the degree of influence of the condition field and the attribute value. Show trends for result field values.

Further, when adopting this processing configuration, the detailed information display means 18 displays the information of the graphic part when the graphic part to be displayed on the display means 14 is selected. By displaying on the screen, detailed information that cannot be displayed by the display graphic is displayed. Also,
The changing unit 19 changes the drawing form of the three-dimensional display graphic displayed by the display unit 14 in response to the operation of the user, while restricting the direction in which the degree of influence is allocated to not change. Display graphics for display in a form that is easy for the user to see.

As described above, according to the present invention, when the result field is specified in the tabular database 2 and the analysis is performed from the viewpoint of the influence of each condition field on the result field, the result field is not displayed by a normal analysis tool. Analysis that takes into account the degree of influence of each condition field becomes possible.

This solves the problem of the prior art that the analysis target of the tabular database 2 is limited to ordinary statistical information, so that the effectiveness of the analysis function is improved and the user can use the data more effectively. You will be able to gain a good knowledge.

[0028]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, the present invention will be described in detail according to embodiments.

FIG. 2 shows an embodiment of the present invention.

The field influence degree display device 1 of the present invention according to this embodiment is installed via a floppy disk, a line, or the like, and influences each attribute value of each condition field constituting the tabular database 2 on a result field. Calculation program 100 for performing processing for calculating the degree of influence, a working memory 101 for storing the processing results of the degree of influence calculation program 100, and a processing program installed on the floppy disk or line for processing the influence degree calculation program 100. A display data generation program 102 that performs a process of generating data used for displaying the degree of influence using the result, a display data file 103 that stores display data generated by the display data generation program 102,
An impact display program 104 installed via a floppy disk or a line to perform a process of displaying an impact using data of the display data file 103
3 is called from the influence display program 104 to perform a process of drawing a three-dimensional figure used for displaying the influence.
And a dimension drawing library 105.

The influence degree calculation program 100 is shown in FIG.
When the tabular database 2 as shown in FIG. 4 is given, as shown in FIG. 4, the number of all records and the number of records for each result field value are obtained, and the attribute value type is determined for each condition field. (There are categorical values that cannot be represented by numerical values, and discrete values that can be classified by being represented by numerical values), and the number of records that do not have attribute values (the number of missing values) is calculated. For each value, the number of records taking the attribute value, the degree of influence calculated by the CCF method, and the number of records for each result field value are obtained, and the process of storing them in the work memory 101 is performed.

The display data generating program 102 creates data to be used for displaying the influence using the processing result of the influence calculation program 100 and stores the data in the display data file 103.

FIGS. 5 to 7 show one embodiment of the processing flow executed by the display data generation program 102. FIG. Next, processing executed by the display data generation program 102 will be described according to this processing flow.

When the processing request is issued, the display data generation program 102 first determines the handling of the missing value in step 1 as shown in the processing flow of FIGS. That is, when the tabular database 2 as shown in FIG. 8A is given, whether to handle the total number of records including the missing values as shown in FIG. Alternatively, as shown in FIG. 8C, it is determined whether to handle the total number of records without including any missing value.

Subsequently, in step 2, one unprocessed condition field is selected from the condition fields of the tabular database 2, and in step 3, it is determined whether the selection of all the condition fields has been completed. to decide.

If it is determined in step 3 that the selection of all the condition fields has not been completed, that is, if it is determined in step 2 that the condition fields have been selected, the process proceeds to step 4 and the selected fields are selected. One unprocessed attribute value is selected from the attribute values of the condition field, and it is determined in the following step 5 whether the selection of all the attribute values has been completed.

When it is determined in step 5 that the selection of all attribute values has been completed, that is, when it is determined in step 4 that the attribute values cannot be selected, the process proceeds to step 2 in order to proceed to the processing of the next condition field. Return. On the other hand, when it is determined in step 5 that all the attribute values have not been selected, that is, when it is determined in step 4 that the attribute values have been selected, the process proceeds to step 6 and proceeds to step 1.
After considering the handling of the missing value determined in the above, the ratio of the records that the selected attribute value takes is calculated, and then the process returns to step 4 to proceed to the processing of the next attribute value.

For example, in the case of the table format database 2 shown in FIG.
Then, when selecting the condition field of “sex”, in step 1, if it is determined that the total number of records is calculated including the missing value, “male”
"5/8 = 0.625", "Female"
Calculate “1 ÷ 8 = 0.125” as the ratio of records in step 1 and return to step 4. On the other hand, in step 1, when deciding how to calculate the total number of records without including missing values, , "5%" as the percentage of records for "male"
6 = 0.833 ”, the percentage of records of“ Woman ”is“ 1 $
6 = 0.167 ”and the process returns to step 4.

In this way, by repeating the processing of step 2 to step 6, the ratio of records taking the attribute value is calculated for each attribute value of each condition field, and the calculation is performed. When it is completed, it is determined in step 3 that the selection of all the condition fields has been completed.
At that time, the process proceeds to step 7, where the degree of influence of each condition field is obtained from the degree of influence calculated by the degree of influence calculation program 100 and the ratio value calculated in step 6, and the condition field to be displayed is determined accordingly. I do.

The details of this determination processing are executed according to the processing flow of FIG. That is, when the maximum number of condition fields to be displayed is set, it is set, and when the maximum number of attribute values of the condition field to be displayed is set, it is set.

Then, as shown in FIG. 9A, the degree of influence of the condition field = {proportion value × the degree of influence, where Σ is the influence of each condition field according to the formula for calculating the sum of the attribute values of the condition field. Find the degrees and sort the condition fields in order of their magnitude.

Then, one condition field is selected in the sort order, and if the number of attribute values of the condition field is smaller than the set maximum value, the condition field is repeatedly set as a display object. When the number of condition fields to be reached reaches the set maximum value, the process is terminated to determine a condition field to be displayed.

The idea of this determination processing is difficult to see if the number of condition fields to be displayed is too large, and also difficult to see if the number of attribute fields is too large. In addition, by selecting condition fields having a small number of attribute values as display targets, the condition fields to be displayed are narrowed down. If the maximum number of condition fields to be displayed and the maximum number of attribute values of the condition field to be displayed are not set, all condition fields are displayed.

As described above, in step 7, the degree of influence of each condition field is obtained, and the condition field to be displayed is determined accordingly.
One unprocessed condition field is selected from the condition fields to be displayed in descending order of the influence degree, and the selection of all the condition fields to be displayed is completed in the following step 9 (the processing flow of FIG. 6). It is determined whether or not it has been done.

When it is determined in step 9 that all the condition fields to be displayed have not been selected, that is, when it is determined in step 8 that the condition fields have been selected, the process proceeds to step 11, and For each attribute value of the selected condition field, calculate the ratio between the percentage of records that take each result field value and the percentage of records that take that result field value in all records, and the result that maximizes the ratio value Determine the field value as the result field value that characterizes the attribute value,
Return to step 8.

For example, as shown in FIG. 9B, 40% of the records take the result field value of "buy" in the records which take the attribute value of "Tokyo" in the condition field of "address", and "buy". The proportion of records that take the result field value of "not available" is 60%, the proportion of records that take the result field value of "buy" in all records is 30%, and the proportion of records that take the result field value of "do not buy" is 70%. If it is%,
Since the ratio value of "buy" is larger than the ratio value of "do not buy", people living in Tokyo are more likely to buy compared to the whole, so "Tokyo" in the condition field of "address""Buy" is determined as a result field value that characterizes the attribute value of.

On the other hand, when it is determined in step 9 that the selection of all the condition fields to be displayed has been completed, the process proceeds to step 10 in which the influence calculated by the influence calculation program 100 and the ratio obtained in step 6 are calculated. A display data file 103 having a data structure as shown in FIG. 10 is created using the result field values obtained in step 11.

In this way, the display data generation program 102 determines the condition fields to be displayed according to the processing flows of FIGS. 5 to 7, and changes the data structure as shown in FIG. 10 for those condition fields. The display data file 103 is created.

In response to the creation of the display data file 103, the influence degree display program 104
According to the processing flow of 2, the influence calculation program 100
The display processing of the influence degree calculated by is performed.

That is, the influence degree display program 104
When a request to display the degree of influence calculated by the degree of influence calculation program 100 is issued, first, as shown in the processing flow of FIGS. 11 and 12, first, in step 1, it is stored in the display data file 103. By designating the data as drawing data and calling the drawing routine of the three-dimensional drawing library 105, a three-dimensional display graphic used for displaying the degree of influence as shown in FIG. 13 is displayed on the display screen of the terminal 3. .

The graphic for displaying the degree of influence shown in FIG.
The three-dimensional figures whose basic length is divided according to the length of the bottom surface in accordance with the ratio stored in the display data file 103 and whose height is allocated in accordance with the degree of influence stored in the display data file 103 are based on these three-dimensional figures. The dimensional figures are arranged, for example, in the order of the degree of influence of the condition field.

Here, FIG. 13 shows a three-dimensional figure defined in correspondence with the condition field having a width (thickness), but may be constituted by a substantially two-dimensional figure having no width. is there. Further, “* address” / “* gender” shown in the figure indicates that the condition field of “address” / “gender” is a category value. Note that the attribute values are preferably arranged in ascending or descending order when the type of the attribute value is a discrete value. However, when the type of the attribute value is a categorical value, there is no special rule for the arrangement. Instead, they are arranged in the order of the magnitude of the influence or in the dictionary order of the field names.

Subsequently, in step 2, the process waits until a processing instruction is issued from the user, and when the processing instruction is issued from the user, in step 3 which follows, it is determined whether a display end request has been issued from the user. When it is determined that this display end request has been issued, the process is terminated, and when it is determined that this display end request has not been issued, the process proceeds to step 4 where the result to be displayed by the user is displayed. It is determined whether or not the specification of the field value has been issued.

In this determination processing, when it is determined that the specification of the result field value to be displayed has been issued by the user, the process proceeds to step 5 where the display data file 1 is displayed.
03 by searching for a condition field and an attribute value having the specified result field value as a feature,
The three-dimensional display graphic used to display the degree of influence is displayed on the display screen of the terminal 3 in a form in which only these are explicitly displayed.

That is, as shown in FIGS. 14 and 15,
In a form in which only the condition field and the attribute value having the specified result field value as a feature are explicitly displayed, the three-dimensional display graphic used for displaying the degree of influence is displayed on the terminal 3.
Is displayed on the display screen. Here, dashed lines in the figure indicate condition fields and attribute values that do not have the specified result field value as a feature,
Instead of adopting such a display form, a configuration may be adopted in which only the condition field and the attribute value having the specified result field value as a feature are displayed.

When the processing of step 5 is completed, or when it is determined in step 4 that the user does not issue the designation of the result field value to be displayed, the process proceeds to step 6 and the result to be displayed by the user is determined. When it is determined whether or not a release request for designating a field value has been issued, and when it is determined that the release request has been issued, the process proceeds to step 7 in which all condition fields and attribute values are displayed. The three-dimensional display graphic used for displaying the degree is displayed on the display screen of the terminal 3. In other words, the display form is returned to the display form as shown in FIG. 13, and the three-dimensional display graphic used for displaying the degree of influence is displayed on the display screen of the terminal 3.

If the process of step 7 is completed, or if it is determined in step 6 that the user does not issue a request to cancel the designation of the result field value to be displayed, the process proceeds to step 8 (the process flow of FIG. 12). Then, it is determined whether or not the user has designated the graphic position of the graphic for displaying the degree of influence, and whether or not the request for displaying the detailed information has been issued is determined. Then, the detailed information of the designated graphic part is displayed on the display screen of the terminal 3.

That is, as shown in FIG. 16, a window screen is opened, and the condition field name / attribute value / impact degree / rate / class (characteristic result field) Value).

When the process of step 9 is completed, or when it is determined in step 8 that the user does not issue a request for displaying detailed information, the process proceeds to step 10.
It is determined whether or not the user has issued a rotation request for the influence display graphic, and when it is determined that this rotation request has been issued, the process proceeds to step 11, where the influence display graphic rotation processing is executed.

Then, when the process of step 11 is completed, or when it is determined in step 10 that the user does not issue a request to rotate the graphic for influence degree display, the process returns to step 2.

Next, the rotation processing of the influence display graphic executed in step 11 will be described with reference to the processing flow of FIG. 17 and FIG.

When the influence display program 104 determines that the user has issued a request to rotate the influence display graphic, the influence display program 104 starts the influence display graphic rotation processing, and FIG.
As shown in the processing flow of FIG. 18, first, in step 1, the process waits for the user to press the mouse button, and when it is detected that the user presses the mouse button, the process proceeds to step 2, and the process proceeds to step 2. Record the coordinates A pointed by the mouse.

Subsequently, in step 3, waiting for the user to release the mouse button, and detecting that the user has released the mouse button, the process proceeds to step 4, where the coordinates B indicated by the mouse at that time are recorded.

Subsequently, in step 5, it is determined whether or not the coordinates A and B do not match. If it is determined that they match, the process returns to step 1; if it is determined that they do not match, the process returns to step 6 And go to coordinates A and B
From this, the displacement Δx in the horizontal direction and the displacement Δy in the vertical direction are obtained.

Subsequently, in step 7, a displacement angle Δθ about the rotation axis proportional to the displacement Δy and an azimuth Δφ of the elevation angle proportional to the displacement Δx are determined. As shown in FIG. 19, the rotation axis is set in the direction of the degree of influence, and the elevation angle is set from the bottom of the figure for displaying the degree of influence. Therefore, according to the displacement Δy, the displacement angle Δθ around the rotation axis is obtained. ,
According to the displacement Δx, the azimuth angle Δφ of the elevation angle is obtained. As can be seen from FIG. 19, the graphic for displaying the degree of influence is not a graphic seen by the viewpoint but a graphic obtained by externally viewing the graphic seen by the viewpoint.

Subsequently, in step 8, a routine for rotating the projection direction by Δθ around the rotation axis parallel to the direction of influence is called for the three-dimensional rendering library 105. Subsequently, in step 9, the current rotation angle ま わ り around the rotation axis is updated by Δθ.

Subsequently, in step 10 (the processing flow in FIG. 18), Θ from the initial position perpendicular to the direction of the influence degree.
The axis that has been rotated only is set as the rotation axis for changing the elevation angle. In FIG. 19, the rotation axis for changing the elevation angle stands upright on the paper, but the rotation axis for changing the elevation angle is rotated by Θ from the initial position.

Subsequently, in step 11, a routine for rotating the projection direction by Δφ around the rotation axis for changing the elevation angle is called for the three-dimensional drawing library 105. Subsequently, in step 12, a redrawing routine is called for the three-dimensional drawing library 105.

As described above, the influence degree display program 1
When it is determined that the user has issued a request to rotate the influence degree display graphic, the influence degree does not become oblique as shown in FIG. 20 according to the processing flow of FIGS. 17 and 18. While controlling, in response to the user's mouse operation, the influence display graphic is rotated so that the influence display graphic is displayed in a form that is easy for the user to view. is there.

In the embodiment described above, the influence degree display program 104 adopts a configuration in which a three-dimensional form of influence degree display graphic as shown in FIG. 13 is displayed on the display screen. A configuration may be adopted in which a two-dimensional form of influence display graphic as shown is displayed on a display screen.

The graphic for displaying the degree of influence shown in FIG. 21 is defined corresponding to the condition field, and is displayed in the display data file 1.
The two-dimensional figures are basically divided into two-dimensional figures in which the length in the longitudinal direction is divided according to the ratio stored in the display data file 03 and the colors or densities are allocated according to the degree of influence stored in the display data file 103. The graphics are arranged, for example, in the order of the degree of influence of the condition field.

Even when this configuration is adopted, when the user issues a designation of a result field value to be displayed, the influence display program 104 searches the display data file 103 to specify the designated result field value. A condition field and an attribute value having the characteristic of the result field value are searched, and as shown in FIG. 22, processing is performed so as to explicitly display only them.

The present invention has been described with reference to the illustrated embodiments.
The present invention is not limited to this. For example, in the embodiment, two result fields, “buy” and “do not buy”, are assumed. However, the present invention can be applied to the case where the result field value has three or more values.

[0074]

As described above, according to the present invention,
When analyzing the tabular database from the viewpoint of the effect of each condition field on the result field by specifying it, it is possible to analyze taking into account the degree of influence of each condition field that is not displayed by ordinary analysis tools become.

As a result, the problem of the prior art that the analysis target of the tabular database is limited to ordinary statistical information can be solved, so that the effectiveness of the analysis function is improved, and the user can obtain more useful information from the data. You will be able to gain knowledge.

[Brief description of the drawings]

FIG. 1 is a principle configuration diagram of the present invention.

FIG. 2 is an embodiment of the present invention.

FIG. 3 is an explanatory diagram of a tabular database.

FIG. 4 is an explanatory diagram of processing of an influence degree calculation program.

FIG. 5 is a processing flow of a display data generation program.

FIG. 6 is a processing flow of a display data generation program.

FIG. 7 is a processing flow of a display data generation program.

FIG. 8 is an explanatory diagram of processing for handling a missing value.

FIG. 9 is an explanatory diagram of processing of a display data generation program.

FIG. 10 is an explanatory diagram of a display data file.

FIG. 11 is a processing flow of an influence degree display program.

FIG. 12 is a processing flow of an influence degree display program.

FIG. 13 is an explanatory diagram of a display screen.

FIG. 14 is an explanatory diagram of a display screen.

FIG. 15 is an explanatory diagram of a display screen.

FIG. 16 is an explanatory diagram of a display screen.

FIG. 17 is a processing flow of an influence degree display program.

FIG. 18 is a processing flow of an influence degree display program.

FIG. 19 is an explanatory diagram of processing of an influence degree display program.

FIG. 20 is an explanatory diagram of processing of an influence degree display program.

FIG. 21 is an explanatory diagram of a display screen.

FIG. 22 is an explanatory diagram of a display screen.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 field influence display device 2 tabular database 3 terminal 10 influence calculation means 11 calculation means 12 narrowing means 13 creation means 14 display means 15 identification means 16 determination means 17 search means 18 detailed information display means 19 change means

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 5B069 AA01 BA01 BA04 DD01 FA04 HA03 HA16 5B075 NK46 PQ02 PQ40 QT06 5E501 AA13 AC17 AC18 AC23 AC34 BA03 BA09 CA03 CA04 DA08 FA14 FA24 FA27 FA44 FA46 FB24 FB28 FB43

Claims (3)

[Claims] 1. A field influence display device for displaying the influence of attribute values of a condition field constituting a tabular database on a result field, wherein said attribute value is obtained while including or excluding a missing value according to designation. Calculating means for calculating the ratio of records; creating means for creating a graphic for displaying the influence degree from the ratio calculated by the calculating means and the degree of influence; and a display screen for creating the display graphic created by the creating means And a display means for displaying on the display. 2. The field influence degree display device according to claim 1, wherein: a ratio of each record to each result field value indicated by all records;
Specifying means for specifying, for each of the attribute values, a result field value characterizing the result field value indicated by a record having the attribute value with respect to each result field value; determining means for determining a result field value to be displayed; Searching means for searching for a condition field and an attribute value characterized by the result field value determined by the determining means according to the specification result of the specifying means; and displaying means for the condition field and the attribute value to be searched by the searching means. A field influence degree display device characterized in that only the influence degree of the field is displayed or the influence degree is explicitly displayed. 3. A program recording medium for storing a program used for realizing a field influence degree display device for displaying an influence degree on a result field of an attribute value of a condition field constituting a tabular database. A calculation process of calculating the ratio of records that take the attribute value while including or excluding the missing value; and a creation process of creating the display graphic of the impact from the ratio calculated by the calculation and the impact. A program recording medium characterized by storing a program for causing a computer to execute a display process for displaying a display graphic created by the creation process on a display screen.