CN105786786B - A kind of implementation method of the asynchronous filling of web report datas - Google Patents
A kind of implementation method of the asynchronous filling of web report datas Download PDFInfo
- Publication number
- CN105786786B CN105786786B CN201610110466.6A CN201610110466A CN105786786B CN 105786786 B CN105786786 B CN 105786786B CN 201610110466 A CN201610110466 A CN 201610110466A CN 105786786 B CN105786786 B CN 105786786B
- Authority
- CN
- China
- Prior art keywords
- formula
- data
- unit
- report
- filling
- 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
- 238000000034 method Methods 0.000 title claims abstract description 42
- 241001269238 Data Species 0.000 title claims abstract description 15
- 238000012545 processing Methods 0.000 claims abstract description 23
- 230000005540 biological transmission Effects 0.000 claims description 8
- 238000012546 transfer Methods 0.000 claims description 4
- 238000005429 filling process Methods 0.000 claims description 3
- 238000007781 pre-processing Methods 0.000 claims description 3
- 238000005457 optimization Methods 0.000 description 4
- 230000006835 compression Effects 0.000 description 2
- 238000007906 compression Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000000889 atomisation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000000354 decomposition reaction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (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 kind of implementation method of the asynchronous filling of web report datas, including data processing unit, report compilation unit and asynchronous fills unit, wherein data processing unit onboard data engine modules, specific implementation process is：Report data is arranged by data engine module first, then hands over to report compilation unit；Report compilation unit to involved in report data cell formats and formula format pre-process, then by the asynchronous fills unit of pretreated data handover；Progress interface formats have been filled after asynchronous filling module parses pretreated data；Finally the report data filled is shown at the interfaces UI.A kind of implementation method of asynchronous filling of web report datas of the present invention compared with prior art, substantially increases the loading speed of report, ensures that data calculate accuracy, that improves report shows efficiency, satisfaction of the client to product can be greatly improved, it is highly practical, it is easy to spread.
Description
Technical field
The present invention relates to communication information technical field, specifically a kind of realization side of the asynchronous filling of web report datas
Method.
Background technology
With the development of network information system, more and more enterprises dispose Web-based methodology.However
The report section of core is just at the principal concern of function in enterprise ERP.Traditional enterprise report depends on third side plug,
Loading efficiency is slow, and the experience and working efficiency to user all have an impact, and web reports can not be reached due to browser limitation
Efficiently shows and flexibly configure.Based on the present situation of WEB reporting systems, a kind of asynchronous filling of web report datas is now provided
Implementation method.So that traditional Web reports filling is showed data more high efficient and flexible by this method, operation is carried out at atomization
Reason, by asynchronous means successive optimization shows logic, shows efficiency to achieve the purpose that improve WEB reports.
Invention content
The technical assignment of the present invention is to be directed to the above shortcoming, provides a kind of realization of the asynchronous filling of web report datas
Method.
A kind of implementation method of the asynchronous filling of web report datas, including data processing unit, report compilation unit and asynchronous
Fills unit, wherein data processing unit onboard data engine modules, specific implementation process are：
Report data is arranged by data engine module first, then hands over to report compilation unit；
Report compilation unit to involved in report data cell formats and formula format pre-process, then will be pre-
The asynchronous fills unit of data handover of processing；
Progress interface formats have been filled after asynchronous filling module parses pretreated data；
Finally the report data filled is shown at the interfaces UI.
In data processing unit, the data transmission between data engine module and precompile unit uses http protocol,
Data format carries out semantization description using JSON, and network transmission is compressed using ProtocolBuffer.
The report compilation unit includes formula precompile unit and format precompile unit two parts, data engine module
Data order that treated carries out formula compiling pretreatment, format after being sent to formula precompile unit, format precompile unit
Compiler pretreatment.
Formula precompile unit is to formula compiling preprocessing process：
The result obtained after data engine processing transfers formula precompile cell processing to；
Formula precompile unit forms formula tree according to formula data recurrence, records the association reference between formula and is directed toward
Pointer；
Formula part includes custom formula, formula between formula, table in table, and difference is loaded according to different formula types
Precompile strategy, while the pointer of same reference do caching process improve multiplexing efficiency；
Dynamic formula, which prelists, to be translated into MAP tables and is indexed again to table position, and such cell that reached is in longitudinal direction
It is updated with the real time position of opportunity extending transversely and formula cell.
Format precompile unit is to format compiler pretreatment process：
Result, the result of data engine of formula precompile unit precompile can all give format unit processing, first root
Come form format tree load format and location information according to the formatted data of unit, initializes load mode, initialization formula letter
Breath, while the data and filling of report are recombinated；Format information is integrated in advance with formula info, forms complete report
Description scheme ultimately forms the data structure of the format description of a pending filling.
The specific filling process of asynchronous fills unit is：
The compiling of format precompile unit is received first as a result, being parsed into filling instruction, then gives instruction to asynchronous fill out
Unit is filled, enabling WebWorker with JavaScript carries out the asynchronous filling of multithreading, and asynchronous fills unit here uses two kinds
Fill pattern：
Block is filled, i.e., data are carried out with the filling of block rank；
Extension filling is extended to the cell that formula cue mark is extension, carry out horizontal and vertical extension filling.
The detailed process that report data is shown at the interfaces UI is：After interface formats have been filled, readjustment formula calculates
Module, the formula calculation which uses calculate and show independent behaviour for the mode of asynchronous delay load
Make, separate threads analytic formula is as a result, filling mode is taken by load mode left-to-right, from top to bottom；Finally carry out formula
Caching multiplexing, caches identical formulae results and is no longer computed repeatedly, and unified readjustment shows the interfaces UI after calculating.
Compared to the prior art a kind of implementation method of asynchronous filling of web report datas of the present invention, has beneficial below
Effect：
The present invention quickly shows statement form and data suitable for Web reporting systems, right by the flow and method
Data are pre-processed, and statement form, asynchronous filling report data, the calculating for carrying out formula and user can be quickly loaded
Privately owned logic control etc.；Precompile wherein is carried out to formula tree, the delay of formula cells loads, the lightweight of format tree
Dynamic mode, asynchronous mode when description, filling report, all substantially increase the loading speed of report；In addition this pattern is simultaneously
It guarantees data security, ensures that data calculate accuracy, that improves report shows efficiency, and satisfaction of the client to product can be greatly improved
Degree, it is highly practical, it is easy to spread.
Description of the drawings
Attached drawing 1 is the operation principle schematic diagram of the present invention.
Specific implementation mode
The invention will be further described in the following with reference to the drawings and specific embodiments.
As shown in Fig. 1, the implementation method of a kind of asynchronous filling of web report datas of the invention, including data processing list
Member, report compilation unit and asynchronous fills unit, wherein data processing unit onboard data engine modules, using front and back end point
From supporting customized access interface；Transmission process data format compression optimization.Report compilation unit for cell formats and
Formula format pre-processes, and improves report speed；Store formula by the way of tree form data structure, be used for expression formula according to
The relationship of relying；The formula of introducing instructs, and is filled by order-driven report, formula carries out between custom formula and Biao Neibiao
Optimization, i.e. duplicate removal, caching；Fonnat part is described using lightweight data structure JSON, saves memory and data structure language
Justiceization.Asynchronous fills unit utilizes WEB（HTML5）Characteristic carries out multithreading asynchronous operation to filling logic, promotes user experience；
Fill pattern point strategy load, i.e. block filling, extension filling, improve the performance of load；Formula result of calculation cachingization, formula draw
With real-time update, formulae results delay loading, the accuracy of data ensure that.
Based on above structure, specific implementation process of the invention is：
Report data is arranged by data engine module first, then hands over to report compilation unit；
Report compilation unit to involved in report data cell formats and formula format pre-process, then will be pre-
The asynchronous fills unit of data handover of processing；
Progress interface formats have been filled after asynchronous filling module parses pretreated data；
Finally the report data filled is shown at the interfaces UI.
In data processing unit, the data transmission between data engine module and precompile unit uses http protocol,
Data format carries out semantization description using JSON（Light weight readability）, network transmission compressed using ProtocolBuffer
（Overall transfer is small）, in this way carried out the promotion of performance and efficiency to the access unit of WEB reports, reduce
The expense of network, improves search efficiency.
The report compilation unit includes formula precompile unit and format precompile unit two parts, data engine module
Data order that treated carries out formula compiling pretreatment, format after being sent to formula precompile unit, format precompile unit
Compiler pretreatment.
Formula precompile unit is to formula compiling preprocessing process：
The result obtained after data engine processing transfers formula precompile cell processing to；
Formula precompile unit forms formula tree according to formula data recurrence, records the association reference between formula and is directed toward
Pointer；
Formula part includes custom formula, formula between formula, table in table, and difference is loaded according to different formula types
Precompile strategy, while the pointer of same reference do caching process improve multiplexing efficiency；
Dynamic formula, which prelists, to be translated into MAP tables and is indexed again to table position, and such cell that reached is in longitudinal direction
It is updated with the real time position of opportunity extending transversely and formula cell.
Format precompile unit is to format compiler pretreatment process：
Result, the result of data engine of formula precompile unit precompile can all give format unit processing, first root
Come form format tree load format and location information according to the formatted data of unit, initializes load mode, initialization formula letter
Breath, while the data and filling of report are recombinated；Format information is integrated in advance with formula info, forms complete report
Description scheme ultimately forms the data structure of the format description of a pending filling.
The specific filling process of asynchronous fills unit is：
The compiling of format precompile unit is received first as a result, being parsed into filling instruction, then gives instruction to asynchronous fill out
Unit is filled, enabling WebWorker with JavaScript carries out the asynchronous filling of multithreading, and asynchronous fills unit here uses two kinds
Fill pattern：
Block is filled, and has been abandoned traditional cell filling mode, has been introduced the concept of data area, and block rank is carried out to data
Filling, improve charging efficiency.
Extension filling is extended to the cell that formula cue mark is extension, carries out horizontal and vertical extension filling, this
When cell initial position can also change, the formula quoting of cell can be changed with the filling of mode of extension.
The detailed process that report data is shown at the interfaces UI is：After interface formats have been filled, readjustment formula calculates
Module, the formula calculation which uses calculate and show independent behaviour for the mode of asynchronous delay load
Make, separate threads analytic formula is as a result, filling mode is taken by load mode left-to-right, from top to bottom；Finally carry out formula
Caching multiplexing, caches identical formulae results and is no longer computed repeatedly, and unified readjustment shows the interfaces UI after calculating.
The present invention is directed to Web Report form applications, and the flexibility of Web development technique, the separation of front end rear end is made full use of to use
Completely new asynchronous system carries out data filling, introduces new flow and method, and step decomposition is carried out to filling data：It is single to introduce access
Member optimizes compression to report form figure selection, reduces network overhead and efficiency of transmission, introduces precompile unit, to report
The data structure of format description has carried out bottom optimization, improves the loading efficiency of data and operable ease for use, introduces simultaneously
Formula command unit, is optimized traditional formula mode and packet transaction, and introduces formula caching and formula quoting
Concept improves formula computational efficiency.Asynchronous fills unit has been finally introducing it, using multithreading asynchronous process, formula result of calculation
Finally delay load, improves the Caton phenomenon that conventional web browsers mode shows UI, improves the experience of product.
The technical personnel in the technical field can readily realize the present invention with the above specific embodiments,.But it answers
Work as understanding, the present invention is not limited to above-mentioned specific implementation modes.On the basis of the disclosed embodiments, the technical field
Technical staff can arbitrarily combine different technical features, to realize different technical solutions.
It is the known technology of those skilled in the art in addition to the technical characteristic described in specification.
Claims (5)
1. a kind of implementation method of the asynchronous filling of web report datas, which is characterized in that compiled by data processing unit, report
Unit and asynchronous fills unit realize that wherein data processing unit onboard data engine modules, specific implementation process are：
One, report data is arranged by data engine module first, then hands over to report compilation unit；
Two, report compilation unit to involved in report data cell formats and formula format pre-process, then will be pre-
The asynchronous fills unit of data handover of processing；
The report compilation unit includes formula precompile unit and format precompile unit two parts, data engine resume module
Data order afterwards carries out formula compiling pretreatment, format compiling after being sent to formula precompile unit, format precompile unit
Pretreatment, formula precompile unit are to formula compiling preprocessing process：
The result obtained after data engine processing transfers formula precompile cell processing to；
Formula precompile unit forms formula tree according to formula data recurrence, and the association reference and direction recorded between formula refers to
Needle；
Formula part includes custom formula, formula between formula, table in table, is loaded according to different formula types different pre-
Compilation strategy, while the pointer of same reference does caching process and improves multiplexing efficiency, the precompile strategy includes will dynamic public affairs
Formula, which prelists, to be translated into MAP tables and is indexed again to table position, realize cell when vertical and horizontal extends with cell public affairs
The real time position of formula updates；
Three, asynchronous fills unit carries out interface formats filling after parsing pretreated data；
Four, finally the report data filled is shown at the interfaces UI.
2. a kind of implementation method of asynchronous filling of web report datas according to claim 1, which is characterized in that in data
Use http protocol into line number between data engine module in processing unit and the formula precompile unit of report compilation unit
According to transmission, data format carries out semantization description using JSON, and network transmission is compressed using ProtocolBuffer.
3. a kind of implementation method of asynchronous filling of web report datas according to claim 1, which is characterized in that format is pre-
Compilation unit is to format compiler pretreatment process：
Result, the result of data engine module of formula precompile unit precompile can all give format unit processing, first root
Come form format tree load format and location information according to the formatted data of unit, initializes load mode, initialization formula letter
Breath, while the data and filling of report are recombinated；Format information is integrated in advance with formula info, forms complete report
Description scheme ultimately forms the data structure of the format description of a pending filling.
4. a kind of implementation method of asynchronous filling of web report datas according to claim 1, which is characterized in that asynchronous to fill out
The specific filling process for filling unit is：
The compiling of format precompile unit is received first as a result, being parsed into filling instruction, and it is single then to give instruction to asynchronous filling
Member enables WebWorker with JavaScript and carries out the asynchronous filling of multithreading, and asynchronous fills unit here is using two kinds of fillings
Pattern：
Block is filled, i.e., data are carried out with the filling of block rank；
Extension filling is extended to the cell that formula cue mark is extension, carry out horizontal and vertical extension filling.
5. a kind of implementation method of asynchronous filling of web report datas according to claim 1, which is characterized in that report number
It is according to the detailed process being shown at the interfaces UI：After interface formats have been filled, formula computing module is adjusted back, which calculates
The formula calculation that module uses calculates and shows independent operation, separate threads parsing for the mode of asynchronous delay load
Formulae results, filling mode are taken by load mode left-to-right, from top to bottom；Formula caching multiplexing is finally carried out, for phase
Same formulae results, which are cached, no longer to be computed repeatedly, and unified readjustment shows the interfaces UI after calculating.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610110466.6A CN105786786B (en) | 2016-02-29 | 2016-02-29 | A kind of implementation method of the asynchronous filling of web report datas |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610110466.6A CN105786786B (en) | 2016-02-29 | 2016-02-29 | A kind of implementation method of the asynchronous filling of web report datas |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105786786A CN105786786A (en) | 2016-07-20 |
| CN105786786B true CN105786786B (en) | 2018-08-14 |
Family
ID=56403111
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610110466.6A Active CN105786786B (en) | 2016-02-29 | 2016-02-29 | A kind of implementation method of the asynchronous filling of web report datas |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105786786B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407171B (en) * | 2016-11-03 | 2023-09-26 | 华能澜沧江水电股份有限公司 | Tree structure-based security monitoring custom report generation system and method |
| CN114548061B (en) * | 2022-04-25 | 2022-08-05 | 深圳源中瑞科技有限公司 | Intelligent data filling method, device and system, mobile terminal and storage medium |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8458589B2 (en) * | 2008-09-18 | 2013-06-04 | Apple Inc. | Localized label user interface control |
| CN103020033B (en) * | 2013-01-10 | 2015-08-19 | 昆山百润科技有限公司 | A kind of support off-line to use Electronic Bill System and construction method |
| CN104657384A (en) * | 2013-11-21 | 2015-05-27 | 航天信息股份有限公司 | Dynamic allocation report data processing method based on two-dimension relationship |
-
2016
- 2016-02-29 CN CN201610110466.6A patent/CN105786786B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN105786786A (en) | 2016-07-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104376068B (en) | A kind of data exhibiting system and method based on dynamic statement template | |
| CN104391868B (en) | The device and method of dynamic page static | |
| CN103336808A (en) | System and method for real-time graph data processing based on BSP (Board Support Package) model | |
| CN105786786B (en) | A kind of implementation method of the asynchronous filling of web report datas | |
| CN103338272B (en) | A kind of content distributing network and cache implementing method thereof | |
| CN102938776A (en) | Dynamic page processing system based on Asynchronous JavaScript and XML (ajax) technique | |
| CN106020944B (en) | It is a kind of to configure the method and system for carrying out data downloading based on background data base | |
| CN103116508B (en) | A kind of general-purpose interface of SAP system and its implementation | |
| CN106055590A (en) | Power grid data processing method and system based on big data and graph database | |
| WO2019140382A3 (en) | Probabilistic modeling system and method | |
| CN105956666A (en) | Machine learning method and system | |
| CN105354258A (en) | Website data cache update apparatus and method | |
| CN103871402A (en) | Language model training system, a voice identification system and corresponding method | |
| CN103678490B (en) | Deep Web query interface clustering method based on Hadoop platform | |
| CN102222108B (en) | Scripting method and device | |
| CN106095889A (en) | A kind of document management method based on Markdown | |
| CN102231118A (en) | Compilation optimization method for loongson-based 3A vector memory access | |
| CN108921289A (en) | A kind of FPGA isomery accelerated method, apparatus and system | |
| CN109388460A (en) | A method of it promoting client application and pulls homepage data efficiency | |
| CN105991668B (en) | A kind of CDN file updating method and device | |
| WO2014035628A3 (en) | Optimizing language translation orders and automating fulfillment | |
| CN110290182A (en) | Distributed Web application storage system, service system and access method | |
| CN109635161A (en) | A kind of cross-domain Collaborative Design method under mass data environment | |
| CN110442808A (en) | Page rendering acceleration method and device | |
| CN202364244U (en) | Processing device of distributed log analysis system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |