CN109872265A - A kind of visual government affairs service data analysis method - Google Patents
A kind of visual government affairs service data analysis method Download PDFInfo
- Publication number
- CN109872265A CN109872265A CN201910151741.2A CN201910151741A CN109872265A CN 109872265 A CN109872265 A CN 109872265A CN 201910151741 A CN201910151741 A CN 201910151741A CN 109872265 A CN109872265 A CN 109872265A
- Authority
- CN
- China
- Prior art keywords
- data
- dimension
- chart
- database
- sql
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of visual government affairs service data analysis method, belong to government affairs service data visualization technique field, the present invention is based on open source Visual Chart component echarts and onboard data precomputation models, secondary encapsulation is carried out to the open source js component echarts various charts provided, receive unified parameter and data type, by calling built-in data precomputation model, data are returned the result, realize that the chart visualization of data acquisition system shows.The general relevant database of data precomputation model supports includes oracle, sqlserver, mysql, db2 etc., and what million grades of data can be realized with second grade shows output, reduces and repeats hair development.
Description
Technical field
The present invention relates to government affairs service data visualization technique more particularly to a kind of visual government affairs service data analyses
Method.
Background technique
In recent years, country constantly pushed the construction of " internet+government affairs service ", realized standardization, the essence of government affairs service
Standardization, facilitation, hardware and software platform, collaborative, government affairs service procedure significantly optimize, and service form is more polynary, and services channels are more
Unimpeded, masses' working satisfaction is obviously improved.
Clearly propose that government affairs service facilitation, customer-centric, integrate government affairs Service Source and process, provide individual character
Change government affairs service, realizes one-stop handle.The new technologies such as innovation and application cloud computing, big data, mobile Internet, classification push away
It is built into novel smart city.Process and result are handled to government affairs service and carry out big data analysis, the control of innovation working quality and
Service effectiveness assessment, greatly improves onlineization, personalization, the intelligent level of government affairs service.
In this context, the data analysis application demand of government affairs service customized development more and more prominent, traditional,
Be unable to satisfy increasing demand, be badly in need of it is a kind of data volume be not it is especially big, do not need to expend a large amount of computing resources,
Energy data rapidly and efficiently analyze the Method and kit for showed.
Summary of the invention
Against the above technical problems, it the invention proposes a kind of visual government affairs service data analysis method, is not consuming
Take a large amount of computing resources, without complex operations, can be achieved with the data analysis of lightweight, it is internal single preferably to solve government affairs service
The data of million data-level of table analyze showing problem, more rapidly efficiently configure expected analysis chart, intuitive to data
It shows.
The technical scheme is that
A kind of visual government affairs service data analysis method, based on open source Visual Chart component echarts and built-in
Data precomputation model carries out secondary encapsulation to the open source js component echarts various charts provided, receive unified parameter and
Data type returns the result data, realizes the chart visualization exhibition of data acquisition system by calling built-in data precomputation model
It is existing.
The general relevant database of data precomputation model supports includes oracle, sqlserver, mysql, db2 etc.,
What million grades of data can be realized with second grade shows output, reduces and repeats hair development.
The data precomputation model, can be according to the analysis dimension of configuration, measure and other customized computational charts
Up to formula, automatic assembling sql sentence obtains primary Calculation data from data source, then passes through the filtering of data acquisition system, collects,
It calculates final as a result, returning in the chart of encapsulation, is shown for data.
The general relevant database of the data precomputation model supports include oracle, sqlserver, mysql,
Db2, what million grades of data can be realized with second grade shows output.
The visualization component includes echarts or highcharts or D3.js.
Wherein, each chart of visualization component is standardized encapsulation, is encapsulated as common data acquisition component js, Ge Getu
Table js is respectively used to the acquisition of chart data, and defines for chart style personalization, the load of chart data.
Public data securing component, including 3 partial datas obtain, respectively dimension data, and dimension calculates data, and dimension is fixed
Adopted data.
Each chart components js includes four parts, the configuration of echarts base model, customized style configuration loading method, number
According to loading method, branch's chart definition.
Database data precomputation model is divided into data source load, self-defining data collection obtains, according to dimension initial data
Collection sql is assembled, database connection, obtain initial data, obtain dimension data, customized expression calculates, data set filter this 8
Part.
(1) data source is loaded as obtaining original database address, user name, password, connects for database；
(2) self-defining data collection obtains, and is the data acquisition system selected for analysis, can be configured by sql or data model；
(3) assembled according to dimension raw data set sql, it, can be according to analysis in the case where data set is customized sql
Dimension and aggregate function, automatically generate obtain data original sql；
(4) database connects, and is established the link by the configuration of data source to database；
(5) it obtains dimension data and the data acquisition system of dimension is got according to the result set of (3) part respectively；
(6) customized expression calculates, and on the basis of dimension data, according to the expression formula of setting, carries out mathematics automatically
Operation generates new dimension data；
(7) data set filters, can be to the data of dimension if the data of configuration show that the filtering for having data in model configures
It is filtered, only returns to the data acquisition system to be analyzed.
The beneficial effects of the invention are as follows
1) simplify chart development process
By the source of configuration data and the data acquisition system of analysis, select chart template, setting analysis dimension and calculating are tieed up
Degree can automatically generate chart, simplify exploitation, configuration simply.
2) a variety of relevant databases are supported
It supports a variety of common relevant databases such as oracle, mysql, sqlserver, db2, meets most of number
According to source.
3) chart style is customized
On the basis of original chart parameter, the original visuals components such as wide height, background colour, transparency, coordinate value are supported
Parameter setting, realize the personalized setting of chart.
4) chart fast response time
The reading of data selects to read from caching or the direct-connected acquisition of database can under the data cases of million ranks
To reach the response speed within 2 seconds.
Detailed description of the invention
Fig. 1 is visualized data analysis flow chart diagram of the invention.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments, based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention
The invention mainly comprises the secondary envelopes of the echarts of two parts visualization component (being not limited to the visualization component)
Dress, relevant database data precomputation model, detailed process are detailed in Fig. 1, visualized data analysis process.
Technical solution of the present invention is as follows:
One, (not limited to this component may include highcharts, D3.js to the secondary encapsulation of visualization component echarts
Deng)
(1) each chart of visualization component echarts is standardized encapsulation, be encapsulated as common data acquisition component js,
Each chart js is respectively used to the acquisition of chart data, and defines for chart style personalization, the load of chart data.
(2) public data securing component, including 3 partial datas obtain, respectively dimension data, and dimension calculates data, dimension
Degree defines data
(3) each chart components js includes four parts, and echarts base model configures, customized style configuration loading method,
Data load method, branch's chart definition (such as histogram is divided into accumulation histogram, percentage histogram)
Two, relevant database data precomputation model
(1) relevant database data precomputation model is divided into data source load, self-defining data collection obtains, according to dimension
Raw data set sql is assembled, database connection, obtains initial data, obtain dimension data, customized expression calculates, data
Collection filters this 8 part.
(2) data source is loaded as obtaining the parameters such as original database address, user name, password, connects for database
(3) self-defining data collection obtains, and is the data acquisition system selected for analysis, can be configured by sql or data model
(4) assembled according to dimension raw data set sql, it, can be according to analysis in the case where data set is customized sql
Dimension and aggregate function, automatically generate obtain data original sql
(5) database connects, and is established the link by the configuration of data source to database
(6) it obtains dimension data and the data acquisition system of dimension is got according to the result set of (4) part respectively
(7) customized expression calculates, and on the basis of dimension data, according to the expression formula of setting, carries out mathematics automatically
Operation generates new dimension data
(8) data set filters, can be to the data of dimension if the data of configuration show that the filtering for having data in model configures
It is filtered, only returns to the data acquisition system to be analyzed.
The foregoing is merely presently preferred embodiments of the present invention, is only used to illustrate the technical scheme of the present invention, and is not intended to limit
Determine protection scope of the present invention.Any modification, equivalent substitution, improvement and etc. done all within the spirits and principles of the present invention,
It is included within the scope of protection of the present invention.
Claims (9)
1. a kind of visual government affairs service data analysis method, which is characterized in that
Based on open source Visual Chart component and onboard data precomputation model, the various charts provided open source js component are carried out
Secondary encapsulation receives unified parameter and data type, by the built-in data precomputation model of calling, returns the result data,
Realize that the chart visualization of data acquisition system shows.
2. the method according to claim 1, wherein
The general relevant database of data precomputation model supports includes oracle, sqlserver, mysql, db2, can be right
Million grades of data realization second grade shows output.
3. method according to claim 1 or 2, which is characterized in that
The data precomputation model, according to the analysis dimension of configuration, measure and other customized calculation expressions, automatically
Assembled sql sentence obtains primary Calculation data from data source, then passes through the filtering of data acquisition system, collects, and calculates final
As a result, back to encapsulation chart in, for data show.
4. according to the method described in claim 3, it is characterized in that,
The visualization component includes echarts or highcharts or D3.js.
5. according to the method described in claim 4, it is characterized in that,
Each chart of visualization component is standardized encapsulation, is encapsulated as common data acquisition component js, each chart js, respectively
It is defined for the acquisition of chart data, and for chart style personalization, the load of chart data.
6. according to the method described in claim 5, it is characterized in that,
Public data securing component, including 3 partial datas obtain, respectively dimension data, and dimension calculates data, and dimension defines number
According to.
7. according to the method described in claim 5, it is characterized in that,
Each chart components js includes four parts, and echarts base model configures, and customized style configuration loading method, data add
Support method, branch's chart definition.
8. the method according to claim 1, wherein
Database data precomputation model is divided into data source load, self-defining data collection obtains, according to dimension raw data set sql
Assembled, database connection, acquisition initial data, acquisition dimension data, customized expression calculates, data set filters this 8 part.
9. according to the method described in claim 8, it is characterized in that,
(1) data source is loaded as obtaining original database address, user name, password, connects for database；
(2) self-defining data collection obtains, and is the data acquisition system selected for analysis, can be configured by sql or data model；
(3) assembled according to dimension raw data set sql, it, can be according to the dimension of analysis in the case where data set is customized sql
Degree and aggregate function automatically generate the original sql for obtaining data；
(4) database connects, and is established the link by the configuration of data source to database；
(5) it obtains dimension data and the data acquisition system of dimension is got according to the result set of (3) part respectively；
(6) customized expression calculates, and on the basis of dimension data, according to the expression formula of setting, performs mathematical calculations automatically,
Generate new dimension data；
(7) data set filters, if the data of configuration show that the filtering for having data in model configures, can carry out to the data of dimension
Filtering, only returns to the data acquisition system to be analyzed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910151741.2A CN109872265A (en) | 2019-02-28 | 2019-02-28 | A kind of visual government affairs service data analysis method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910151741.2A CN109872265A (en) | 2019-02-28 | 2019-02-28 | A kind of visual government affairs service data analysis method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109872265A true CN109872265A (en) | 2019-06-11 |
Family
ID=66919456
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910151741.2A Pending CN109872265A (en) | 2019-02-28 | 2019-02-28 | A kind of visual government affairs service data analysis method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109872265A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111176634A (en) * | 2020-01-17 | 2020-05-19 | 天阳宏业科技股份有限公司 | Method and device for configurable embeddable high-tube view |
| CN112084194A (en) * | 2020-09-07 | 2020-12-15 | 广东赛博威信息科技有限公司 | ECharts-based visual chart self-defining method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| US20170235466A1 (en) * | 2015-06-17 | 2017-08-17 | NetSuite Inc. | System and Method to Generate Interactive User Interface for Visualizing and Navigating Data or Information |
| CN108228169A (en) * | 2017-12-08 | 2018-06-29 | 平安科技（深圳）有限公司 | Chart production method, apparatus, equipment and medium based on eCharts tools |
-
2019
- 2019-02-28 CN CN201910151741.2A patent/CN109872265A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| US20170235466A1 (en) * | 2015-06-17 | 2017-08-17 | NetSuite Inc. | System and Method to Generate Interactive User Interface for Visualizing and Navigating Data or Information |
| CN108228169A (en) * | 2017-12-08 | 2018-06-29 | 平安科技（深圳）有限公司 | Chart production method, apparatus, equipment and medium based on eCharts tools |
Non-Patent Citations (2)
| Title |
|---|
| RICO_WANG: "《简书》", 12 December 2017 * |
| 张烨: "基于物化数据立方体的营销数据在线分析平台设计与实现", 《中国优秀硕士学位论文全文数据库》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111176634A (en) * | 2020-01-17 | 2020-05-19 | 天阳宏业科技股份有限公司 | Method and device for configurable embeddable high-tube view |
| CN112084194A (en) * | 2020-09-07 | 2020-12-15 | 广东赛博威信息科技有限公司 | ECharts-based visual chart self-defining method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107256265B (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
| CN110019396A (en) | A kind of data analysis system and method based on distributed multidimensional analysis | |
| CN107193967A (en) | A kind of multi-source heterogeneous industry field big data handles full link solution | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN107122344B (en) | Report generation method and system | |
| CN109597974B (en) | Report generation method and device | |
| CN110334274A (en) | Information-pushing method, device, computer equipment and storage medium | |
| Johannesson et al. | Systematic product platform design: a combined function-means and parametric modeling approach | |
| CN106484785B (en) | A kind of method of efficient Automatic Adaptation Data field mapping | |
| CN110533389A (en) | The determination method and device of Project Cost | |
| Froeschl | Metadata management in statistical information processing: a unified framework for metadata-based processing of statistical data aggregates | |
| CN109597858B (en) | Merchant classification method and device and merchant recommendation method and device | |
| CN109165428B (en) | Intelligent clothing customization platform | |
| CN105824855B (en) | Method and device for screening and classifying data objects and electronic equipment | |
| CN109872265A (en) | A kind of visual government affairs service data analysis method | |
| CN110851667A (en) | Integrated analysis method and tool for multi-source large data | |
| Homocianu et al. | Business Intelligence facilities with applications in audit and financial reporting | |
| CN106484401A (en) | A kind of Automated Refactoring of object-oriented software | |
| CN110232178A (en) | Report generation method and device | |
| CN109002334A (en) | A kind of operation platform and its data processing method | |
| CN110826896A (en) | Data processing control method and device, computer equipment and storage medium | |
| CN111522817B (en) | Table content mapping system, method and non-transitory storage medium | |
| Rossi et al. | Design for environmental sustainability: collect and use company information to design green products | |
| CN110109902A (en) | A kind of electric business platform recommender system based on integrated learning approach | |
| Görg et al. | Multinationals and productivity spillovers |
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: 20190611 |