CN105335508A - Method for visually displaying data source information by dragging on basis of browser - Google Patents
Method for visually displaying data source information by dragging on basis of browser Download PDFInfo
- Publication number
- CN105335508A CN105335508A CN201510725019.7A CN201510725019A CN105335508A CN 105335508 A CN105335508 A CN 105335508A CN 201510725019 A CN201510725019 A CN 201510725019A CN 105335508 A CN105335508 A CN 105335508A
- Authority
- CN
- China
- Prior art keywords
- data
- browser
- dimension
- tolerance
- visual
- 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/90—Details of database functions independent of the retrieved data types
- G06F16/904—Browsing; Visualisation therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention relates to a method for visually displaying data source information by dragging on the basis of a browser. The method comprises the following steps: step 1) measuring drag dimensionality, namely dragging different types of data to each area, the data types are divided into date type dimensionality, non-date type dimensionality and screening area; step 2) automatically generating or configuring the dimensionality, measurement, and SQL (structured query language) statements of automatic generation according to the differences of areas-dragged in and the data types, and sending a request to backend; step 3) according to an array returned from the backend, rendering and constructing visual analysis graphics through JS and html technologies, and displaying data according to the visual graphics; step 4) acquiring data once, then storing the data into browser caching, freely switching other diagrams until the dimensionality and the measurement are changed. According to the method, relation and change condition among data can be more intuitively shown to users, read and think time of the users can be reduced, data validity can be improved, the simple operational motion of visual dragging can perform an analysis of large data.
Description
Technical field
The present invention relates to data source information display packing, particularly relate to a kind of visual method pulling display data sources information based on browser.
Background technology
, there is following defect at present data analysis tool on the market: (1) only have fraction to understand the people of technology can use; (2) be all that city edition installs can not compatible major browsers; (3) need to go to write complicated SQL statement, threshold is high; (4) data analysis more complicated needs to understand data structure and database.
Summary of the invention
For overcoming the deficiencies in the prior art, the object of the present invention is to provide a kind of easy to operate, simple visual method pulling display data sources information based on browser of introduction.
For achieving the above object, the present invention is achieved through the following technical solutions:
Based on the visual method pulling display data sources information of browser, comprise the following steps:
Step 1) pull dimension tolerance: namely pull different types of data into each region, wherein said data type is divided into date class dimension, non-date class dimension, screening areas;
Step 2) automatically generate according to the difference of the described each region pulled into and described data type or be configured to dimension, tolerance, automatically generates SQL statement, sends a request to rear end;
Step 3) array that returns according to rear end, played up by JS, html technology and build visual analyzing figure, show data by visualized graphs;
Step 4) obtain a secondary data then stored in browser rs cache, can freely switch other charts, until the change of dimension tolerance.
Preferably, the described visual method pulling display data sources information based on browser, wherein, and described step 1) also comprising all data generates or is configured to dimension, tolerance automatically before.
Preferably, the described visual method pulling display data sources information based on browser, wherein, described step 1) after also comprise the dimension of described garbled data, tolerance jumps out screening frame, enters described step 2 after then inputting screening conditions).
Preferably, the described visual method pulling display data sources information based on browser, wherein, described step 1) after comprise described date dimension display enter described step 2 to sky).
Beneficial effect of the present invention: this method solve current one of the server end that is accumulated in and push away greatly data close and numerous, hard to understand, being pulled digital conversion by simple mouse is figure, can more intuitively to the contact between user's display data and situation of change, reduce reading and the think time of user, to make a policy well, excavate its existent value, promote data validity; " visual pull " shirtsleeve operation action just can carry out huge data analysis, and everybody can be used, and everybody can use:
(1) ease for use: application is simple, enters gate threshold low, does not need meeting sql like language, major browsers that can be compatible applied on the market;
(2) interactivity: simple and quick, represents dimension (X-axis) tolerance (Y-axis) field fast;
(3) visual: to be pulled by simple mouse, the effect that complicated SQL statement is identical can be realized;
(4) user does not need to understand data structure, database;
(5) application: applied range, can be applicable to the data source information process in each large field.
Accompanying drawing explanation
Fig. 1 is the visual schematic flow sheet pulling the method for display data sources information based on browser described in one embodiment of the invention.
Embodiment
Below in conjunction with accompanying drawing, the present invention is described in further detail, can implement according to this with reference to instructions word to make those skilled in the art.
Based on the visual method pulling display data sources information of browser, refer to accompanying drawing 1, comprise: play up chart at browser end and insert the information that rear end returns, namely back-end services configuration different pieces of information source is asked, metadata configurations, comprise JS by front-end code, html technology generates Visual Chart automatically, comprises the following steps:
Step 1) pull dimension tolerance: namely pull different types of data into each region, wherein said data type is divided into date class dimension, non-date class dimension, screening areas;
Step 2) automatically generate according to the difference of the described each region pulled into and described data type or be configured to dimension, tolerance, automatically generates SQL statement, sends a request to rear end;
Step 3) array that returns according to rear end, played up by JS, html technology and build visual analyzing figure, show data by visualized graphs;
Step 4) obtain a secondary data then stored in browser rs cache, can freely switch other charts, until the change of dimension tolerance.Formulate region dimension metric parameter by front end webpage transmission and generate SQL statement, all action needs are dragged in appointed area, are pulled by simple mouse, realize the combination of data and chart, can realize the effect that complicated SQL statement is identical;
Further, described step 1) also comprising all data generates or is configured to dimension, tolerance automatically before.
Further, described step 1) after also comprise the dimension of described garbled data, tolerance jumps out screening frame, enters described step 2 after then inputting screening conditions).
Further, described step 1) after comprise the dimension display of described date enter described step 2 to sky).
Although embodiment of the present invention are open as above, but it is not restricted to listed in instructions and embodiment utilization, it can be applied to various applicable the field of the invention completely, for those skilled in the art, can easily realize other amendment, therefore do not deviating under the universal that claim and equivalency range limit, the present invention is not limited to specific details and illustrates here and the legend described.
Claims (4)
1., based on the visual method pulling display data sources information of browser, it is characterized in that, comprise the following steps:
Step 1) pulls dimension tolerance: namely pull different types of data into each region, wherein said data type is divided into date class dimension, non-date class dimension, screening areas;
Step 2) automatically generate according to the difference of the described each region pulled into and described data type or be configured to dimension, tolerance, automatically generates SQL statement, sends a request to rear end;
The array that step 3) returns according to rear end, is played up by JS, html technology and builds visual analyzing figure, show data by visualized graphs;
Step 4) obtains a secondary data then stored in browser rs cache, can freely switch other charts, until the change of dimension tolerance.
2., as claimed in claim 1 based on the visual method pulling display data sources information of browser, it is characterized in that, also comprise all data before described step 1) and automatically generate or be configured to dimension, tolerance.
3. as claimed in claim 2 based on the visual method pulling display data sources information of browser, it is characterized in that, also comprise the dimension of described garbled data after described step 1), tolerance jumps out screening frame, after then inputting screening conditions, enter described step 2).
4. as claimed in claim 3 based on the visual method pulling display data sources information of browser, it is characterized in that, comprise described date dimension display after described step 1) and enter described step 2 to sky).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510725019.7A CN105335508A (en) | 2015-10-29 | 2015-10-29 | Method for visually displaying data source information by dragging on basis of browser |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510725019.7A CN105335508A (en) | 2015-10-29 | 2015-10-29 | Method for visually displaying data source information by dragging on basis of browser |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105335508A true CN105335508A (en) | 2016-02-17 |
Family
ID=55286035
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510725019.7A Pending CN105335508A (en) | 2015-10-29 | 2015-10-29 | Method for visually displaying data source information by dragging on basis of browser |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105335508A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106503202A (en) * | 2016-10-26 | 2017-03-15 | 广州市勤思网络科技有限公司 | The Dynamic Configuration that a kind of data drawing list linkage shows |
| CN106777121A (en) * | 2016-12-16 | 2017-05-31 | 济南浪潮高新科技投资发展有限公司 | A kind of service end caching method of browser chart |
| CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
| CN108536696A (en) * | 2017-03-02 | 2018-09-14 | 塞纳德（北京）信息技术有限公司 | A kind of database personalized self-service query platform and method |
| CN109254976A (en) * | 2017-07-11 | 2019-01-22 | ***通信集团北京有限公司 | A kind of method for drafting of figure, device, electronic equipment and storage medium |
| CN109446209A (en) * | 2018-09-13 | 2019-03-08 | 北京中科闻歌科技股份有限公司 | A kind of generation of dynamic screen and display methods and system |
| CN112100991A (en) * | 2019-05-30 | 2020-12-18 | 北京奇虎科技有限公司 | Data report generation method and device |
| CN113254812A (en) * | 2021-06-17 | 2021-08-13 | 浙江口碑网络技术有限公司 | Object set generation method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| CN104915378A (en) * | 2015-05-08 | 2015-09-16 | 珠海世纪鼎利通信科技股份有限公司 | Rapid statistics task generation system and method suitable for big data |
-
2015
- 2015-10-29 CN CN201510725019.7A patent/CN105335508A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| CN104915378A (en) * | 2015-05-08 | 2015-09-16 | 珠海世纪鼎利通信科技股份有限公司 | Rapid statistics task generation system and method suitable for big data |
Non-Patent Citations (1)
| Title |
|---|
| 大数据魔镜知识问答社区: "了解数据可视化分析台？", 《HTTP://ZHISHI.MOOJNN.COM/QUESTION/368》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106503202A (en) * | 2016-10-26 | 2017-03-15 | 广州市勤思网络科技有限公司 | The Dynamic Configuration that a kind of data drawing list linkage shows |
| CN106777121A (en) * | 2016-12-16 | 2017-05-31 | 济南浪潮高新科技投资发展有限公司 | A kind of service end caching method of browser chart |
| CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
| CN106909610B (en) * | 2017-01-10 | 2020-11-24 | 中电科华云信息技术有限公司 | Method and system for visually dragging and querying data based on browser |
| CN108536696A (en) * | 2017-03-02 | 2018-09-14 | 塞纳德（北京）信息技术有限公司 | A kind of database personalized self-service query platform and method |
| CN109254976A (en) * | 2017-07-11 | 2019-01-22 | ***通信集团北京有限公司 | A kind of method for drafting of figure, device, electronic equipment and storage medium |
| CN109446209A (en) * | 2018-09-13 | 2019-03-08 | 北京中科闻歌科技股份有限公司 | A kind of generation of dynamic screen and display methods and system |
| CN112100991A (en) * | 2019-05-30 | 2020-12-18 | 北京奇虎科技有限公司 | Data report generation method and device |
| CN113254812A (en) * | 2021-06-17 | 2021-08-13 | 浙江口碑网络技术有限公司 | Object set generation method and device |
| CN113254812B (en) * | 2021-06-17 | 2021-09-28 | 浙江口碑网络技术有限公司 | Object set generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105335508A (en) | Method for visually displaying data source information by dragging on basis of browser | |
| CN106909610B (en) | Method and system for visually dragging and querying data based on browser | |
| CN109033260B (en) | Knowledge graph interactive visual query method based on RDF | |
| WO2016041372A1 (en) | Data presentation method and device | |
| US11727200B2 (en) | Annotation tool generation method, annotation method, electronic device and storage medium | |
| CN104699742B (en) | Method, system and product for enabling extended extreme visualization of large datasets | |
| CN105843945A (en) | Report generation method and system | |
| WO2014140977A9 (en) | Improving entity recognition in natural language processing systems | |
| US10078634B2 (en) | Visualizing and exploring natural-language text | |
| JP2017517069A (en) | Automatic generation of semantic mapping for relational databases | |
| WO2017152703A1 (en) | Three-dimensional tag implementation method and device | |
| CN112256790A (en) | WebGL-based three-dimensional visualization display system and data visualization method | |
| CN111078729B (en) | Medical data tracing method, device, system, storage medium and electronic equipment | |
| CN108829653A (en) | A kind of generation method of report, device, equipment and medium | |
| CN117057318A (en) | Domain model generation method, device, equipment and storage medium | |
| CN109617944B (en) | WEB parameter management method, device, computer storage medium and equipment | |
| CN114356962A (en) | Data query method and device, electronic equipment and storage medium | |
| CN108008947B (en) | Intelligent prompting method and device for programming statement, server and storage medium | |
| CN110909017B (en) | Data analysis method and system | |
| Fu et al. | The SQL-based all-declarative FORWARD web application development framework. | |
| CN103605806A (en) | Implementation method for configurable structural data organization mode | |
| CN107515913A (en) | A kind of multivariate data model integrated construction method and its virtual interactive interface system | |
| Hilliard | OPTIMISING VIEWER COMPREHENSION AND SHAPING IMPRESSIONS AND ATTENTION: through the formatting of content in tools like Microsoft® PowerPoint® | |
| CN111221898B (en) | Data visualization method based on browser | |
| Schwärzler et al. | Fast accurate soft shadows with adaptive light source sampling |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160217 |
|
| RJ01 | Rejection of invention patent application after publication |