CN109086397B - Dynamic report generation method based on query dimension - Google Patents
Dynamic report generation method based on query dimension Download PDFInfo
- Publication number
- CN109086397B CN109086397B CN201810850055.XA CN201810850055A CN109086397B CN 109086397 B CN109086397 B CN 109086397B CN 201810850055 A CN201810850055 A CN 201810850055A CN 109086397 B CN109086397 B CN 109086397B
- Authority
- CN
- China
- Prior art keywords
- data
- query
- search engine
- display
- generation method
- 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
Images
Landscapes
- Processing Or Creating Images (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a dynamic report generation method based on query dimension, which comprises the following steps: s1: constructing a real-time data stream, and completing real-time data indexing by a search engine through association with the search engine; establishing connection between a data source and a search engine, and finishing an asynchronous data indexing process between the search engine and the data source; s2: acquiring data query information, wherein the data query information at least comprises keywords, data presentation dimensions and statistical indexes; s3: after receiving the input of query information, the search engine converts the query instruction of the data query information according to a processing rule set by a preset system and executes a query statement to return a query result; s4 converting the query result set into a data result set used for representing computer graphics; s5: after a data result set is obtained, rendering through a graphic rendering engine; s6: presenting the above graphical data on a display; s7: S3-S6 are executed again after a designated time. The effect of displaying the data change condition in a plurality of visual modes in real time is achieved, and data analysis work is facilitated.
Description
Technical Field
The invention relates to the technical field of data visualization, in particular to a dynamic report generation method based on query dimension
Background
The intelligent old man care is a sensing network system and an information platform for the old man at home, a community and an old man care mechanism, and provides real-time, quick, efficient and low-cost, internet-of-things, interconnection and intelligent old man care service on the basis, and the intelligent old man care not only can protect the safety of the old man at any time, but also can monitor the health condition of the old man in an all-round manner.
With the continuous popularization of 'intelligent endowment', the information platform can acquire a large amount of relevant data through the sensing network system, and can play a positive promoting role in the optimization of endowment services, the formulation of management and management strategies of service organizations, relevant policy and regulations and the like through the analysis of the data; however, how to search data quickly through keywords for the data and show the data result to users clearly, accurately, vividly and easily becomes a new problem.
Most of the existing endowment information platform systems or tools provide data query and report generation functions, and data are displayed in planar graphs such as bar charts, pie charts and the like through a chart system or tool, so that the purposes of data retrieval and data visualization are achieved.
However, the existing technology has the disadvantage that most of the existing data visualization systems or tools are difficult to meet the requirement of real-time data display, that is, the data change situation can be displayed in a plurality of visualization modes in real time in a dynamic report form, which brings inconvenience to the data analysis work.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provides a dynamic report generation method based on query dimensionality, different dynamic reports are generated according to differential query requirements, the data change condition can be displayed in a plurality of visual modes in real time, and data analysis work is facilitated.
The purpose of the invention is realized by the following technical scheme: the dynamic report generation method based on the query dimension comprises the following steps:
s1: constructing a real-time data stream, and completing real-time data indexing by a search engine through association with the search engine; establishing connection between a data source and a search engine, and finishing an asynchronous data indexing process between the search engine and the data source;
s2: acquiring data query information, wherein the data query information at least comprises keywords, data presentation dimensions and statistical indexes;
s3: after receiving the input of query information, the search engine converts the query instruction of the data query information according to a processing rule set by a preset system and executes a query statement to return a query result;
s4 converting the query result set into a data result set used for representing computer graphics;
s5, after obtaining the data result set, rendering through a graphic rendering engine;
s6 presenting the above graphic data on a display;
s7 executes S3-S6 again after a designated time.
By the method, the connection between the data source and the search engine is established, the query statement is obtained through the conversion of the query information so as to realize the differentiated query requirement, the query result is converted into different graphical dynamic reports, the implementation and the updating are obtained, the data change condition can be displayed in a plurality of visual modes in real time, and the data analysis work is greatly facilitated.
Further, in step S4, according to the difference between the data presentation dimension and the statistical index, using a preset comparison table to perform shape indexing on the data structure representing the computer graphics converted from the different query result sets;
using a plurality of differently shaped displays, each also having a shape index attached thereto, in step S6; matching the display with the computer graphics according to the principle of same shape indexing; and displaying the computer graphics on a display matched with the computer graphics.
The graphical dynamic report is more reasonably displayed by utilizing the matching of the shape and the graph.
Further, in step S6, one or more of a square, rectangular, circular and triangular display is used, and accordingly, the shape index includes one or more of a square, rectangular, circular and triangular.
The display is arranged aiming at the commonly used display graphs, so that the adaptability is strong.
Further, in step S6, a total display is used, and the LED display is divided into different shaped areas, each area being used as a separate display.
The split screen and partition function of the display equipment is utilized, the hardware quantity is reduced, the system is simplified, and the cost is saved.
Further, the display is an LED display.
The display has small volume, wide application and low cost.
Further, in step S3, the query information content is analyzed using NLP technology.
The NLP (natural language processing) processes the input query information, a user can directly utilize natural language to input information, keywords required by a generated instruction are analyzed, and the keywords do not need to be input according to a specified format, so that the input mode can be more natural and more convenient for the user to use.
Further, the data result set described in step S4 is returned in the form of an interface.
By using the interface technology, the result can be stored at a far end, and the result is only called locally by using a network instead of all data, so that the data transmission quantity is reduced.
Drawings
FIG. 1 is a flowchart of a dynamic report generation method based on query dimensions according to an embodiment of the present invention.
Fig. 2 is a schematic functional block diagram of a dynamic report generation system adopted in the embodiment of the present invention.
Detailed Description
The following is further detailed by way of specific embodiments:
the dynamic report generation method based on query dimension in the embodiment includes the following steps:
s1: the cloud server constructs a real-time data stream, and the search engine completes real-time data indexing by associating with the search engine; establishing connection between a data source and a search engine, and finishing an asynchronous data indexing process between the search engine and the data source;
s2: the cloud server acquires data query information from a local input terminal, wherein the data query information at least comprises keywords, data presentation dimensions and statistical indexes; for example, "the aged over 65 years old in Chongqing City distributes according to county and displays pie chart"
S3: after receiving query information input, a search engine performs word segmentation analysis on the query information by using an NPL (network provider language) technology to obtain corresponding keywords, data presentation dimensions and statistical indexes;
after the NPL technology analysis, the data required by the query is obtained, including a first-level region: in Chongqing, the query condition is that the age is more than 65 years old, the statistical index is that the second-level region (district and county) is taken as granularity, the statistical index is in proportion, and the data presentation dimension is a pie chart;
performing query instruction conversion on the data query information according to a processing rule set by a preset system, and executing a query statement to return a query result;
s4, converting the query result set into a data result set used for representing computer graphics, wherein the graph is marked as 'round' according to the preset shape;
s5, after obtaining the data result set, rendering through a graphic rendering engine;
s6 obtaining the above image data through API interface, and displaying the image data on a circular area divided on the main display according to the index of 'circle';
s7 executes S3-S6 again after 1 minute until an exit instruction is obtained.
The embodiment is implemented by the dynamic report generating system in fig. 2, which includes: the device comprises a data stream real-time construction module, an input module, an inquiry information processing module, a graphical rendering module, a display module and an updating module.
The data stream real-time construction module is associated with a search engine, and the search engine completes real-time data indexing; establishing connection between a data source and a search engine, and finishing an asynchronous data indexing process between the search engine and the data source;
a user inputs data query information through an input module, wherein the data query information at least comprises keywords, data presentation dimensions and statistical indexes;
after receiving the input of query information, the query information processing module performs word segmentation analysis on the query information by using an NPL (network provider language) technology to obtain corresponding keywords, data presentation dimensions and statistical indexes;
the query information processing module carries out query instruction conversion on the data query information according to a processing rule set by a preset system and sends the data query information to a search engine, and the search engine executes a query statement and returns a query result;
the graphical module converts the query result set into a data result set used for representing computer graphics, and indexes the graph according to preset shape indexes;
after the completion, the data is supplied to a local graphic rendering module in the form of an API (application programming interface), and the module is rendered through a graphic rendering engine module;
the display module displays the rendered graphic data on an area which is divided on the display and has a corresponding shape in a matching way according to the index; the area is obtained by dividing the sub-modules according to the preset setting, and the LED display is adopted in the embodiment.
According to the different input query information, a plurality of dynamic graphs can be displayed on the display, and according to the different display dimensions, the dynamic graphs can be but are not limited to bar graphs, graph graphs and pyramid graphs, and the corresponding shape indexes are respectively set to be rectangle, square and triangle.
The updating module triggers the query information processing module again to repeatedly send the unified query instruction after 1 minute, so that the graphic data can be updated; the process is repeated until an exit instruction is obtained, but the updating time can be set according to the speed of data change.
The data source and search engine of the present embodiment employ third party services, but may be built into the platform in some embodiments.
The data of the built-in data source comes from an intelligent old-age care robot used by the old, the robot has a plurality of data acquisition functions, the robot is particularly provided with functions of emotion recognition and acquisition of the old in the embodiment, the emotion recognition of the old adopts the technical means in the prior art, and the emotion of the old is acquired in real time through artificial intelligent matching means such as picture matching, sound matching and the like; on the other hand, by counting the emotion data in real time and arranging the emotion data on the display according to the places where the data are collected, and meanwhile, the emotion data points are distinguished according to the sequence of colors from cold to warm, for example, green is adopted for happy emotion, blue is adopted for sad emotion, red is adopted for angry and irritability, and white is adopted for no special emotion, so that a display mode similar to a heat point diagram is formed, the emotion data can be quantified, the value of the emotion beneficial to the old is high, the value of the emotion not beneficial or harmful to the old is low, and color filling is performed after region averaging is performed. Meanwhile, a data graph of the temperature, the air pressure, the noise and the medical facility distribution in the current area can be displayed; the distance hot spot diagram of the old and the children can be displayed by colors, namely, the farther the distance is, the deeper the color is, a plurality of children are based on the nearest one, the meeting frequency hot spot diagram of the old and the children can be displayed by colors, and the database also needs a robot to be equipped with the existing face recognition technology and a face feature library of the old and the children, which can be realized by the prior art means; finally, the different data graphs and the emotion graphs of the old people are used for carrying out cross analysis, so that instructive opinions are provided for macroscopic works such as infrastructure construction, issue of consolation, policy making, social security and the like, follow-up effects of the works can be analyzed through emotion change, and the big data are better used for providing old people with care.
The search engine completes real-time data indexing by associating with the search engine; the connection between the data source and the search engine is established, the search engine completes the asynchronous data indexing process with the data source, and the rendering technology of the graph, the API technology and the split screen display technology all adopt the prior art, and are not described herein again.
By the method, the connection between the data source and the search engine is established, the query information is converted to obtain the production statement to realize the differentiated query requirement, the query result is converted into different graphical dynamic reports, and the data change condition can be displayed in real time in various visual modes.
The foregoing is merely an example of the present invention, and common general knowledge in the field of known specific structures and characteristics is not described herein in any greater extent than that known in the art at the filing date or prior to the priority date of the application, so that those skilled in the art can now appreciate that all of the above-described techniques in this field and have the ability to apply routine experimentation before this date can be combined with one or more of the present teachings to complete and implement the present invention, and that certain typical known structures or known methods do not pose any impediments to the implementation of the present invention by those skilled in the art. It should be noted that, for those skilled in the art, without departing from the structure of the present invention, several changes and modifications can be made, which should also be regarded as the protection scope of the present invention, and these will not affect the effect of the implementation of the present invention and the practicability of the patent. The scope of the claims of the present application shall be determined by the contents of the claims, and the description of the embodiments and the like in the specification shall be used to explain the contents of the claims.
The methods, systems, and modules disclosed herein may be implemented in other ways. For example, the above-described embodiments are merely illustrative, and for example, the division of the modules may be merely a logical division, and an actual implementation may have another division, for example, a plurality of modules or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be referred to as an indirect coupling or communication connection through some interfaces, systems or modules, and may be in an electrical, mechanical or other form. The modules described as discrete components may or may not be physically separate, and the components shown as modules may or may not be physical modules, may be located in one place, or may be distributed over a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing module, or each of the modules may exist alone physically, or two or more modules are integrated into one module.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, an optical disk, or other various media capable of storing program codes.
Claims (7)
1. The dynamic report generation method based on the query dimension is characterized by comprising the following steps: the dynamic report generation method based on the query dimension comprises the following steps:
s1: constructing a real-time data stream, and completing real-time data indexing by a search engine through association with the search engine; establishing connection between a data source and a search engine, and finishing an asynchronous data indexing process between the search engine and the data source; the data source comprises a built-in data source, data of the built-in data source are from an elderly care robot used by the elderly, and the elderly care robot is used for collecting emotion data of the elderly in real time;
s2: acquiring data query information, wherein the data query information at least comprises keywords, data presentation dimensions and statistical indexes;
s3: after receiving the input of query information, the search engine converts the query instruction of the data query information according to a processing rule set by a preset system and executes a query statement to return a query result;
s4 converting the query result set into a data result set used for representing computer graphics;
s5, after obtaining the data result set, rendering through a graphic rendering engine;
s6 presenting the above graphic data on a display; the emotion data are counted in real time and arranged on a display according to the positions where the emotion data are collected, meanwhile, emotion data points are distinguished according to the sequence of colors from cold to warm, the emotion data are quantized, the emotion value beneficial to the old is high, the emotion value without benefit or harmful positions to the old is low, and color filling is performed after regional averaging;
s7 executes S3-S6 again after a designated time.
2. The query dimension-based dynamic report generation method according to claim 1, wherein: in step S4, according to the difference between the data presentation dimension and the statistical index, using a preset comparison table to perform shape indexing on the data structure representing the computer graphics converted from the different query result sets;
using a plurality of differently shaped displays, each also having a shape index attached thereto, in step S6; matching the display with the computer graphics according to the principle of same shape indexing; and displaying the computer graphics on a display matched with the computer graphics.
3. The query dimension-based dynamic report generation method according to claim 2, wherein: in step S6, one or more of a square, rectangular, circular and triangular display is used, and accordingly, the shape index includes one or more of a square, rectangular, circular and triangular.
4. The query dimension-based dynamic report generation method according to claim 2, wherein: in step S6, a total display is used, and the LED display is divided into different shaped areas, each area being used as a separate display.
5. The query dimension-based dynamic report generation method according to claim 4, wherein: the display adopts an LED display.
6. The query dimension-based dynamic report generation method according to claim 1, wherein: in step S3, the query information content is analyzed using NLP technology.
7. The query dimension-based dynamic report generation method according to claim 1, wherein: the data result set described in step S4 is returned in the form of an interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810850055.XA CN109086397B (en) | 2018-07-28 | 2018-07-28 | Dynamic report generation method based on query dimension |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810850055.XA CN109086397B (en) | 2018-07-28 | 2018-07-28 | Dynamic report generation method based on query dimension |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109086397A CN109086397A (en) | 2018-12-25 |
| CN109086397B true CN109086397B (en) | 2022-05-17 |
Family
ID=64833467
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810850055.XA Active CN109086397B (en) | 2018-07-28 | 2018-07-28 | Dynamic report generation method based on query dimension |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109086397B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109948009A (en) * | 2019-03-12 | 2019-06-28 | 福建奇点时空数字科技有限公司 | A kind of data visualization engine system |
| CN110489732A (en) * | 2019-07-23 | 2019-11-22 | 中国平安人寿保险股份有限公司 | Method for processing report data and equipment |
| CN110717319B (en) * | 2019-09-24 | 2023-10-20 | 车智互联（北京）科技有限公司 | Self-service report generation method, device, computing equipment and system |
| CN111143356B (en) * | 2019-12-12 | 2023-08-01 | 中盈优创资讯科技有限公司 | Report retrieval method and device |
| CN113535782B (en) * | 2021-07-22 | 2024-05-07 | 成都数之联科技股份有限公司 | BI report query response method, system, electronic equipment and computer readable storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102081641A (en) * | 2010-10-15 | 2011-06-01 | 上海海洋大学 | Design of GPU-based real-time data stream high-speed matching analysis system |
| JP5922255B2 (en) * | 2011-12-28 | 2016-05-24 | インテル コーポレイション | Real-time natural language processing of data streams |
| US20170124464A1 (en) * | 2015-10-28 | 2017-05-04 | Fractal Industries, Inc. | Rapid predictive analysis of very large data sets using the distributed computational graph |
| CN107256265B (en) * | 2017-06-14 | 2019-05-17 | 成都四方伟业软件股份有限公司 | A kind of search-engine results data visualization methods of exhibiting and system |
| CN107785061A (en) * | 2017-10-10 | 2018-03-09 | 东南大学 | Autism-spectrum disorder with children mood ability interfering system |
-
2018
- 2018-07-28 CN CN201810850055.XA patent/CN109086397B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN109086397A (en) | 2018-12-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109086397B (en) | Dynamic report generation method based on query dimension | |
| CN107256265B (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
| Kehrer et al. | Visualization and visual analysis of multifaceted scientific data: A survey | |
| CN105740333A (en) | Visual advertisement management platform, and implementation method thereof | |
| Kumar et al. | Visualization: a novel approach for big data analytics | |
| CN104298983A (en) | Tongue fur image acquisition and analysis system with distributed user terminals | |
| CN109086396B (en) | Old people-care big data analysis platform | |
| CN111177249B (en) | Multi-data-source data visualization method and device based on federal learning thought | |
| CN111522735B (en) | Shunting method and device for test experiment | |
| CN107220286A (en) | Emergency command information demonstrating method and emergency commading system platform and server | |
| CN112652067A (en) | Three-dimensional GIS model-based text and travel virtual scene construction system | |
| WO2021169630A1 (en) | Configurable report generation method, apparatus and device, and readable storage medium | |
| CN110083632A (en) | A kind of project cost listing service system | |
| US20190147095A1 (en) | System and method for visual construction of nested operations for data querying | |
| CN113517074B (en) | Information three-dimensional space visualization method for epidemic patients | |
| CN112487018B (en) | Method and device for generating list, electronic equipment and computer readable storage medium | |
| Qiang et al. | Application of visualization technology in spatial data mining | |
| CN110110010A (en) | Data processing method and device | |
| CN103942405A (en) | Three-dimensional mechanical data simulation remote sharing and interactive discussion method | |
| CN111443966A (en) | IETM searching and positioning method based on desktop type virtual simulation | |
| CA2561150A1 (en) | Method and system for data understanding using sociomapping | |
| CN110209886A (en) | A kind of storage mode of the figure based on bigtable data model construction object-oriented | |
| WO2021051874A1 (en) | Information pushing method and related device | |
| CN113032476A (en) | Method for acquiring and monitoring dynamic data based on visualization | |
| CN105938476A (en) | Reporting system with Word as template |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |