CN101576881A - Data visualization system and realization method - Google Patents
Data visualization system and realization method Download PDFInfo
- Publication number
- CN101576881A CN101576881A CNA200810037054XA CN200810037054A CN101576881A CN 101576881 A CN101576881 A CN 101576881A CN A200810037054X A CNA200810037054X A CN A200810037054XA CN 200810037054 A CN200810037054 A CN 200810037054A CN 101576881 A CN101576881 A CN 101576881A
- Authority
- CN
- China
- Prior art keywords
- row
- value
- numerical value
- data
- column
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
Images
Landscapes
- Image Generation (AREA)
- User Interface Of Digital Computer (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention relates to a data visualization system which can express at least two numerical value rows in a table at the same time and one or a plurality of attribute rows. On the basis, through selecting an attention point by a user, detail data is located, or analysis application such as statistics, clustering, and the like based on the attention point.
Description
Technical field
The present invention relates to a kind of data visualisation system, several exhibition methods that can express in the form at least two numerical value row in a figure simultaneously be provided, so as user's quicklook find focus, and inquire about on this basis and statistics, cluster analysis.It belongs to the data visualization field.
Background technology
Analyze visualization of data and represent to comprise figure, form, crosstab etc.At present, the existing exhibition method that can express multi-column data simultaneously has hotspot graph, form, crosstab.
Hotspot graph can be expressed 3 column data.But, 3 column data are many times only arranged, still be not enough to select the data of being paid close attention to.When representing correlation rule with hotspot graph, can only represent condition, two attribute column of conclusion, and numerical value row in degree of confidence or the support, but in fact we often need to investigate simultaneously degree of confidence and support.
Current, form is the data representation mode that non-normal open is used, but comes presentation data value directly perceived inadequately with literal merely.In order to represent data intuitively in form, to play up the numerical value row be more effective with rectangular, but a plurality of data rows all in this way, can significantly increase the width of form.
Current crosstab, the content in the grid is numeral or literal often, and for searching focus, visual help also is short of to some extent.There has been part of O LAP demonstration tool to be supported in the crosstab and played up the numerical value row, and the edge data have been carried out special playing up, added frame, red display etc. such as value with rectangular.
Summary of the invention
All the time, people all wish by one intuitively the interface promptly find focus, and then extract corresponding detailed data, perhaps carry out further statistical study, cluster analysis etc.Key issue is exactly how can represent one or more attribute column (that is, the coordinate part) intuitively simultaneously, and two or more numerical value row (that is the definite value of coordinate).
In order to represent more attribute column and numerical value row simultaneously intuitively, the invention discloses six kinds and represent scheme:
1, enhancement mode hotspot graph
(a) input is a form, contains two discrete columns, and they can determine any data line in the input form together uniquely, be called attribute column X and attribute column Y, contain two or more numerical value row in addition, these numerical value row can disperse, and also can be continuous;
(b) be output as the grid chart of similar chessboard of go, laterally, vertically expression row X and row Y respectively, the Fill Color of grid is represented the value of a numerical value row A of its horizontal ordinate correspondence, and Fill Color changes with the variation of number of degrees value train value, is called hotspot graph;
(c) use one of following mode to represent the data of other numerical value row, be called the enhancement mode hotspot graph:
(c1) increase one or more patterns in the grid, the size of pattern, the another one of reflection respective regions correspondence or the difference of a plurality of numerical value train values, if only need represent the value of another one numerical value row B, can represent different values respectively with different patterns, the perhaps value of these numerical value row of Direct Mark B in grid, these patterns can be geometric figures such as circle, rectangle, also can be non-geometric figures such as humanoid pattern;
(c2) also can represent the value that the one or more numerical value except that A are listed as with bar shaped or column diagram, wherein each series is represented numerical value row, do not need unified linear module between the series, as long as in bar shaped or column diagram, express each data value with respect to the relative size between other data of its column;
(c3) when mouse moves on the grid, show the prompting frame of all other numerical value train values that comprise its correspondence.
2, focus crosstab/enhancement mode focus crosstab
(a) input is a form, contain two or more discrete columns, they can determine any data line in the input form together uniquely, be called attribute column, contain one or above numerical value row in addition, these numerical value row can disperse, and also can be continuous, and which attribute column the user need specify as wardrobe (remaining attribute column is as the row head);
(b) be output as crosstab, wardrobe and row heads are used to place the value of attribute column, and other grid are used for representing the data of numerical value row, and the Fill Color of grid is represented the value of a numerical value row A of its gauge outfit coordinate correspondence, Fill Color changes with the variation of number of degrees value train value, is called the focus crosstab;
During (c) more than numerical value row, use one of following mode to represent the data of other numerical value row, be called enhancement mode focus crosstab:
(c1) increase one or more patterns in the grid, the size of pattern, the another one of reflection respective regions correspondence or the difference of a plurality of numerical value train values, if only need represent the value of another one numerical value row B, can represent different values respectively with different patterns, the perhaps value of these numerical value row of Direct Mark B in grid, these patterns can be geometric figures such as circle, rectangle, also can be non-geometric figures such as humanoid pattern;
(c2) also can represent the value that the one or more numerical value except that A are listed as with bar shaped or column diagram, wherein each series is represented numerical value row, do not need unified linear module between the series, as long as in bar shaped or column diagram, express each data value with respect to the relative size between other data of its column;
(c3) when mouse moves on the grid, show the prompting frame of all other numerical value train values that comprise its correspondence.
3, enhancement mode colorimetric map
(a) the input data are forms, the row that comprise an expression geographic area, these row are also referred to as the area attribute row, the value of zone row is unique, and the two or more numerical value row on the respective regions, and another form that comprises the geographic area and represent the polygonal vertex data on its border;
(b) be output as the map that comprises relevant geographic area, each regional Fill Color is represented the value of a numerical value row A of its correspondence in the map, is called the colorimetric map;
(c) use one of following mode to represent the data of other numerical value row, be called enhancement mode colorimetric map:
(c1) increase one or more patterns in the grid, the size of pattern, the another one of reflection respective regions correspondence or the difference of a plurality of numerical value train values, if only need represent the value of another one numerical value row B, can represent different values respectively with different patterns, the perhaps value of these numerical value row of Direct Mark B in grid, these patterns can be geometric figures such as circle, rectangle, also can be non-geometric figures such as humanoid pattern;
(c2) also can represent the value that the one or more numerical value except that A are listed as with bar shaped or column diagram, wherein each series is represented numerical value row, do not need unified linear module between the series, as long as in bar shaped or column diagram, express each data value with respect to the relative size between other data of its column;
(c3) when mouse moves on the grid, show the prompting frame of all other numerical value train values that comprise its correspondence.
4, background colour is played up table
(a) input is a form, contain two or more discrete columns, they can determine any data line in the input form together uniquely, be called attribute column, contain one or above numerical value row in addition, these numerical value row can disperse, and also can be continuous, and the user need specify one or more numerical value to classify as and play up row;
(b) be output as tabulation, gauge outfit is used for placing each row row name, the corresponding each row of data of placing in the input data table of each row of back;
(c) play up carrying out background color according to its value and filling of row, background color changes with the variation of value.
5, background colour is played up crosstab
(a) the input data are forms, the attribute column that comprises two or more discrete types, they can determine any data line in the input form together uniquely, and one or more numerical value row, the user need specify a numerical value to classify first-selected numerical value row as, and crosstab data sink global schema;
(b) be output as crosstab, be called and play up contingency table, which attribute column the user can specify as wardrobe, and which attribute column is as the row head, and data rows is as column heading or row headers:
(b1) draw whole crosstab according to the normal crossing table, the numeral of data field is calculated according to the data sink global schema;
(b2) play up carrying out background color according to its value and filling of the corresponding grid of row, background color changes with the variation of value.
6, contingency table
(a) the input data are forms, the attribute column that comprises two or more discrete types, they can determine any data line in the input form together uniquely, and one or more numerical value row, the user need specify an attribute to classify category column as, when surpassing two attribute column, also can specify a plurality of attribute column to be listed as assembled classification, perhaps specify one or more classifying as to analyze the grouping row, remaining attribute is classified the analytic attribute row as;
(b) be output as crosstab, be called contingency table:
(b1) the row head shows the value of category column or assembled classification row, the row name of wardrobe display analysis attribute column, or the value of the row display analysis of wardrobe front grouping row, the row name of last row display analysis attribute column;
(b2) other grid show according to contrast bar chart as described below or contrast column diagram:
(b2.1) value of the analytic attribute of grid correspondence constitutes the coordinate figure of classification axle;
(b2.2) each series is represented numerical value row;
(b2.3) each bar or post comprise two parts, part represents the respective value row overall or gather value V by analyzing the grouping column split on the correspondence analysis property value, another part represents respective value row overall or gather value V* by analyzing the grouping column split on correspondence analysis property value and classification value or assembled classification value, be shown as one than comprising another the wide bar or post at the end altogether in long bar or the post, the ratio of length is listed as the ratio of corresponding V and V*.
Contingency table can further strengthen by following scheme:
(a) increase an input form, comprise the importance of each analytic attribute, or each analytic attribute is analyzed importance in the grouping with respect to each classification value or assembled classification value at each with respect to each classification value or assembled classification value;
(b) when click was listed as the grid at certain classification value place of head, each display line was according to the attribute importance ranking with respect to this classification value.
Wherein, preceding 5 kinds represent scheme, can adopt following Fill Color to determine scheme:
(a) when numerical value row A is expression number percent digital, the size of the size of color gray scale projection numeral, perhaps the size of color wavelength is anti-or reflect the size of numeral;
(b) when numerical value row A be that expression is common when digital, find out the minimum and maximum value of this column of figure, be expressed as 1 and 0 respectively, other values are scaled between 1 and 0, with the digital size of size projection of color gray scale, perhaps reflect the size of numeral then with the size of color wavelength;
(c) when numerical value row A is discrete value, according to what of discrete value, what system generated respective numbers has notable difference color value, respectively corresponding each value.
On the described in front new displaying scheme, the present invention further discloses the technical scheme of focus inquiry:
(a) the input data are a query sentence of database or database table name/view name, are called detail list;
(b) parameter comprises displaying scheme (user selects and belongs to displaying scheme in the described system of claim 1 to 8 or other can express the displaying scheme of multi-column data simultaneously), shows related packet attributes row, gathers the one or more summary column and the corresponding data sink global schema thereof of generation according to the packet attributes column split, and gathering scheme can be a formula even one section program;
(c) form of forming with (b) definite packet attributes row and summary column is as the required input of (b) selected displaying scheme, and on this basis, further sets and show that required attribute column and numerical value are listed as, and the required parameter of other displayings;
(d) when the user chooses figure that the setting according to (c) shows or the one or more zone in the form, can select generated query or check the action of corresponding detailed data, be called the focus inquiry, the zone of choosing is called focus.
Similarly, on focus, add up, claim the focus statistics; On focus, carry out cluster, claim the focus cluster.
The present invention further discloses the technical essential that realizes above-mentioned displaying scheme: adopt model-view-control model, model part comprises the data structure of an expression selected areas.
For the displaying scheme of pattern type,, draw flow process and relate to the drafting of selected areas, the drafting of mouse sheet favored area, and need follow certain sequence with respect to the generic graphic type:
(a) drawing is prepared, and carries out necessary calculating, comprises the graphic presentation ratio, and for the enhancement mode hotspot graph, all values in the X row removes repetition values, forms abscissa value, and all values during Y is listed as removes repetition values, forms ordinate value;
(b) fill drawing area with background colour;
(c) graphing itself:
(c1),, draw coordinate axis according to coordinate figure for the enhancement mode hotspot graph, promptly draw coordinate figure, draw each grid then, i.e. the value that is listed as according to A in the relevant position, calculate Fill Color, fill rectangle, then the value that is listed as according to other numerical value with it, and be provided with, draw corresponding text or figured value, perhaps draw bar chart, column diagram, last, draw the frame of each grid, i.e. mesh lines;
(c2) for enhancement mode colorimetric map, tables of data is drawn each zone according to the map, according to the value of A row, calculate Fill Color, use its filled polygon, the value that is listed as according to other numerical value, and setting then, draw corresponding text or figured value, perhaps draw bar chart, column diagram, last, the border of drawing All Ranges;
(d) draw selected areas;
(e) draw modified regions, such as legend etc.;
(f) draw mouse sheet favored area.
Displaying scheme for form types comprises crosstab, and is simple relatively, mainly is to present assembly by the cell of revising criteria table to reach required effect, can adopt Java Swing form component:
For focus crosstab and enhancement mode focus crosstab, each each data train value of row is concentrated and is shown with a single data structural table, make the cell that as a whole correspondence represents form, present this data structure with the self-defining assembly that presents, attribute column uses the default assembly that presents to handle;
For contingency table, V on each series and V* concentrate and show with a single data structural table, make the cell that as a whole correspondence represents form, with the self-defining assembly that presents, promptly contrast bar chart or the contrast column diagram presents this data structure, attribute column uses the default assembly that presents to handle.
Description of drawings
Accompanying drawing is the graphic plotting flow process that graph style is showed scheme.The special character of graphic plotting flow process is, carries out focus for the ease of the user and selects, and has increased the process of drawing selected areas and mouse sheet favored area.In the accompanying drawing, draw modified regions, mainly be meant modification contents such as drawing legend.
Embodiment
The realization of system of the present invention, the front has been described data structure, figure and form types and has been showed the method for drafting of scheme, the realization details of focus inquiry, focus statistics, focus cluster correlation is described below, how to comprise according to the starting point of click position or sheet favored area, the data item that terminal point coordinate is determined and the expression user chooses, and how to be converted into the condition of extracting detailed data according to the data item of choosing.Determine and represent the method for click location data items
For focus crosstab/enhancement mode focus crosstab, background colour play up table, background colour is played up crosstab, the grid that directly utilizes the method for form component to obtain to choose, row by grid number, row number represent to determine the data item chosen, and the tuple that the attribute train value of corresponding wardrobe and the representative of row head is formed can be used for representing the data item that this is chosen.Capable number, row representation are called view and represent; Attribute train value composition element group representation is called key word and represents.
For hotspot graph and enhancement mode hotspot graph, the row of the hotspot graph of the grid correspondence that we are fallen into according to the click position number, row number are determined the data item chosen, and the tuple of the coordinate figure composition of row number, row correspondence can be used for representing the data item that this is chosen.Capable number, row representation are called view and represent; Coordinate figure composition element group representation is called key word and represents.
Each geographic area of enhancement mode colorimetric map, corresponding polygon, which polygon the click position falls into, the geographic area of this polygon correspondence, the data item of choosing exactly also can directly be represented the data item that this is chosen with this geographic area.The geographic region thresholding is that view is represented, also is that key word is represented.
For contingency table, the user can select a classification axle of the contrast column diagram in the data grid with click, the row of grid correspondence number, row number, the classification axle of choosing can be determined the data item chosen, and it can be represented by the tuple that the data item of correspondence is made up of a row categorical attribute value, wardrobe analytic attribute or fractional analysis attribute, the classification axle value of column diagram.Represent with row number, row number, the classification axle chosen, be called view and represent; Represent by the tuple that the data item of correspondence is made up of a row categorical attribute value, wardrobe analytic attribute or fractional analysis attribute, the classification axle value of column diagram, be called key word and represent.Owing to during actual the use, carry out line ordering according to attribute importance usually, so capable number will be represented with the former number of beginning.
Other exhibition methods can be with reference to said method.
The user can pin Ctrl or shift key, selects a plurality of data item with mouse.Therefore, we represent the data item that the user chooses with array.View is represented, is used to upgrade view.Key word is represented to be used for detailed data and is extracted.Usually we only need a kind of expression, and promptly view is represented.When needs extract detailed data, just change into key word and represent.
When selecting with the mouse sheet, form component itself can will select the zone be converted into row number, row number, graphic assembly then according to grid whether by mouse sheet favored area cover judge whether selected.
Be converted into the method for the condition of extracting detailed data according to the data item of choosing
In order to extract detailed data, the view of selected areas need be represented to be converted into key word and represent.
For focus crosstab/enhancement mode focus crosstab, background colour play up table, background colour is played up crosstab, hotspot graph and enhancement mode hotspot graph, the extraction conditions of each data item correspondence, suppose that key table is shown (a, b, c, ...), corresponding attribute is (A, B, C, ...), then data extract condition is A=aAND B=bAND C=cAND....
For enhancement mode colorimetric map, the extraction conditions of each data item correspondence supposes that key table is shown (a), and the geographic area attribute is called AREA, and then data extract condition is AREA=a.
Contingency table is more special, and the user uses it to extract the feature of certain or some classification usually, and therefore when data extract, the user can ignore the constraint condition of a row categorical attribute value representative usually.The extraction conditions of each data item correspondence, suppose key table be shown (a, b, c ... x, y), corresponding attribute be (A, B, C ... X, Y), then data extract condition is A=aANDB=bANDC=cAND...ANDX=x.X is an analytic attribute, and x is its property value.Expression such as A, B, C assembled classification row or analysis grouping row.Y is a categorical attribute, is left in the basket usually.
Claims (13)
1, a kind of data visualisation system can be expressed at least two numerical value row in the form simultaneously, it is characterized in that:
(a) input is a form, contains two discrete columns, and they can determine any data line in the input form together uniquely, be called attribute column X and attribute column Y, contain two or more numerical value row in addition, these numerical value row can disperse, and also can be continuous;
(b) be output as the grid chart of similar chessboard of go, laterally, vertically expression row X and row Y respectively, the Fill Color of grid is represented the value of a numerical value row A of its horizontal ordinate correspondence, and Fill Color changes with the variation of number of degrees value train value, is called hotspot graph;
(c) use one of following mode to represent the data of other numerical value row, be called the enhancement mode hotspot graph:
(c1) increase one or more patterns in the grid, the size of pattern, the another one of reflection respective regions correspondence or the difference of a plurality of numerical value train values, if only need represent the value of another one numerical value row B, can represent different values respectively with different patterns, the perhaps value of these numerical value row of Direct Mark B in grid, these patterns can be geometric figures such as circle, rectangle, also can be non-geometric figures such as humanoid pattern;
(c2) also can represent the value that the one or more numerical value except that A are listed as with bar shaped or column diagram, wherein each series is represented numerical value row, do not need unified linear module between the series, as long as in bar shaped or column diagram, express each data value with respect to the relative size between other data of its column;
(c3) when mouse moves on the grid, show the prompting frame of all other numerical value train values that comprise its correspondence.
2, a kind of data visualisation system can be expressed at least two numerical value row in the form simultaneously, it is characterized in that:
(a) input is a form, contain two or more discrete columns, they can determine any data line in the input form together uniquely, be called attribute column, contain one or above numerical value row in addition, these numerical value row can disperse, and also can be continuous, and which attribute column the user need specify as wardrobe (remaining attribute column is as the row head);
(b) be output as crosstab, wardrobe and row heads are used to place the value of attribute column, and other grid are used for representing the data of numerical value row, and the Fill Color of grid is represented the value of a numerical value row A of its gauge outfit coordinate correspondence, Fill Color changes with the variation of number of degrees value train value, is called the focus crosstab;
During (c) more than numerical value row, use one of following mode to represent the data of other numerical value row, be called enhancement mode focus crosstab:
(c1) increase one or more patterns in the grid, the size of pattern, the another one of reflection respective regions correspondence or the difference of a plurality of numerical value train values, if only need represent the value of another one numerical value row B, can represent different values respectively with different patterns, the perhaps value of these numerical value row of Direct Mark B in grid, these patterns can be geometric figures such as circle, rectangle, also can be non-geometric figures such as humanoid pattern;
(c2) also can represent the value that the one or more numerical value except that A are listed as with bar shaped or column diagram, wherein each series is represented numerical value row, do not need unified linear module between the series, as long as in bar shaped or column diagram, express each data value with respect to the relative size between other data of its column;
(c3) when mouse moves on the grid, show the prompting frame of all other numerical value train values that comprise its correspondence.
3, a kind of data visualisation system can be expressed at least two numerical value row in the form simultaneously, it is characterized in that:
(a) the input data are forms, the row that comprise an expression geographic area, these row are also referred to as the area attribute row, the value of zone row is unique, and the two or more numerical value row on the respective regions, and another form that comprises the geographic area and represent the polygonal vertex data on its border;
(b) be output as the map that comprises relevant geographic area, each regional Fill Color is represented the value of a numerical value row A of its correspondence in the map, is called the colorimetric map;
(c) use one of following mode to represent the data of other numerical value row, be called enhancement mode colorimetric map:
(c1) increase one or more patterns in the grid, the size of pattern, the another one of reflection respective regions correspondence or the difference of a plurality of numerical value train values, if only need represent the value of another one numerical value row B, can represent different values respectively with different patterns, the perhaps value of these numerical value row of Direct Mark B in grid, these patterns can be geometric figures such as circle, rectangle, also can be non-geometric figures such as humanoid pattern;
(c2) also can represent the value that the one or more numerical value except that A are listed as with bar shaped or column diagram, wherein each series is represented numerical value row, do not need unified linear module between the series, as long as in bar shaped or column diagram, express each data value with respect to the relative size between other data of its column;
(c3) when mouse moves on the grid, show the prompting frame of all other numerical value train values that comprise its correspondence.
4, a kind of data visualisation system can be expressed at least two numerical value row in the form simultaneously, it is characterized in that:
(a) input is a form, contain two or more discrete columns, they can determine any data line in the input form together uniquely, be called attribute column, contain one or above numerical value row in addition, these numerical value row can disperse, and also can be continuous, and the user need specify one or more numerical value to classify as and play up row;
(b) be output as tabulation, gauge outfit is used for placing each row row name, the corresponding each row of data of placing in the input data table of each row of back;
(c) play up carrying out background color according to its value and filling of row, background color changes with the variation of value, is called background colour and plays up table.
5, a kind of data visualisation system can be expressed at least two numerical value row in the form simultaneously, it is characterized in that:
(a) the input data are forms, the attribute column that comprises two or more discrete types, they can determine any data line in the input form together uniquely, and one or more numerical value row, the user need specify a numerical value to classify first-selected numerical value row as, and crosstab data sink global schema;
(b) be output as crosstab, be called and play up contingency table, which attribute column the user can specify as wardrobe, and which attribute column is as the row head, and data rows is as column heading or row headers:
(b1) draw whole crosstab according to the normal crossing table, the numeral of data field is calculated according to the data sink global schema;
(b2) play up carrying out background color according to its value and filling of the corresponding grid of row, background color changes with the variation of value, is called background colour and plays up crosstab.
6, as system as described in the claim 1 to 5, it is characterized in that:
(a) when numerical value row A is expression number percent digital, the size of the size of color gray scale projection numeral, perhaps the size of color wavelength is anti-or to reflect the people of numeral little;
(b) when numerical value row A be that expression is common when digital, find out the minimum and maximum value of this column of figure, be expressed as 1 and 0 respectively, other values are scaled between 1 and 0, with the digital size of size projection of color gray scale, perhaps reflect the size of numeral then with the size of color wavelength;
(c) when numerical value row A is discrete value, according to what of discrete value, what system generated respective numbers has notable difference color value, respectively corresponding each value.
7, a kind of data visualisation system can be expressed at least two numerical value row in the form simultaneously, it is characterized in that:
(a) the input data are forms, the attribute column that comprises two or more discrete types, they can determine any data line in the input form together uniquely, and one or more numerical value row, the user need specify an attribute to classify category column as, when surpassing two attribute column, also can specify a plurality of attribute column to be listed as assembled classification, perhaps specify one or more classifying as to analyze the grouping row, remaining attribute is classified the analytic attribute row as;
(b) be output as crosstab, be called contingency table:
(b1) the row head shows the value of category column or assembled classification row, the row name of wardrobe display analysis attribute column, or the value of the row display analysis of wardrobe front grouping row, the row name of last row display analysis attribute column;
(b2) other grid show according to contrast bar chart as described below or contrast column diagram:
(b2.1) value of the analytic attribute of grid correspondence constitutes the coordinate figure of classification axle;
(b2.2) each series is represented numerical value row;
(b2.3) each bar or post comprise two parts, part represents the respective value row overall or gather value V by analyzing the grouping column split on the correspondence analysis property value, and another part represent the respective value row overall or gather value V by the analysis column split of dividing into groups on correspondence analysis property value and classification value or assembled classification value
*, being shown as one than comprising another the wide bar or post at the end altogether in long bar or the post, the ratio of length is listed as corresponding V and V
*Ratio.
8, the expansion of the described system of claim 7 is characterized in that:
(a) increase an input form, comprise the importance of each analytic attribute, or each analytic attribute is analyzed importance in the grouping with respect to each classification value or assembled classification value at each with respect to each classification value or assembled classification value;
(b) when click was listed as the grid at certain classification value place of head, each display line was according to the attribute importance ranking with respect to this classification value.
9, a kind of data visualisation system is characterized in that:
(a) the input data are a query sentence of database or database table name/view name, are called detail list;
(b) parameter comprises displaying scheme (user selects and belongs to displaying scheme in the described system of claim 1 to 8 or other can express the displaying scheme of multi-column data simultaneously), shows related packet attributes row, gathers the one or more summary column and the corresponding data sink global schema thereof of generation according to the packet attributes column split, and gathering scheme can be a formula even one section program;
(c) form of forming with (b) definite packet attributes row and summary column is as the required input of (b) selected displaying scheme, and on this basis, further sets and show that required attribute column and numerical value are listed as, and the required parameter of other displayings;
(d) when the user chooses figure that the setting according to (c) shows or the one or more zone in 2 forms, can select following action:
(d1) generated query or check the action of corresponding detailed data is called the focus inquiry, and the zone of choosing is called focus;
(d2) action of statistical study is called the focus statistics;
(d3) action of cluster analysis is called the focus cluster.
10, realize the method for the described system of claim 9, it is characterized in that visuals adopts model-view-control model, model part comprises the data structure of an expression selected areas.
11, realize the method for the described system of claim 9, it is characterized in that when the user selects claim 1 or 3 described displaying schemes that employing is as figure below drafting flow process:
(a) drawing is prepared, and carries out necessary calculating, comprises the graphic presentation ratio, and for the enhancement mode hotspot graph, all values in the X row removes repetition values, forms abscissa value, and all values during Y is listed as removes repetition values, forms ordinate value;
(b) fill drawing area with background colour;
(c) graphing itself:
(c1),, draw coordinate axis according to coordinate figure for the enhancement mode hotspot graph, promptly draw coordinate figure, draw each grid then, i.e. the value that is listed as according to A in the relevant position, calculate Fill Color, fill rectangle, then the value that is listed as according to other numerical value with it, and be provided with, draw corresponding text or figured value, perhaps draw bar chart, column diagram, last, draw the frame of each grid, i.e. mesh lines;
(c2) for enhancement mode colorimetric map, tables of data is drawn each zone according to the map, according to the value of A row, calculate Fill Color, use its filled polygon, the value that is listed as according to other numerical value, and setting then, draw corresponding text or figured value, perhaps draw bar chart, column diagram, last, the border of drawing All Ranges;
(d) draw selected areas;
(e) draw modified regions, such as legend etc.;
(f) draw mouse sheet favored area.
12, realize the method for the described system of claim 2, it is characterized in that adopting Java Swing form component, each each data train value of row is concentrated and is shown with a single data structural table, make the cell that as a whole correspondence represents form, present this data structure with the self-defining assembly that presents, attribute column uses the default assembly that presents to handle.
13, realize the method for the described system of claim 6, it is characterized in that adopting Java Swing form component, V on each series and V
*Concentrate and to show with a single data structural table, make the cell that as a whole correspondence represents form, with the self-defining assembly that presents, promptly contrast bar chart or contrast column diagram and present this data structure, the default assembly that presents of attribute column use is handled.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA200810037054XA CN101576881A (en) | 2008-05-07 | 2008-05-07 | Data visualization system and realization method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA200810037054XA CN101576881A (en) | 2008-05-07 | 2008-05-07 | Data visualization system and realization method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101576881A true CN101576881A (en) | 2009-11-11 |
Family
ID=41271815
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA200810037054XA Pending CN101576881A (en) | 2008-05-07 | 2008-05-07 | Data visualization system and realization method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101576881A (en) |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102542580A (en) * | 2010-12-14 | 2012-07-04 | 上海三旗通信科技股份有限公司 | Drawing board function based on cells |
| CN103425781A (en) * | 2013-08-20 | 2013-12-04 | 北京国双科技有限公司 | Data processing method and device for column position in table on software interface |
| CN103778140A (en) * | 2012-10-22 | 2014-05-07 | 苏州市迅泰信息科技有限公司 | Application process operation mode based visual data acquisition method |
| CN104216922A (en) * | 2013-06-05 | 2014-12-17 | 腾讯科技（深圳）有限公司 | Data screening method and device |
| CN104239319A (en) * | 2013-06-16 | 2014-12-24 | 倪成胜 | Data analysis method |
| CN104239025A (en) * | 2013-06-20 | 2014-12-24 | 深圳市华傲数据技术有限公司 | Form lead fixing method and form lead fixing device |
| CN104462691A (en) * | 2014-12-09 | 2015-03-25 | 广州大学 | Method and device for implementation of intelligent drawing with mouse in dynamic geometric software |
| CN104685496A (en) * | 2012-09-28 | 2015-06-03 | 甲骨文国际公司 | Pruning disk blocks of a clustered table in a relational database management system |
| CN105005550A (en) * | 2014-04-18 | 2015-10-28 | 腾讯科技（深圳）有限公司 | Table generation method and apparatus |
| CN106682231A (en) * | 2017-01-10 | 2017-05-17 | 深圳淞鑫金融服务科技发展有限公司 | Graphical visual display method and device for big data |
| CN106688002A (en) * | 2014-09-09 | 2017-05-17 | 英特格拉托公司 | Simulation system, simulation method, and simulation program |
| CN107256229A (en) * | 2017-05-02 | 2017-10-17 | 上海斐讯数据通信技术有限公司 | A kind of successive value measurement statistical method and system |
| CN107358456A (en) * | 2017-05-27 | 2017-11-17 | 无锡雅座在线科技股份有限公司 | Data show method and apparatus |
| CN107367755A (en) * | 2016-05-11 | 2017-11-21 | 中国石油化工股份有限公司 | A kind of improved multi-parameter crossplot method for drafting |
| CN107632998A (en) * | 2017-07-24 | 2018-01-26 | 电子科技大学 | A kind of multidimensional data visualization method based on human figure |
| CN107688600A (en) * | 2017-07-12 | 2018-02-13 | 百度在线网络技术（北京）有限公司 | Knowledge point method for digging and device |
| US9922139B2 (en) | 2013-06-05 | 2018-03-20 | Tencent Technology (Shenzhen) Company Limited | Method and device for data screening |
| CN108845850A (en) * | 2017-08-21 | 2018-11-20 | 中云开源数据技术（上海）有限公司 | A kind of method for visualizing and system of discrete data |
| CN110413605A (en) * | 2018-04-26 | 2019-11-05 | 中移(苏州)软件技术有限公司 | A kind of method and apparatus of data visualization |
| CN111159502A (en) * | 2019-12-27 | 2020-05-15 | 中国银行股份有限公司 | Data processing method and device for visual display |
| CN111445099A (en) * | 2019-01-17 | 2020-07-24 | 国网电子商务有限公司 | Industrial production data analysis method and system based on association rule |
| CN112507049A (en) * | 2020-11-19 | 2021-03-16 | 雾实(福建)科技有限公司 | Method, system, equipment and medium for transmitting satellite data in marine dynamic environment |
-
2008
- 2008-05-07 CN CNA200810037054XA patent/CN101576881A/en active Pending
Cited By (28)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102542580A (en) * | 2010-12-14 | 2012-07-04 | 上海三旗通信科技股份有限公司 | Drawing board function based on cells |
| CN104685496A (en) * | 2012-09-28 | 2015-06-03 | 甲骨文国际公司 | Pruning disk blocks of a clustered table in a relational database management system |
| CN104685496B (en) * | 2012-09-28 | 2018-03-06 | 甲骨文国际公司 | The disk block of cluster table is deleted in Relational DBMS |
| CN103778140A (en) * | 2012-10-22 | 2014-05-07 | 苏州市迅泰信息科技有限公司 | Application process operation mode based visual data acquisition method |
| CN103778140B (en) * | 2012-10-22 | 2017-04-05 | 苏州市迅泰信息科技有限公司 | A kind of visualization collecting method based on application flow operator scheme |
| CN104216922A (en) * | 2013-06-05 | 2014-12-17 | 腾讯科技（深圳）有限公司 | Data screening method and device |
| US9922139B2 (en) | 2013-06-05 | 2018-03-20 | Tencent Technology (Shenzhen) Company Limited | Method and device for data screening |
| CN104239319A (en) * | 2013-06-16 | 2014-12-24 | 倪成胜 | Data analysis method |
| CN104239025A (en) * | 2013-06-20 | 2014-12-24 | 深圳市华傲数据技术有限公司 | Form lead fixing method and form lead fixing device |
| CN104239025B (en) * | 2013-06-20 | 2018-03-13 | 深圳市华傲数据技术有限公司 | A kind of form fixes preposition treating method and apparatus |
| CN103425781B (en) * | 2013-08-20 | 2018-04-06 | 北京国双科技有限公司 | The data processing method and device of column position in software interface form |
| CN103425781A (en) * | 2013-08-20 | 2013-12-04 | 北京国双科技有限公司 | Data processing method and device for column position in table on software interface |
| CN105005550A (en) * | 2014-04-18 | 2015-10-28 | 腾讯科技（深圳）有限公司 | Table generation method and apparatus |
| CN106688002A (en) * | 2014-09-09 | 2017-05-17 | 英特格拉托公司 | Simulation system, simulation method, and simulation program |
| CN104462691A (en) * | 2014-12-09 | 2015-03-25 | 广州大学 | Method and device for implementation of intelligent drawing with mouse in dynamic geometric software |
| CN107367755A (en) * | 2016-05-11 | 2017-11-21 | 中国石油化工股份有限公司 | A kind of improved multi-parameter crossplot method for drafting |
| CN106682231A (en) * | 2017-01-10 | 2017-05-17 | 深圳淞鑫金融服务科技发展有限公司 | Graphical visual display method and device for big data |
| CN107256229A (en) * | 2017-05-02 | 2017-10-17 | 上海斐讯数据通信技术有限公司 | A kind of successive value measurement statistical method and system |
| CN107358456A (en) * | 2017-05-27 | 2017-11-17 | 无锡雅座在线科技股份有限公司 | Data show method and apparatus |
| CN107688600A (en) * | 2017-07-12 | 2018-02-13 | 百度在线网络技术（北京）有限公司 | Knowledge point method for digging and device |
| CN107632998A (en) * | 2017-07-24 | 2018-01-26 | 电子科技大学 | A kind of multidimensional data visualization method based on human figure |
| CN107632998B (en) * | 2017-07-24 | 2021-04-23 | 电子科技大学 | Human body form-based multidimensional data visualization method |
| CN108845850A (en) * | 2017-08-21 | 2018-11-20 | 中云开源数据技术（上海）有限公司 | A kind of method for visualizing and system of discrete data |
| CN110413605A (en) * | 2018-04-26 | 2019-11-05 | 中移(苏州)软件技术有限公司 | A kind of method and apparatus of data visualization |
| CN111445099A (en) * | 2019-01-17 | 2020-07-24 | 国网电子商务有限公司 | Industrial production data analysis method and system based on association rule |
| CN111159502A (en) * | 2019-12-27 | 2020-05-15 | 中国银行股份有限公司 | Data processing method and device for visual display |
| CN112507049A (en) * | 2020-11-19 | 2021-03-16 | 雾实(福建)科技有限公司 | Method, system, equipment and medium for transmitting satellite data in marine dynamic environment |
| CN112507049B (en) * | 2020-11-19 | 2022-06-17 | 雾实(福建)科技有限公司 | Method, system, equipment and medium for transmitting satellite data in marine dynamic environment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101576881A (en) | Data visualization system and realization method | |
| CN103064689B (en) | The implementation method of a kind of Dynamic Generating Report page and system | |
| AU2021204978B2 (en) | Using an object model of heterogeneous data to facilitate building data visualizations | |
| US8200618B2 (en) | System and method for analyzing data in a report | |
| CN102332056B (en) | Information visualization technology-based house property data visualization system | |
| CN102841938A (en) | Method and system for generating parameterized report | |
| US20130246484A1 (en) | Systems and Methods for Displaying Data in Split Dimension Levels | |
| US20070061611A1 (en) | Computer systems and methods for automatically viewing multidimensional databases | |
| CN104899288B (en) | Dimension hierarchical method for visualizing based on radial direction layout | |
| JP2008523473A (en) | Computer system and method for visualizing data using mark generation | |
| CN101268462A (en) | Building of database queries from graphical operations | |
| CN104317923A (en) | Method for presenting multi-dimensional data of regulation and control integrated systems of power grids | |
| US20070233666A1 (en) | Drilling on elements in arbitrary ad-hoc reports | |
| US8161374B2 (en) | Butterfly diagrams enabling multi-dimensional performance analysis | |
| CN110188435A (en) | A kind of ornamental plant intelligent selecting method based on Excel | |
| CN104866567A (en) | Method and apparatus for presenting business data | |
| CN114003621A (en) | Dynamic visualization method and system for regional carbon emission | |
| CN102509510A (en) | Interactive automatically updating method for legend content of electronic map | |
| CN108537441A (en) | Land Use Transition economic society Effect Evaluation and monitoring information integrated system | |
| CN113885859B (en) | Low-code report implementation method based on SIS production operation data | |
| CN110674195A (en) | Form-based query method | |
| CN111949658A (en) | Method for constructing operable graph perspective table facing data cube | |
| CN111797193A (en) | Farming and animal husbandry professional service industry distribution electronic map | |
| CN111400278B (en) | Method and system for constructing multi-level target crowd based on dragging of labels | |
| Bhatt et al. | HOW TO VISUALIZE YOUR BUSINESS INTELLIGENCE REPORT-A RESEARCH BASED STUDY. |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| DD01 | Delivery of document by public notice |
Addressee: Wan Dehong Document name: Notification of before Expiration of Request of Examination as to Substance |
|
| DD01 | Delivery of document by public notice |
Addressee: Wan Dehong Document name: Notification that Application Deemed to be Withdrawn |
|
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20091111 |