CN106951534A - A kind of big data visualizes the graphic processing method and device of data correlation relation - Google Patents
A kind of big data visualizes the graphic processing method and device of data correlation relation Download PDFInfo
- Publication number
- CN106951534A CN106951534A CN201710171827.2A CN201710171827A CN106951534A CN 106951534 A CN106951534 A CN 106951534A CN 201710171827 A CN201710171827 A CN 201710171827A CN 106951534 A CN106951534 A CN 106951534A
- Authority
- CN
- China
- Prior art keywords
- data
- user
- worksheet
- visualizes
- data correlation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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/26—Visual data mining; Browsing structured data
-
- 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
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)
- User Interface Of Digital Computer (AREA)
Abstract
A kind of big data visualizes the graphic processing method of data correlation relation, a set of easy intuitively graphical operation interface can be provided, user can also be patterned association process in the case of no programming basis to existing data, it is widely used in data visualization displaying, the analysis of every profession and trade, helps user to set up the self-service analysis system of data of oneself.Including：(1) data file imported the need for obtaining user's selection, the data file is worksheet；(2) using the graph technology of web terminal, worksheet tool as into several solid patterns, the title of business object is marked on these solid patterns；(3) when detect solid pattern directly collide, it is overlapping when, prompt the user whether create data correlation, receive be then perform step (4), otherwise perform step (5)；(4) field that user is selected each worksheet carries out data correlation, and tie is associated in interface display after preservation；(5) terminate.Additionally provide device.
Description
Technical field
The present invention relates to the visual technical field of big data, more particularly to a kind of big data visualization data correlation relation
Graphic processing method, and using this method device, primarily directed to non-database professional, there is provided a set of simplicity
Intuitively graphical operation interface, user can also be patterned in the case of no programming basis to existing data
Association process.
Background technology
As computer application system is in the depth business integration of industry-by-industry, the data in the various sources produced therewith
Day by day accumulate, the demand of various application, excavations to data is also arisen at the historic moment.
As low as excel, greatly to relevant database such as mysql, oracle, sqlserver, and the big number risen in recent years
According to platform such as Hadoop, the storing mode of data is can serve as, the business datum preserved here has substantial amounts of association, than
As user data table T_USER and order data table T_ORDER there is the association of ID.The premise associated in correct understanding
Under, effectively data can just be made with analysis, so as to obtain to the valuable result of policymaker.
The mode of association between existing establishment database table substantially has following pattern：
First, Computer Database professional is employed, existing database table is carried out by SQL (SQL)
Analysis, then sets up table association.This mode requires that operating personnel must possess professional knowledge, it is impossible to popularize.
2nd, on the basis of having certain computer operation level, by the client utility of certain database, number is selected
According to table, select relevant field, the function of being provided by software interface is completed.This mode depends on the reality of each software vendor
It is existing, it is also desirable to which that related professional skill, is still the presence of technical threshold for domestic consumer.
The content of the invention
To overcome the defect of prior art, number is visualized the technical problem to be solved in the present invention is to provide a kind of big data
According to the graphic processing method of incidence relation, it can provide a set of easy intuitively graphical operation interface, and user is not having
Programming can also be patterned association process in the case of basis to existing data, can be widely applied to the number of every profession and trade
According to visual presentation, analysis, user can be helped to set up the self-service analysis system of data of oneself.
The technical scheme is that：This big data visualizes the graphic processing method of data correlation relation, and it is wrapped
Include following steps：
(1) data file imported the need for obtaining user's selection, the data file is worksheet；
(2) using the graph technology of web terminal, worksheet tool as into several solid patterns, on these solid patterns
Mark the title of business object；
(3) when detect solid pattern directly collide, it is overlapping when, prompt the user whether create data correlation, receive
It is then to perform step (4), otherwise performs step (5)；
(4) field that user is selected each worksheet carries out data correlation, and tie is associated in interface display after preservation；
(5) terminate.
The present invention is had worksheet as into solid pattern one by one using the graph technology of web terminal, such as circular, in figure
The title of business object is marked in shape, such as customer, order, user clicked by mouse, last time local excel or other numbers
According to file, system is to be automatically performed the processing and importing of data, generates the figure of worksheet, user can select two or more
Worksheet is added to workbench, then it can be seen that each worksheet relation of plane in system, can also pass through mouse drag
Represent the spheroid of worksheet to collide other spheroids, then system can point out which field selected, and preserve after the completion of selection, spheroid
Between association just establish, therefore, it is possible to provide a set of easy intuitively graphical operation interface, user is in no programming base
Association process can also be patterned to existing data, can be widely applied to the data visualization of every profession and trade in the case of plinth
Change displaying, analysis, user can be helped to set up the self-service analysis system of data of oneself.
The device using this method is additionally provided, it includes：
Acquisition module, it configures the data file to be imported the need for obtaining user's selection, and the data file is worksheet；
Tool is as labeling module, and it configures use the graph technology of web terminal, and worksheet is had as into several sterograms
Shape, marks the title of business object on these solid patterns；
Detection module, its configure detect solid pattern directly collide, it is overlapping, and prompt the user whether create data
Association；
Relating module, it configures to select user the field of each worksheet to carry out data correlation, at interface after preservation
Display association tie.
Brief description of the drawings
Fig. 1 show the flow of the graphic processing method of the big data visualization data correlation relation according to the present invention
Figure.
Fig. 2 show one using the graphic processing method that data correlation relation is visualized according to the big data of the present invention
Individual example.
Fig. 3 shows the state after Fig. 2 association foundation.
Embodiment
As shown in figure 1, this big data visualizes the graphic processing method of data correlation relation, it includes following step
Suddenly：
(1) data file imported the need for obtaining user's selection, the data file is worksheet；
(2) using the graph technology of web terminal, worksheet tool as into several solid patterns, on these solid patterns
Mark the title of business object；
(3) when detect solid pattern directly collide, it is overlapping when, prompt the user whether create data correlation, receive
It is then to perform step (4), otherwise performs step (5)；
(4) field that user is selected each worksheet carries out data correlation, and tie is associated in interface display after preservation；
(5) terminate.
The present invention is had worksheet as into solid pattern one by one using the graph technology of web terminal, such as circular, in figure
The title of business object is marked in shape, such as customer, order, user clicked by mouse, last time local excel or other numbers
According to file, system is to be automatically performed the processing and importing of data, generates the figure of worksheet, user can select two or more
Worksheet is added to workbench, then it can be seen that each worksheet relation of plane in system, can also pass through mouse drag
Represent the spheroid of worksheet to collide other spheroids, then system can point out which field selected, and preserve after the completion of selection, spheroid
Between association just establish, therefore, it is possible to provide a set of easy intuitively graphical operation interface, user is in no programming base
Association process can also be patterned to existing data, can be widely applied to the data visualization of every profession and trade in the case of plinth
Change displaying, analysis, user can be helped to set up the self-service analysis system of data of oneself.
In addition, between the step (1) and (2) include it is following step by step：
(1.2) data preview interface is provided, guiding user carries out next step operation.
In addition, the step (1.1) performs step (1.2) afterwards, user's interpolation data is detected on data correlation interface
When, all working table for pointing out active user to import, so that user can complete selection by mouse.
In addition, the step (5) performs step (6) afterwards, when detecting user corresponding figure being dragged out, correspondence is released
The association of figure.
The effect that this programme is realized is it will be apparent that by from the point of view of the situation that different big data visualization projects are implemented：
By taking Gansu Province's big data unified platform project as an example, possess the user of primary computer operative skill, can be very
It is fast to understand that simultaneously left-hand seat imported into the process that associated configuration is completed from data.
From the point of view of non-computer sector application, other laymans, as long as possessing the experience of upper net operation, by brief
A few minutes training, the self-service processing and analysis of conventional business datum can also be completed.
So, the present invention has greatly facilitated the application of data visualization in the industry, also reduces Data Analysis Services
Threshold, for every field all have obvious meaning.
Fig. 2 represents three worksheets, is customer, order, commodity respectively, between do not associate.
Each can be dragged by mouse and represent the circle of worksheet, associated as long as colliding and will point out to create.
Fig. 3 be association set up after state, it can be seen that between tie, click on tie can see the detailed of association
Explain.
Specifically operate and be：
User enters software operation interface, and selection needs data file and the determination imported.
System guides user to carry out next step operation after data preview interface is provided.
User clicks " addition " button at data correlation interface, and system can point out all working table that active user imports,
User can complete selection by mouse.
Select after worksheet confirmation, the multiple circles selected just now can be shown in operation interface, each figure represents correspondence
Worksheet, user can pull figure, directly collide when figure, it is overlapping when, system can prompt the user whether to create number
According to association, user selects the field of each worksheet, and tie is associated in interface display after preservation.
If it is desired to disassociation, it is only necessary to which corresponding figure is dragged out, that is, association is automatically terminated, without more multioperation.
Above technology realizes and can completed by WEB page that, without keyboard operation, institute can be completed by being clicked by mouse
There is operation.
By the foundation of incidence relation, in follow-up data analysis scene, can with the visual visual field of extension data and
Depth, takes more value informations to have significant help and support for being dug from data.
Can be with it will appreciated by the skilled person that realizing that all or part of step in above-described embodiment method is
The hardware of correlation is instructed to complete by program, described program can be stored in a computer read/write memory medium,
The program upon execution, includes each step of above-described embodiment method, and described storage medium can be：ROM/RAM, magnetic
Dish, CD, storage card etc..Therefore, corresponding with the method for the present invention, the present invention is also simultaneously including a kind of visualization of big data
The graphical treatment device of data correlation relation, the device generally table in the form of the functional module corresponding with each step of method
Show.Using the device of this method, it includes：
Acquisition module, it configures the data file to be imported the need for obtaining user's selection, and the data file is worksheet；
Tool is as labeling module, and it configures use the graph technology of web terminal, and worksheet is had as into several sterograms
Shape, marks the title of business object on these solid patterns；
Detection module, its configure detect solid pattern directly collide, it is overlapping, and prompt the user whether create data
Association；
Relating module, it configures to select user the field of each worksheet to carry out data correlation, at interface after preservation
Display association tie.
In addition, the device also includes guiding module, it is configured to provide data preview interface, and guiding user carries out next step
Operation.
In addition, the device also includes reminding module, it configures to detect user's interpolation data on data correlation interface
When, all working table for pointing out active user to import, so that user can complete selection by mouse.
In addition, the device also includes releasing module, it is configured come when detecting user corresponding figure being dragged out, releasing
The association of correspondence figure.
The above, is only presently preferred embodiments of the present invention, not makees any formal limitation to the present invention, it is every according to
Any simple modification, equivalent variations and the modification made according to the technical spirit of the present invention to above example, still belong to the present invention
The protection domain of technical scheme.
Claims (8)
1. a kind of big data visualizes the graphic processing method of data correlation relation, it is characterised in that：It comprises the following steps：
(1) data file imported the need for obtaining user's selection, the data file is worksheet；
(2) using the graph technology of web terminal, worksheet tool as into several solid patterns, being marked on these solid patterns
The title of business object；
(3) when detect solid pattern directly collide, it is overlapping when, prompt the user whether create data correlation, it is then to receive
Step (4) is performed, step (5) is otherwise performed；
(4) field that user is selected each worksheet carries out data correlation, and tie is associated in interface display after preservation；
(5) terminate.
2. big data according to claim 1 visualizes the graphic processing method of data correlation relation, it is characterised in that：
Between the step (1) and (2) include it is following step by step：
(1.1) data preview interface is provided, guiding user carries out next step operation.
3. big data according to claim 2 visualizes the graphic processing method of data correlation relation, it is characterised in that：
The step (1.1) performs step (1.2) afterwards, when user's interpolation data is detected on data correlation interface, points out current use
The all working table that family is imported, so that user can complete selection by mouse.
4. big data according to claim 3 visualizes the graphic processing method of data correlation relation, it is characterised in that：
The step (5) performs step (6) afterwards, when detecting user corresponding figure being dragged out, and releases the association of correspondence figure.
5. a kind of big data visualizes the graphical treatment device of data correlation relation, it is characterised in that：The device includes：
Acquisition module, it configures the data file to be imported the need for obtaining user's selection, and the data file is worksheet；
Tool is as labeling module, and it configures use the graph technology of web terminal, and worksheet is had as into several solid patterns,
The title of business object is marked on these solid patterns；
Detection module, its configure detect solid pattern directly collide, it is overlapping, and prompt the user whether create data close
Connection；
Relating module, it configures to select user the field of each worksheet to carry out data correlation, in interface display after preservation
Associate tie.
6. big data according to claim 5 visualizes the graphical treatment device of data correlation relation, it is characterised in that：
The device also includes guiding module, and it is configured to provide data preview interface, and guiding user carries out next step operation.
7. big data according to claim 6 visualizes the graphical treatment device of data correlation relation, it is characterised in that：
The device also includes reminding module, when it is configured to detect user's interpolation data on data correlation interface, points out current use
The all working table that family is imported, so that user can complete selection by mouse.
8. big data according to claim 7 visualizes the graphical treatment device of data correlation relation, it is characterised in that：
The device also includes releasing module, and it configures when detecting user and dragging out corresponding figure, to release the pass of corresponding figure
Connection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710171827.2A CN106951534A (en) | 2017-03-22 | 2017-03-22 | A kind of big data visualizes the graphic processing method and device of data correlation relation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710171827.2A CN106951534A (en) | 2017-03-22 | 2017-03-22 | A kind of big data visualizes the graphic processing method and device of data correlation relation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106951534A true CN106951534A (en) | 2017-07-14 |
Family
ID=59473032
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710171827.2A Pending CN106951534A (en) | 2017-03-22 | 2017-03-22 | A kind of big data visualizes the graphic processing method and device of data correlation relation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106951534A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107526832A (en) * | 2017-09-05 | 2017-12-29 | 江苏电力信息技术有限公司 | A kind of method for building the big data business model that technology is pulled based on the page |
| CN108415695A (en) * | 2018-01-25 | 2018-08-17 | 新智数字科技有限公司 | A kind of data processing method, device and equipment based on visualization component |
| CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
| CN109491998A (en) * | 2018-10-08 | 2019-03-19 | 杭州数梦工场科技有限公司 | Analyze the method, apparatus and electronic equipment of business datum |
| CN109697066A (en) * | 2018-12-28 | 2019-04-30 | 第四范式（北京）技术有限公司 | Realize the method and system of tables of data splicing and automatic training machine learning model |
| CN109739855A (en) * | 2018-12-28 | 2019-05-10 | 第四范式（北京）技术有限公司 | Realize the method and system of tables of data splicing and automatic training machine learning model |
| CN113468261A (en) * | 2021-06-24 | 2021-10-01 | 苏州琅润达检测科技有限公司 | Method and system for constructing entity relationship of Internet of things based on graphic editing engine |
| WO2024065338A1 (en) * | 2022-09-28 | 2024-04-04 | 京东方科技集团股份有限公司 | Electronic kanban determining method and apparatus |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090292730A1 (en) * | 2008-05-23 | 2009-11-26 | Microsoft Corporation | Spreadsheet formula translation of server calculation rules |
| CN103606037A (en) * | 2013-11-06 | 2014-02-26 | 远光软件股份有限公司 | Query and configuration method of business data and device thereof |
| CN104516646A (en) * | 2013-09-30 | 2015-04-15 | 北大方正集团有限公司 | Method and device for relating image to button |
| CN105335462A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | Visual mapping method for data relation of XBRL application platform |
-
2017
- 2017-03-22 CN CN201710171827.2A patent/CN106951534A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090292730A1 (en) * | 2008-05-23 | 2009-11-26 | Microsoft Corporation | Spreadsheet formula translation of server calculation rules |
| CN104516646A (en) * | 2013-09-30 | 2015-04-15 | 北大方正集团有限公司 | Method and device for relating image to button |
| CN103606037A (en) * | 2013-11-06 | 2014-02-26 | 远光软件股份有限公司 | Query and configuration method of business data and device thereof |
| CN105335462A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | Visual mapping method for data relation of XBRL application platform |
Non-Patent Citations (1)
| Title |
|---|
| LITEYE_14608: "使用PowerPivot建立简单的分析模型", 《HTTPS://BLOG.CSDN.NET/ITEYE_14608/ARTICLE/DETAILS/82481551》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107526832A (en) * | 2017-09-05 | 2017-12-29 | 江苏电力信息技术有限公司 | A kind of method for building the big data business model that technology is pulled based on the page |
| CN108415695A (en) * | 2018-01-25 | 2018-08-17 | 新智数字科技有限公司 | A kind of data processing method, device and equipment based on visualization component |
| CN109491998A (en) * | 2018-10-08 | 2019-03-19 | 杭州数梦工场科技有限公司 | Analyze the method, apparatus and electronic equipment of business datum |
| CN109189849A (en) * | 2018-10-16 | 2019-01-11 | 浪潮天元通信信息系统有限公司 | A kind of standardization, the data entry method of procedure and system |
| CN109697066A (en) * | 2018-12-28 | 2019-04-30 | 第四范式（北京）技术有限公司 | Realize the method and system of tables of data splicing and automatic training machine learning model |
| CN109739855A (en) * | 2018-12-28 | 2019-05-10 | 第四范式（北京）技术有限公司 | Realize the method and system of tables of data splicing and automatic training machine learning model |
| CN109697066B (en) * | 2018-12-28 | 2021-02-05 | 第四范式（北京）技术有限公司 | Method and system for realizing data sheet splicing and automatically training machine learning model |
| CN113468261A (en) * | 2021-06-24 | 2021-10-01 | 苏州琅润达检测科技有限公司 | Method and system for constructing entity relationship of Internet of things based on graphic editing engine |
| CN113468261B (en) * | 2021-06-24 | 2022-04-01 | 苏州琅润达检测科技有限公司 | Method and system for constructing entity relationship of Internet of things based on graphic editing engine |
| WO2024065338A1 (en) * | 2022-09-28 | 2024-04-04 | 京东方科技集团股份有限公司 | Electronic kanban determining method and apparatus |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106951534A (en) | A kind of big data visualizes the graphic processing method and device of data correlation relation | |
| CN106354760B (en) | Multiple view space-time data method for visualizing and application based on deformable statistical map | |
| US9582573B2 (en) | Interactive composite plot for visualizing multi-variable data | |
| CN101946228A (en) | On-screen menu buttons including multiple modes | |
| US9824470B2 (en) | Use of dynamic numeric axis to indicate and highlight data ranges | |
| US20110298805A1 (en) | Method and Data Processing System for Financial Planning | |
| US8185817B2 (en) | Utilizing spreadsheet references with grouped aggregate views | |
| CN106802894B (en) | File induction method and equipment | |
| CN108664406A (en) | Exploitation test method, terminal device and the medium of mobile application | |
| CN103413002A (en) | Topological graph editing method and topological graph editor | |
| CN112506502B (en) | Visual programming method, device, equipment and storage medium based on man-machine interaction | |
| CN103902258A (en) | Method and device for displaying self-defined menu in webpage | |
| CN102104510A (en) | Data view processing method and system | |
| CN115081414B (en) | Spreadsheet generation method, device, equipment and medium based on data model | |
| WO2015106894A1 (en) | Method and system for use in connection with an industrial control system | |
| CN104123633A (en) | Calendar control | |
| US20120041985A1 (en) | Systems and methods for replicating values from multiple interface elements | |
| US20140130008A1 (en) | Generating information models | |
| CN106126254B (en) | The associated head-up interface game editing system of one kind and method | |
| CN103902511A (en) | Data conversion and amplifying display method and system for data table | |
| US20150116329A1 (en) | Multi-attribute visualization including multiple coordinated views of non-overlapped cells | |
| CN105487754A (en) | Test paper generating method and device based on cloud | |
| JP2013206020A (en) | Task flow generation support system and task flow generation method | |
| CN111291543B (en) | Data display method and device, storage medium and processor | |
| US9251609B1 (en) | Timelined spider diagrams |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170714 |