RU2653235C1 - Method of displaying data from database on computer screen - Google Patents

Abstract

FIELD: physics.

SUBSTANCE: method of displaying data from a database on a computer screen classified by the parameters is opened, each of which contains a set of values that includes obtaining a primary graphic display of data so that a figure divided into parts corresponds to each parameter, each of which corresponds to a separate value of the parameter, and its area is proportional to the amount of data corresponding to a particular value of the parameter, wherein the method includes subsequently obtaining a transformed graphical display of the data, that when one or more parameter values are selected, the area of the parts of each figure changes according to the selected parameter values.

EFFECT: providing the interactivity of the graphical data display on the computer screen.

4 dwg

Description

The invention relates to the field of information display and can be used to display, as a rule, a large amount of data classified by parameters obtained by conducting a sociological survey, a population census, collecting information about a series during production, collecting information about an audience visiting a particular site on the Internet, who bought a certain product and more.

A known method of displaying data, which includes generating the first data array, visualizing the array by displaying qualitative indicators in a proportional ratio to each other, and subsequent clustering by selecting indicators of interest from the data array, leads to the display of the second data array in which there are objects corresponding to the selected indicator [Application for invention US 20090013271, IPC G06F 3/048, publication date 1/8/2009].

The disadvantage of this method is that the known method can only be used to display data organized according to the principle of hierarchy. The known method allows clustering data and does not imply the preservation of the displayed parameters after it.

As a prototype, a method for displaying data was chosen, which consists in the fact that a computer selects the classification parameters of the data included in the relational database, and then graphically displays the data in the form of a bar chart [Web Analytics Website “We reveal the functionality of Google Analytics reports. Part 1". Electronic resource. Access mode: http://web-analytic.ru/raskryvaem-funkcional-otchetov-google-analytics/. Date of publication: 11/23/2009].

The disadvantage of the prototype method is that it is not possible to automatically filter data to obtain a converted graphical display. Bar charts are not interactive. Thus, the claimed method has low visibility and information content, especially in the case of a large number of data and classification parameters. Filtering the database displayed by the prototype method requires the use of additional automation tools.

The technical problem is the creation of a data display method that has advanced functionality and allows to increase the information content of the data display.

EFFECT: ensuring interactivity of graphic display of data on a computer screen.

The essence of the proposed method is as follows.

A method of displaying data from a database on a computer screen, classified by parameters, each of which contains a set of values, including obtaining an initial graphical display of data so that each parameter corresponds to a figure divided into parts, each of which corresponds to a separate parameter value, and its area proportional to the amount of data corresponding to a single parameter value. Unlike the prototype, the method includes the subsequent receipt of the converted graphical display of the data so that when you select one or more parameter values, the area of the parts of each figure changes in accordance with the selected parameter values.

The data displayed is related data. The displayed data is stored in a database, where it can be presented in table form. The displayed data is classified by parameters. The displayed data can be classified by any number of parameters. The parameter can be presented in the form of any format: numeric, text, date format and others. For example, the displayed data can be classified by the following parameters: “gender”, “age”, “date of access to the site”, “profession” and other parameters.

Each parameter contains a set of values. For example, the parameter "gender" may contain the values "female" and "male"; the parameter "age" contains the values "from 0 to 1 year"; “From 1 to 10 years”; "From 10 to 18 years"; "From 18 to 25 years old" and so on; the parameter “date of access to the site” contains the values “01.01.2015” and other dates; the parameter “profession” contains the values “lawyer”, “engineer”, “teacher” and other professions.

The inventive method includes obtaining a primary graphical display of data. In the primary graphical display of data, each parameter corresponds to a figure, which can be used as a rectangle, circle, square or other flat geometric shapes. If a volumetric figure corresponds to each parameter in the initial graphic display of data, its volume is proportional to the volume of data corresponding to a single value, and according to the claimed method, when selecting one or more values, the volume of parts of each figure changes in accordance with the selected values.

Each figure is divided into parts. Each part corresponds to a separate value. For example, if the figure corresponds to the “gender” parameter, it can be divided into two parts, one of which corresponds to the value “female” and the second to “male”.

The area of each part is proportional to the amount of data corresponding to a single value. For example, the database contains data on 1000 visitors to the site, among them 200 visitors are female and 800 are male. Thus, the figure corresponding to the gender parameter is divided into two parts. One of the parts corresponds to the value “female gender” and its area is proportional to the volume of data corresponding to the value “female gender”, that is, the area is 20% of the total area of the figure. The second part corresponds to the value "male gender", its area is proportional to the amount of data corresponding to the value "male gender", that is, the area is 80% of the total area of the figure. Thus, the area of the parts allows you to visually determine the relationship between the amount of data corresponding to individual values.

The converted graphical display of the data is obtained instead of the primary graphical display of the data when one or more values are selected. The converted graphical display of the data shows only the data corresponding to the selected values and the data associated with them in the database. The data displayed on the converted graphic display is classified by the same parameters as the data displayed on the primary graphic display. For example, figures corresponding to the parameters "gender", "age", "profession" are displayed. If you select the value "female" from the parameter "gender", the figure corresponding to the parameter "gender" displays only the value "female". Other figures display only data corresponding to the age and profession of women.

When you select one or more values, the area of the parts of each figure changes. In addition, when selecting one or more values, the number of parts of the figure corresponding to the parameter whose values were selected changes, and the number of parts of other figures can be changed. For example, figures corresponding to the parameters "gender", "age", "profession" are displayed. The “profession” parameter contains the values “fireman”, “teacher”, “doctor” with a data volume ratio of 20%, 30%, and 50%, respectively. If you select the values “teacher” and “doctor” in the parameter “profession”, a figure divided into three parts with a ratio of areas of 20%, 30% and 50% of the total area of the figure and corresponding to the parameter “profession” is converted into a figure divided into two parts with an area ratio of 37.5% and 62.5%, respectively. The area of the part corresponding to the value “fireman” becomes equal to zero. The display of other shapes is also changing. Other figures display only data corresponding to the gender and age of teachers and doctors. Thus, the area and the number of parts into which the figures corresponding to the parameters "gender" and "age" are changed. Moreover, the mappings of the figures, not divided into parts, on the initial graphic display, the converted graphic display, and subsequent converted graphic displays obtained by re-selecting one or more values are not changed. Since the figure corresponds to a parameter having one value, which is 100% of the data volume.

Representation of the primary and transformed graphic displays in the form of figures, divided into parts, increases the information content of the display by increasing the amount of knowledge (conclusions) that the user can get during analysis. The choice of the displayed parameter values and their graphical representation allows you to expand the functionality of a computer that implements the inventive method. In addition, the ability to select the displayed parameter values allows you to increase the content of the information displayed to the user, since it most closely meets its goals.

The computer screen may be represented by a part of the computer, for example, a display, and / or a separate external device, such as a monitor, projector, etc.

Increasing information content allows us to simplify, increase convenience and reduce the time of data analysis. Convenience is enhanced by the ability to display data within a single window of a computer program that implements the inventive method, and one display.

Unlike the prototype, the claimed invention has a number of distinctive features. This allows us to conclude that the proposed method meets the patentability criterion of "novelty."

The prior art methods are known, including the step of graphically displaying data classified by a plurality of parameters or by a selected parameter, in the form of a figure divided into parts whose areas are interconnected with the amount of data in the group. However, the prior art does not know how to display data that allows you to select the displayed values and convert the graphic display in accordance with the choice.

The combination of the distinctive features of the proposed method allows to achieve a synergistic effect on saving time costs required to identify the totality of the data that solve the user's tasks by simultaneously increasing the information content of the data display and expanding the functionality of the computer that implements the inventive method. Testing results showed that the inventive method allows, in comparison with the prototype, to increase the information content of the graphical display of data by an average of 20 times, which depends on the number of parameters, and was estimated by the method of expert evaluations.

The ability to select the values necessary for the user according to the claimed method allows to reduce the time required to perform user tasks from an average of 3 to 60 times. And getting a converted graphic display reduces this indicator on average by another 3 times. In this case, a synergistic effect is observed. Compared with the prototype, when implementing the proposed method, the time required to complete user tasks is reduced by more than 9 times, which depends on the number of displayed parameters. The more parameters are displayed, the higher the information content and the lower the time required to analyze them. This allows us to conclude that the proposed method meets the patentability criterion of "inventive step".

The claimed invention can be implemented using known means and methods, which allows us to conclude that the proposed method meets the patentability criterion of "industrial applicability".

The inventive method is illustrated by the following drawings:

FIG. 1 - image of the database of site visitors.

FIG. 2 - initial graphic display.

FIG. 3 - converted graphic display.

FIG. 4 - re-converted graphic display.

The inventive method is implemented by a computer as follows.

The user works with a database stored on a server that is connected to a computer using specialized software. The database contains related data on site visitors, classified by the parameters: “date of user’s visit to the site”, “income level”, “weight”, “gender”, “city of residence”, “eye color”, “education”, "age". The data are presented in tabular form. Initially, in the specialized software, the lower and upper boundaries of the dates of user access are selected, in this case from 04/12/2016 to 07/25/2016. Next, select one or more parameters to display them. For example, the selected parameters: “eye color”, “education”, “age”.

Next, on the display of the computer through specialized software receive a primary graphical display. Each parameter is represented in the form of figures 1-3, respectively, divided into parts 4-15. Each part 4-15 corresponds to a separate value of the selected parameters. The area of each part 4-15 is proportional to the amount of data corresponding to a particular value. For example, the parameter “eye color” corresponds to figure 1, and its part 4 corresponds to the value “brown eye color”, the area of part 4 corresponds to the number of website visitors for a selected period of time having brown eye color; part 5 corresponds to the value “gray eye color”, the area of part 5 corresponds to the number of website visitors who have gray eyes for a selected period of time, and so on. In addition, the computer displays a graph of the change in the number of visitors to the site 16. This can further increase the information content of the display by 1.5-2 times, which is estimated by the expert assessment method.

By hovering over parts 12 and 13 and clicking with the mouse, two values are selected from the parameter “age”, that is, age “from 16 to 20 years” and age “from 20 to 25 years”.

Then, a transformed graphical display of the data is obtained, displaying on the computer display only data corresponding to the values of “from 16 to 20 years old” and “from 20 to 25 years old” and related data. In addition, the computer displays a graph of changes in the number of visitors to the site corresponding to the selected values of 17. Thus, the total amount of displayed data changes; the area of parts 4-13, into which figures 1-3 are divided, and their number is from twelve to ten.

The area of each part 4-13 is proportional to the volume of data of a single value corresponding to the values of “from 16 to 20 years old” and the age of “from 20 to 25 years” and related data. Part 4 corresponds to the value “brown eye color”, the area of part 4 corresponds to the number of site visitors in the selected period, having brown eye color and age from 16 to 20 or from 20 to 25; part 5 corresponds to the value “gray eye color”, the area of part 5 corresponds to the number of website visitors in the selected period, having gray eyes and age from 16 to 20 or from 20 to 25; part 6 corresponds to the value “blue eye color”, the area of part 6 corresponds to the number of website visitors in the selected period, having blue eye color and age from 16 to 20 or from 20 to 25 and so on.

The user then re-chooses the values. By moving the cursor to part 9 and clicking the mouse, select the value from the “education” parameter, that is, the education is “secondary special”.

Then, a converted graphic display of the data is obtained, displaying on the computer display only data corresponding to the values of the age “from 16 to 20 years” or the age of “from 20 to 25 years”, the formation of “secondary special” and related data. Thus, the total amount of displayed data changes; the area of the parts 4, 6, 7, 8, 9, 13, 14, into which figures 1-3 are divided, and their number.

The area of each part 4, 6, 7, 8, 9, 13, 14 is proportional to the volume of data of a single value, corresponding to the values of age “from 16 to 20 years” or age “from 21 to 25 years” and education “secondary special” and related with them data. Part 4 corresponds to the value “brown eye color”, the area of part 4 corresponds to the number of website visitors in the selected period, having brown eye color and age from 16 to 20 or from 20 to 25 and secondary special education; part 5 corresponds to the value “gray eye color”, the area of part 5 corresponds to the number of website visitors in the selected period who have gray eyes and age from 16 to 20 or from 20 to 25 and secondary special education (in this case, the data volume is 0 ); part 6 corresponds to the value “blue eye color”, the area of part 6 corresponds to the number of website visitors in the selected period, having blue eye color and age from 16 to 20 or from 20 to 25 and secondary special education and so on.

The claimed technical result is achieved by ensuring the interactivity of the primary graphic image due to the possibility of changing it depending on the user's choice.

Testing results showed that the claimed method allows to increase the information content of the graphical display of data by an average of 20 times in comparison with the prototype, and also reduce the time required to identify a set of data that solves the user's tasks by 10-20 times.

Claims (1)

1. A method of displaying data from a database on a computer screen, classified by parameters, each of which contains a set of values, including obtaining an initial graphical display of data so that each parameter corresponds to a figure divided into parts, each of which corresponds to a separate parameter value, and its area proportional to the amount of data corresponding to a single parameter value, characterized in that it includes the subsequent receipt of the converted graphical display of the data so that when by selecting one or more parameter values, the area of the parts of each figure changes in accordance with the selected parameter values.

Images