CN106682183A - Linkable data visualization spectacular system - Google Patents
Linkable data visualization spectacular system Download PDFInfo
- Publication number
- CN106682183A CN106682183A CN201611246959.9A CN201611246959A CN106682183A CN 106682183 A CN106682183 A CN 106682183A CN 201611246959 A CN201611246959 A CN 201611246959A CN 106682183 A CN106682183 A CN 106682183A
- Authority
- CN
- China
- Prior art keywords
- data
- various dimensions
- data visualization
- visualization
- query engine
- 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/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/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- 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
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/04812—Interaction techniques based on cursor appearance or behaviour, e.g. being affected by the presence of displayed objects
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a linkable data visualization spectacular system. The linkable data visualization spectacular system comprises a data visualization graphic spectacular, a multi-dimension query engine, SQL query sentences, a calculating database, data request acquisition, generation request construction, a query request, result data and format-converted data, wherein the data visualization graphic spectacular is communicated with the multi-dimension query engine, the multi-dimension query engine is communicated with the SQL query sentences, the calculating database is communicated with the multi-dimension query engine, and the SQL query sentences are communicated with the calculating database. The invention further discloses a workflow of the linkable data visualization spectacular system. A linkage event is generated by clicking of visualized graphs on an interface, and related linkage calculating results are obtained immediately. The linkable data visualization spectacular system and the workflow thereof have the advantages that visualization and analytic calculation of the data can be completed in a step, so that high processing efficiency and simplicity in operation are achieved, large-scale and large-data-volume analysis can be handled, and the results can be displayed in the form of the visualized graphs.
Description
Technical field
The present invention relates to big data field, the data visualization banner system of specifically a kind of linkage.
Background technology
Big data, or claim flood tide data, refer to need new tupe could have higher decision edge, insight and
The magnanimity of process optimization ability, high growth rate and diversified information assets.In order to application is convenient, people are can using data
Observed depending on changing banner system.Existing data visualization banner system in the data analysiss in being applied to business intelligence,
Commonly use SQL query statement and obtain result of calculation from data base, and write results in other tables in data base, visually
When changing figure displaying, the data read in result table are shown.For the scheme of some automatic business processings, also simply by
Sql like language writes storing process, and calls sql procedure by timing, and result of calculation is written to into result table.Such place
Reason mode, if facing multiple figures, during the instant linkage analysis demand of multiple dimensions, needs for all of linkage situation,
Substantial amounts of SQL query statement and storing process are developed, degree of flexibility is low, the cycle length and development cost for changing change is high, no
It is easy to the application of people.
The content of the invention
It is an object of the invention to provide a kind of data visualization banner system of linkage, to solve above-mentioned background technology
The problem of middle proposition.
For achieving the above object, the present invention provides following technical scheme：
A kind of data visualization banner system of linkage, including data visualization figure billboard, various dimensions query engine,
SQL query statement, calculating data base, acquisition request of data, structure generate request, inquiry request, result data and format transformation
Data afterwards, between data visualization figure billboard and various dimensions query engine after acquisition request of data and format transformation
Data be connected, between various dimensions query engine and SQL query statement by build generate request be connected, calculate data base
It is connected with various dimensions query engine by result data, SQL query statement is connected by inquiry request with data base is calculated.
As further scheme of the invention：Various dimensions query engine is using the various dimensions query engine based on OLAP.
As further scheme of the invention：Calculate data base and adopt Large-scale parallel computing data base.
The workflow of the data visualization banner system of the linkage, comprises the following steps that：
Step one, data visualization figure billboard is inquired about by the various dimensions query engine request data based on OLAP, base
SQL query statement is built and is generated in the various dimensions query engine of OLAP, connects and be sent to Large-scale parallel computing data base,
Obtain inquiry result of calculation；
Step 2, Large-scale parallel computing data base returns result to the various dimensions query engine of OLAP, the multidimensional of OLAP
Degree query engine converts the data into suitable form carries out visual presentation to data visualization figure billboard.
Compared with prior art, the invention has the beneficial effects as follows：The present invention can pass through to click on the visualization figure on interface
Shape, produces linkage event, and related linkage result of calculation is obtained immediately；The visualization of data and the step of analytical calculation one in the present invention
Complete, treatment effeciency is high, simple to operate, the analysis of extensive and big data quantity can be tackled, and by result with visual figure
Shape is shown, and using effect is good.
Description of the drawings
Fig. 1 is the structural representation of the data visualization banner system of linkage.
Fig. 2 is the workflow diagram of the data visualization banner system of linkage.
Wherein：1- data visualization figure billboard, 2- various dimensions query engines, 3-SQL query statements, 4- calculates data
Storehouse, 5- obtains request of data, and 6- builds and generates request, 7- inquiry requests, 8- result datas, the data after 9- format transformations, 10-
Triggering linkage visualized graphs, 11- triggering linkage data visualizations graphics field, 12- receives linkage data visualization figure.
Specific embodiment
The technical scheme of this patent is described in more detail with reference to specific embodiment.
Refer to Fig. 1-2, a kind of data visualization banner system of linkage, including it is data visualization figure billboard 1, many
Dimension query engine 2, SQL query statement 3, calculate data base 4, obtain request of data 5, build generate request 6, inquiry request 7,
Data 9 after result data 8 and format transformation, by obtaining between data visualization figure billboard 1 and various dimensions query engine 2
Data 9 after request of data 5 and format transformation are connected, and structure is passed through between various dimensions query engine 2 and SQL query statement 3
Build generation request 6 to be connected, calculate data base 4 and be connected with various dimensions query engine 2 by result data 8, SQL query statement
3 are connected by inquiry request 7 with data base 4 is calculated.Various dimensions query engine 2 is drawn using the various dimensions inquiry based on OLAP
Hold up.Calculate data base 4 and adopt Large-scale parallel computing data base.
The present invention operation principle be：Triggering linkage visualized graphs 10 in data visualization figure billboard 1 receive boundary
When cake hits, according to the triggering linkage data visualization graphics field 11 clicked on, using the data in clicked region as linkage bar
Part is sent to other reception linkage data visualization figures 12, while changing the display effect of itself, highlights and is selected
Region, others receive the linkage condition that the record of linkage data visualization figures 12 is received, and add this condition to being based on
The various dimensions query engine 2 of OLAP, various dimensions query engine 2 builds and generates SQL query statement 3, and connecting and send inquiry please
7 are asked to Large-scale parallel computing data base 4, inquiry result of calculation is obtained and returning result data 8 is inquired about to the various dimensions of OLAP
Result data is converted into the data after the format transformation of suitable format 9 to data by engine 2, the various dimensions query engine 2 of OLAP
Visualized graphs billboard 1 carries out visual presentation.Triggering linkage visualized graphs 10 in data visualization figure billboard 1 receive
When interface is clicked on, if click on having been used to triggering linkage data visualization graphics field 11, using the data in the region as taking
The dynamic condition of consumption-association is sent to other reception linkage data visualization figures 12, while recover the display effect of itself, it is other
The cancellation linkage condition that the record of linkage data visualization figure 12 is received is received, and deletes this condition, re-request is based on
The various dimensions query engine 2 of OLAP, various dimensions query engine 2 builds and generates SQL query statement 3, and connecting and send inquiry please
7 are asked to Large-scale parallel computing data base 4, inquiry result of calculation is obtained, and returning result data 8 are inquired about to the various dimensions of OLAP
Result data 8 is converted into the data after the format transformation of suitable format 9 to data by engine 2, the various dimensions query engine 2 of OLAP
Visualized graphs billboard 1 carries out visual presentation.
The present invention can pass through to click on the visualized graphs on interface, produce linkage event, and related linkage is obtained immediately
Result of calculation；The visualization of data and the step of analytical calculation one are completed in the present invention, and treatment effeciency is high, simple to operate, can tackle
The analysis of extensive and big data quantity, and result is shown with visual figure, using effect is good.
It is obvious to a person skilled in the art that the invention is not restricted to the details of above-mentioned one exemplary embodiment, Er Qie
In the case of spirit or essential attributes without departing substantially from the present invention, the present invention can be in other specific forms realized.Therefore, no matter
From the point of view of which point, embodiment all should be regarded as exemplary, and be nonrestrictive, the scope of the present invention is by appended power
Profit is required rather than described above is limited, it is intended that all in the implication and scope of the equivalency of claim by falling
Change is included in the present invention.Any reference in claim should not be considered as and limit involved claim.
Moreover, it will be appreciated that although this specification is been described by according to embodiment, not each embodiment is only wrapped
Containing an independent technical scheme, this narrating mode of description is only that for clarity those skilled in the art should
Using description as an entirety, the technical scheme in each embodiment can also Jing it is appropriately combined, form those skilled in the art
Understandable other embodiment.
Claims (4)
1. the data visualization banner system of a kind of linkage, it is characterised in that including data visualization figure billboard, various dimensions
Query engine, SQL query statement, calculate data base, obtain request of data, build generate request, inquiry request, result data and
Data after format transformation, by obtaining request of data and turning between data visualization figure billboard and various dimensions query engine
The data changed after form are connected, and are connected by building generation request between various dimensions query engine and SQL query statement, count
Calculate data base to be connected with various dimensions query engine by result data, SQL query statement is by inquiry request and calculating data
Storehouse is connected.
2. the data visualization banner system of linkage according to claim 1, it is characterised in that the various dimensions inquiry
Engine is using the various dimensions query engine based on OLAP.
3. the data visualization banner system of linkage according to claim 1 and 2, it is characterised in that the calculating number
Large-scale parallel computing data base is adopted according to storehouse.
4. a kind of workflow of the data visualization banner system of the linkage as described in claim 1-3 is arbitrary, its feature
It is to comprise the following steps that：
Step one, data visualization figure billboard is inquired about by the various dimensions query engine request data based on OLAP, is based on
The various dimensions query engine of OLAP builds and generates SQL query statement, connects and be sent to Large-scale parallel computing data base, obtains
Take inquiry result of calculation；
Step 2, Large-scale parallel computing data base returns result to the various dimensions query engine of OLAP, and the various dimensions of OLAP are looked into
Inquiry engine converts the data into suitable form carries out visual presentation to data visualization figure billboard.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611246959.9A CN106682183A (en) | 2016-12-29 | 2016-12-29 | Linkable data visualization spectacular system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611246959.9A CN106682183A (en) | 2016-12-29 | 2016-12-29 | Linkable data visualization spectacular system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106682183A true CN106682183A (en) | 2017-05-17 |
Family
ID=58872498
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611246959.9A Pending CN106682183A (en) | 2016-12-29 | 2016-12-29 | Linkable data visualization spectacular system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106682183A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111274304A (en) * | 2019-12-31 | 2020-06-12 | 武汉优聘科技有限公司 | Data visualization chart control method and system |
| CN113254514A (en) * | 2020-07-16 | 2021-08-13 | 北京亦庄国际产业互联网研究院股份公司 | Intelligent comprehensive treatment platform product based on big data technology |
| CN113867582A (en) * | 2021-09-17 | 2021-12-31 | 北京易成时代科技有限公司 | Billboard data changing method, device, equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| CN204557477U (en) * | 2015-04-10 | 2015-08-12 | 安徽三联学院 | Based on the cluster result system of data warehouse and OLAP technology |
| CN104899291A (en) * | 2015-06-05 | 2015-09-09 | 北京京东尚科信息技术有限公司 | Method and device for multidimensional analysis of relational database |
-
2016
- 2016-12-29 CN CN201611246959.9A patent/CN106682183A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| CN204557477U (en) * | 2015-04-10 | 2015-08-12 | 安徽三联学院 | Based on the cluster result system of data warehouse and OLAP technology |
| CN104899291A (en) * | 2015-06-05 | 2015-09-09 | 北京京东尚科信息技术有限公司 | Method and device for multidimensional analysis of relational database |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111274304A (en) * | 2019-12-31 | 2020-06-12 | 武汉优聘科技有限公司 | Data visualization chart control method and system |
| CN113254514A (en) * | 2020-07-16 | 2021-08-13 | 北京亦庄国际产业互联网研究院股份公司 | Intelligent comprehensive treatment platform product based on big data technology |
| CN113867582A (en) * | 2021-09-17 | 2021-12-31 | 北京易成时代科技有限公司 | Billboard data changing method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8972443B2 (en) | Distributed platform for network analysis | |
| Chuang et al. | Applying cloud computing technology to BIM visualization and manipulation | |
| US9836552B2 (en) | GUI for viewing and manipulating connected tag clouds | |
| US20110154253A1 (en) | Process field extensibility for business objects | |
| WO2015060893A1 (en) | Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations | |
| CN104965886B (en) | Data dimension processing method | |
| CN103955549A (en) | Web GIS system based on SVG and data input and search method thereof | |
| US9582573B2 (en) | Interactive composite plot for visualizing multi-variable data | |
| CN104317842A (en) | Intelligent data extraction and thematic map generation engine based on geographic information technology | |
| US10133793B2 (en) | Tag cloud visualization and/or filter for large data volumes | |
| CN103631791B (en) | Information fusion classification display method and system | |
| JP7116744B2 (en) | Method and apparatus for displaying textual information | |
| CN106682183A (en) | Linkable data visualization spectacular system | |
| CN102867282A (en) | Implementation method for mobile Internet-based customer service quality analysis system | |
| CN115081414B (en) | Spreadsheet generation method, device, equipment and medium based on data model | |
| CN107315842A (en) | A kind of unstructured data collection method for visualizing based on clustering | |
| O'Sullivan | Geographically weighted regression: the analysis of spatially varying relationships | |
| US20150161224A1 (en) | Optimized Network Analysis Rendering and User Interfaces | |
| US10789261B1 (en) | Visual distributed data framework for analysis and visualization of datasets | |
| AU2009280854A1 (en) | Method to send a short message service (SMS) campaign to a related object by selecting the base object | |
| CN104866508B (en) | The method and apparatus of file is managed under cloud environment | |
| CN104317972B (en) | A kind of dynamic layer inducing method and system | |
| US20130268855A1 (en) | Examining an execution of a business process | |
| Li et al. | Valid: A web framework for visual analytics of large streaming data | |
| CN109101544A (en) | Heating power drawing generating method, calculates equipment and readable storage medium storing program for executing at device |
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 |
Application publication date: 20170517 |
|
| RJ01 | Rejection of invention patent application after publication |