CN103530346A - Drawing method and system for converting data sheets into data visual graphs - Google Patents

Abstract

The invention provides a drawing method and system for converting data sheets into data visual graphs. The drawing method includes the steps that S1, a data base is selected; S2, the data sheets and data are extracted from the data base selected in the S1; S3, the data sheets and the data extracted in the S2 are stored as array variables; S4, data conversion is carried out on the array variables in the S3; S5, the data visual graphs are drawn according to practical situations of the array variables after data conversion in the S4. The system comprises a data base selecting module, a data extracting module, a data storing module, a data converting module and a data visual graph drawing module. The drawing method and system convert the data sheets into tables with the graphs and convert numerical data in all walks of life into graphic data, and in this way not only are advantages of graphs highlighted, but also advantages of the tables are reserved.

Description

A kind of method for drafting and system that tables of data is converted to data visual picture

Technical field

The present invention relates to graphics field, be specially a kind of method for drafting and system that tables of data is converted to visual picture.

Background technology

In the live and work of human society, there is a large amount of information.These information become the table in data form or database through rough handling.From tables of data, can carry out some and analyze, but not directly perceived, horizontal and vertical analysis is got up very hard.Graphic interpretation can show information better.Common histogram, broken line graph, curve map, sector diagram, 3 dimensional drawing, star-plot, radar map and the Qie Nuofu face graph etc. of the general employing of diagram of information.But too many for field, record too many data, these graphic techniques are with regard to crowded, the mutual covering that seems, directly perceived and make display effect very poor.

Size for each column data existing in some tables of data differs greatly, and the unit of each column data disunity again, causes this tables of data just just nonsensical on across comparison, can not reach desired effect.

Being not difficult to find out, also there is certain defect in prior art.

Summary of the invention

Technical matters to be solved by this invention is to provide a kind of form advantage that both had, and has again pattern drawing method and the system of figure advantage, i.e. a kind of method for drafting and system that tables of data is converted to data visual picture.

For achieving the above object, the invention provides following technical scheme:

A method for drafting that tables of data is converted to data visual picture, comprising:

S1. choose data village, often used in village names;

S2. in the database of choosing, extract tables of data and data from described S1;

S3. the tables of data extracting in described S2 and data are stored as to array variable;

S4. the array variable in described S3 is carried out to data transformation;

S5. according to the actual conditions drawing data visual picture that has carried out the array variable after data transformation in described S4.

Further, described data visual picture is two dimension (x, y) grid pattern, different grid cell position corresponding to (x, y), and different data present with the ellipse figure of different sizes in different grid cells.

Further, the array variable in described S3 is two-dimensional array, and tables of data described in S2 is deposited in two-dimensional array, and the ranks number in two-dimensional array is corresponding with the ranks number of described tables of data.

Further, the data transformation in described S4 comprises:

Longitudinal audio-visual picture data transformation: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

Further, the data transformation in described S4 comprises:

Horizontal audio-visual picture data transformation: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

Further, the data transformation in described S4 comprises:

Full table audio-visual picture data transformation: carry out standardization with extreme difference by full table, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n,1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

Further, described S5 comprises:

S51. the mesh lines of drawing data visual picture and sign, form each grid cell;

S52. longitudinal semiaxis of the corresponding ellipse of each data and horizontal semiaxis in specified data visual picture;

S53. in each grid cell according to data after S4 data transformation, and longitudinal semiaxis of the determined ellipse of described S52 and laterally semiaxis draw ellipse, form oval beading figure.

Further, described S5 also comprises:

S54. for time series data, oval beading figure Smoothing fit is become to curve, form evolution diagram.

Further, S52 is characterised in that:

The level altitude that longitudinally in audio-visual picture, longitudinal semiaxis of the corresponding ellipse of each data is corresponding grid cell, its horizontal semiaxis is the width that the data after longitudinal audio-visual picture data transformation are multiplied by corresponding grid cell;

The fixed width that laterally in audio-visual picture, the horizontal semiaxis of the corresponding ellipse of each data is corresponding grid cell, its longitudinal semiaxis is the height that the data after horizontal audio-visual picture data transformation are multiplied by described grid cell;

In full table audio-visual picture, longitudinal semiaxis of the corresponding ellipse of each data is through the full data of showing after audio-visual picture data transformation, to be multiplied by the height of corresponding grid cell, and its horizontal semiaxis is for being multiplied by the width of corresponding grid cell through the full data of showing after audio-visual picture data transformation.

In method, by user, provide the maximum normal number (be greater than all plotting of this numerical value full lattice oval) of drawing and minimum normal number (be less than this numerical value all plot minimum ellipse), solve the less indivedual larger showing problems of data subject and data subject less data display problems greatly individually.

A system that data Yuan is converted to data visual picture, comprising:

Database is selected module, for selecting all databases that need to carry out the conversion of data visual picture;

Data extraction module, for extracting data Yuan and the data of the selected database of described database selection module;

Data memory module, is stored as array variable for tables of data and the data that described data extraction module is extracted;

Data transformation module, for carrying out data transformation by the array variable of storing in described data memory module;

Data visual picture drafting module, for the actual conditions drawing data visual picture according to the array variable after data transformation in described data transformation module.

Further, described data visual picture is two dimension (x, y) grid pattern, different grid cell position corresponding to (x, y), and different data present with the ellipse figure of different sizes in different grid cells.

Further, the array variable in described data memory module is two-dimensional array, and tables of data described in S2 is deposited in two-dimensional array, and the ranks number in two-dimensional array is corresponding with the ranks number of described tables of data.

Further, described data transformation module comprises:

Longitudinal audio-visual picture data transformation submodule: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Further, described data transformation module comprises:

Horizontal audio-visual picture data transformation submodule: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Further, described data transformation module comprises:

Full table audio-visual picture data transformation submodule: carry out standardization with extreme difference by full table, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n,1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

Further, described data visual picture drafting module comprises:

Audio-visual picture framework rendering submodule: mesh lines and sign for drawing data visual picture, form each grid cell;

Ellipse size is determined submodule: for the size of the oval longitudinal semiaxis of specified data audio-visual picture and horizontal semiaxis;

Oval beading rendering submodule: in each grid cell according to the data after described data transformation module data transformation, and described oval size determine longitudinal semiaxis of the determined ellipse of submodule and laterally semiaxis draw ellipse, form oval beading figure.

Further, described data visual picture drafting module also comprises:

Evolution diagram rendering submodule, in time series data, becomes curve by oval beading figure Smoothing fit, forms evolution diagram.

Further, described oval size determines that submodule comprises:

The oval big or small determining unit of longitudinal audio-visual picture: for determining the size of the corresponding ellipse of each data of longitudinal audio-visual picture; The level altitude that its longitudinal semiaxis is corresponding grid cell, its horizontal semiaxis is the width that the data after longitudinal audio-visual picture data transformation are multiplied by corresponding grid cell.

The oval big or small determining unit of horizontal audio-visual picture: for determining the size of the corresponding ellipse of each data of horizontal audio-visual picture; The fixed width that its horizontal semiaxis is corresponding grid cell, its longitudinal semiaxis is the height that the data after horizontal audio-visual picture data transformation are multiplied by corresponding grid cell.

The oval big or small determining unit of full table audio-visual picture: for determining the size of the corresponding ellipse of full table audio-visual picture different pieces of information; Its longitudinal semiaxis is for being multiplied by the height of corresponding grid cell through the full data of showing after audio-visual picture data transformation, its horizontal semiaxis is the width that the data after full table audio-visual picture data transformation are multiplied by corresponding grid cell.

In system, by user, provide the maximum normal number (be greater than all plotting of this numerical value full lattice oval) of drawing and minimum normal number (be less than this numerical value all plot minimum ellipse), solve the less indivedual larger showing problems of data subject and data subject less data display problems greatly individually.

The present invention is by longitudinal audio-visual picture data transformation submodule, laterally audio-visual picture data transformation submodule, audio-visual picture data transformation submodule are comprehensively set, and longitudinally the oval big or small determining unit of audio-visual picture, laterally the oval big or small determining unit of audio-visual picture, entirely show the oval big or small determining unit of audio-visual picture; By the digital representation in traditional data table, be converted into the form of expression of figure, and the mesh model that has retained legacy data table, allow people when analyzing various data, can not only from oval size, judge intuitively the height and size of data, but also the grid advantage of having preserved traditional data table.

Accompanying drawing explanation

In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.

A kind of outline flowchart that tables of data is converted to the method for drafting of data visual picture that Fig. 1 provides for the embodiment of the present invention;

Fig. 2 is the detail flowchart of S5 in Fig. 1;

Fig. 3 is a kind of structured flowchart that tables of data is converted to the system of data visual picture that the embodiment of the present invention provides;

Fig. 4 is the structured flowchart of data transformation module and data visual picture drafting module in Fig. 3.

Fig. 5 to Figure 11 is the audio-visual picture that in embodiment, data are changed according to the present invention.Specific as follows:

The longitudinal audio-visual picture example of Fig. 5--west-bank economic region's prefectures and cities' major economic indicators in 2011;

The longitudinal audio-visual picture example of Fig. 6 time series--10 economic targets of Hunan 1988-2002;

Longitudinally level and smooth audio-visual picture example--10 economic targets of Hunan 1988-2002 of Fig. 7 time series;

Longitudinally level and smooth filling audio-visual picture example--10 economic targets of Hunan 1988-2002 of Fig. 8 time series;

The horizontal audio-visual picture example of Fig. 9--China in 2004 urban households situation;

Laterally level and smooth filling audio-visual picture example--the China in 2004 urban households situation of Figure 10;

Figure 11 shows audio-visual picture example entirely--western 11 provinces and regions 1991-2004 GDP per capitas (unit)

Embodiment

For making object, technical scheme and the advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention and accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described.It should be noted that, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.

Embodiment

It should be noted that, all data visual pictures that relate to are two dimension (x herein, y) grid pattern, different (x, y) corresponding different grid cell position, different data present with the figure of different sizes in different grid cells, and the present embodiment is the oval figure as data preferably.

As shown in Figure 1, a kind of method for drafting that tables of data is converted to data visual picture that the present embodiment provides, comprising:

S5. choose database; It should be noted that, selected database includes but not limited to following database herein: SQL Server, MySQL, 0racle, Excel, Access.

S2. in the database of choosing, extract tables of data and data from described S1.

As preferably, described in S2, tables of data comprises: the 1. Sheet in Excel file, the first behavior field (column), all the other behavior records (sample), in tables of data, should there be row to there are the row that are equivalent to catalogue number(Cat.No.) of identification record (sample) uniqueness, all the other should be computable numeric type data for the row of drawing, rather than incalculable letter or word; 2. the table in access file database; 3. the table in the database such as SQL Server, MySQL, 0racle.Table in the databases such as Access, SQL Server, MySQL, Oracle, similar with the table in Excel, there are field (column) and record (sample).

As preferably, if while adopting Excel or Access database, can directly Excel and Access data file be uploaded and extract tables of data; If while adopting SQL Server, MySQL, oracle database, type, title, user name, password and the server ip address etc. of adopted database must be provided, obtain database, extract after table name, and then obtain data subsegment and data.

S3. the tables of data extracting in described S2 and data are stored as to array variable; It should be noted that, the array variable in described S3 is two-dimensional array, and the tables of data of extracting in S2 is deposited in two-dimensional array, and the ranks number in two-dimensional array is corresponding with the ranks number of described tables of data.

In described S2, extract after tables of data and data, can select data field and record, according to self-demand, need which data just to select which data, the content of selected data field and record is stored as to array variable; Above-mentioned tables of data is stored in two-dimensional array, and its ranks number is corresponding with tables of data; If replace by one-dimension array, there are how many columns, just should there be how many one-dimension array.Direct access according to the data in table also draw can, just when drawing by circulation, expression data and usage data are more numerous.

S4. the array variable in described S3 is carried out to data transformation; It should be noted that, data transformation herein can be the data transformation of various ways, and as preferably, the present embodiment provides following three kinds of data transformation modes:

The first: longitudinal audio-visual picture data transformation:

If the raw data matrix of x to be n capable m row, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, longitudinally audio-visual picture data transformation carries out standardization with extreme difference by row, and its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Be about in this column data maximum number and deduct after minimum number as denominator, the Arbitrary Digit that will convert deducts after this row minimum number as molecule, and the value of trying to achieve whole expression formula is the value after longitudinal audio-visual picture data transformation.Data, after longitudinal audio-visual picture data transformation, become 1 by the maximum data of every row, and minimum data becomes 0, and remainder data value is between 0～1.

The second: horizontal audio-visual picture data transformation:

If the raw data matrix of x to be n capable m row, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, laterally audio-visual picture data transformation carries out standardization with extreme difference by row, and its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Different from described longitudinal audio-visual picture data transformation, laterally in audio-visual picture data transformation formula, row maximal value and row minimum value are all under every row i determines, in j field value, try to achieve.Be about in the row data maximum number and deduct after minimum number as denominator, the Arbitrary Digit that will convert deducts after this row minimum number as molecule, and the value of trying to achieve whole expression formula is the value after conversion.After conversion, the maximum data of every row is become to 1, minimum data becomes 0, and remainder data value is between 0～1.

The third: entirely show audio-visual picture data transformation:

If the raw data matrix of x to be n capable m row, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, entirely show audio-visual picture data transformation and carry out standardization with extreme difference by full table, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n,1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m$

By double program loop, find out full table maximal value and minimum value, by its difference, as denominator, then recirculate and deduct full table minimum value as molecule with the number that each will convert by two, the value of obtaining expression formula is the data after full table audio-visual picture data transformation.After full table data transformation, the maximum data of full table becomes 1, and minimum data becomes 0, and remainder data value is between 0～1.

S5. according to the actual conditions drawing data visual picture that has carried out the array variable after data transformation in described S4.

As shown in Figure 2, as preferably, described S5 comprises:

S51. the mesh lines of drawing data visual picture and sign; It should be noted that, drawing mesh lines herein and identifying is the framework for specified data audio-visual picture; It should be noted that the grid of drawn data audio-visual picture and original tables of data obtain in correspondence with each other, the amount of capacity of grid (being line number and columns) is identical; Form outside is directly drawn or be put into sign (being catalogue number(Cat.No.) or recording mechanism) in form, and field name (column name) also can be placed on first trip or the form top of audio-visual picture.The corresponding grid cell of each data is equally large, and the length and width of the data audio-visual picture of drawing depend on the size of customized whole figure.

S52. longitudinal semiaxis of the corresponding ellipse of each data and horizontal semiaxis in specified data audio-visual picture.

As preferably, corresponding with longitudinal audio-visual picture data transformation mentioned above, described S52 comprises:

The level altitude that longitudinally in audio-visual picture, longitudinal semiaxis of the corresponding ellipse of each data is corresponding grid cell, its horizontal semiaxis is the width that the data after longitudinal audio-visual picture data transformation are multiplied by corresponding grid cell.

As preferably, corresponding with horizontal audio-visual picture data transformation mentioned above, described S52 comprises:

The fixed width that laterally in audio-visual picture, the horizontal semiaxis of the corresponding ellipse of each data is corresponding grid cell, its longitudinal semiaxis is the height that the data after horizontal audio-visual picture data transformation are multiplied by described grid cell.

As preferably, corresponding with full table audio-visual picture data transformation mentioned above, described S52 comprises:

In full table audio-visual picture, longitudinal semiaxis of the corresponding ellipse of each data is through the full data of showing after audio-visual picture data transformation, to be multiplied by the height of corresponding grid cell, and its horizontal semiaxis is for being multiplied by the width of corresponding grid cell through the full data of showing after audio-visual picture data transformation.

S53. in each grid cell according to data after S4 data transformation, and longitudinal semiaxis of the determined ellipse of described S52 and laterally semiaxis draw ellipse, form oval beading figure.

That is, in conjunction with through S4, original tables of data being carried out to the data after data transformation, and longitudinal semiaxis of the determined ellipse of described S52 and laterally semiaxis draw ellipse, thereby form oval beading figure.Originally the data in tables of data have changed the ellipse of response data relative size into, make data variation rule very clear, and can compare the rate of change of adjacent beads.

As preferably, described S5 also comprises:

S54. for time series data, oval beading figure both sides Smoothing fit is become to curve, form evolution diagram.The fact that more directly reflects data variation.

In method and system, by user, provide the maximum normal number (be greater than all plotting of this numerical value full lattice oval) of drawing and minimum normal number (be less than this numerical value all plot minimum ellipse), solve the less indivedual larger showing problems of data subject and data subject less data display problems greatly individually.

For a kind of method for drafting that tables of data is converted to data visual picture that makes that the present embodiment provides is more easily understood, at the several examples of this measure, describe.The size of each instance graph, color, font are for black and white, to be printed conveniently here by user configured, have selected simple tone.

1) longitudinal audio-visual picture, data are as shown in table 1, laterally cannot contrast, longitudinally can contrast, be applicable to doing longitudinal audio-visual picture, by implementing a kind of software of said system, press prompting step-by-step operation drafting pattern 5, can clearly be seen that Hai Xi four little dragons Foochow, Xiamen, Quanzhou and Wenzhou.Time series data as shown in table 2 can be found out longitudinal variation tendency of Fig. 6.Beading both sides are just formed to Fig. 7 with curve, then carry out can obtaining Fig. 8 after filling.Figure after curve fit is level and smooth can clearly reflect variation tendency.

Table 1 west-bank economic region prefectures and cities' major economic indicators in 2011

10 economic targets of table 2 Hunan 1988-2002

2) horizontal audio-visual picture, data as shown in table 3, longitudinally cannot contrast, and laterally can contrast, and are applicable to doing the horizontal audio-visual picture of Fig. 9, after curve and level and smooth filling as Figure 10.

Table 3 China in 2004 urban households situation

3) entirely show audio-visual picture, data as shown in table 4, full list position is consistent, and vertical and horizontal can contrast, and are applicable to doing the full table audio-visual picture of Figure 11.

The western 11 provinces and regions 1991-2004 GDP per capitas (unit) of table 4

Time	Guangxi	Sichuan	Guizhou	Yunnan	Tibet	Shaanxi	Gansu	Qinghai	Ningxia	Inner Mongol	Xinjiang
													2001	7196	8113	1215	6733	7779	7757	5970	8606	7880	11305	11199
2003	5964	6418	3601	5647	6874	6180	4984	7276	6685	8734	9686
												2002	5062	5766	3140	5178	5983	5523	4493	6424	5800	7233	8365
2001	4668	5250	2895	1866	5307	5024	4163	5735	5340	6463	7913
												2000	4319	4784	2662	4637	4559	4549	3838	5087	4839	5872	7470
1999	4148	4452	2475	4452	4262	4101	3668	4662	4473	5350	6470
												1998	4076	4339	2342	4355	3716	3834	3456	4367	4270	5068	6229
1997	4356	4029	2215	4042	3194	3707	3137	4066	4025	4691	5904
												1996	4081	3763	2093	3715	2732	3313	2901	3748	3731	4259	5167
1995	3304	3081	1853	3044	2392	2843	2288	3430	3328	3639	4819
												1994	2772	2516	1553	2490	1984	2344	1925	2910	2685	3013	3953
1993	2031	1911	1034	2006	1642	1041	1600	2337	2123	2382	2980
												1992	1318	1356	1009	1334	1233	1458	1314	1821	1635	1712	2458
1991	1058	1180	890	1147	1388	1292	1133	1592	1451	1466	2047

As shown in Figure 3 and Figure 4, the present embodiment also provides a kind of system that tables of data is converted to data visual picture, comprising:

Database is selected module, for selecting all databases that need to carry out the conversion of data visual picture; Selected database includes but not limited to following database herein: SQL Server, MySQL, Oracle, Excel, Access.

Data extraction module, for extracting tables of data and the data of the selected data village, often used in village names of described database selection module; As preferably, tables of data in described data extraction module comprises: the 1. Sheet in Excel file, the first behavior field (column), all the other behavior records (sample), the catalogue number(Cat.No.) that is equivalent to that should have row to have identification record (sample) uniqueness in tables of data is listed as, all the other should be computable numeric type data for the row of drawing, rather than incalculable letter or word; 2. the table in access file database; 3. the table in the database such as SQL Server, MySQL, Oracle.Table in the data village, often used in village names such as Access, SQL Server, MySQL, Oracle, similar with the table in Excel, there are field (column) and record (sample).

As preferably, if while adopting Excel or Access database, can be directly using Excel and Access database as tables of data; If while adopting SQL Server, MySQL, oracle database, type, title, user name, password and the server ip address etc. of adopted database must be provided, obtain database, extract after table name, and then obtain tables of data title, data field and data.

Data memory module, is stored as array variable for tables of data and the data that described data extraction module is extracted; As preferably, described array variable is two-dimensional array, and the tables of data of extracting in described data extraction module is deposited in two-dimensional array, and the ranks number in two-dimensional array is corresponding with the ranks number of described tables of data.

In described data extraction module, extract after tables of data and data, can select data field record, according to self-demand, need which data just to select which data, the content of selected data field and record is stored as to array variable; Above-mentioned tables of data is stored in two-dimensional array, and its ranks number is corresponding with tables of data; If replace by one digit number group, there are how many columns, just should there be how many one-dimension array.Direct access according to the data in table also draw can, just when drawing by circulation, expression data and usage data are more numerous

Data transformation module, for carrying out data transformation by the array variable of storing in described data memory module.

As preferably, described data transformation module comprises:

Longitudinal audio-visual picture data transformation submodule: if the raw data matrix of the x capable m row that are n at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, longitudinally audio-visual picture data transformation carries out standardization with extreme difference by row, and its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Be about in this column data maximum number and deduct after minimum number as denominator, the Arbitrary Digit that will convert deducts after this row minimum number as molecule, and the value of trying to achieve whole expression formula is the value after longitudinal audio-visual picture data transformation.Data, after longitudinal audio-visual picture data transformation, become 1 by the maximum data of every row, and minimum data becomes 0, and remainder data value is between 0～1.

As preferably, described data transformation module comprises:

Horizontal audio-visual picture data transformation submodule:

If the raw data matrix of x to be n capable m row, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, laterally audio-visual picture data transformation carries out standardization with extreme difference by row, and its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Different from described longitudinal audio-visual picture data transformation, laterally in audio-visual picture data transformation formula, row maximal value and row minimum value are all under every row i determines, in j field value, try to achieve.Be about in the row data maximum number and deduct after minimum number as denominator, the Arbitrary Digit that will convert deducts after this row minimum number as molecule, and the value of trying to achieve whole expression formula is the value after conversion.After conversion, the maximum data of every row is become to 1, minimum data becomes 0, and remainder data value is between 0～1.

As preferably, described data transformation module comprises:

Full table audio-visual picture data transformation submodule:

If the raw data matrix of x to be n capable m row, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, entirely show audio-visual picture data transformation and carry out standardization with extreme difference by full table, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n,1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m$

By double program loop, find out full table maximal value and minimum value, by its difference, as denominator, then recirculate and deduct full table minimum value as molecule with the number that each will convert by two, the value of obtaining expression formula is the data after full table audio-visual picture data transformation.After full table data transformation, the maximum data of full table becomes 1, and minimum data becomes 0, and remainder data value is between 0～1.

Data visual picture drafting module, for the actual conditions drawing data visual picture according to the array variable after data transformation in described data transformation module.

As preferably, described data visual picture drafting module comprises:

Audio-visual picture framework rendering submodule: for drawing data mesh lines and the sign of visual picture by all means; It should be noted that, drawing mesh lines herein and identifying is the framework for specified data audio-visual picture; It should be noted that the grid of drawn data audio-visual picture and original tables of data obtain in correspondence with each other, the amount of capacity of grid (being line number and columns) is identical; Sign (being catalogue number(Cat.No.) or recording mechanism) is directly drawn very directly perceived in form, and the corresponding grid cell of each data is equally large, and the length and width of the data audio-visual picture of drawing depend on the size of customized whole figure.

Ellipse size is determined submodule: for the size of the oval longitudinal semiaxis of specified data audio-visual picture and horizontal semiaxis.

As preferably, described oval size determines that submodule comprises:

The oval big or small determining unit of longitudinal audio-visual picture: for determining the size of the corresponding ellipse of each data of longitudinal audio-visual picture; The level altitude that its longitudinal semiaxis is corresponding grid cell, its horizontal semiaxis is the width that the data after longitudinal audio-visual picture data transformation are multiplied by corresponding grid cell.

As preferably, described oval size determines that submodule comprises:

The oval big or small determining unit of horizontal audio-visual picture: for determining the size of the corresponding ellipse of each data of horizontal audio-visual picture; The fixed width that its horizontal semiaxis is corresponding grid cell, its longitudinal semiaxis is the height that the data after horizontal audio-visual picture data transformation are multiplied by corresponding grid cell.

Further, described oval size determines that submodule comprises:

The oval big or small determining unit of full table audio-visual picture: for determining the size of the corresponding ellipse of full table audio-visual picture different pieces of information; Its longitudinal semiaxis is for being multiplied by the height of corresponding grid cell through the full data of showing after audio-visual picture data transformation, its horizontal semiaxis is the width that the data after full table audio-visual picture data transformation are multiplied by corresponding grid cell.

Further, described oval size determines that submodule comprises:

Oval beading rendering submodule, be used in the data of foundation after described data transformation module data transformation in each grid cell, and described oval size determine longitudinal semiaxis of the determined ellipse of submodule and laterally semiaxis draw ellipse, form oval beading figure.

; in conjunction with through data transformation module, original tables of data being carried out to the data after data transformation; and described oval size determine submodule (longitudinally the oval big or small determining unit of audio-visual picture, laterally the oval big or small determining unit of audio-visual picture or entirely show the oval big or small determining unit of audio-visual picture) longitudinal semiaxis of determined ellipse and laterally semiaxis draw ellipse, thereby form oval beading figure.Originally the data in tables of data have changed the ellipse of response data relative size into, make data variation rule very clear, and can compare the rate of change of adjacent beads.

As preferably, described data visual picture drafting module also comprises:

Evolution diagram rendering submodule, in time series data, becomes curve by oval beading figure Smoothing fit, forms evolution diagram.For time series data, oval both sides can be carried out level and smooth or ellipse is filled and formed evolution diagram with curve.

The present invention is by longitudinal audio-visual picture data transformation submodule, laterally audio-visual picture data transformation submodule, audio-visual picture data transformation submodule are comprehensively set, and longitudinally the oval big or small determining unit of audio-visual picture, laterally the oval big or small determining unit of audio-visual picture, entirely show the oval big or small determining unit of audio-visual picture; By the numerical data form of expression in traditional data table, be converted into the form of expression of graph data, and the mesh model that has retained legacy data Yuan, allow people when analyzing various data, can not only from oval size, judge intuitively the height and size of data, and preserved traditional data Yuan's grid advantage, avoid the mutual crowded of histogram or stereographic map etc. and hidden phenomenon.Meanwhile, also solve not corresponding the causing of unit such as same column data and between data, there is no comparability and the property concluded.

In addition, for time series data, level and smooth or filling formation evolution diagram can be carried out to curve in oval both sides.

The above embodiment has only expressed one embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.

Claims (10)

1. tables of data is converted to a method for drafting for data visual picture, it is characterized in that, comprising:

S1. choose database;

S2. in the database of choosing, extract tables of data and data from described S1;

S3. the tables of data extracting in described S2 and data are stored as to array variable;

S4. the array variable in described S3 is carried out to data transformation;

S5. according to the actual conditions drawing data visual picture that has carried out the array variable after data transformation in described S4.

2. the method for drafting that tables of data is converted to data visual picture according to claim 1, it is characterized in that, array variable in described S3 is two-dimensional array, and tables of data described in S2 is deposited in two-dimensional array, and the ranks number in two-dimensional array is corresponding with the ranks number of described tables of data.

3. the method for drafting that tables of data is converted to data visual picture according to claim 2, is characterized in that, the data transformation in described S4 comprises:

Longitudinal audio-visual picture data transformation: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

Horizontal audio-visual picture data transformation: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

Full table audio-visual picture data transformation: carry out standardization with extreme difference by full table, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n,1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

4. the method for drafting that tables of data is converted to data visual picture according to claim 3, is characterized in that, described S5 comprises:

S51. the mesh lines of drawing data visual picture and sign, form each grid cell;

S52. longitudinal semiaxis of the corresponding ellipse of each data and horizontal semiaxis in specified data visual picture;

S53. in each grid cell according to data after S4 data transformation, and longitudinal semiaxis of the determined ellipse of described S52 and laterally semiaxis draw ellipse, form oval beading figure.

S54. for time series data, oval beading figure both sides Smoothing fit is become to curve, form evolution diagram.

5. the method for drafting that tables of data is converted to data visual picture according to claim 4, is characterized in that, S52 is characterised in that:

The level altitude that longitudinally in audio-visual picture, longitudinal semiaxis of the corresponding ellipse of each data is corresponding grid cell, its horizontal semiaxis is the width that the data after longitudinal audio-visual picture data transformation are multiplied by corresponding grid cell;

The fixed width that laterally in audio-visual picture, the horizontal semiaxis of the corresponding ellipse of each data is corresponding grid cell, its longitudinal semiaxis is the height that the data after horizontal audio-visual picture data transformation are multiplied by described grid cell;

In full table audio-visual picture, longitudinal semiaxis of the corresponding ellipse of each data is through the full data of showing after audio-visual picture data transformation, to be multiplied by the height of corresponding grid cell, and its horizontal semiaxis is for being multiplied by the width of corresponding grid cell through the full data of showing after audio-visual picture data transformation.

6. tables of data is converted to a system for data visual picture, it is characterized in that, comprising:

Database is selected module, for selecting all databases that need to carry out the conversion of data visual picture;

Data extraction module, for extracting tables of data and the data of the selected database of described database selection module;

Data memory module, is stored as array variable for tables of data and the data that described data extraction module is extracted;

Data transformation module, for carrying out data transformation by the array variable of storing in described data memory module;

Data visual picture drafting module, for the actual conditions drawing data visual picture according to the array variable after data transformation in described data transformation module.

7. the system that tables of data is converted to data visual picture according to claim 6, it is characterized in that, array variable in described data memory module is two-dimensional array, and tables of data described in S2 is deposited in two-dimensional array, and the ranks number in two-dimensional array is corresponding with the ranks number of described tables of data.

8. the system that tables of data is converted to data visual picture according to claim 7, is characterized in that, described data transformation module comprises:

Longitudinal audio-visual picture data transformation submodule: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Horizontal audio-visual picture data transformation submodule: carry out standardization with extreme difference by row, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m;$

Full table audio-visual picture data transformation submodule: carry out standardization with extreme difference by full table, establishing x is the raw data matrix of the capable m row of n, at this, represents x with two-dimensional array _ijmatrix element, x ' _ijbe the data after conversion, its algorithm is:

${x^{\′}}_{\mathrm{ij}}=\frac{x_{\mathrm{ij}}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}}{\underset{1\≤i\≤n,1\≤j\≤m}{\max \left(x_{\mathrm{ij}}\right)}-\underset{1\≤i\≤n,1\≤j\≤m}{\min \left(x_{\mathrm{ij}}\right)}},i=\mathrm{1,2},\·\·\·,n;j=\mathrm{1,2},\·\·\·,m.$

9. the system that tables of data is converted to data visual picture according to claim 8, is characterized in that, described data visual picture drafting module comprises:

Audio-visual picture framework rendering submodule: mesh lines and sign for drawing data visual picture, form each grid cell;

Ellipse size is determined submodule: for the size of the oval longitudinal semiaxis of specified data audio-visual picture and horizontal semiaxis;

Oval beading rendering submodule: in each grid cell according to the data after described data transformation module data transformation, and described oval size determine longitudinal semiaxis of the determined ellipse of submodule and laterally semiaxis draw ellipse, form oval beading figure;

Evolution diagram rendering submodule, in time series data, becomes curve by oval beading figure both sides Smoothing fit, forms evolution diagram.

10. the system that tables of data is converted to data visual picture according to claim 9, is characterized in that, described oval size determines that submodule comprises:

The oval big or small determining unit of longitudinal audio-visual picture: for determining the size of the corresponding ellipse of each data of longitudinal audio-visual picture; The level altitude that its longitudinal semiaxis is corresponding grid cell, its horizontal semiaxis is the width that the data after longitudinal audio-visual picture data transformation are multiplied by corresponding grid cell;

The oval big or small determining unit of horizontal audio-visual picture: for determining the size of the corresponding ellipse of each data of horizontal audio-visual picture; The fixed width that its horizontal semiaxis is corresponding grid cell, its longitudinal semiaxis is the height that the data after horizontal audio-visual picture data transformation are multiplied by corresponding grid cell;

The oval big or small determining unit of full table audio-visual picture: for determining the size of the corresponding ellipse of full table audio-visual picture different pieces of information; Its longitudinal semiaxis is for being multiplied by the height of corresponding grid cell through the full data of showing after audio-visual picture data transformation, its horizontal semiaxis is the width that the data after full table audio-visual picture data transformation are multiplied by corresponding grid cell.

Images