CN105511885B - The method that data visualization is realized in business intelligence data application JSON description - Google Patents
The method that data visualization is realized in business intelligence data application JSON description Download PDFInfo
- Publication number
- CN105511885B CN105511885B CN201510933002.0A CN201510933002A CN105511885B CN 105511885 B CN105511885 B CN 105511885B CN 201510933002 A CN201510933002 A CN 201510933002A CN 105511885 B CN105511885 B CN 105511885B
- Authority
- CN
- China
- Prior art keywords
- data
- visualization
- description
- business intelligence
- panels
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/31—Programming languages or programming paradigms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides utilize JSON to describe basic bivariate table data in business intelligence and be applied to a kind of method of data visualization, include: that JSONization description is carried out to the original service data column of user's two dimension sheet form, high flexible, expansible data column description definition are provided in the data visualization of business intelligence；This data structure will be used to create complex query in business intelligence, and the data description used for various data visualization components is finally organized into combination with query result.The present invention can make the user of business intelligence visualization tool and developer more direct to the setting of visualization option, and the pilot process for avoiding concern complicated is absorbed in specific visualization tasks and is realized.
Description
Technical field
The invention belongs to business intelligence fields, more particularly, to a kind of method for describing visualized data using JSON.
Background technique
Business intelligence software usually requires to turn to data visualization with break-up value and particular proposition chart, and original use
User data can not provide more diverse, customized information for final visualization, meanwhile, for using third party's visualization group
For the developer and user of part, design and safeguard that the process of data and visual description will be duplicate, and complicated mistake
Journey.The basic graphics library iteration of data visualization is very fast, this requirement is right in the exploitation and use process of business intelligence software
The adjustment of visualization component type selecting must also closely follow its paces, it is a kind of universal standard, the high applicability and high scalability can
It is needed depending on changing data description by inevitable design is become.
Summary of the invention
The problem to be solved in the present invention is the business intelligence data for being applied to visible customization using JSON description, avoids closing
Complicated pilot process is infused, specific visualization tasks is absorbed in and realizes.
The technical solution adopted by the present invention is that: the method that data visualization is realized in business intelligence data application JSON description,
Include:
1) JSONization description is carried out to the original service data column of user's two dimension sheet form, establishes the description of visualized data area
Item set panels；
2) complex query is created with this data structure, be finally organized into combination with query result for various data visualizations
The data description that component uses.
Preferably, the step of step 1) panels is established are as follows:
101) by reading the basic table structure of data source, initial field project is created；
102) default formization definition is specified in field project；
103) by field assignment on item.field attribute and fill or by ui allow the specified setting of user other belong to
Property；
104) item is assigned to corresponding visualized data area gathers and finally described.
Further, other attributes described in step 103) include level, title, derivation, sort attribute.
Further, the implementation method of step 2) are as follows:
201) data query description is assembled into according to the panels result of step 1), and executes inquiry；
202) after returning to query results, item set panels is described again depending on visualized data area and is organized data into
The supported standard input data of Visual Chart, and visualize.
The design philosophy that the present invention uses is that the setting for arranging data user is described as JSON data segment, these data quilts
Group is woven in the set of relatively different group descriptions, these group descriptions are directly related to the setting of the data field of Visual Chart, in conjunction with
Query result describes to determine the data distribution in chart according to this JSON.The present invention can make making for business intelligence visualization tool
User and developer are more direct to the setting of visualization option, and the pilot process for avoiding concern complicated is absorbed in and specifically may be used
It is realized depending on change task.
Detailed description of the invention
Fig. 1 is the schematic diagram for inquiring and realizing data visualization in the prior art；
Fig. 2 is that JSON of the present invention describes user data setting area；
Fig. 3 is visualization result of the present invention.
Specific embodiment
The process of data visualization is inquired and realized as shown in Figure 1 in the prior art, it is seen that original user in the prior art
Data can not provide more diverse, customized information for final visualization, meanwhile, for using third party's visualization component
Developer and user for, design and safeguard that the process of data and visual description is duplicate, and complicated process.
The setting that user arranges data is described as JSON data segment by the present invention, these data are organized in relatively different groups
In the set of description, these group descriptions are directly related to the setting of the data field of Visual Chart, in conjunction with query result according to this
JSON description determines the data distribution in chart.
1. initial field project is created by the basic table structure for reading data source, such as:
3. by field assignment on item.field attribute and fill (or by ui allow the specified setting of user) other
The attributes such as level, title, derivation, sort；
4. item is assigned to corresponding visualized data area gathering and finally being described and (or allow user is specified to set by ui
It sets)；
5. being assembled into data query description according to this panels, and execute inquiry；
6. after returning to query results, describing that item set panels organizes data into again depending on visualized data area can
Depending on changing the supported standard input data of chart, and visualize.
As shown in Fig. 2, to describe example as follows by JSON；
Wherein, panels is that visualized data area describes item set, comparative diagram 1 respectively represent x-axis, y-axis and
Breakby (data grouping)；
Items is the description item set for inserting data field in visualized data；
Field and format is two groups of important descriptions of data item, the field essential informations for describing data item and
User's setting, and format then describes the Green Formula that data should apply after visualization；
ColumnName is field unique identification, and respective column is nominal in the table of corresponding data source；
DataType indicates the data type of this field；
DbTableName indicates data source identification belonging to this field；
Level is the fractionation grade setting that detachable data arrange (such as date type column data)；
Display Name when title is visualization；
Derivation is field polymeric type；
Sort is field sequence setting；
Sort.order is field sortord；
Sort.priority is field Sort Priority.
Data structure obtained above will be used to create complex query in business intelligence, final in combination with query result
It is organized into the data description used for various data visualization components, query structure example is as follows:
Final result is as shown in Figure 3.
One embodiment of the present invention has been described in detail above, but the content is only preferable implementation of the invention
Example, should not be considered as limiting the scope of the invention.It is all according to all the changes and improvements made by the present patent application range
Deng should still be within the scope of the patent of the present invention.
Claims (2)
1. the method that data visualization is realized in business intelligence data application JSON description characterized by comprising
1) JSONization description is carried out to the original service data column of user's two dimension sheet form, establishes visualized data area and describes item collection
Close panels；
2) complex query is created with the step 1) panels, be finally organized into combination with query result for various data visualizations
Change the data description that component uses；
The step of step 1) panels is established are as follows:
101) by reading the basic table structure of data source, initial field project is created；
102) default formization definition is specified in field project；
103) field assignment on item.field attribute and is filled or allows user is specified other attributes are arranged by ui；
104) item is assigned to corresponding visualized data area gathers and finally described；
The implementation method of step 2) are as follows:
201) data query description is assembled into according to the panels of step 1), and executes inquiry；
202) after returning to query results, item set panels is described again depending on visualized data area and is organized data into visually
Change the supported standard input data of chart, and visualizes.
2. the method that data visualization is realized in business intelligence data application JSON description according to claim 1, feature
It is, other attributes described in step 103) include level, title, derivation, sort attribute.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510933002.0A CN105511885B (en) | 2015-12-12 | 2015-12-12 | The method that data visualization is realized in business intelligence data application JSON description |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510933002.0A CN105511885B (en) | 2015-12-12 | 2015-12-12 | The method that data visualization is realized in business intelligence data application JSON description |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105511885A CN105511885A (en) | 2016-04-20 |
| CN105511885B true CN105511885B (en) | 2019-03-08 |
Family
ID=55719895
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510933002.0A Active CN105511885B (en) | 2015-12-12 | 2015-12-12 | The method that data visualization is realized in business intelligence data application JSON description |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105511885B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106802804B (en) * | 2017-01-12 | 2020-01-10 | 合肥速显微电子科技有限公司 | Method and system for visualizing variable association component of human-computer interface |
| CN107832282A (en) * | 2017-11-21 | 2018-03-23 | 苏州正载信息技术有限公司 | A kind of implementation method for defining Visual Report Forms |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8874620B1 (en) * | 2011-06-15 | 2014-10-28 | Amazon Technologies, Inc. | Data transfer optimization |
| CN104572096A (en) * | 2014-12-29 | 2015-04-29 | 中国科学院计算机网络信息中心 | Multi-model data visualization development method based on WEB and platform thereof |
| CN105094928A (en) * | 2015-09-06 | 2015-11-25 | 浪潮集团有限公司 | Dynamic chart loading method based on plug-in |
-
2015
- 2015-12-12 CN CN201510933002.0A patent/CN105511885B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8874620B1 (en) * | 2011-06-15 | 2014-10-28 | Amazon Technologies, Inc. | Data transfer optimization |
| CN104572096A (en) * | 2014-12-29 | 2015-04-29 | 中国科学院计算机网络信息中心 | Multi-model data visualization development method based on WEB and platform thereof |
| CN105094928A (en) * | 2015-09-06 | 2015-11-25 | 浪潮集团有限公司 | Dynamic chart loading method based on plug-in |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105511885A (en) | 2016-04-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106528129B (en) | A kind of Web application interface generation system and method | |
| CN102779040B (en) | A kind of method and apparatus generating customizing form | |
| CN106055528B (en) | Document automatic generation method and device | |
| US8683370B2 (en) | Systems and methods for generating data visualization dashboards | |
| CN105717890B (en) | Industrial automation visualizes instrument board and creates example | |
| CN105487864A (en) | Method and device for automatically generating code | |
| CN111190597A (en) | Data UE visual design system | |
| CN102567027B (en) | Interface framework construction system and interface framework construction method | |
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| CN104063361A (en) | Report design method and system | |
| US10448227B2 (en) | Mobile database access application development system and method | |
| CN103838933A (en) | Three-dimensional model integrating and labeling method based on digital technology | |
| WO2014070037A1 (en) | Automated report generation method | |
| AU2017322114A8 (en) | Real-time document filtering systems and methods | |
| CN104063495A (en) | Form extension method and form extension device | |
| CN105701165B (en) | Browser model switching method and switching device | |
| CN105511885B (en) | The method that data visualization is realized in business intelligence data application JSON description | |
| CN104679792A (en) | Data permission achievement method | |
| CN107273369A (en) | A kind of table data modification method and device | |
| CN105138355A (en) | Method and device for inserting elements in interface of application program and electronic equipment | |
| CN104699863A (en) | Webpage data display system | |
| CN102496081A (en) | Three-dimensional visualized and interaction method of project structured message | |
| CN108255964B (en) | Method for displaying process flow route | |
| CN104615431A (en) | Method and device for achieving Web application | |
| CN107067200A (en) | The operating method and device of a kind of BOM data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |