CN103699557A - Report processing method and report processing system - Google Patents
Report processing method and report processing system Download PDFInfo
- Publication number
- CN103699557A CN103699557A CN201310397941.9A CN201310397941A CN103699557A CN 103699557 A CN103699557 A CN 103699557A CN 201310397941 A CN201310397941 A CN 201310397941A CN 103699557 A CN103699557 A CN 103699557A
- Authority
- CN
- China
- Prior art keywords
- report
- request message
- report generation
- generation request
- distributed caching
- 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.)
- Granted
Links
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24539—Query rewriting; Transformation using cached or materialised query results
-
- 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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention provides a report processing method and a report processing system. The method comprises the following steps of receiving a report generation request message sent by user equipment, wherein the report generation request message comprises report generation rules and report demand information; storing the report generation request message in distributed cache; inquiring the report generation request message in the distributed cache at regular time, extracting report data matched with the report demand information from a first database according to the inquired report generation request message, storing the report data into the distributed cache, and generating a report in the distributed cache according to the report generation rules and the report data; writing the generated report in a file server for the user equipment to download the report from the file server. According to the report processing method and a report processing system provided by the invention, a user does not need to register a report system for lookup and export when requiring the report data every time, and therefore the system load is reduced, and the user is facilitated.
Description
Technical field
The present invention relates to technical field of data processing, relate in particular to a kind of report processing method and system.
Background technology
Form is basic measures and the approach of business administration, it is the basic service requirement of enterprise, also be to implement business intelligence (Business Intelligence, hereinafter to be referred as BI) strategic basis, form can help accessed enterprise, formatted data, also data message is and dedicate user in reliable and safe mode, deeply seeing clearly enterprise operation situation, is the powerful driving force of enterprise development.
At present, many application programs are all saved in data in data base management system (DBMS), and when user need to derive form, needing first from data base management system (DBMS), to find needed data then could derive.And general large enterprise has a large amount of data need to check derivation every day, if adopt above-mentioned derivation process, waste time and energy, and along with the increase of visit data amount, also can increase the burden of data base management system (DBMS), thereby cause derivation speed slow.
Summary of the invention
The invention provides a kind of report processing method and system, be used for solving and when user needs report data, all must login reporting system and go to search and derive, and along with the increase of visit data amount, also can increase the burden of data base management system (DBMS), thereby cause derivation speed slow.
The invention provides a kind of report processing method, comprising:
Receive the report generation request message that subscriber equipment sends, in described report generation request message, comprise report generation rule and form demand information;
Described report generation request message is stored in distributed caching;
Regularly inquire about the report generation request message in described distributed caching, and according to the report generation request message inquiring, from the first database, extract the report data mating with described form demand information, and described report data is stored in described distributed caching, according to described report generation rule and report data generating report forms in described distributed caching;
By the form writing in files server generating, for described subscriber equipment, from described file server, download described form.
The present invention also provides a kind of report processing system, comprising:
Receiver module, the report generation request message sending for receiving subscriber equipment, comprises report generation rule and form demand information in described report generation request message;
Memory module, for being stored in distributed caching by described report generation request message;
Generation module, for regularly inquiring about the report generation request message of described distributed caching, and according to the report generation request message inquiring, from the first database, extract the report data mating with described form demand information, and described report data is stored in described distributed caching, according to described report generation rule and report data generating report forms in described distributed caching;
Writing module, for by the form writing in files server generating, downloads described form for described subscriber equipment from described file server.
The present invention is according to user preset report generation rule and form demand information automatic report generation data, the form generating is in advance write to server directly to be downloaded for user, while not needing user to need report data, all will login reporting system goes to search and derive at every turn, and, can for example, in system (late into the night) automatic report generation data during the free time according to user preset report generation rule and form demand information, thus system burden reduced.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of report processing method embodiment mono-provided by the invention;
Fig. 2 is the process flow diagram of report processing method embodiment bis-provided by the invention;
Fig. 3 is the structural drawing of report processing system embodiment mono-provided by the invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only a part of embodiment of the present invention, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
As shown in Figure 1, the process flow diagram for report processing method embodiment mono-provided by the invention, comprises the steps:
The report generation request message that S101, reception subscriber equipment send, comprises report generation rule and form demand information in report generation request message;
It should be noted that, report generation rule mainly refers to the information such as the form, type of generating report forms, such as report form type, can be common list, detailed form, grouping form, nested report, Cross Report, chart form, the list of tree type, tree control, consolidated statement etc.Form demand information mainly refers to the date of formation of the data that user need to extract and the content of the data that needs extract etc.For example, user need to formulate relevant 2013.8 month running velocity relevant data form, need in form demand information, carry 2013.8.1 to 2013.8.30 of upper date and key word car speed.
S102, report generation request message is stored in distributed caching;
Here, report generation request message is stored in distributed caching, is convenient to reporting system and extracts fast report generation request message.In addition, report generation request message can also be stored in the second database.While there is no report generation request message in inquiring distributed caching, inquire about in the second database whether store report generation request message, if so, from the second database, extract report generation request message in distributed caching.Like this, when distributed caching breaks down, system can also be extracted the report generation request message that subscriber equipment sends from database.
Report generation request message in S103, timing Querying Distributed buffer memory;
Specifically, reporting system can periodically be inquired about report generation request message from distributed caching, and according to report generation request message, from the first database, extract the report data mating with form demand information, and report data is stored in distributed caching, distributed slow in, according to report generation rule and report data record a demerit calculate generate user need to form.
S104, by the form writing in files server generating, for subscriber equipment, from file server, download described form.
When user is available free, can login reporting system downloading data from file server as required.In addition, system, by after the form writing in files server generating, can send a response message to subscriber equipment and notify user, so that user downloads and checks in time.Wherein, in response message, comprise form attribute information, as form size, statement form, rise time etc., so that user understands the essential information of form in advance, thereby be convenient to the follow-up Report Server Management work of user.
The present embodiment writes server by the form generating in advance and directly downloads for user, while not needing user to need report data, all will login reporting system goes to search and derive at every turn, and, can for example, in system (late into the night) automatic report generation data during the free time according to user preset report generation rule and form demand information, thus system burden reduced.
As shown in Figure 2, be the process flow diagram of report processing method embodiment bis-provided by the invention, the difference of the present embodiment and embodiment mono-is, the present embodiment is further comprising the steps of except comprising the method step in embodiment mono-:
The report query request message that S201, reception subscriber equipment send, report query request message comprises query demand information;
The query demand information spinner here will refer to needed date of report generation and the key word of the inquiry that user will inquire about.For example, user wants to inquire about the vehicle travel record on August 7th, 2013, need in query demand information, comprise date 2013.8.7 and content vehicle travel.
S202, according to query demand information, from the first database, extract the data with query demand information matches;
First database is here the database of the above-mentioned vehicle data of storage.
S203, the data that inquire are stored in distributed caching, middle according to system default rule and data generating report forms in distributed caching of inquiring;
Specifically, the data that inquire are stored in distributed caching, and according to system default rule and the data that inquire, by calculating, generate required form in distributed caching.
S204, the form that distributed caching is generated are pushed to subscriber equipment.
The form of generation is sent to subscriber equipment to be shown.
The present embodiment user can check report data according to the demand of oneself, when viewing important data and need to download, can arrive on the server of generating report forms in advance and download, and all data that do not need disposable derivation to find, thereby system burden reduced.
As shown in Figure 3, be the structural drawing of report processing system embodiment mono-provided by the invention, mainly comprise with lower module:
Writing module 34, for by the form writing in files server generating, downloads form for subscriber equipment from file server.
Above-mentioned report processing system can also comprise communication module 35, for after by the form writing in files server generating, sends report generation response message to subscriber equipment, with notifying user equipment, from described file server, downloads the form of being asked.Wherein, in response message, comprise form attribute information, as form size, statement form, report generation time etc., so that user understands the essential information of form in advance, thereby be convenient to the follow-up Report Server Management work of user.Further, memory module 32, also for being stored in the second database by report generation request message.
Further, generation module 33, also for after regularly inquiring about the report generation request message of described distributed caching, if there is no report generation request message in Querying Distributed buffer memory, inquire about and in the second database, whether store report generation request message, if so, from the second database, extract report generation request message in distributed caching.
The report processing system of the present embodiment is for carrying out the scheme of embodiment of the method shown in above-mentioned Fig. 1, and it realizes principle and technique effect is similar, repeats no more herein.
On the basis of above-described embodiment, further:
Particularly, this receiver module 31, generation module 33, memory module 32 and communication module 35 can be for carrying out the scheme of embodiment of the method shown in above-mentioned Fig. 2, and it realizes principle and technique effect is similar, repeats no more herein.
One of ordinary skill in the art will appreciate that: all or part of step that realizes above-mentioned each embodiment of the method can complete by the relevant hardware of programmed instruction.Aforesaid program can be stored in a computer read/write memory medium.This program, when carrying out, is carried out the step that comprises above-mentioned each embodiment of the method; And aforesaid storage medium comprises: various media that can be program code stored such as ROM, RAM, magnetic disc or CDs.
Finally it should be noted that: each embodiment, only in order to technical scheme of the present invention to be described, is not intended to limit above; Although the present invention is had been described in detail with reference to aforementioned each embodiment, those of ordinary skill in the art is to be understood that: its technical scheme that still can record aforementioned each embodiment is modified, or some or all of technical characterictic is wherein equal to replacement; And these modifications or replacement do not make the essence of appropriate technical solution depart from the scope of various embodiments of the present invention technical scheme.
Claims (10)
1. a report processing method, is characterized in that, comprising:
Receive the report generation request message that subscriber equipment sends, in described report generation request message, comprise report generation rule and form demand information;
Described report generation request message is stored in distributed caching;
Regularly inquire about the report generation request message in described distributed caching, and according to the report generation request message inquiring, from the first database, extract the report data mating with described form demand information, and described report data is stored in described distributed caching, according to described report generation rule and report data generating report forms in described distributed caching;
By the form writing in files server generating, for described subscriber equipment, from described file server, download described form.
2. method according to claim 1, is characterized in that, described by after the form writing in files server generating, and also comprises:
Send report generation response message to subscriber equipment, to notify described subscriber equipment to download the form of being asked from described file server;
Described response message comprises form attribute information.
3. method according to claim 1, is characterized in that, also comprises:
Receive the report query request message that subscriber equipment sends, described report query request message comprises query demand information;
According to described query demand information, from described the first database, extract the data with described query demand information matches;
The data that inquire are stored in described distributed caching so that in described distributed caching according to system default rule and the data generating report forms that inquires;
The form that described distributed caching is generated is pushed to described subscriber equipment.
4. according to the method described in any one in claim 1～3, it is characterized in that, also comprise:
Described report generation request message is stored in the second database.
5. method according to claim 4, is characterized in that, described timing also comprises after inquiring about the report generation request message in described distributed caching:
If inquire about, in described distributed caching, there is no described report generation request message, inquire about in described the second database and whether store report generation request message, if so, from described the second database, extract described report generation request message in distributed caching.
6. a report processing system, is characterized in that, comprising:
Receiver module, the report generation request message sending for receiving subscriber equipment, comprises report generation rule and form demand information in described report generation request message;
Memory module, for being stored in distributed caching by described report generation request message;
Generation module, for regularly inquiring about the report generation request message of described distributed caching, and according to the report generation request message inquiring, from the first database, extract the report data mating with described form demand information, and described report data is stored in described distributed caching, according to described report generation rule and report data generating report forms in described distributed caching;
Writing module, for by the form writing in files server generating, downloads described form for described subscriber equipment from described file server.
7. system according to claim 6, is characterized in that, also comprises:
Communication module, for after by the form writing in files server generating, sends report generation response message to subscriber equipment, to notify described subscriber equipment to download the form of being asked from described file server;
Described response message comprises form attribute information.
8. system according to claim 6, is characterized in that, described receiver module, and the report query request message also sending for receiving subscriber equipment, described report query request message comprises query demand information;
Described generation module, also for the data from described the first database extraction and described query demand information matches according to described query demand information; Described memory module, also for the data that inquire are stored in to described distributed caching, according to system default rule and the data generating report forms in described distributed caching inquiring;
Described communication module, is also pushed to described subscriber equipment for the form that described distributed caching is generated.
9. according to the system described in any one in claim 6～8, it is characterized in that, described memory module, also for being stored in the second database by described report generation request message.
10. system according to claim 9, is characterized in that, described generation module,
Also for after regularly inquiring about the report generation request message of described distributed caching, if inquire about, in described distributed caching, there is no described report generation request message, inquire about in described the second database and whether store report generation request message, if so, from described the second database, extract described report generation request message in distributed caching.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310397941.9A CN103699557B (en) | 2013-09-04 | 2013-09-04 | report processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310397941.9A CN103699557B (en) | 2013-09-04 | 2013-09-04 | report processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103699557A true CN103699557A (en) | 2014-04-02 |
| CN103699557B CN103699557B (en) | 2017-10-10 |
Family
ID=50361087
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310397941.9A Active CN103699557B (en) | 2013-09-04 | 2013-09-04 | report processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103699557B (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN106021420A (en) * | 2016-05-13 | 2016-10-12 | 乐视控股（北京）有限公司 | Method and device for optimizing table structure |
| CN106254435A (en) * | 2016-07-28 | 2016-12-21 | 努比亚技术有限公司 | Message push system and method |
| CN106777037A (en) * | 2016-12-09 | 2017-05-31 | 南京欣网互联信息技术有限公司 | A kind of method for generating operation platform integration form |
| CN109697209A (en) * | 2018-12-25 | 2019-04-30 | 广东亿迅科技有限公司 | A kind of report processing method and device of Based on Distributed database |
| CN110097343A (en) * | 2019-05-08 | 2019-08-06 | 上海海洋大学 | Laboratory Intelligent office reporting system |
| CN110413610A (en) * | 2019-06-19 | 2019-11-05 | 中国平安财产保险股份有限公司 | Improve method and system, the database server of business datum report export efficiency |
| CN110750804A (en) * | 2019-10-30 | 2020-02-04 | 政采云有限公司 | Report asynchronous downloading method, device, equipment and readable storage medium |
| CN113190581A (en) * | 2021-04-30 | 2021-07-30 | 宝宝巴士股份有限公司 | Method and terminal for dynamically generating report form based on big data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1482766A (en) * | 2002-09-13 | 2004-03-17 | 华为技术有限公司 | Method for automatic generating of net management report form |
| CN101004758A (en) * | 2007-01-26 | 2007-07-25 | 华为技术有限公司 | Method and corresponding system for creating and obtaining report forms |
| US20090055341A1 (en) * | 2007-08-22 | 2009-02-26 | American Express Travel Related Services Company, Inc. | Regulatory Survey Automation System (RSAS) |
| CN102854870A (en) * | 2012-05-09 | 2013-01-02 | 上海西门子工业自动化有限公司 | Distributed control system and data report generating method |
| CN302368261S (en) * | 2012-12-05 | 2013-03-27 | 浙江理工大学 | Desk (2) |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
-
2013
- 2013-09-04 CN CN201310397941.9A patent/CN103699557B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1482766A (en) * | 2002-09-13 | 2004-03-17 | 华为技术有限公司 | Method for automatic generating of net management report form |
| CN101004758A (en) * | 2007-01-26 | 2007-07-25 | 华为技术有限公司 | Method and corresponding system for creating and obtaining report forms |
| US20090055341A1 (en) * | 2007-08-22 | 2009-02-26 | American Express Travel Related Services Company, Inc. | Regulatory Survey Automation System (RSAS) |
| CN102854870A (en) * | 2012-05-09 | 2013-01-02 | 上海西门子工业自动化有限公司 | Distributed control system and data report generating method |
| CN302368261S (en) * | 2012-12-05 | 2013-03-27 | 浙江理工大学 | Desk (2) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN106021420A (en) * | 2016-05-13 | 2016-10-12 | 乐视控股（北京）有限公司 | Method and device for optimizing table structure |
| CN106254435A (en) * | 2016-07-28 | 2016-12-21 | 努比亚技术有限公司 | Message push system and method |
| CN106777037A (en) * | 2016-12-09 | 2017-05-31 | 南京欣网互联信息技术有限公司 | A kind of method for generating operation platform integration form |
| CN109697209A (en) * | 2018-12-25 | 2019-04-30 | 广东亿迅科技有限公司 | A kind of report processing method and device of Based on Distributed database |
| CN110097343A (en) * | 2019-05-08 | 2019-08-06 | 上海海洋大学 | Laboratory Intelligent office reporting system |
| CN110413610A (en) * | 2019-06-19 | 2019-11-05 | 中国平安财产保险股份有限公司 | Improve method and system, the database server of business datum report export efficiency |
| CN110413610B (en) * | 2019-06-19 | 2023-10-27 | 中国平安财产保险股份有限公司 | Method and system for improving export efficiency of business data report forms and database server |
| CN110750804A (en) * | 2019-10-30 | 2020-02-04 | 政采云有限公司 | Report asynchronous downloading method, device, equipment and readable storage medium |
| CN113190581A (en) * | 2021-04-30 | 2021-07-30 | 宝宝巴士股份有限公司 | Method and terminal for dynamically generating report form based on big data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103699557B (en) | 2017-10-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103699557A (en) | Report processing method and report processing system | |
| CN102725755B (en) | Method and system of file access | |
| CN103268336A (en) | Fast data and big data combined data processing method and system | |
| CN103095819A (en) | Data information pushing method and data information pushing system | |
| CN104090889A (en) | Method and system for data processing | |
| CN105493028A (en) | Data consistency and rollback for cloud analytics | |
| CN103164525A (en) | Method and device for WEB application release | |
| CN104113576A (en) | Method and device for updating client | |
| CN104794190A (en) | Method and device for effectively storing big data | |
| CN102750317A (en) | Method and device for data persistence processing and data base system | |
| CN103853714A (en) | Data processing method and device | |
| CN103051671A (en) | Repeating data deletion method for cluster file system | |
| CN105900093A (en) | Keyvalue database data table updating method and data table updating device | |
| CN102722405A (en) | Counting method in high concurrent and multithreaded application and system | |
| CN103038742A (en) | Method and system for dynamically replicating data within a distributed storage system | |
| CN104778229A (en) | Telecommunication service small file storage system and method based on Hadoop | |
| CN104750855A (en) | Method and device for optimizing big data storage | |
| CN104881454A (en) | Updating method and system of parameter | |
| CN105491078A (en) | Data processing method and device in SOA system, and SOA system | |
| CN111008183B (en) | Storage method and system for business wind control log data | |
| CN102917005A (en) | Method and device supporting massive memory access to transactions | |
| CN102591935A (en) | Distributive data storage management method and distributive data storage management system | |
| US10191818B2 (en) | Filtered replication of data in distributed system of data centers | |
| CN103870571A (en) | Cube reconstruction method and device in MOLAP (multi dimension online analytical processing) system | |
| CN103841168A (en) | Data copy updating method and metadata server |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Hu Kai Inventor after: Bi Lei Inventor after: Zheng Yongjin Inventor after: Qian Chunyang Inventor after: Song Bo Inventor after: Zhao Liang Inventor after: Chang Biao Inventor before: Hu Kai Inventor before: Bi Lei Inventor before: Song Bo Inventor before: Zhao Liang Inventor before: Chang Biao Inventor before: Pi Zhiyun Inventor before: Li Guowang Inventor before: Lu Haolei Inventor before: Zhao Jiaying |
|
| CB03 | Change of inventor or designer information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |