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

Method of displaying data from database on computer screen Download PDF

Info

Publication number
RU2653235C1
RU2653235C1 RU2016147402A RU2016147402A RU2653235C1 RU 2653235 C1 RU2653235 C1 RU 2653235C1 RU 2016147402 A RU2016147402 A RU 2016147402A RU 2016147402 A RU2016147402 A RU 2016147402A RU 2653235 C1 RU2653235 C1 RU 2653235C1
Authority
RU
Russia
Prior art keywords
data
parameter
values
corresponds
display
Prior art date
Application number
RU2016147402A
Other languages
Russian (ru)
Inventor
Иван Александрович Шкиря
Original Assignee
Иван Александрович Шкиря
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Иван Александрович Шкиря filed Critical Иван Александрович Шкиря
Priority to RU2016147402A priority Critical patent/RU2653235C1/en
Application granted granted Critical
Publication of RU2653235C1 publication Critical patent/RU2653235C1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048Interaction techniques based on graphical user interfaces [GUI]
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06TIMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T11/002D [Two Dimensional] image generation
    • G06T11/20Drawing from basic elements, e.g. lines or circles
    • G06T11/206Drawing of charts or graphs

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.
RU2016147402A 2016-12-02 2016-12-02 Method of displaying data from database on computer screen RU2653235C1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
RU2016147402A RU2653235C1 (en) 2016-12-02 2016-12-02 Method of displaying data from database on computer screen

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
RU2016147402A RU2653235C1 (en) 2016-12-02 2016-12-02 Method of displaying data from database on computer screen

Publications (1)

Publication Number Publication Date
RU2653235C1 true RU2653235C1 (en) 2018-05-07

Family

ID=62105541

Family Applications (1)

Application Number Title Priority Date Filing Date
RU2016147402A RU2653235C1 (en) 2016-12-02 2016-12-02 Method of displaying data from database on computer screen

Country Status (1)

Country Link
RU (1) RU2653235C1 (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6529900B1 (en) * 1999-01-14 2003-03-04 International Business Machines Corporation Method and apparatus for data visualization
US20090013271A1 (en) * 2007-05-23 2009-01-08 Oracle International Corporation Filtering for data visualization techniques
US20130275904A1 (en) * 2012-04-11 2013-10-17 Secondprism Inc. Interactive data visualization and manipulation
RU2517379C2 (en) * 2008-12-18 2014-05-27 Майкрософт Корпорейшн Architecture of data visualisation interactivity
US20140225889A1 (en) * 2013-02-08 2014-08-14 Samsung Electronics Co., Ltd. Method and apparatus for high-dimensional data visualization

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6529900B1 (en) * 1999-01-14 2003-03-04 International Business Machines Corporation Method and apparatus for data visualization
US20090013271A1 (en) * 2007-05-23 2009-01-08 Oracle International Corporation Filtering for data visualization techniques
RU2517379C2 (en) * 2008-12-18 2014-05-27 Майкрософт Корпорейшн Architecture of data visualisation interactivity
US20130275904A1 (en) * 2012-04-11 2013-10-17 Secondprism Inc. Interactive data visualization and manipulation
US20140225889A1 (en) * 2013-02-08 2014-08-14 Samsung Electronics Co., Ltd. Method and apparatus for high-dimensional data visualization

Similar Documents

Publication Publication Date Title
Hallinger et al. Leadership for learning: Does collaborative leadership make a difference in school improvement?
Tsinidou et al. Evaluation of the factors that determine quality in higher education: an empirical study
Pousman et al. Casual information visualization: Depictions of data in everyday life
Kelleher et al. Ten guidelines for effective data visualization in scientific publications
Lee et al. Sparkclouds: Visualizing trends in tag clouds
World Health Organization Handbook on health inequality monitoring: with a special focus on low-and middle-income countries
Bender-deMoll et al. The art and science of dynamic network visualization
Cress et al. The collective knowledge of social tags: Direct and indirect influences on navigation, learning, and information processing
CN102467596A (en) Instrument board evaluator
Nutley et al. Improving the use of health data for health system strengthening
US20090210272A1 (en) Methods & systems for energy, information, and business systems modeling
US20140100922A1 (en) Employee engagement system, method and computer readable media
Snilstveit et al. Evidence gap maps—a tool for promoting evidence-informed policy and prioritizing future research
Mendonça et al. The strategic strength of weak signal analysis
Batanero et al. Statistics and probability in high school
Stahnke et al. Probing projections: Interaction techniques for interpreting arrangements and errors of dimensionality reductions
Ramirez et al. Measuring knowledge work: the knowledge work quantification framework
French et al. Comparison study of multi‐attribute decision analytic software
Browning Managing complex project process models with a process architecture framework
Beri Business Statistics, 2E
Carr et al. Visualizing data patterns with micromaps
Sopan et al. Community Health Map: A geospatial and multivariate data visualization tool for public health datasets
AU2002248090B2 (en) Preference and attribute profiler
Gettinger et al. A comparison of representations for discrete multi-criteria decision problems
Urban Social entrepreneurship in an emerging economy: A focus on the institutional environment and social entrepreneurial self-efficacy.