CN109086397A - Dynamic report generation method based on inquiry dimension - Google Patents
Dynamic report generation method based on inquiry dimension Download PDFInfo
- Publication number
- CN109086397A CN109086397A CN201810850055.XA CN201810850055A CN109086397A CN 109086397 A CN109086397 A CN 109086397A CN 201810850055 A CN201810850055 A CN 201810850055A CN 109086397 A CN109086397 A CN 109086397A
- Authority
- CN
- China
- Prior art keywords
- data
- display
- search engine
- query
- dimension
- 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.)
- Granted
Links
Landscapes
- User Interface Of Digital Computer (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention discloses a kind of dynamic report generation methods based on inquiry dimension, include the following steps: S1: building real-time stream, and by being associated with search engine, search engine completes real time data index；The connection of data source and search engine is constructed, search engine completes asynchronous data directory process between data source；S2: it obtains into data query information, the data query information includes at least keyword, dimension and statistical indicator is presented in data；S3: search engine carries out inquiry instruction conversion according to the processing rule of preparatory default after receiving query information input, to data query information, and executes query statement to return to query result；S4 converts query results to the data result collection for being used to indicate computer graphical；S5: it after obtaining data result collection, is rendered by graphics rendering engine；S6: above graph data is presented over the display；S7: S3~S6 is executed after at the appointed time again.Have the effect of can by real time with it is a variety of it is visual in a manner of display data situation of change, facilitate data analyze work.
Description
Technical field
The present invention relates to data visualization technique fields, and in particular to a kind of Making Dynamic Report Forms side based on inquiry dimension
Method
Background technique
Wisdom endowment is sensor network system and information platform towards house old man, community and geriatric nursing home, and in this base
There is provided on plinth in real time, it is quick, efficiently, low cost, instrumentation, interconnected, intelligentized endowment service, " wisdom endowment " not only
The safety of old man will be protected constantly, moreover it is possible to the health status of comprehensive monitoring old man.
With the continuous popularization of " wisdom endowment ", information platform can obtain the related data of magnanimity with sensor network system, lead to
The analysis to these data is crossed, for the optimization of endowment service, the operation and management strategy of service organization and relevant policy
The formulation of regulation etc. can play positive impetus；However, how these data are passed through keyword quickly retrieves number
According to, and data result is clear, accurately, vividly, understandable shows user to become new problem.
Existing most of endowment information platform system or tool provide data query and report generation function, and
By chart system or tool by data with histogram, the planar graphs such as pie chart show result, reach data retrieval and
The purpose of data visualization.
But the existing deficiency of the prior art is, overwhelming majority data visualisation system or tool are difficult to meet real at present
When the requirement that shows of data, i.e., in the form of " dynamic statement ", can by real time with it is a variety of it is visual in a manner of display data
Situation of change is made troubles to data analysis work.
Summary of the invention
It is an object of the invention to overcome the deficiencies of the prior art and provide a kind of Making Dynamic Report Forms based on inquiry dimension
Method generates different dynamic statements according to the query requirement of differentiation, can by real time with it is a variety of it is visual in a manner of show
Data situation facilitates data to analyze work.
The purpose of the present invention is achieved through the following technical solutions: the Making Dynamic Report Forms side based on inquiry dimension
Method includes the following steps:
S1: building real-time stream, by being associated with search engine, search engine completes real time data index；Construct number
According to the connection in source and search engine, search engine completes asynchronous data directory process between data source；
S2: it obtains into data query information, the data query information includes at least keyword, dimension and system is presented in data
Count index；
S3: search engine is after receiving query information input, to data query information according to the place of preparatory default
Reason rule carries out inquiry instruction conversion, and executes query statement to return to query result；
S4 converts query results to the data result collection for being used to indicate computer graphical；
After S5 obtains data result collection, rendered by graphics rendering engine；
S6 is presented above graph data over the display；
S7 at the appointed time after execute S3~S6 again.
By this method, the connection of data source and search engine is constructed, is looked by the conversion for query information
Sentence is ask to realize the query requirement of differentiation, query result is converted into different patterned " dynamic statement ", and obtains reality
Apply update, can by real time with it is a variety of it is visual in a manner of display data situation of change, significantly facilitate data analysis work.
Further, the difference that dimension and statistical indicator is presented according to data in step s 4, utilizes the preset table of comparisons pair
The data structure for the expression computer graphical that different query results are converted into carries out shape index；
The display of multiple and different shapes is used in step s 6, and each display also has shape index；By display with
Computer graphical is matched according to the principle that same shape indexes；And the Computer Graphic Demonstration is shown to matched
Show on device.
It utilizes " dynamic statement " of the more reasonable present graphical of the cooperation of shape and figure.
Further, in step s 6, use is rectangular, one of the display of rectangle, circle and triangle or a variety of, phase
It answers, the shape index includes one of rectangular, rectangle, circle and triangle or a variety of.
For common present graphical, display setting is carried out, it is adaptable.
Further, in step s 6, using a total display, the light-emitting diode display is originally divided into institute different shape
Region, each region be used as an individual display.
Using the split screen screen partition domain-functionalities of display equipment, hardware quantity is reduced, simplifies system, save the cost.
Further, the display is adopted as light-emitting diode display.
The display is small in size, and using extensive, cost is relatively low.
Further, in step s3, query information content is analyzed using NLP technology.
The query information of NLP (natural language processing) processing input, user directly can carry out information using natural language
Input, analyzing generate instruction needed for keyword, without being inputted according to specified format, so that the mode of input can be with
The use of more natural, more convenient user.
Further, the data result collection is returned in the form of interface in step s 4.
Using interfacing, distal end can be stored the result into, it is local only to need to be called result using network, and
Not all data reduce volume of transmitted data.
Detailed description of the invention
Fig. 1 is the flow chart of dynamic report generation method of the embodiment of the present invention based on inquiry dimension.
Fig. 2 is the functional block diagram of Making Dynamic Report Forms system used by the embodiment of the present invention.
Specific embodiment
It is further described below by specific embodiment:
The dynamic report generation method based on inquiry dimension in the present embodiment, includes the following steps:
S1: cloud server constructs real-time stream, and by being associated with search engine, search engine completes real time data rope
Draw；The connection of data source and search engine is constructed, search engine completes asynchronous data directory process between data source；
S2: cloud server is obtained from local input terminal into data query information, and the data query information is at least wrapped
Include keyword, dimension and statistical indicator is presented in data；Such as " Chongqing City over-65s old man is distributed according to district, shows pie
Figure "
S3: search engine carries out participle solution to the query information using NPL technology after receiving query information input
Analysis obtains corresponding keyword, dimension and statistical indicator is presented in data；
After parsing by NPL technology, obtain inquiring required data, including, level-one region: Chongqing, querying condition are year
Age is greater than 65 years old, and statistical indicator is with second level region (district) for granularity, and statistical indicator is accounting, and it is pie that dimension, which is presented, in data
Figure；
Inquiry instruction conversion is carried out according to the processing rule of preparatory default to data query information, and executes inquiry language
Sentence is to return to query result；
S4 converts query results to the data result collection for being used to indicate computer graphical, and the figure according to setting in advance at this time
The shape set is indexed as " circle "；
After S5 obtains data result collection, rendered by graphics rendering engine；
S6 by api interface obtain more than graph data the graph data is matched and according to " circle " this index
It is shown on the border circular areas marked off on total display；
S7 executed S3-S6 after 1 minute again, until obtaining exit instruction.
The present embodiment realizes that the system includes: that data flow constructs mould in real time by the Making Dynamic Report Forms system in Fig. 2
Block, input module, query information processing module, graphical module, graph rendering module, display module and update module.
Data flow constructs module by being associated with search engine in real time, and search engine completes real time data index；Construct number
According to the connection in source and search engine, search engine completes asynchronous data directory process between data source；
User includes at least keyword, data by input module input data query information, the data query information
Dimension and statistical indicator is presented；
Query information processing module divides the query information using NPL technology after receiving query information input
Word parsing obtains corresponding keyword, dimension and statistical indicator is presented in data；
Query information handles mould and carries out inquiry instruction turn according to the processing rule of preparatory default to data query information
Change, and start to search engine, search engine executes query statement and returns to query result；
Graphical module converts query results to the data result collection for being used to indicate computer graphical, and by the figure root
It is indexed according to pre-set shape；
For local graph rendering module by way of api interface after completing, which passes through graphics rendering engine
Module is rendered；
Display module is shown to the phase marked off on display according to index, by the graph data matching after rendering
It answers on the region of shape；The region is divided to obtain by split screen submodule according to preparatory setting, and the present embodiment uses
Light-emitting diode display.
According to the difference of the query information of input, multiple motion graphics can be shown on display, according to display dimension
Difference can be but not limited to histogram, curve graph and pyramid diagram, their shape index is respectively set to accordingly
" rectangle ", " square " and " triangle ".
Update module triggers query information processing module again after 1 minute and repeats to send unified query instruction, so that figure
Graphic data is updated；The process repeats always, until obtaining exit instruction, but the time updated can be according to data variation
Speed is configured.
The data source of the present embodiment and search engine use third-party service, but can also be built-in in some embodiments
In platform.
The intelligent endowment robot that the data in onboard data source are used from old man, such robot per se with
Numerous is data acquisition function, especially has old man's Emotion identification and acquisition function, the Emotion identification of old man in the present embodiment
Using technological means in the prior art, by picture match, the artificial intelligent Matching means such as Sound Match acquire always in real time
The mood of people；On the other hand, by the way that these mood datas are carried out statistics in real time and over the display according to collecting data
Place arrange, meanwhile, mood data point is distinguished according to color sequence from cold to warm, such as happy pleasant
Mood using green, sad mood is using blue, and indignation is irascible using red, and no special mood is using white, so
The display mode for forming similar hotspot graph, can also quantify mood data, and the mood value being beneficial to old man is high, to old
People is low without benefit or harmful mood value, color in after region is average.At the same time it can also show in current locale together
Temperature, air pressure, noise, medical facilities distribution datagram；It can also show that old man is hot at a distance from its children with color
Point diagram, i.e. the remoter color of distance is about deep, and multiple children are subject to nearest one, can also show old man and children with color
Meeting frequency hotspot graph, which then also needs robot to be equipped with existing face recognition technology and the people of old man children
Face feature database, these are that prior art means may be implemented；Finally, the mood of these different datagrams and old man is utilized
Figure carries out alternate analysis, to be macroscopic view such as infrastructure construction, expression of sympathy is provided, and policy making, the work such as social security mention
For guiding opinion, the carryover effect of these work can also be analyzed by emotional change, preferably utilize big data nest egg
Service.
By being associated with search engine, search engine completes real time data index；Construct the company of data source and search engine
Connect, search engine completes the asynchronous data directory process between data source, the Rendering of figure, api interface technology and
Split screen display available technology is all made of the prior art, and therefore not to repeat here.
By this method, the connection of data source and search engine is constructed, is produced by the conversion for query information
Sentence is sought to realize that the query requirement of differentiation, query result are originally converted into different patterned " dynamic statement ", Ke Yishi
When with a variety of visual mode display data situations of change.
What has been described above is only an embodiment of the present invention, and the common sense such as well known specific structure and characteristic are not made herein in scheme
Excessive description, technical field that the present invention belongs to is all before one skilled in the art know the applying date or priority date
Ordinary technical knowledge can know the prior art all in the field, and have using routine experiment hand before the date
The ability of section, one skilled in the art can improve and be implemented in conjunction with self-ability under the enlightenment that the application provides
This programme, some typical known features or known method should not become one skilled in the art and implement the application
Obstacle.It should be pointed out that for those skilled in the art, without departing from the structure of the invention, can also make
Several modifications and improvements out, these also should be considered as protection scope of the present invention, these all will not influence the effect that the present invention is implemented
Fruit and patent practicability.The scope of protection required by this application should be based on the content of the claims, the tool in specification
The records such as body embodiment can be used for explaining the content of claim.
Disclosed herein method, system and module, may be implemented in other ways.For example, described above
Embodiment be only illustrative, it is practical to realize for example, the division of the module, can be only a kind of logical function partition
When there may be another division manner, such as multiple module or components can be combined or can be integrated into another system, or
Some features can be ignored or not executed.Another point, shown or discussed mutual coupling or direct-coupling or communication
Connection is it may be said that through some interfaces, the indirect coupling or communication connection of system or module can be electrical property, mechanical or other
Form.The module that the discrete parts illustrates may or may not be physically separated, the portion shown as module
Part may or may not be physical module, it can and it is in one place, or may be distributed over multiple network modules
On.It can select some or all of the modules therein according to the actual needs to realize the scheme purpose of the present embodiment.
It, can also be in addition, each functional module in each embodiment of the present invention can integrate in a processing module
It is that modules physically exist alone, can also be integrated in two or more modules in a module.
It, can be with if the function is realized and when sold or used as an independent product in the form of software function module
It is stored in a computer readable storage medium.Based on this understanding, technical solution of the present invention is substantially right in other words
The part of part or the technical solution that the prior art contributes can be embodied in the form of software products, the calculating
Machine software product is stored in a storage medium, including some instructions are used so that a computer equipment (can be individual
Computer, server or network equipment etc.) it performs all or part of the steps of the method described in the various embodiments of the present invention.And
Storage medium above-mentioned includes: USB flash disk, mobile hard disk, system memory (Read-Only Memory, ROM), random access memory
The various media that can store program code such as device (Random Access Memory, RAM), magnetic or disk.
Claims (7)
1. the dynamic report generation method based on inquiry dimension, it is characterised in that: the Making Dynamic Report Forms side based on inquiry dimension
Method includes the following steps:
S1: building real-time stream, by being associated with search engine, search engine completes real time data index；Construct data source
With the connection of search engine, search engine completes asynchronous data directory process between data source；
S2: data query information is obtained, the data query information includes at least keyword, dimension is presented in data and statistics refers to
Mark；
S3: search engine is advised after receiving query information input, to data query information according to the processing of preparatory default
Inquiry instruction conversion is then carried out, and executes query statement to return to query result；
S4 converts query results to the data result collection for being used to indicate computer graphical；
After S5 obtains data result collection, rendered by graphics rendering engine；
S6 is presented above graph data over the display；
S7 at the appointed time after execute S3~S6 again.
2. the dynamic report generation method according to claim 1 based on inquiry dimension, it is characterised in that: in step s 4
The difference that dimension and statistical indicator are presented according to data, is converted into different query results using the preset table of comparisons
Indicate that the data structure of computer graphical carries out shape index；
The display of multiple and different shapes is used in step s 6, and each display also has shape index；By display and calculate
Machine figure is matched according to the principle that same shape indexes；And by the Computer Graphic Demonstration to matched display
On.
3. the dynamic report generation method according to claim 2 based on inquiry dimension, it is characterised in that: in step S6
In, use is rectangular, one of the display of rectangle, circle and triangle or a variety of, correspondingly, shape index includes side
One of shape, rectangle, circle and triangle are a variety of.
4. the dynamic report generation method according to claim 2 based on inquiry dimension, it is characterised in that: in step S6
In, using a total display, the light-emitting diode display is originally divided into institute region of different shapes, and each region is as one
A individual display uses.
5. the dynamic report generation method according to claim 4 based on inquiry dimension, it is characterised in that: the display
It is adopted as light-emitting diode display.
6. the dynamic report generation method according to claim 1 based on inquiry dimension, it is characterised in that: in step S3
In, query information content is analyzed using NLP technology.
7. the dynamic report generation method according to claim 1 based on inquiry dimension, it is characterised in that: in step s 4
The data result collection is returned in the form of 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 true CN109086397A (en) | 2018-12-25 |
| CN109086397B 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) |
Cited By (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 |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN111143356A (en) * | 2019-12-12 | 2020-05-12 | 中盈优创资讯科技有限公司 | Report retrieval method and device |
| CN113535782A (en) * | 2021-07-22 | 2021-10-22 | 成都数之联科技有限公司 | BI report query response method, system, electronic equipment and computer readable storage medium |
Citations (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 |
| US20170124464A1 (en) * | 2015-10-28 | 2017-05-04 | Fractal Industries, Inc. | Rapid predictive analysis of very large data sets using the distributed computational graph |
| CN107256265A (en) * | 2017-06-14 | 2017-10-17 | 成都四方伟业软件股份有限公司 | A kind of search-engine results data visualization methods of exhibiting and system |
| CN107704449A (en) * | 2011-12-28 | 2018-02-16 | 英特尔公司 | The real-time natural language processing of data flow |
| 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
Patent Citations (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 |
| CN107704449A (en) * | 2011-12-28 | 2018-02-16 | 英特尔公司 | The real-time natural language processing of data flow |
| US20170124464A1 (en) * | 2015-10-28 | 2017-05-04 | Fractal Industries, Inc. | Rapid predictive analysis of very large data sets using the distributed computational graph |
| CN107256265A (en) * | 2017-06-14 | 2017-10-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 |
Cited By (8)
| 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 |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN110717319B (en) * | 2019-09-24 | 2023-10-20 | 车智互联（北京）科技有限公司 | Self-service report generation method, device, computing equipment and system |
| CN111143356A (en) * | 2019-12-12 | 2020-05-12 | 中盈优创资讯科技有限公司 | Report retrieval method and device |
| CN111143356B (en) * | 2019-12-12 | 2023-08-01 | 中盈优创资讯科技有限公司 | Report retrieval method and device |
| CN113535782A (en) * | 2021-07-22 | 2021-10-22 | 成都数之联科技有限公司 | BI report query response method, system, electronic equipment and computer readable storage medium |
| CN113535782B (en) * | 2021-07-22 | 2024-05-07 | 成都数之联科技股份有限公司 | BI report query response method, system, electronic equipment and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109086397B (en) | 2022-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109086397A (en) | Dynamic report generation method based on inquiry dimension | |
| CN107256265B (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
| CN104794221B (en) | A kind of multi-Dimensional Data Analytical System based on business object | |
| CN107111540A (en) | Dynamic telemetry message is dissected and adjusted | |
| CN109670843A (en) | Data processing method, device, computer equipment and the storage medium of complaint business | |
| CN112749266A (en) | Industrial question and answer method, device, system, equipment and storage medium | |
| CN106897386B (en) | A kind of big data multidimensional analysis method and system | |
| US20140082002A1 (en) | Apparatus and method for processing unstructured data event in real time | |
| CN109637602A (en) | Medical data storage and querying method, device, storage medium and electronic equipment | |
| CN109840284A (en) | Family's affiliation knowledge mapping construction method and system | |
| CN105760449A (en) | Multi-source heterogeneous data cloud pushing method | |
| CN103258054A (en) | Method and device for processing data | |
| CN110968624A (en) | Animal epidemic disease monitoring data statistical analysis geographic information system and implementation method | |
| CN109086396A (en) | Endowment big data analysis platform | |
| CN111062260A (en) | Automatic generation method of facial cosmetic recommendation scheme | |
| CN113553341A (en) | Multidimensional data analysis method, multidimensional data analysis device, multidimensional data analysis equipment and computer readable storage medium | |
| CN113516768A (en) | Visual wisdom thing of transformer substation allies oneself with management system | |
| CN118013621B (en) | Intelligent data processing system for indoor design and method thereof | |
| CN113517074B (en) | Information three-dimensional space visualization method for epidemic patients | |
| CN103383649A (en) | Design model of complex virtual instrument system | |
| CN108492367A (en) | A kind of wind power plant methods of exhibiting and wind power plant display systems | |
| CN106022595B (en) | Self cyberrelationship circle division methods of enterprise based on procurement data and server | |
| CN116934960A (en) | Three-dimensional holographic visualization model based on digital twin and implementation method | |
| CN205844801U (en) | A kind of data acquisition unit | |
| CN116128480A (en) | Digital operation and maintenance management method for cement factory equipment |
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 |