System structural frame for fast generating electronic report forms and realization method thereof

Abstract

The invention relates to the filed of business intelligent data application, in particular to a system structural frame for fast generating electronic report forms and a realization method thereof. The system structural frame comprises three layers: a data layer, a control layer and a display layer, wherein the data layer comprises a business index configuration base and a business index database, the control layer is used for periodically extracting business data from the data layer and loading the business data into a memory according to index definition algorithms and rules, and is used for providing data results for the display layer, and the display layer returns instruction results or displays the report forms according to the configuration format. The invention has the advantages that the invention greatly improves the response time, the response time of the business report forms is basically controlled within 500 milliseconds, the zero time delay is realized, the response time is superior to the visit response time of the ordinary report form technology, and the user apperception is improved.

Description

technical field [0001] The invention relates to the application field of business intelligence data, in particular to a system framework for rapidly generating electronic reports and an implementation method thereof. Background technique [0002] The implementation of traditional report technology has a characteristic. When the report is opened, there is a large amount of data interaction, more IO operations, and a longer waiting time, especially when a large amount of data is involved, a longer waiting time will be obtained. , which correspond to fixed reports and multi-dimensional analytical reports (OLAP reports) in terms of presentation forms. [0003] The report data is generally directly obtained from the relational database through the SQL (Structured Query Language) language. The results of the client program are displayed through the client program or the Web program. A more advanced processing method is to put the query results in the cache according to a certain...

AI Technical Summary

Problems solved by technology

A more advanced processing method is to put the query results in the cache according to a certain scheduling algorithm. The next time the same query statement does not need to be submitted to the database for processing, it can directly obtain the data from the cache; or the data can be retrieved from These two technologies can obtain better query response performance, but because the cache size is limited, it will take a long time for the report to process the data.

Images