CN108280191A - The comparison visual analysis method and system of more areas MRL standards - Google Patents
The comparison visual analysis method and system of more areas MRL standards Download PDFInfo
- Publication number
- CN108280191A CN108280191A CN201810071737.0A CN201810071737A CN108280191A CN 108280191 A CN108280191 A CN 108280191A CN 201810071737 A CN201810071737 A CN 201810071737A CN 108280191 A CN108280191 A CN 108280191A
- Authority
- CN
- China
- Prior art keywords
- data
- circle
- agricultural product
- mrl
- user
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of more maximum Pesticide Residue (MRL) Comparison of standards visual analysis method and systems in area, by the top-down structure agricultural product classification tree of MRL normal datas, association comparative analysis, Detail contrast analysis, metrics evaluation comparative analysis and overall contrast analysis are realized in conjunction with interaction technique.System includes user interactive module, and user explores module, index computing module and index visualization model.The record number M of LPM indexs include the taxonomical hierarchy number L of agricultural product in data set, are related to pesticide number P, pesticide Limited Doses take weighting quantitatively to calculate LPM indexs, improve the precision of comparative analysis；Using nested circle, radar map, parallel coordinates and label-cloud, broken line column diagram and interaction technique, the difference for the Stringency that different regions are formulated in agricultural product classification situation, the coverage area of agricultural product MRL standards is quickly found.Present invention may also apply to the comparison visual analysis in dimension hierarchical data other application field.
Description
Technical field
The invention belongs to information visualization and technical field of food safety, relate generally to multinational more areas it is multigroup knit it is (following
Referred to as more areas) MRL standards comparison visual analysis method and system.
Background technology
Pesticide residue maximum limitation (Maxmum Residue Limits, abbreviation MRL) refers to the pesticide in certain agricultural product
Remaining legal maximum permissible concentration is calculated with the milligram number (mg/kg) of every kilogram of Residual Pesticides in Farm Produce.One MRL mark
Quasi- record refers to a kind of maximum Limited Doses of pesticide in some agricultural product.MRL standards reflect a state to a certain extent
Family, area, tissue are to the management level of Pesticide use.China's Mainland, Hong Kong, the U.S., Japan, European Union tissue (with
Lower abbreviation EUR) and Codex Alimentary Commission's tissue (hereinafter referred to as CAC) etc. all limit the quantity Residual Pesticides in Farm Produce and mark
Standard has stringent regulation.Since there are following several respects for the MRL standards in each area of the factor in geographical location or national conditions
Difference：
(1) the agricultural product type of each country tissue has differences, such as China's Mainland, Hong Kong, CAC
There is Chinese bush cherry, and EUR, Japan and the U.S. do not have this agricultural product；In addition to the U.S. does not have fig, China's Mainland, Hong-Kong
There are this agricultural product in area, CAC, EUR and Japan.
(2) each country tissue is different to the mode classification of same agricultural product, such as in China's Mainland, Chinese Fragrant
Port area and CAC in potato mode classification all be vegetables, root vegetables and tuber and tuberous rooted vegetables；EUR be classified as it is fresh or
Refrigerated vegetables class, root tuber and stem tuber vegetables；It is classified as potato in Japan；It is classified as vegetables, root and tubers vegetable in the U.S.
1 group of dish, stem tuber and corm kind vegetables 1C.
(3) quantity that in each country tissue MRL standards identical agricultural product are provided with pesticide Limited Doses is different,
The Limited Doses for such as giving 7 kinds of pesticides in the MRL standards of CAC to spinach, 17 are given in the MRL standards of Hong Kong
The Limited Doses of kind pesticide, the Limited Doses of 24 kinds of pesticides are given in U.S.'s MRL standards, are provided in the MRL standards of China's Mainland
The Limited Doses of 31 kinds of pesticides, the Limited Doses of 315 kinds of pesticides are given in Japanese MRL standards, are given in the MRL standards of EUR
The Limited Doses of 485 kinds of pesticides are gone out.
(4) maximum residue limit magnitude of the identical pesticide in identical agricultural product exists poor during each country is organized
It is different, it is EUR 0.01mg/kg, Japanese 0.1mg/kg, China respectively to the Limited Doses regulation of diazinon pesticides such as in spinach
Continent 0.5mg/kg, CAC 0.5mg/kg, U.S. 0.7mg/kg, Hong Kong does not provide this in spinach kind pesticide residue
Maximum limitation.
Due to more area MRL normal datas have dimension is more, the discrete distribution of attribute value, hierarchical structure complexity feature, adopt
It is not applicable that different attributes is showed with different visual coding modes, and first, the mode of visual coding is limited；Secondly, excessively
Complicated visual coding can cause visual confusion to user, reduce the readability of visualization scheme.Traditional tree structure can only
Single attribute is compared, Comprehensive Correlation can not be carried out in conjunction with multiple attributes；When data structure is complicated, larger,
The quantity for setting interior joint increases as index is presented in the increase of depth, causes the position remote from root node to be susceptible to overlapping existing
As manually carrying out comparison inefficiency using pure.In addition, there is presently no limited for more regional pesticide residues for field of food safety
Measure the comparison visual analysis method and system of MRL standards.
Invention content
In order to overcome the above-mentioned deficiencies of the prior art, the present invention provides a kind of comparison visual analysis of more areas MRL standards
Method and system.
The present invention proposes the comparison visual analysis method of the MRL standards of area more than one, including association comparative analysis, details pair
Than analysis, metrics evaluation comparative analysis and overall contrast analysis.First by one classification of top-down structure of MRL normal datas
Tree is visualized using nesting circle.Select a regional agricultural product, another area associated in the front view centre circle of nesting circle
Agricultural product are highlighted in auxiliary view, while generating parallel coordinates and label-cloud.It can be to 6 on the basis of association analysis
Area carries out details comparison, compares the MRL standard values of specific a certain agricultural product or pesticide.Metrics evaluation comparative analysis includes
The record of pesticide Limited Doses in pesticide number P, MRL standard in data set involved in taxonomical hierarchy number L, MRL standard of agricultural product
Number M.Broken line-column diagram can be from the concrete numerical value of 6 regional LPM indexs of overall contrast.The present invention also provides based on mostly
The comparison visual analysis system for more area MRL standards that the comparison visual analysis method of area's MRL standards is realized, including user's interaction
Module, user explore module, index computing module and index visualization model.The present invention can be towards the agriculture of field of food safety
Medicine residue limits MRL normal datas, library collection catalogue data, organization structure of the enterprise data etc. carry out dimension hierarchical data
Visual analysis is compared, different evaluation indexes is used according to the difference of data set and comparative analysis task.
Technical solution provided by the invention is as follows：
A kind of comparison visual analysis method of more areas MRL standards, the top-down structure classification tree of data set is (specific real
Apply and build an agricultural product classification tree for Pesticide Residue MRL normal datas), it reuses nested circle and is visualized；Knot
It closes interaction technique and is associated comparative analysis, Detail contrast analysis, metrics evaluation comparative analysis and overall contrast analysis；Including such as
Lower step：
A. Pesticide maximum residue limit initial data is pre-processed, is converted according to the mode classification of agricultural product
At the JSON formats with level inclusion relation, one classification tree of top-down structure specifically comprises the following steps：
A1. data prediction deletes the data of non-agricultural product class and non-fruits in initial data, while by pesticide
Maximum residue limit provide with the one-to-many relationship of agricultural product, be separated into one-to-one relationship, such as pesticide A, to agricultural product 1,
Agricultural product 2 and agricultural product 3 have maximum residue limit regulation respectively, are then maximum residue limits of the pesticide A to agricultural product 1 after separation
Gauge is fixed, pesticide A provides the maximum residue limit of agricultural product 2 and pesticide A provides the maximum residue limit of agricultural product 3；It is right
Pretreated data are converted to JSON formats, shaped like：
{‘name’:’XXX’,’children’:[{‘name’:’XXX’}]}
A2. transformed data in A1 are built into a classification tree, is visualized using nesting circle.
B. it is right comparative analysis, Detail contrast analysis, metrics evaluation comparative analysis and entirety to be associated in conjunction with interaction technique
Than analysis；
Specifically comprise the following steps：
B1. a regional agricultural product are selected in the front view centre circle of nesting circle, with the entitled conditional information retrieval number of agricultural product
Contingency table is generated according to relevant agricultural product MRL normal datas in library, it is in auxiliary view that another associated agricultural product in area are high
Bright display, while agricultural product, toxicity of pesticide type and the quantity involved in statistical correlation table generate label-cloud and parallel coordinates, it is real
Now it is associated with comparative analysis.
B2. the interactive mode that mouse can be used to click in the label-cloud that B1 is generated compares a certain agricultural product or agriculture
The specific MRL standard values of medicine generate the data that SQL statement inquires contingency table according to alternative condition, update parallel coordinates, and displaying is thin
Save the result of comparison.
B3. the data that user encloses choosing are directed to, the pesticide in the Count functions statistics MRL standards provided using database is made
For value of all records as M in the value of P, statistics MRL standards, using Sum functions by the taxonomical hierarchy number of each agricultural product
The value summed as L.It takes the mode of weighting quantitatively to calculate partial data collection the scoring of LPM indexs, considers three kinds of situations：
All data of partial data collection；Partial data concentrates the data after duplicate removal；What partial data concentration only occurred in an area
Data.Calculation：
S(L)=u1∑Xi+u2∑Yi+u3∑Zi
Wherein, S(L)Indicate the score of L indexs；XiIndicate the taxonomical hierarchy number of each agricultural product in all data；YiIt indicates
The taxonomical hierarchy number of each agricultural product in data after duplicate removal；ZiIndicate each agricultural product only in the data that an area occurs
Taxonomical hierarchy number；u1,u2,u3Indicate weight coefficient, default value 1；
Pesticide number and the record number of pesticide Limited Doses in MRL standards involved in MRL standards also use identical calculating side
Formula.The result that 3 indexs are obtained by calculation is last comprehensive score.User can voluntarily adjust any one index
Weight coefficient carries out the analysis of stressing property, realizes comparativeanalysis.
B4. by counted in B3 6 regional LPM indexs as a result, being shown by broken line-column diagram, in terms of macroscopic view
Carry out overall contrast analysis.
On the other hand, the specific generation step of the above-mentioned visualization result being related to is：
A. the classification tree of above-mentioned generation is visualized using the mode of nesting circle, the lasso trick work that user passes through toolbar
Tool circle selects interested part, specifically comprises the following steps：
A1. the data of the classification tree with hierarchical structure of above-mentioned generation are visualized using nesting circle algorithm, boundary
Face view is made of data screening frame circle nested with two.The border circular areas size of child node indicates all notes of the node
Item number is recorded, is arranged from big to small by helical form.Then the circumcircle of the border circular areas of all child nodes, the circle of father node are calculated
A diameter of circumscribed diameter of a circle in region, size are the sum of record numbers of its child node；Bottom-up recursive calculation is until root section
The circle of point is completed.
A2. user can use the lasso tool circle of toolbar to select interested data.First option in toolbar
It selects frame, third option that can repeatedly enclose for the circle that rectangular loop selects frame, second option is self-defined figure and selects data, the 4th choosing
Item has enclosed the data of choosing to remove.
A3. user can also use the highlighted classification situation for checking some attribute of mouse, when user's circle selects interested number
The MRL standard recording numbers for selecting each agricultural product in data have been enclosed according to rear prompting frame display user, generate contingency table.
B. the data of the contingency table generated in A are combined with label-cloud, parallel coordinates and carries out Detail contrast analysis, passed through a little
The data of the character can be mapped to parallel coordinates by the character hit in label-cloud, be specifically comprised the following steps：
B1. label-cloud is generated by nesting circle linkage, and the quantity of label-cloud is the type that user's circle selects data in nested circle, greatly
The small quantity for specific object.
B2. parallel coordinates represents different attributes by drawing the parallel reference axis of n items, is recorded according to every each
Attribute value in reference axis draws the curve across n reference axis from left to right.User can use mouse to click label-cloud and select
Select the attribute information for checking some label-cloud.
C. the LPM for counting and calculating refers to the scoring after target value and weighted calculation and uses radar map and broken line-column diagram
It is shown, specifically comprises the following steps：
C1. the top half of radar map indicates that scoring of the attribute in entire data set, lower half portion indicate to enclose in user
The scoring for selecting data is pesticide number involved in MRL standards respectively since clockwise, in MRL standards pesticide Limited Doses note
Record the taxonomical hierarchy number of number, agricultural product.Thermodynamic chart on the left of view illustrates u1,u2,u3Value, be respectively used to LPM indexs
It is weighted, user can be clicked by mouse and is adjusted.u1,u2,u3Value range be 0.1 to 10, default value 1.
C2. line chart indicates that the numerical value of 6 regional LPM indicator-specific statistics in entire data set, column diagram indicate user's circle
The numerical value of 6 regional LPM indicator-specific statistics in the data of choosing.Indicate successively from top to bottom be agricultural product taxonomical hierarchy number,
The record number of pesticide Limited Doses in pesticide number and MRL standards involved in MRL standards.Hover on column diagram as user or
On person's line chart some point when, prompting frame can show specific numerical value.
D. user's interactive visual technology.The present invention explores for the convenience of the user, analysis task provides data screening
Frame, mouse click, mouse-over, filtering, interactive mode circle choosing and be highlighted, specifically include following several respects：
(1) user needs the data checked by screening frame selection, is as a result illustrated in nested circle；
(2) user can further enclose and select interested part in nesting circle；
(3) specific attribute value can be checked using mouse-over in all Visual Charts.
(4) selection that classification in the weight coefficient and label-cloud of LPM indexs can be adjusted by mouse click user, from
And it links and generates parallel coordinates progress Detail contrast analysis.
The present invention also provides the comparison visual analysis systems of the MRL standards of area more than one, including user interactive module, use
Explore module, index computing module and index visualization model in family；User interactive module is explored by data screening frame and user
Mould mouse click in the block, filtering, circle choosing, is highlighted interactive mode composition at mouse-over；Module is explored to be regarded by nesting circle
Figure, parallel coordinates and label-cloud view form；Index computing module according to the conditional systems of user from background query database, and
Refer to target value using sum () function and count () function statistics LPM, in conjunction with user to the weight coefficient of each setup measures
It is weighted read group total；Index visualization model is made of radar map and thermodynamic chart view, broken line-column diagram view.Wherein,
Nesting circle is for the hierarchical structure of display data, parallel coordinates and radar map displaying multidimensional property, label-cloud and broken line-cylindricality
The size of figure displaying specific object value, it is visual compare that interaction technique helps user to drill down to the profound knowledge of excavation
Analysis.
System top half is made of data screening frame, nested circle view, thermodynamic chart and radar map view；User can lead to
Crossing data screening frame selects two areas compared, nesting circle view to show the classification tree generated in the first step, heating power
Figure can adjust the weight coefficient of index, and radar map shows the result of calculation of LPM indexs in two areas that user selects.System
Lower half portion is made of label-cloud and parallel coordinates view and broken line-column diagram view；Label-cloud is used to show that user to enclose choosing
The type and quantity of agricultural product and toxicity of pesticide involved in data, parallel coordinates are used to show the agricultural product of different regions
The distribution situation of MRL standard values, the statistical result of broken line-column diagram displaying LPM indexs.User by interactive module to data into
Row screening, and visualization request is sent out, it explores the corresponding nested circle of module generation, parallel coordinates and label-cloud, index and calculates mould
Block counts LPM and refers to target value accordingly, in conjunction with user in the interactive operation and thermodynamic chart Weight Coefficient of index for exploring module
Setting linkage generates radar map and broken line-column diagram visualizes evaluation index result.
For the comparison visual analysis method and system of above-mentioned more areas MRL standards, in the specific embodiment of the invention, attribute
For the agricultural product title of China's Mainland, Hong Kong, EUR, the U.S., Japan and CAC, agricultural product mode classification, pesticide name
Title, toxicity of pesticide, Pesticide Residue MRL standard values；In conjunction with interaction technique be associated comparative analysis, Detail contrast analysis,
Metrics evaluation comparative analysis and overall contrast analysis.Agricultural product classification tree is shown using nesting circle；LPM is shown by radar map
The result of calculation of index；Show that user encloses the data of choosing, top half label-cloud table in linkage by parallel coordinates and label-cloud
Show that user's circle selects the type for including agricultural product in data, size to indicate the quantity of the type；Lower half portion label-cloud indicates user
Circle selects the type of pesticide in data, size to indicate the quantity of the type.Using parallel coordinates by agricultural product title, multiple areas
Number (including China's Mainland, Hong Kong, the U.S., Japan, EUR, CAC), toxicity of pesticide and the pesticide of MRL standards
Title is shown.Line chart indicates that the statistical result of LPM indexs in this area in entire data set, column diagram indicate that user encloses choosing
The statistical result of this area LPM indexs in data.
Compared with prior art, the beneficial effects of the invention are as follows：
The present invention proposes the comparison visual analysis method and system of the MRL standards of area more than one, according to the classification of agricultural product
The top-down structural classification tree of situation in conjunction with interactive mode and Visual Chart be associated pair more area MRL standards
Than analysis, Detail contrast analysis, metrics evaluation comparative analysis and overall contrast analysis.Use chart technique to analogy with existing
Formula is compared, this method in combination with multiple attributes carry out comparison auxiliary user quickly find two areas agricultural product classify situation,
The difference of the coverage area of agricultural product MRL standards and the Stringency of formulation revises Pesticide Residue MRL for related personnel
Standard provides foundation；It is weighed using the compared result of the LPM index quantifications of weighting, substantially increases the essence of comparative analysis
Accuracy.In addition, it is not limited to which the MRL normal datas in the more areas of comparison can be applied to other with multidimensional hierarchy data
Comparative analysis, such as library collection catalogue data, organization structure of the enterprise relation data.
A kind of more areas MRL Comparison of standards visual analysis systems that the present invention develops, including user interactive module, user visit
Rope module, index computing module and index visualization model, using nested circle, label-cloud, parallel coordinates, broken line-column diagram,
A variety of method for visualizing such as radar map help user to carry out comprehensive multi-level comparison visual analysis to MRL normal datas, to
Quantitative analysis goes out difference of two areas in MRL standard formulations and management.System's operating mode is simple, as a result should be readily appreciated that.
Description of the drawings
Fig. 1 is the entire block diagram of the comparison visual analysis method and system of more areas MRL standards in the embodiment of the present invention；
Wherein, (a) is the flow diagram of method；(b) it is the structure diagram of system.
Fig. 2 is the schematic diagram that MRL normal datas are built to China's Mainland classification tree in present invention specific implementation.
Fig. 3 is the screening conditions according to user in the embodiment of the present invention, visual using nested circle to the data met the requirements
The interface of change；
Wherein, (a) is that user screens choice box；(b) it is that China's Mainland classification tree uses nested circle visualization interface；(c)
It is that Hong Kong classification tree uses nested circle visualization interface；Dotted portion indicates the level of data, the circle table of innermost layer
Show that agricultural product, round size indicate the MRL standard recording numbers of this area's agricultural product.
Fig. 4 is (to be wrapped agricultural product title, the number of multiple area MRL standards using parallel coordinates in the embodiment of the present invention
Include China's Mainland, Hong Kong, the U.S., Japan, EUR, CAC), the boundary that is shown of pesticide name and toxicity of pesticide
Face；
Wherein, user can check distribution situation or the selection of some agricultural product by the label-cloud in mouse click left side
Check the specifying information of certain toxicity of pesticide.
When Fig. 5 is that user clicks winter squash label in agricultural product label-cloud in the embodiment of the present invention, linkage generates parallel coordinates
Interface.
When Fig. 6 is that user clicks high poison label in toxicity of pesticide label-cloud in the embodiment of the present invention, linkage generates parallel seat
Target sectional drawing.
Fig. 7 is the interface being shown to MRL indexs using broken line-column diagram in the embodiment of the present invention；
Wherein, (a) is the statistical result of the taxonomical hierarchy number of agricultural product；(b) system of the pesticide number involved in MRL standards
Count result；(c) it is the statistical result of the record number of pesticide Limited Doses in MRL standards；Line chart indicates 6 ground in entire data set
The numerical value of the LPM indicator-specific statistics in area, column diagram indicate that user encloses the numerical value of 6 regional LPM indicator-specific statistics in the data selected.
Fig. 8 is to use radar map by the LPM of different regions (China's Mainland and Hong Kong) in the embodiment of the present invention
The visualization interface that gained scores after index calculates.
Specific implementation mode
Below in conjunction with the accompanying drawings, the present invention, the model of but do not limit the invention in any way are further described by embodiment
It encloses.
The present invention provides the comparison visual analysis method and system of more areas MRL standards.It is associated in conjunction with interaction technique
Comparative analysis, Detail contrast analysis, comparativeanalysis and overall contrast analysis.The comparison visual analysis of more areas MRL standards
System by representational level structure nesting circle, displaying multidimensional data parallel coordinates and radar map and indicate attribute value size
Label-cloud, broken line-column diagram combination linkage technique carry out comparison visual analysis, while provide interaction technique help user to
Under drill through and excavate profound knowledge.It can be towards Pesticide Residue MRL normal datas, the library collection of field of food safety
Catalogue data, organization structure of the enterprise data etc. carry out dimension hierarchical data comparison visual analysis.
Following embodiment is the comparison visual analysis method and system centering using more areas MRL standards provided by the invention
The process that the Pesticide Residue MRL normal datas of state continent and Hong Kong agricultural product compare and analyze.Fig. 2 is this
The flow chart of the comparison visual analysis system of more areas MRL standards during invention is implemented.Initial data is as shown in table 1, table 2：
The Pesticide Residue MRL standard initial data of 1 China's Mainland agricultural product of table
The Pesticide Residue MRL standard initial data of 2 Hong Kong agricultural product of table
Using the comparison visual analysis method and system of more areas MRL standards proposed by the present invention, to above-mentioned pesticide residue
Limitation MRL normal datas compare and analyze, this method the specific steps are：
A. initial data is pre-processed, is converted into that there is level inclusion relation according to the mode classification of agricultural product
JSON formats, one classification tree of top-down structure, the results are shown in Figure 1 for generation.According to user in system data screening module
Operation, initial data is screened, the data are extracted from database；
In specific implement, user can select two major class of veterinary antibiotics；In front view and in auxiliary view
To select China's Mainland, Hong Kong, the U.S., EUR, Japan and CAC.Visualization is clicked after selection using mouse to press
Button can show the data visualization after screening.
B. it is visualized using the mode of nesting circle to generating tree construction in visual analysis method, user passes through toolbar
Lasso tool circle select interested part to be associated comparative analysis；
For China's Mainland and Hong Kong Practice for Pesticide Residue in Agricultural Products limitation MRL Comparison of standards tasks, process is above-mentioned
Step produces two nested circles, and the nested circle in left side is vegetable species and each vegetables that China's Mainland sampled point detects
Classification, correspondingly right side be then Hong Kong data.The size of leaf node indicates the MRL of agricultural product in nesting circle
Standard recording number, as shown in Fig. 3, the mode classification that user encloses favored area in front view are vegetables, melon vegetables, small-sized melon
Class/large size is melon, small-sized melon including cucurbita pepo, sponge gourd, section melon；It is large-scale melon including winter squash, pumpkin, wax gourd, enclose the agriculture of choosing
Product is cucumber, cucurbita pepo, section melon, sponge gourd, winter squash, pumpkin, wax gourd.The agricultural product production selected in front view centre circle according to user
Contingency table, corresponding agricultural product are highlighted in auxiliary view, i.e. cucumber, section melon, wax gourd, sponge gourd, winter squash, cucurbita pepo and south
Melon, their layered mode are vegetables, melon vegetables.China's Mainland and Hong Kong user enclose the agricultural product of favored area
MRL standard recording numbers it is as shown in table 3.It can be seen that melon vegetables is divided in China's Mainland in conjunction with the visual presentation of nesting circle
Class mode is more careful, and China's Mainland MRL standard recording numbers of each agricultural product compared with Hong Kong are relatively more.
The MRL standard recording numbers of China's Mainland and Hong Kong agricultural product in 3 embodiment of table
C. the data of the contingency table generated in B are combined with label-cloud, parallel coordinates and carries out visual analysis, marked by clicking
The data of the character can be mapped to parallel coordinates by the character in label cloud, carry out Detail contrast analysis；
In specific example, (including China is big by agricultural product title, the number of multiple area MRL standards for parallel coordinates
Land, Hong Kong, the U.S., Japan, EUR, CAC), pesticide name and toxicity of pesticide be shown.The label-cloud of top
Number be user's circle selects data in nested circle agricultural product type, size is the MRL standard recording numbers of the agricultural product.Lower section
The number of label-cloud is the toxicity of pesticide type that user's circle selects data in nested circle, and size is the record number of toxicity of pesticide.
Attached drawing 4 selects the result of data using user's circle in above-mentioned parallel coordinates and label-cloud visualization B.It can from figure
Go out the MRL standard recordings number of most agricultural product in China's Mainland, Hong Kong, the U.S., Japan, CAC and EUR all
It is less, and the record number that toxicity of pesticide is low toxicity is more.Above-mentioned six areas have individual agricultural product MRL standard recording numbers more
The case where；The agricultural product MRL standard recordings number of EUR is fewer on the high side, thus it is speculated that EUR to Pesticide Residue management there is also
Defect.User, which encloses high-toxic pesticide in the data selected, has 5 records, medium toxic pesticides to have 23 records, low-toxin farm chemicals 73 to record,
Toxicity of pesticide is unfiled 7 records.
Attached drawing 5 is the parallel coordinates for the generation that links after user selects beat time melon label-cloud.User encloses winter squash in the data selected
There are 3 MRL standard recordings, wherein user to enclose the U.S., Japan, EUR in the data selected and do not have to the residue limits value of this 3 kinds of pesticides
It is provided, there is specific regulation in China's Mainland to this 3 kinds of pesticides, thus it is speculated that China's Mainland is more complete to the supervision of winter squash
Face.It can also be learnt from figure, it is low-toxin farm chemicals to have 2 kinds in this 3 kinds of pesticides, and a kind is medium toxic pesticides.Further to explore pesticide poison
Sex-related issues can select the toxicity of pesticide label-cloud of lower half portion to be analyzed for certain toxicity of pesticide.
Attached drawing 6 is after user clicks high poison label, and linkage generates parallel coordinates.As can be seen from the figure this five kinds of high poison agricultures
Medicine is applied in respectively in cucurbita pepo, section melon, cucumber, and these types of high poison agriculture can be seen in the reference axis of rightmost by tracking
Medicine is specifically Hostathion, azinphos-methyl, avermectin, oxamyl.Only China is for Hostathion agriculture in the data that user encloses choosing
The residue limits value of medicine is provided that only EUR and CAC provide the residue limits value of azinphos-methyl pesticide, is used
Family circle, which selects in data, does not provide the residue limits value of avermectin pesticides, China's Mainland, Hong Kong, U.S.
State, Japan and CAC are consistent to the residue limits value prescribed level of oxamyl pesticide.Can further it be divided by using parallel coordinates
The case where 6 regional applying pesticides of analysis.
D. comparativeanalysis and overall contrast analysis.The LPM indexs of the data of choosing are enclosed to user in entire data set and B
It is calculated and is counted, the result of calculation of LPM indexs is shown using radar map；Broken line-column diagram shows statistical result；
In specific example, line chart indicates the numerical value of 6 regional LPM indicator-specific statistics in entire data set, cylindricality
Figure indicates that user encloses the numerical value of 6 regional LPM indicator-specific statistics in the data selected.Radar map uses the taxonomical hierarchy of agricultural product
3 indexs of record number of pesticide Limited Doses compare and analyze in pesticide number and MRL standards involved in number, MRL standards.
Attached drawing 7 selects data to show statistical result using broken line-column diagram user in nesting circle centre circle.(a) broken line-column diagram is 6
The mode classification statistical result of a area agricultural product, line chart indicate this area's agricultural product mode classification in entire data set
Statistical value, column diagram indicate that user's circle selects the statistical value of agricultural product mode classification in this area's in data.(b) broken line-column diagram
For the pesticide quantity statistics result of 6 regional agricultural product applications.(c) broken line-column diagram is the MRL marks of 6 regional agricultural product
Quasi- record counting result.It is as shown in the table for the concrete numerical value of three broken line-column diagrams, wherein left side is the system in entire data set
Meter is as a result, right side is the statistical result (table 4) that user selects data in nested circle centre circle：
The concrete numerical value of LPM indexs in 4 broken lines of table-column diagram
Attached drawing 8 be using radar map by the LPM indexs of China's Mainland and Hong Kong calculate after gained score can
Depending on changing interface.Weight coefficient (the u of LPM indexs1,u2,u3) it is defaulted as 1, China's Mainland and Hong-Kong are compared by radar map
The situation in area, user's circle select the scoring of agricultural product mode classification in China's Mainland in data more much higher than Hong Kong,
One kind may be that these agricultural product are the distinctive agricultural product of China.China's Mainland and Hong Kong for entire data set
It is not much different on the MRL standard recording numbers of agricultural product, Hong Kong is compared in China's Mainland on the mode classification of agricultural product
Slightly careful, Hong Kong is more than China's Mainland in the pesticide quantity of agricultural product application.
E. operation is interacted by the use of the tools such as interface button, screening frame, user can arbitrarily adjust thermodynamic chart
The weight coefficient of middle LPM indexs, numberical range is from 0.1 to 10, to which the different aspect of data is analyzed and be compared.
By the operation of above-mentioned steps, final visualization result is obtained.In the embodiment of the present invention, final visualization result is adopted
With following displaying：The upper left corner is data screening frame；Centre is the comparison view of two nested circles；The upper right corner is radar map；Lower-left
Angle is label-cloud and parallel coordinates；The lower right corner is broken line-column diagram.
In addition, the method for visualizing of the present invention can also be applied to the institutional framework relationship of comparison company with system.Each
Can all there be the institutional framework of oneself in company, and such as common membership credentials are president, president, vice president, general manager, Fu Zongjing
Reason, department manager, the person in charge of the project, common employee etc..The comparison visual analysis method of more area MRL standards through the invention with
System user can compare the advantage of different tissues relationship from different angles, to make correct decision.
It should be noted that the purpose for publicizing and implementing example is to help to further understand the present invention, but the skill of this field
Art personnel are appreciated that：It is not departing from the present invention and spirit and scope of the appended claims, various substitutions and modifications are all
It is possible.Therefore, the present invention should not be limited to the content disclosed in embodiment, and the scope of protection of present invention is wanted with right
It asks subject to the range that book defines.
Claims (5)
1. a kind of comparison visual analysis method of more regional pesticide residue maximum limitation MRL standards, includes the following steps：
The first step, by the data set of Pesticide Residue MRL standards one classification tree of top-down structure, statistical data is concentrated
LPM refers to target value, and the mode of weighting is taken to calculate the scorings of each area LPM indexs；The LPM indexs include in data set
The record number M of pesticide Limited Doses in pesticide number P, MRL standard involved in taxonomical hierarchy number L, MRL standard of agricultural product；Including
Following steps：
A. the initial data of Pesticide Residue MRL standards is pre-processed, is converted into having according to the mode classification of agricultural product
The JSON formats for the inclusion relation that has levels, one classification tree of top-down structure；Execute following operation：
A1. pretreated data are converted into JSON formats：
{‘name’:’XXX’,’children’:[{‘name’:’XXX’}]}
A2. transformed JSON formatted datas in A1 are built into a classification tree；
B. statistical data concentrates LPM index values, the scoring of each area LPM indexs is quantitatively calculated by way of weighting, specifically
Include the following steps：
B1. counting statistics is carried out for data sets, obtains the pesticide number in MRL standards, the value as P；It obtains in MRL standards
All record numbers, the value as M；Obtain the sum of the taxonomical hierarchy number of each agricultural product, the value as L；
B2. the scoring of LPM index is quantitatively calculated by the method for weighting partial data collection；
L index values in LPM indexs are calculated using following formula：
S(L)=u1∑Xi+u2∑Yi+u3∑Zi
In formula, S(L)Indicate the score of L indexs；XiIndicate the taxonomical hierarchy number of each agricultural product in all data；YiIndicate duplicate removal
The taxonomical hierarchy number of each agricultural product in data afterwards；ZiIndicate point of each agricultural product only in the data that an area occurs
Class hierarchy number；u1,u2,u3It indicates weight, is defaulted as 1；
Using identical calculation, pesticide Limited Doses in the pesticide number P index values, MRL standards involved in acquisition MRL standards
Record number M index values；As last comprehensive score；
Second step, visualizes above-mentioned statistics result of calculation, and comparative analysis, Detail contrast are associated in conjunction with interaction technique
Analysis, metrics evaluation comparative analysis, overall contrast analysis；Execute following operation：
A. the classification tree that the first step generates is visualized using the mode of nesting circle, nesting circle visual means is designed as
Lasso tool, user select interested part by the lasso tool circle of toolbar, specifically comprise the following steps：
A1. the classification tree data with hierarchical structure are visualized using nesting circle algorithm, view includes that a data are sieved
Select frame and two nested circles；The border circular areas size of classification tree child node indicates all record strip numbers of the node, by helical form
It arranges from big to small；Then calculate the circumcircle of the border circular areas of all child nodes, the border circular areas of classification tree father node it is straight
Diameter is circumscribed diameter of a circle, and diameter is the sum of record number of the child node of the father node；Bottom-up recursive calculation until
The circle of root node is completed；
A2. user selects interested data using the lasso tool circle of toolbar；It includes that rectangular loop selects frame, self-defined that circle, which selects mode,
The circle of figure selects frame, repeatedly circle choosing；
A3. user can also use the highlighted classification situation for checking some attribute of mouse, after user's circle selects interested data,
Prompting frame shows that user has enclosed the MRL standard recording numbers for selecting each agricultural product in data；
B. the data of the contingency table generated in A are combined with label-cloud, parallel coordinates and carries out Detail contrast analysis, marked by clicking
The data of the character are mapped to parallel coordinates by the character in label cloud；Specifically comprise the following steps：
B1. label-cloud is generated by nesting circle linkage, the quantity of label-cloud is the type that user's circle selects data in nested circle, and size is
The quantity of specific object；A regional agricultural product specifically are selected in the front view centre circle of nesting circle, with the entitled item of agricultural product
Relevant agricultural product MRL normal datas generate contingency table in part searching database, in auxiliary view that another area is associated
Agricultural product are highlighted, while agricultural product, toxicity of pesticide type and the quantity involved in statistical correlation table generate label-cloud peace
Row coordinate realizes association comparative analysis；
B2. parallel coordinates represents different attributes by drawing the parallel reference axis of n items, and each coordinate is recorded according to every
Attribute value on axis draws the curve across n reference axis from left to right；Label-cloud selection, which is clicked, by mouse checks some mark
Sign the attribute information of cloud；The data of contingency table are inquired according to alternative condition, are updated parallel coordinates, are shown the result of Detail contrast；
C. comparativeanalysis is realized in the scoring for referring to target value and each area according to LPM；Using radar map and broken line-column diagram
It is shown, including：
C1. the top half of radar map indicates that scoring of the attribute in entire data set, lower half portion indicate to select number in user's circle
According to scoring, be the taxonomical hierarchy numbers of agricultural product, the pesticide number involved in MRL standards respectively since clockwise, in MRL standards
The record number of pesticide Limited Doses；Visualization view passes on left the value that thermodynamic chart shows each weight coefficient, and user can pass through
Mouse click is adjusted；
C2. line chart indicates that the LPM of multiple area data collection refers to target value；Column diagram indicates that user encloses in the data selected multiplely
The LPM in area refers to target value；View indicates the pesticide number involved in the taxonomical hierarchy number of agricultural product, MRL standards successively from top to bottom
And in MRL standards pesticide Limited Doses record number；When user hovers over some point on column diagram or on line chart, c is adopted
Concrete numerical value is shown with prompting frame；
D. user's interactive visual：Interaction is selected and is highlighted using data screening frame, mouse click, mouse-over, filtering, circle
Mode, for comparing and analyzing；Including：
D1. the data checked are needed by screening frame selection, be as a result illustrated in nested circle；
D2. it can further be enclosed in nesting circle and select interested part；
D3. mouse-over can be used to check specific attribute value in all Visual Charts；
D4. the weight coefficient of adjustment LPM indexs is clicked by mouse and selects the classification in label-cloud, generation is parallel to link
Coordinate pair carries out Detail contrast analysis than specific object.
2. comparison visual analysis method as described in claim 1, characterized in that the value of weight coefficient is 0.1 to 10, default value
It is 1.
3. application of the visual analysis method in the comparison visual analysis for dimension hierarchical data is compared described in claim 1,
Including but not limited to library collection catalogue data, organization structure of the enterprise data.
It is in the system, pesticide is residual 4. a kind of comparison visual analysis system of more regional pesticide residue maximum limitation MRL standards
Stay the data set of limitation MRL standards is top-down to be expressed as a classification tree, statistical data concentrates LPM to refer to target value, and takes
The mode of weighting calculates the scoring of each area LPM indexs；The LPM indexs include the taxonomical hierarchy number of agricultural product in data set
L, in pesticide number P, MRL standard involved in MRL standards pesticide Limited Doses record number M；The system comprises users to interact mould
Block, user explore module, index computing module and index visualization model, for realizing to more regional pesticide residue maximum limitations
MRL normal datas are associated comparative analysis, Detail contrast analysis, metrics evaluation comparative analysis and overall contrast analysis；
The user interactive module explores mould mouse click in the block, mouse-over, filtering, circle by data screening frame and user
It selects, be highlighted interactive mode composition；User screens data by interactive module, and sends out visualization request；
The exploration module is made of nesting circle view, parallel coordinates and label-cloud view；
The index computing module is used for the conditional systems according to user from background query database, and statistics LPM refers to target value, profit
Read group total is weighted to the weight of each setup measures with user；
The index visualization model is made of radar map and thermodynamic chart view, broken line-column diagram view；Wherein, nested circle is used
Carry out the hierarchical structure of display data；Parallel coordinates and radar map show multidimensional property；Label-cloud and broken line-column diagram displaying tool
The size of body attribute value；And by interaction so that user drills down to excavate profound knowledge and carries out comparison visual analysis.
5. comparison visual analysis system as claimed in claim 4, characterized in that the top half of the view of the system is by data
Screening frame, nested circle view, thermodynamic chart and radar map view composition；User can select compared two by data screening frame
A area；It is illustrated in classification tree using nesting circle view；The weight of index is adjusted using thermodynamic chart；User is shown using radar map
The result of calculation of LPM indexs in two areas of selection；The lower half portion of system view is by label-cloud, parallel coordinates view and folding
Line-column diagram view composition；Label-cloud is used to show the type that user encloses the agricultural product and toxicity of pesticide involved in the data of choosing
And quantity；Parallel coordinates is used to show the distribution situation of the MRL standard values of the agricultural product of different regions；Broken line-column diagram displaying
The statistical result of LPM indexs.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810071737.0A CN108280191B (en) | 2018-01-25 | 2018-01-25 | Multi-region MR L standard contrast visual analysis method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810071737.0A CN108280191B (en) | 2018-01-25 | 2018-01-25 | Multi-region MR L standard contrast visual analysis method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108280191A true CN108280191A (en) | 2018-07-13 |
| CN108280191B CN108280191B (en) | 2020-07-17 |
Family
ID=62805015
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810071737.0A Active CN108280191B (en) | 2018-01-25 | 2018-01-25 | Multi-region MR L standard contrast visual analysis method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108280191B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109783532A (en) * | 2018-12-12 | 2019-05-21 | 航天信息股份有限公司 | Food/pharmaceutical analysis method and system based on micro services framework |
| CN111291896A (en) * | 2020-02-03 | 2020-06-16 | 深圳前海微众银行股份有限公司 | Interactive random forest subtree screening method, device, equipment and readable medium |
| CN112101522A (en) * | 2020-08-20 | 2020-12-18 | 四川大学 | Interactive machine learning method based on visualization |
| WO2022203627A1 (en) * | 2021-03-22 | 2022-09-29 | Turkiye Urun Ihtisas Borsasi Anonim Sirketi | Agricultural commodity indices determination system and method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060010410A1 (en) * | 2004-07-12 | 2006-01-12 | International Business Machines Corporation | Genie: a method for classification and graphical display of negative slack timing test failures |
| CN105403694A (en) * | 2015-11-05 | 2016-03-16 | 合肥学院 | Preparation method of PS@SiO2 artificial antibody for detecting paraquat molecules |
| CN106227828A (en) * | 2016-07-25 | 2016-12-14 | 北京工商大学 | A kind of isomorphism hierarchical data contrast visual analysis methods and applications |
| CN107016617A (en) * | 2016-01-28 | 2017-08-04 | 北京工商大学 | A kind of method for visualizing of the residual detection data of agricultural product agriculture based on multiple radiation ring |
-
2018
- 2018-01-25 CN CN201810071737.0A patent/CN108280191B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060010410A1 (en) * | 2004-07-12 | 2006-01-12 | International Business Machines Corporation | Genie: a method for classification and graphical display of negative slack timing test failures |
| CN105403694A (en) * | 2015-11-05 | 2016-03-16 | 合肥学院 | Preparation method of PS@SiO2 artificial antibody for detecting paraquat molecules |
| CN107016617A (en) * | 2016-01-28 | 2017-08-04 | 北京工商大学 | A kind of method for visualizing of the residual detection data of agricultural product agriculture based on multiple radiation ring |
| CN106227828A (en) * | 2016-07-25 | 2016-12-14 | 北京工商大学 | A kind of isomorphism hierarchical data contrast visual analysis methods and applications |
Non-Patent Citations (1)
| Title |
|---|
| 陈谊等: "基于平行坐标的多视图协同可视分析方法", 《系统仿真学报》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109783532A (en) * | 2018-12-12 | 2019-05-21 | 航天信息股份有限公司 | Food/pharmaceutical analysis method and system based on micro services framework |
| CN111291896A (en) * | 2020-02-03 | 2020-06-16 | 深圳前海微众银行股份有限公司 | Interactive random forest subtree screening method, device, equipment and readable medium |
| CN111291896B (en) * | 2020-02-03 | 2022-02-01 | 深圳前海微众银行股份有限公司 | Interactive random forest subtree screening method, device, equipment and readable medium |
| CN112101522A (en) * | 2020-08-20 | 2020-12-18 | 四川大学 | Interactive machine learning method based on visualization |
| CN112101522B (en) * | 2020-08-20 | 2023-04-18 | 四川大学 | Interactive machine learning method based on visualization |
| WO2022203627A1 (en) * | 2021-03-22 | 2022-09-29 | Turkiye Urun Ihtisas Borsasi Anonim Sirketi | Agricultural commodity indices determination system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108280191B (en) | 2020-07-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108280191A (en) | The comparison visual analysis method and system of more areas MRL standards | |
| Rivest et al. | SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data | |
| CN107180076A (en) | Residues of pesticides based on high resolution mass spectrum+internet+geography information are traced to the source and early warning video method online | |
| CN106920044B (en) | Pesticide residue risk assessment method based on fuzzy comprehensive evaluation model | |
| US20040139102A1 (en) | Parameterized database drill-through | |
| CN106227828B (en) | A kind of isomorphism hierarchical data comparison visual analysis methods and applications | |
| CN108205783A (en) | A kind of automation credit scoring system in agricultural credit field | |
| Jennings et al. | Guidelines for describing associations and alliances of the US National Vegetation Classification | |
| Laurent et al. | Interactive web‐based data visualization and analysis tool for synthetizing on‐farm research networks data | |
| CN111949658A (en) | Method for constructing operable graph perspective table facing data cube | |
| Wati et al. | GIS Land Suitability to Increasing Agricultural Production for the Agriculture Supply Chain: A Systematic Literature Review | |
| CN110008279A (en) | One kind is based on " relationship-weight " the orderly visual analysis method of matrix and application | |
| Vico et al. | Business Intelligence in Agriculture–A Practical Approach | |
| Grešlová et al. | Land cover flows and land use intensity in the three decades of the post-communist Czechia: Changing trends and driving forces | |
| Madhuri et al. | Big Data Analytics-Based Agro Advisory System for Crop Recommendation Using Spark Platform | |
| Tai et al. | Design reuse method of corn picking device based on case-based reasoning | |
| CN109523143A (en) | A kind of land evaluation method based on multiple granular computing | |
| Yang et al. | Visual analysis of occurrence and control of forest pests with multi-view collaboration | |
| Zhang et al. | Promoting the development of Astragalus mongholicus Bunge Industry in Guyang County (China) Based on MaxEnt and remote sensing | |
| Sleight et al. | Belowground Biomass and Root: Shoot Ratios of Three Willow Cultivars at Two Sites | |
| US11580116B2 (en) | Viewport location based method and apparatus for generation and promotion of type ahead results in a multi-source agricultural parcel search | |
| US11768840B2 (en) | Method and apparatus for rapid search for agricultural parcels and generation of relevant search results | |
| Al-Hasan et al. | Context-aware computing for balanced agricultural production using machine learning | |
| CN106874407A (en) | Agriculture residue based on concept abstraction hierarchy is according to method for amalgamation processing and its system | |
| US20220012234A1 (en) | Method and apparatus for generation and promotion of type ahead results in a multi-source agricultural parcel search |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |