CN105893488A - Method for quickly, conveniently and flexibly making data statistics report forms - Google Patents
Method for quickly, conveniently and flexibly making data statistics report forms Download PDFInfo
- Publication number
- CN105893488A CN105893488A CN201610188309.7A CN201610188309A CN105893488A CN 105893488 A CN105893488 A CN 105893488A CN 201610188309 A CN201610188309 A CN 201610188309A CN 105893488 A CN105893488 A CN 105893488A
- Authority
- CN
- China
- Prior art keywords
- virtual
- data
- view
- virtual table
- report
- 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.)
- Withdrawn
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/256—Integrating or interfacing systems involving database management systems in federated or virtual databases
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for quickly, conveniently and flexibly making data statistics report forms based on a hichart technology. The method comprises the steps that a virtual table/view generator creates the mapping relation between database tables and virtual tables or the mapping relation between the virtual tables and virtual views according to parameter information submitted by interfaces, each virtual table corresponds to one database table, virtual table fields correspond to database table fields, users on the client-side perform operation, and the virtual tables are eventually mapped to the corresponding database tables; a virtual view parser generates a final SQL; a report form statistics analyzer assembles report form format data; a report form display client-side displays the data dynamically. The method can also quickly, conveniently and flexibly make customized commonly-used data statistics report forms as required without proficiency in hichart report form technology and commonly used relational database SQL and can be used for making the data statistics report forms.
Description
Technical field
The present invention relates to data statistics technical field, be specifically related to a kind of based on hichart technical foundation on
Convenient flexible homemade data statistics report making method.
Background technology
Along with the developing rapidly of Internet technology, the raising of social informatization degree, to information obtaining ability,
Data analysis capabilities, decision-making capability propose the requirement of the swifter, higher, stronger.Thus, there is exhibition comprehensively
The application of the form of registration analysis result according to statistics is more extensive, and report form statistics analytical tool is the most increasingly
Many, relevant art is more of extensive knowledge and profound scholarship, and technical staff's GPRS is also proficient in each report form statistics analytical tool
Application technology and use not a duck soup flexibly.And present operation system data mostly leave relationship type number in
According in storehouse, thus the making of data statistic analysis form not merely pertains only to the application of report form statistics analytical tool
And the grasp of correlation technique, further relate to the technology in terms of data base.Data are wanted first from each relevant database
By SQL query, come out, need to be packaged into the data of specific format in conjunction with statement analysis instrument.
And it being generally consistent for different this processes of form business, traditional report making but will be for often
Individual form business is done according to similar Making programme and data handling procedure, thus causes substantial amounts of repetition
Working and require higher to technical staff's technology, technical staff must grasp statistical forms technology, data
Storehouse technology.
Summary of the invention
Present invention solves the technical problem that and be to provide a kind of based on the convenient spirit on hichart technical foundation
Homemade data statistics report making method alive.By the method, user only needs the void that adopting said method provides
Plan table is machine-processed and creates required virtual view on the basis of Virtual table, just can create oneself required number flexibly
Analytical statement according to statistics.
The present invention solves the technical scheme of above-mentioned technical problem:
Described method is mainly by Virtual table/view generation device, virtual view resolver, report data statistical
Parser, form show that the parts such as client realize；
Parameter information is submitted to create the mapping of database table and Virtual table by Virtual table/view generation device according to interface
Relation, or the mapping relations of Virtual table and virtual view, the corresponding data Kuku table of each Virtual table, empty
Intending literary name section correspondence database literary name section, user can finally be mapped to its correspondence in client operation Virtual table
Data Kuku table；
It is parsed with data Kuku table according to its Virtual table field and relationship model by virtual view resolver
Mapping relations, and generate final SQL；
By report data statistical analyzer according to virtual view resolver analysis result by data from corresponding Ku Biaocha
Inquiry comes out, and is assembled into statement form data in conjunction with virtual view structure；
Shown that client is led to according to data result and the form property parameters of report data statistical analyzer by form
Cross the hichart form inserter tool of client by data Dynamic Display out.
Described Virtual table is and data Kuku table a kind of mapping relations one to one, is also with field as list
Position, simply preserves storehouse literary name section with the form of object json serializing character string, program unserializing json
Each Virtual table field corresponding object describing storehouse table field attribute when of character string, by operation void
Intend literary name section and can be reassembled into Virtual table view.
Described data base's virtual view is built upon a kind of data Kuku table mapping relations on the basis of Virtual table,
User selects different Virtual table fields and view model relation i.e. can be assembled into oneself want virtual to regard
Figure.
First described method is registered Virtual table by user, and i.e. first the registration Virtual table module in client is carried out
This operation, user need on interface input database association attributes, e.g., ip address, database-name, number
According to storehouse type, port, data base's account, password etc.；Click on after connecting data base, the optional number of user
According to the storehouse table below storehouse, it is also possible to directly input data Kuku table name, click on and register；Virtual table is noted
After volume success, user can check details at corresponding managing listings；User creates Virtual table view to be needed
On registered good Virtual table basis, and make data statistics form by oneself and need on Virtual table view basis；
Web browser front end form is shown on based on hichart Report form application plug-in unit, by user according to use
Guide creates the virtual view that form is corresponding.
By the method for the logical present invention, user is without grasping the report form statistics instrument application technology of complexity, number
According to also making oneself required data statistic analysis form in the case of the technology of storehouse by oneself.User only need to be in client
Operate associated component after registration database Virtual table, create virtual view and view relation model, select
Form association attributes, such as report form type, form size, report name, unit etc..Click on generation form to press
Button just can automatically generate form, can continue on-demand adjustment form association attributes and generate after user's preview effect
Final required form, clicks on and preserves form.User the most only need to access the url path that form is corresponding
Just can be with Dynamic Display report data statistic analysis result.
Accompanying drawing explanation
The present invention is further described below in conjunction with the accompanying drawings:
Fig. 1 is the overall flow figure that system realizes this method
Detailed description of the invention
As it is shown in figure 1, the method for the present invention provides corresponding web program end, user is first in registration Virtual table
The Module registers data Kuku corresponding Virtual table of table, then on the basis of Virtual table, create virtual view, Yong Hu
The when of on-demand self-control statistical forms, select respective view and form association attributes, as form size,
Report form type, report name, unit etc., click on preview and generate form, and user can also pass through immediately
Adjust parameter and adjust form.The final reports user generated can be directly direct by corresponding url path after preserving
Check.The method provide corresponding program, specifically include that Virtual table view generation device, virtual view resolve
Device, report data statistical analyzer, form show the parts such as client.Virtual table view generation device mainly
Parameter information is submitted to create database table and the mapping relations of Virtual table or Virtual table and virtual view according to interface
Mapping relations, the corresponding data Kuku table of each Virtual table, Virtual table field correspondence database literary name section,
User can finally be mapped to the data Kuku table of its correspondence in client operation Virtual table.Virtual view resolver
Mainly parse it according to its Virtual table field and relationship model with the mapping relations of data Kuku table and raw
Become final SQL.Report data statistical analyzer mainly according to virtual view resolver analysis result by data from right
Answer storehouse table query statistic out, be assembled into statement form data in conjunction with virtual view structure.Form shows visitor
Family end passes through client according to data result and the form property parameters of report data statistical analyzer
Hichart form inserter tool is by data Dynamic Display out.
Fig. 1 is the overall flow figure that the present invention realizes this method, and its principal character is as follows:
User fills in Relational database parameter by web client, clicks on and submits button to, and it is empty that parameter reaches backstage
Intend table/view generation device, Virtual table can be generated, could create, after generating Virtual table, the view that form is corresponding.
After user creates oneself required form, form shows that client is by virtual view address, form attribute
Parameter reaches virtual view resolver, and view is resolved by virtual view resolver with data Kuku table mapping relations
Out, and produce final statistical analysis SQL.Analysis result is reached report data system by virtual view resolver again
Score parser, by data from corresponding storehouse table query statistic out, is assembled into form in conjunction with virtual view structure
Formatted data.Form shows that client receives report data by its Dynamic Display out.
The present invention is mainly suitable for the report making scene of each application system based on relevant database, especially
It is in the case of user needs batch to create the data statistic analysis form that operation flow is similar.Pass through the method
User can reduce a lot of workload, decreases a lot of study to data base, hichart Report technique and becomes
This, user has only to just can realize the report making of oneself at interface simple, intuitive operation respective modules assembly
Demand.
Claims (5)
1. the most homemade convenient data statistics report making method, it is characterised in that: described
Method is mainly by Virtual table/view generation device, virtual view resolver, report data statistical analyzer, form
Show that the parts such as client realize；
Parameter information is submitted to create the mapping of database table and Virtual table by Virtual table/view generation device according to interface
Relation, or the mapping relations of Virtual table and virtual view, the corresponding data Kuku table of each Virtual table, empty
Intending literary name section correspondence database literary name section, user can finally be mapped to its correspondence in client operation Virtual table
Data Kuku table；
It is parsed with data Kuku table according to its Virtual table field and relationship model by virtual view resolver
Mapping relations, and generate final SQL；
By report data statistical analyzer according to virtual view resolver analysis result by data from corresponding Ku Biaocha
Inquiry comes out, and is assembled into statement form data in conjunction with virtual view structure；
Shown that client is led to according to data result and the form property parameters of report data statistical analyzer by form
Cross the hichart form inserter tool of client by data Dynamic Display out.
Data statistics report making method the most according to claim 1, it is characterised in that: described void
Plan table is and data Kuku table a kind of mapping relations one to one, is also in units of field, simply by storehouse
Literary name section preserves, the when of program unserializing json character string with the form of object json serializing character string
The corresponding object describing storehouse table field attribute of each Virtual table field, can be weighed by operation Virtual table field
Newly it is assembled into Virtual table view.
Data statistics report making method the most according to claim 1, it is characterised in that: described number
Being built upon a kind of data Kuku table mapping relations on the basis of Virtual table according to storehouse virtual view, user selects not
Same Virtual table field and view model relation i.e. can be assembled into the virtual view oneself wanted.
Data statistics report making method the most according to claim 2, it is characterised in that: described number
Being built upon a kind of data Kuku table mapping relations on the basis of Virtual table according to storehouse virtual view, user selects not
Same Virtual table field and view model relation i.e. can be assembled into the virtual view oneself wanted.
5. according to the data statistics report making method described in Claims 1-4, it is characterised in that: institute
First the method stated is registered Virtual table by user, and i.e. first the registration Virtual table module in client carries out this operation,
User need on interface input database association attributes, e.g., ip address, database-name, type of database,
Port, data base's account, password etc.；Click on after connecting data base, below user's selecting data storehouse
Storehouse table, it is also possible to directly input data Kuku table name, clicks on and registers；After Virtual table succeeds in registration
User can check details at corresponding managing listings；User creates Virtual table view to be needed registered good
On Virtual table basis, and make data statistics form by oneself and need on Virtual table view basis；Web browsing
Device front end form is shown on based on hichart Report form application plug-in unit, user create according to guide for use
The virtual view that form is corresponding.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610188309.7A CN105893488A (en) | 2016-03-29 | 2016-03-29 | Method for quickly, conveniently and flexibly making data statistics report forms |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610188309.7A CN105893488A (en) | 2016-03-29 | 2016-03-29 | Method for quickly, conveniently and flexibly making data statistics report forms |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105893488A true CN105893488A (en) | 2016-08-24 |
Family
ID=57014633
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610188309.7A Withdrawn CN105893488A (en) | 2016-03-29 | 2016-03-29 | Method for quickly, conveniently and flexibly making data statistics report forms |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105893488A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106447181A (en) * | 2016-09-18 | 2017-02-22 | 金蝶软件（中国）有限公司 | Analysis method and device based on timeliness of ERP business approval |
| CN108345646A (en) * | 2018-01-16 | 2018-07-31 | 广东电网有限责任公司信息中心 | A method of with the fast automatic structure multi-dimensional report of Interception Technology |
| CN108984619A (en) * | 2018-06-13 | 2018-12-11 | 东莞市盟大塑化科技有限公司 | A method of the self-defined report based on big data |
| CN113126849A (en) * | 2021-04-07 | 2021-07-16 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
| WO2022134363A1 (en) * | 2020-12-24 | 2022-06-30 | 平安科技（深圳）有限公司 | Service report integration method and apparatus, device, and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001086504A2 (en) * | 2000-05-05 | 2001-11-15 | Orillion Corporation | Browser oriented method to view contents of a plurality of databases |
| CN102609256A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Motion chart generating method based on webpages |
| CN103020158A (en) * | 2012-11-26 | 2013-04-03 | 中兴通讯股份有限公司 | Report form creation method, device and system |
| CN103593194A (en) * | 2013-11-21 | 2014-02-19 | 北京国双科技有限公司 | Object serialization method and device |
| CN104462559A (en) * | 2014-12-25 | 2015-03-25 | 广东电子工业研究院有限公司 | Mainstream relation type database table mode objectification and virtualization mechanism |
-
2016
- 2016-03-29 CN CN201610188309.7A patent/CN105893488A/en not_active Withdrawn
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001086504A2 (en) * | 2000-05-05 | 2001-11-15 | Orillion Corporation | Browser oriented method to view contents of a plurality of databases |
| CN102609256A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Motion chart generating method based on webpages |
| CN103020158A (en) * | 2012-11-26 | 2013-04-03 | 中兴通讯股份有限公司 | Report form creation method, device and system |
| CN103593194A (en) * | 2013-11-21 | 2014-02-19 | 北京国双科技有限公司 | Object serialization method and device |
| CN104462559A (en) * | 2014-12-25 | 2015-03-25 | 广东电子工业研究院有限公司 | Mainstream relation type database table mode objectification and virtualization mechanism |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106447181A (en) * | 2016-09-18 | 2017-02-22 | 金蝶软件（中国）有限公司 | Analysis method and device based on timeliness of ERP business approval |
| CN108345646A (en) * | 2018-01-16 | 2018-07-31 | 广东电网有限责任公司信息中心 | A method of with the fast automatic structure multi-dimensional report of Interception Technology |
| CN108345646B (en) * | 2018-01-16 | 2022-02-22 | 广东电网有限责任公司信息中心 | Method for rapidly and automatically constructing multi-dimensional report by applying interception technology |
| CN108984619A (en) * | 2018-06-13 | 2018-12-11 | 东莞市盟大塑化科技有限公司 | A method of the self-defined report based on big data |
| WO2022134363A1 (en) * | 2020-12-24 | 2022-06-30 | 平安科技（深圳）有限公司 | Service report integration method and apparatus, device, and storage medium |
| CN113126849A (en) * | 2021-04-07 | 2021-07-16 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
| CN113126849B (en) * | 2021-04-07 | 2022-06-07 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105893488A (en) | Method for quickly, conveniently and flexibly making data statistics report forms | |
| Bai et al. | Effect of parental migration on the academic performance of left behind children in North Western China | |
| US11227259B2 (en) | System and method for online information, employment, social and other compatibility search, matching and ranking | |
| CN103544212B (en) | A kind of content recommendation method and system | |
| Veletsianos et al. | Selective openness, branding, broadcasting, and promotion: Twitter use in Canada’s public universities | |
| US8966436B2 (en) | Systems and methods for providing and customizing a virtual event platform | |
| US20140200988A1 (en) | System and method for normalizing campaign data gathered from a plurality of advertising platforms | |
| CN104615725B (en) | A kind of online self-defined report implementation method based on Web | |
| US20130262510A1 (en) | Query derived communication mechanism for communication between relational databases and object-based computing environments and systems | |
| US8732159B2 (en) | Generic outer join across database borders | |
| US10599654B2 (en) | Method and system for determining unique events from a stream of events | |
| JP2012519918A (en) | Method, apparatus and system for visualizing the behavior of a user browsing a web page | |
| US11120016B2 (en) | Automated generation of a query statement based on user selections received through a user interface | |
| CN106462880A (en) | Dynamically generating feedback based on contextual information | |
| US20150199399A1 (en) | Query generator | |
| CN105488219B (en) | Webpage information method for automatically inputting and system | |
| JP2005209042A (en) | Questionnaire system and questionnaire page forming method | |
| US20190197169A1 (en) | Generating a combined database with data extracted from multiple systems | |
| Ciobanu et al. | Development of a News Recommender System based on Apache Flink. | |
| CN107749032A (en) | A kind of topic management platform based on content analysis, method and device | |
| Pansanato et al. | An evaluation with web developers of capturing user interaction with rich internet applications for usability evaluation | |
| Langer et al. | URI-aware user input interfaces for the unobtrusive reference to Linked Data | |
| Dietze | Linked Data as facilitator for TEL recommender systems in research and practice. | |
| Solodovnikova et al. | Using Data Warehouse Resources for Assessment of E-Learning Influence on University Processes. | |
| JP2014229042A (en) | User operation recording system, operation record collecting apparatus, user operation recording method, and program thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20160824 |