CN101777079B - Realization method for fast generating electronic report forms - Google Patents
Realization method for fast generating electronic report forms Download PDFInfo
- Publication number
- CN101777079B CN101777079B CN2010101223013A CN201010122301A CN101777079B CN 101777079 B CN101777079 B CN 101777079B CN 2010101223013 A CN2010101223013 A CN 2010101223013A CN 201010122301 A CN201010122301 A CN 201010122301A CN 101777079 B CN101777079 B CN 101777079B
- Authority
- CN
- China
- Prior art keywords
- index
- data
- index group
- key
- layer
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
The present invention relates to the business intelligence data application, relate in particular to a kind of implementation method of quick generation electronic report forms.
Background technology
Tradition form technology realizes having a characteristic, when form is opened, there is bigger data volume mutual, more IO operation is arranged, long time waiting, when relating in particular to big data quantity,, on the form of expression, also correspond to fixed form and multidimensional analysis type form (OLAP form) respectively with obtaining the longer stand-by period.
Report data is general direct to be obtained from relevant database by SQL (Structured Query Language) language.The client-side program result is by client-side program or Web program display.More the advanced processes mode is exactly that Query Result is placed in the buffer memory according to certain dispatching algorithm, and same next time query statement need not submitting to database processing, directly obtains data and get final product from buffer memory; Perhaps data are obtained from multi-dimensional database by MDX (MultiDimensional EXpressions) language, these two kinds of technology can obtain inquiry response performance preferably, and, determined form when deal with data because cache size is restricted, also to spend the long time.
For the business intelligence data application, form also is all characteristics with general form, and the historical data amount is bigger, generally all form can be deposited several years historical data, the record number all can have more than one hundred million, so system need be from these many data, do inquiry, add up, gather, the inquiry response performance is well imagined, client perception is poor, especially Guan Jian bordereaux, the important indicator when development and Design is exactly the response time, and how long control be the essential condition of system when paying.
Summary of the invention
The present invention is for overcoming the deficiencies in the prior art part, purpose is to provide a kind of method of quick generation electronic report forms, this method adopts the memory report technology, when the reporting system initialization, in advance read internal memory from database all key business data, the user is when the visit form, system directly reads corresponding report data according to the role and the authority of login user from internal memory, avoided data to read consuming time that internal memory brings, solved and exist the time-delay of conventional form high in the prior art from hard disk, low-response causes some row problems such as the non-constant of client perception.
The present invention achieves the above object by the following technical programs: a kind of system of quick generation electronic report forms comprises three layers of data Layer, key-course and presentation layers;
Data Layer comprises being used to define with the operational indicator repository of store data model structure and memory report structural information and being used to deposit the operational indicator database of business datum;
Key-course is used for periodically according to index definition algorithm, rule, extracts business datum from data Layer and is loaded into the internal memory; Be used to provide data result to presentation layer;
Presentation layer is positioned at system-oriented managerial personnel and reports user foremost, is used for being responsible for submission system managerial personnel and user's instruction, search request and parameter, wait for that key-course is finished dealing with after, link order result or represent form by configuration format.
The caching mechanism that the caching system that useful Java language is write in the described key-course forms is to be used for storing data at internal memory.
As preferably, use the lru algorithm in the key-course, when the memory cache zone is full, at first delete least-recently-used data cached.
As preferably, the operational indicator repository comprises index definition, and index refreshes the SQL definition, and the contextual definition of definition of index group and index and group need represent the configuration and the definition of business tine in client.
A kind of implementation method of quick generation electronic report forms comprises the steps:
1) configure base index: be positioned at the needs of the managerial personnel of presentation layer, send instruction, in the operational indicator repository of data Layer configuration index the most basic, that script directly generates, define the SQL that refreshes of index simultaneously to key-course according to report form showing;
2) definition index group: be positioned at the needs of the managerial personnel of presentation layer, send instruction, dispose the shell script of title, affiliated relation and the corresponding operation of index group at the operational indicator repository of data Layer to key-course according to report form showing;
3) n-th-trem relation n in configuration index, index group, the index group: be positioned at the needs of the managerial personnel of presentation layer according to report form showing, send instruction to key-course, in the operational indicator repository configuration index of data Layer and the relation of index group mean terms, the relation of index group and index group mean terms;
4) memory configurations: be positioned at the needs of the managerial personnel of presentation layer according to report form showing, send instruction to key-course, the maximum object count of definition internal memory reaches the lru algorithm to scheduling memory in the operational indicator repository of data Layer;
5) key-course is brushed the data in the operational indicator database into internal memory according to the SQL that refreshes in the operational indicator storehouse;
6) key-course is by lru algorithm, and whether inquiry has the data that need fall clearly and execute instruction in internal memory;
7) key-course brushes up-to-date data object into internal memory;
When 8) presentation layer sends query SQL, preferential data query from internal memory;
9) if there are not the data of client's needs in the internal memory, then from professional achievement data library inquiry data;
10) Query Result is returned to presentation layer.
As preferably, the main deploy content in the described step 1) comprises the index numbering, unit, and index name, index refreshes SQL, index refresh cycle, index early warning bound.
As preferably, described step 2) deploy content comprises the index group # in, and the index group name claims that the index group is described, and the index group refreshes job title.
As preferably, the deploy content in the described step 3) comprises index group mean terms numbering, index group mean terms title, and index group mean terms unit, affiliated index group comprises index, shows title, and whether ordering rule is available.
Beneficial effect of the present invention: the present invention has set up internal memory at key-course, and the caching mechanism that the caching system of writing with Java language forms is to be used for storing data at internal memory; System directly reads corresponding report data according to the role and the authority of login user from internal memory, avoided data to read consuming time that internal memory brings from the hard disk of model layer, improved the response time greatly, the bordereaux response time, basic controlling was in 500 milliseconds, realize zero propagation, be better than the access response time of common form technology, promoted user's perception, solved and have in the prior art that the time-delay of conventional form is high, low-response causes some row problems such as the non-constant of client perception.
Description of drawings
Fig. 1 is a system architecture synoptic diagram of the present invention.
Embodiment
Embodiment 1: the present invention is described further below in conjunction with specific embodiment, but protection scope of the present invention is not limited in this:
As shown in Figure 1: a kind of system of quick generation electronic report forms comprises three layers of data Layer, key-course and presentation layers; Data Layer comprises being used to define with the operational indicator repository of store data model structure and memory report structural information and being used to deposit business datum operational indicator database; The operational indicator repository comprises index definition, and index refreshes the SQL definition, and the contextual definition of definition of index group and index and group need represent the configuration and the definition of business tine in client.
Key-course is used for periodically according to index definition algorithm, rule, extracts business datum from data Layer and is loaded into the internal memory; Be used to provide data result to presentation layer; The caching mechanism that the caching system that useful Java language is write in the described key-course forms is to be used for storing data at internal memory.Use the lru algorithm in the key-course, when the memory cache zone is full, at first delete least-recently-used data cached.
Presentation layer is positioned at system-oriented managerial personnel and reports user foremost, is used for being responsible for submission system managerial personnel and user's instruction, search request and parameter, wait for that key-course is finished dealing with after, link order result or represent form by configuration format.
A kind of implementation method of quick generation electronic report forms, as follows:
1) configure base index: be positioned at the needs of the managerial personnel of presentation layer according to report form showing, send instruction to key-course, what define base values in the operational indicator repository of data Layer configuration index the most basic, that script directly generates, simultaneously refreshes relevant information such as SQL; Main deploy content comprises the index numbering, unit, and index name, index refreshes SQL, index refresh cycle, index early warning bound.
2) definition index group: be positioned at the needs of the managerial personnel of presentation layer, send instruction, dispose the shell script of title, affiliated relation and the corresponding operation of index group at the operational indicator repository of data Layer to key-course according to report form showing; Deploy content comprises the index group #, and the index group name claims that the index group is described, and the index group refreshes job title.
3) n-th-trem relation n in configuration index, index group, the index group: be positioned at the needs of the managerial personnel of presentation layer according to report form showing, send instruction to key-course, in the operational indicator repository configuration index of data Layer and the relation of index group mean terms, the relation of index group and index group mean terms; Deploy content comprises index group mean terms numbering, index group mean terms title, and index group mean terms unit, affiliated index group comprises index, shows title, and whether ordering rule is available.
4) memory configurations: be positioned at the needs of the managerial personnel of presentation layer according to report form showing, send instruction to key-course, the maximum object count of definition internal memory reaches the lru algorithm to scheduling memory in the operational indicator repository of data Layer;
5) key-course is brushed the data in the operational indicator database into internal memory according to the SQL that refreshes in the operational indicator storehouse;
6) key-course is by lru algorithm, and whether inquiry has the data that need fall clearly and execute instruction in internal memory;
7) key-course brushes up-to-date data object into internal memory;
When 8) presentation layer sends query SQL, preferential data query from internal memory;
9) if there are not the data of client's needs in the inherence, then from professional achievement data library inquiry data;
10) Query Result is returned to presentation layer.
Be example with " broadband charging number of users " index group mean terms generative process in certain form below, provide the embodiment of report form generation method and process to be described in detail invention
The index group # | The index group name claims | The index group is described | Corresponding operation |
1004 | User's development | User's development | MOL901_KPI_DAILY_0500Z |
N-th-trem relation n in index, index group, the index group
Here be noted that " comprising index " configuration field, it is to have several indexs synthetic, and form is as follows: " 200501:3; 200502:3; 200501:6; 200502:6; 200503:3 ", each index has certain form, AAAAA:BB; AAAAAA represents index ID, and BB represents the account form of index, represents base values as 3; 6 represent chain rate etc., and WEB continues when reading these forms like this, resolves corresponding desired value automatically.In the actual application, 200501 indexs are represented CDMA development amount, and 200502 represent landline telephone development amount, and 200503 representatives have a broadband development amount, and the earning in a day is worked as in 3 representatives, and 6 represent sequential growth rate, so to " 200501:3; 200502:3; 200501:6; 200502:6; 200503:3 " just resolve to one group of index: " CDMA development on same day amount; Landline telephone development on same day amount; CDMA development on same day amount sequential growth rate; Landline telephone development on same day amount sequential growth rate; Broadband development on same day amount ";
Configuration cache.ccf file, definition maximum object count, scheduling memory algorithm (lru algorithm) definition
cacheattributes.MaxObjects=1000
cacheattributes.MemoryCacheName=memory.lru.LRUMemoryCache
By the LRU method, (NameSpace of organizing is used to hold one group of cache object in the buffer zone, need define the buffer zone in configuration file is implemented in the independent memory headroom and stores data, manage data cached valid period) whether inquiry have the data object that need fall clearly, if have then from internal memory, remove a data designated object by the cleanBlog method, by the setBlog method data object is placed in the buffer memory then, this method is used the new data object of information creating that imports into, then this object data is placed in the internal memory.
Data query is the same with data query in database in internal memory, and directly the data in the audit memory are to picture, and the object by in the next heavily loaded buffer memory of IoadCacheObject () returns to client.
Above described be specific embodiments of the invention and the know-why used, if the change of doing according to conception of the present invention, when the function that it produced does not exceed spiritual that instructions and accompanying drawing contain yet, must belong to protection scope of the present invention.
Claims (4)
1. an implementation method that generates electronic report forms fast is characterized in that comprising the steps:
1) configure base index: be positioned at the needs of the managerial personnel of presentation layer, send instruction, in the operational indicator repository of data Layer configuration index the most basic, that script directly generates, define the SQL that refreshes of index simultaneously to key-course according to report form showing;
2) definition index group: be positioned at the needs of the managerial personnel of presentation layer, send instruction, dispose the shell script of title, affiliated relation and the corresponding operation of index group at the operational indicator repository of data Layer to key-course according to report form showing;
3) n-th-trem relation n in configuration index, index group, the index group: be positioned at the needs of the managerial personnel of presentation layer according to report form showing, send instruction to key-course, in the operational indicator repository configuration index of data Layer and the relation of index group mean terms, the relation of index group and index group mean terms;
4) memory configurations: be positioned at the needs of the managerial personnel of presentation layer according to report form showing, send instruction to key-course, the maximum object count of definition internal memory reaches the lru algorithm to scheduling memory in the operational indicator repository of data Layer;
5) key-course is brushed the data in the operational indicator database into internal memory according to the SQL that refreshes in the operational indicator repository;
6) key-course is by lru algorithm, and whether inquiry has the data that need fall clearly and execute instruction in internal memory;
7) key-course brushes up-to-date data object into internal memory;
When 8) presentation layer sends query SQL, preferential data query from internal memory;
9) if there are not the data of client's needs in the internal memory, then from professional achievement data library inquiry data;
10) Query Result is returned to presentation layer.
2. the implementation method of a kind of quick generation electronic report forms according to claim 1 is characterized in that the main deploy content in the described step 1) comprises the index numbering, unit, and index name, index refreshes SQL, index refresh cycle, index early warning bound.
3. the implementation method of a kind of quick generation electronic report forms according to claim 1 is characterized in that described step 2) in deploy content comprise the index group #, the index group name claims, the index group is described, the index group refreshes job title.
4. the implementation method of a kind of quick generation electronic report forms according to claim 1, it is characterized in that the deploy content in the described step 3) comprises index group mean terms numbering, index group mean terms title, index group mean terms unit, affiliated index group comprises index, shows title, ordering rule, whether available.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010101223013A CN101777079B (en) | 2010-03-11 | 2010-03-11 | Realization method for fast generating electronic report forms |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010101223013A CN101777079B (en) | 2010-03-11 | 2010-03-11 | Realization method for fast generating electronic report forms |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101777079A CN101777079A (en) | 2010-07-14 |
CN101777079B true CN101777079B (en) | 2011-11-09 |
Family
ID=42513540
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2010101223013A Active CN101777079B (en) | 2010-03-11 | 2010-03-11 | Realization method for fast generating electronic report forms |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101777079B (en) |
Families Citing this family (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101923538B (en) * | 2010-08-20 | 2012-02-29 | 伊马莱富(北京)制药系统有限公司 | Application of configurable batch report in lyophilizer |
CN103020146A (en) * | 2012-11-22 | 2013-04-03 | 华为技术有限公司 | Data processing method and equipment |
CN103488688A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Cell data cache system and cell data cache method |
CN103927378B (en) * | 2014-04-29 | 2017-04-12 | 智业软件股份有限公司 | Automatic positioning and early-warning method of problem data of report output results |
CN104408180A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Stored data inquiring method and device |
CN107451109B (en) * | 2017-07-05 | 2022-01-04 | 北京京东尚科信息技术有限公司 | Report generation method and system |
CN109582938B (en) * | 2017-09-28 | 2023-01-13 | 北京国双科技有限公司 | Report generation method and device |
CN109325053A (en) * | 2018-06-29 | 2019-02-12 | 平安科技(深圳)有限公司 | Data processing method, device and the computer readable storage medium of reporting system |
CN109739647A (en) * | 2018-12-28 | 2019-05-10 | 北京小米移动软件有限公司 | A kind of data processing method and device |
CN110263055B (en) * | 2019-06-18 | 2021-06-25 | 上海达梦数据库有限公司 | Parameter prompting method, device, equipment and storage medium |
CN110377896B (en) * | 2019-07-26 | 2023-08-22 | 中国工商银行股份有限公司 | Method, system, computer system, and medium for generating a spreadsheet |
CN110597851B (en) * | 2019-09-20 | 2022-06-07 | 深圳易嘉恩科技有限公司 | Big data based data processing and report display method |
CN112069218A (en) * | 2020-11-16 | 2020-12-11 | 浙江岩华文化科技有限公司 | Big data real-time processing method and device, electronic device and storage medium |
CN112465364B (en) * | 2020-12-03 | 2024-03-19 | 合肥天源迪科信息技术有限公司 | Management system for index library |
CN115859930A (en) * | 2023-02-21 | 2023-03-28 | 翌飞锐特电子商务(北京)有限公司 | System and method for quickly generating electronic report |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101140562A (en) * | 2007-02-14 | 2008-03-12 | 中兴通讯股份有限公司 | Method for realizing user-defined report forms |
CN101247620A (en) * | 2008-03-24 | 2008-08-20 | 中兴通讯股份有限公司 | Method for realizing user-defined report forms |
CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
-
2010
- 2010-03-11 CN CN2010101223013A patent/CN101777079B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101140562A (en) * | 2007-02-14 | 2008-03-12 | 中兴通讯股份有限公司 | Method for realizing user-defined report forms |
CN101247620A (en) * | 2008-03-24 | 2008-08-20 | 中兴通讯股份有限公司 | Method for realizing user-defined report forms |
CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
Also Published As
Publication number | Publication date |
---|---|
CN101777079A (en) | 2010-07-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101777079B (en) | Realization method for fast generating electronic report forms | |
US11853283B2 (en) | Dynamic aggregate generation and updating for high performance querying of large datasets | |
US9946780B2 (en) | Interpreting relational database statements using a virtual multidimensional data model | |
CN110651264B (en) | Query plan generation and execution in a relational database management system with temporal relational databases | |
US10467250B2 (en) | Data model design collaboration using semantically correct collaborative objects | |
CN107515927A (en) | A kind of real estate user behavioural analysis platform | |
CN102629269B (en) | Searching and storing method for embedded database | |
Dehdouh et al. | Columnar nosql star schema benchmark | |
EP2869220B1 (en) | Networked database system | |
CN108595664A (en) | A kind of agricultural data monitoring method under hadoop environment | |
CN109669975B (en) | Industrial big data processing system and method | |
Macura | Integration of data from heterogeneous sources using ETL technology | |
Ptiček et al. | Big data and new data warehousing approaches | |
CN102314514A (en) | Scoping method of table data structuration | |
Abdullahi et al. | Big data: performance profiling of meteorological and oceanographic data on hive | |
Chereja et al. | Operationalizing analytics with NewSQL | |
CN103309890A (en) | Technology for merging Linux file system and real-time database index | |
CN103870497B (en) | Column intelligent mechanism for per-column database | |
Bog et al. | Normalization in a mixed OLTP and OLAP workload scenario | |
Westerlund | Business intelligence: Multidimensional data analysis | |
US11372872B2 (en) | Dynamic chronometry data orientation | |
EP3889798A1 (en) | Dynamic chronometry data orientation | |
US20230124508A1 (en) | Dynamic Chronometry Data Orientation | |
Ferle | Storage and Performance Concepts | |
Pereira et al. | Real time data loading and OLAP queries: Living together in next generation BI environments |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CP02 | Change in the address of a patent holder |
Address after: Hangzhou City, Zhejiang Province, Binjiang District Puyan street 310053 Albert Road No. 1 Building 2 Zhejiang Hongcheng computer system Co. Ltd. Patentee after: Zhejiang Hongcheng Computer Systems Co., Ltd. Address before: 1, building 11, building 1, No. 310013, staff Road, Hangzhou, Zhejiang Patentee before: Zhejiang Hongcheng Computer Systems Co., Ltd. |
|
CP02 | Change in the address of a patent holder |