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 PDF

Info

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
Application number
CN201610188309.7A
Other languages
Chinese (zh)
Inventor
唐素芳
季统凯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
G Cloud Technology Co Ltd
Original Assignee
G Cloud Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by G Cloud Technology Co Ltd filed Critical G Cloud Technology Co Ltd
Priority to CN201610188309.7A priority Critical patent/CN105893488A/en
Publication of CN105893488A publication Critical patent/CN105893488A/en
Withdrawn legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/256Integrating 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

A kind of convenient flexible homemade data statistics report making method
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.
CN201610188309.7A 2016-03-29 2016-03-29 Method for quickly, conveniently and flexibly making data statistics report forms Withdrawn CN105893488A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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
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
US20180357285A1 (en) Method and system for determining unique events from a stream of events
CN103246963A (en) Staff training system based on Internet of Things
US11120016B2 (en) Automated generation of a query statement based on user selections received through a user interface
Eng et al. Students’ perception: Student feedback online (SuFO) in higher education
US20150199399A1 (en) Query generator
CN107391470A (en) A kind of single database table handling method based on Form Designer
US10896194B2 (en) Generating a combined database with data extracted from multiple systems
CN105488219B (en) Webpage information method for automatically inputting and system
JP2005209042A (en) Questionnaire system and questionnaire page forming method
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
US20230328332A1 (en) Methods and systems for counseling a user with respect to identified content
US20220413905A1 (en) Data curation with synthetic data generation
CN107544953A (en) XBRL data acquisitions and display systems based on jqGrid

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