CN103699557B - report processing method and system - Google Patents
report processing method and system Download PDFInfo
- Publication number
- CN103699557B CN103699557B CN201310397941.9A CN201310397941A CN103699557B CN 103699557 B CN103699557 B CN 103699557B CN 201310397941 A CN201310397941 A CN 201310397941A CN 103699557 B CN103699557 B CN 103699557B
- Authority
- CN
- China
- Prior art keywords
- report
- request message
- report generation
- distributed caching
- generation request
- 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
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
Abstract
The present invention provides a kind of report processing method and system, wherein, method includes：Receive in the report generation request message that user equipment is sent, report generation request message comprising report generation rule and form demand information；Report generation request message is stored in distributed caching；Report generation request message in timing Querying Distributed caching, and the report data matched with form demand information is extracted from the first database according to the report generation request message inquired, and report data is stored in distributed caching, form is generated in distributed caching according to report generation rule and report data；The form of generation is write into file server, so that user equipment downloads form from file server.It need not need will to log in reporting system every time during report data by user of the present invention to go to search and export, so as to reduce system burden, facilitate user.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of report processing method and system.
Background technology
Form is the basic measures and approach of business administration, is the basic service requirement of enterprise, is also to implement business intelligence
（Business Intelligence, hereinafter referred to as BI）Strategy basis, form can help accessed enterprise, format data,
And data message is presented to user in reliable and safe mode, enterprise operation situation is deeply seen clearly, is enterprise development
Powerful driving force.
At present, many application programs are all stored data into data base management system, when user needs export form,
Need the data required for first being found from data base management system and then could export.And general large enterprise has largely daily
Data need check export, wasted time and energy if using above-mentioned export process, and with access data volume increase,
The burden of data base management system can be increased, so as to cause export speed slow.
The content of the invention
The present invention provides a kind of report processing method and system, needs all to have to step on during report data for solving user
Record reporting system goes to search and exported, and with the increase for accessing data volume, can also increase the burden of data base management system,
So as to cause export speed slow.
The present invention provides a kind of report processing method, including：
Receive in the report generation request message that user equipment is sent, the report generation request message and include report generation
Rule and form demand information；
The report generation request message is stored in distributed caching；
The report generation request message that timing is inquired about in the distributed caching, and asked according to the report generation inquired
Message extracts the report data matched with the form demand information from the first database, and the report data is stored in
In the distributed caching, form is generated in the distributed caching according to report generation rule and report data；
The form of generation is write into file server, so that the user equipment downloads the report from the file server
Table.
The present invention also provides a kind of report processing system, including：
Receiving module, the report generation request message for receiving user equipment transmission, the report generation request message
In comprising report generation rule and form demand information；
Memory module, for the report generation request message to be stored in distributed caching；
Generation module, for regularly inquiring about the report generation request message in the distributed caching, and according to inquiring
Report generation request message extract the report data matched with the form demand information from the first database, and will be described
Report data is stored in the distributed caching, according to report generation rule and report data in the distributed caching
Middle generation form；
Writing module, for the form of generation to be write into file server, so that the user equipment takes from the file
Business device downloads the form.
The present invention is according to user preset report generation rule and form demand information automatic report generation data, by pre- Mr.
Into form write service device directly downloaded for user, it is not necessary to user needs that form will be logged in during report data every time
System is gone to search and exported, moreover, can be when system is idle according to user preset report generation rule and form demand information
（Such as late into the night）Automatic report generation data, so as to reduce system burden.
Brief description of the drawings
The flow chart for the report processing method embodiment one that Fig. 1 provides for the present invention；
The flow chart for the report processing method embodiment two that Fig. 2 provides for the present invention；
The structure chart for the report processing system embodiment one that Fig. 3 provides for the present 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 carried out clear, complete
Site preparation is described, it is clear that described embodiment is only a part of embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, the every other reality that those of ordinary skill in the art obtain under the premise of creative work is not made
Example is applied, the scope of protection of the invention is belonged to.
As shown in figure 1, the flow chart of the report processing method embodiment one provided for the present invention, comprises the following steps：
Form life is included in S101, the report generation request message for receiving user equipment transmission, report generation request message
Into rule and form demand information；
It should be noted that report generation rule is primarily referred to as the information, such as form class such as generation report tableau format, type
Type can be common list, detailed form, packet form, nested report, Cross Report, chart form, tree-shaped list, tree-shaped control
Part, consolidated statement etc..Form demand information, which is primarily referred to as user, to be needed the date of formation for the data extracted and needs what is extracted
Content of data etc..For example, user need formulate about 2013.8 month running velocity about the form of data, then need
2013.8.1 of upper date to 2013.8.30 and keyword car speed are carried in form demand information.
S102, report generation request message is stored in distributed caching；
Here, report generation request message is stored in distributed caching, is easy to reporting system quickly to extract form
Generate request message.Furthermore it is also possible to which report generation request message is stored in the second database.It is distributed slow when inquiring
When there is no report generation request message in depositing, then the report generation request message that whether is stored with the second database is inquired about, if so,
Report generation request message is then extracted from the second database into distributed caching.So, when distributed caching breaks down
When, then system can also extract the report generation request message of user equipment transmission from database.
Report generation request message in S103, timing Querying Distributed caching；
Specifically, reporting system can inquire about report generation request message periodically from distributed caching, and according to report
Table generation request message extracts the report data matched with form demand information from the first database, and report data is stored
In distributed caching, in distribution is slow, is recorded a demerit according to report generation rule and report data and calculate what generation user needed
Form.
S104, the form write-in file server by generation, so that user equipment downloads the form from file server.
When user is available free, reporting system can be logged in as needed from file server download data.In addition, being
Unite and write the form of generation after file server, can send a response message to notify user to user equipment, so as to
User downloads check in time.Wherein, form attribute information, such as form size, statement form, generation time are included in response message
Etc., in order to which user understands the essential information of form in advance, consequently facilitating the follow-up Report Server Management work of user.
The present embodiment directly downloads the form write service device previously generated for user, it is not necessary to which user needs every time
Want that reporting system will be logged in during report data and go to search and export, moreover, according to user preset report generation rule and form
Demand information can be when system be idle（Such as late into the night）Automatic report generation data, so as to reduce system burden.
As shown in Fig. 2 the flow chart of the report processing method embodiment two provided for the present invention, the present embodiment and embodiment
One difference is that the present embodiment is further comprising the steps of in addition to the method and step in including embodiment one：
S201, the report query request message for receiving user equipment transmission, report query request message include query demand
Information；
Here query demand information is primarily referred to as date and inquiry key required for the report generation to be inquired about of user
Word.For example, user wants the vehicle travel record of inquiry August 7 in 2013, then need to include the date in query demand information
2013.8.7 with content vehicle travel.
S202, extract from the first database according to query demand information data with query demand information matches；
Here the first database is the database for storing above-mentioned vehicle data.
S203, by the data storage inquired in distributed caching, it is middle according to system default rule and the number that inquires
According to generating form in distributed caching；
Specifically, by the data storage inquired in distributed caching, and it is silent according to system in distributed caching
Recognize the form of rule and the data inquired needed for by calculating generation.
S204, the form that distributed caching is generated is pushed to user equipment.
The form of generation is sent to user equipment and shown.
The present embodiment user can check report data according to the demand of oneself, be needed when viewing important data
When downloading, then can to being downloaded on the server for previously generate form, without disposable export find it is all
Data, so as to reduce system burden.
As shown in figure 3, the structure chart of the report processing system embodiment one provided for the present invention, mainly including following mould
Block：
In receiving module 31, the report generation request message for receiving user equipment transmission, report generation request message
Include report generation rule and form demand information；
Memory module 32, for report generation request message to be stored in distributed caching；
Generation module 33, the report generation request message in being cached for timing Querying Distributed, and according to inquiring
Report generation request message extracts the report data matched with form demand information from the first database, and report data is deposited
Storage generates form according to report generation rule and report data in distributed caching in distributed caching；
Writing module 34, for the form of generation to be write into file server, so that user equipment is under file server
Carry form.
Above-mentioned report processing system can also include communication module 35, for the form of generation to be write into file server
Afterwards, report generation response message is sent to user equipment, is downloaded and asked from the file server with notifying user equipment
The form asked.Wherein, form attribute information, such as form size, statement form, report generation time are included in response message
Deng in order to which user understands the essential information of form in advance, consequently facilitating the follow-up Report Server Management work of user.Further,
Memory module 32, is additionally operable to report generation request message being stored in the second database.
Further, generation module 33, are additionally operable to disappear in the report generation request that timing is inquired about in the distributed caching
After breath, if not having report generation request message in Querying Distributed caching, the report that whether is stored with the second database is inquired about
Table generates request message, if so, then extracting report generation request message from the second database into distributed caching.
The report processing system of the present embodiment is used for the scheme for performing embodiment of the method shown in above-mentioned Fig. 1, its realization principle
Similar with technique effect, here is omitted.
On the basis of above-described embodiment, further：
Receiving module 31, is additionally operable to receive the report query request message that user equipment is sent, report query request message
Including query demand information；
Generation module 33, is additionally operable to be extracted from the first database according to query demand information and query demand information matches
Data；
Memory module 32, is additionally operable to the data storage that will be inquired in distributed caching, according to system default rule and
The data inquired generate form in distributed caching；
Communication module 35, the form for being additionally operable to generate distributed caching is pushed to user equipment.
Specifically, the receiving module 31, generation module 33, memory module 32 and communication module 35 can be used in execution
The scheme of embodiment of the method shown in Fig. 2 is stated, its implementing principle and technical effect is similar, and here is omitted.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above-mentioned each method embodiment can lead to
The related hardware of programmed instruction is crossed to complete.Foregoing program can be stored in a computer read/write memory medium.The journey
Sequence upon execution, performs the step of including above-mentioned each method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or
Person's CD etc. is various can be with the medium of store program codes.
Finally it should be noted that：Various embodiments above is merely illustrative of the technical solution of the present invention, rather than its limitations；To the greatest extent
The present invention is described in detail with reference to foregoing embodiments for pipe, it will be understood by those within the art that：Its according to
The technical scheme described in foregoing embodiments can so be modified, or which part or all technical characteristic are entered
Row equivalent substitution；And these modifications or replacement, the essence of appropriate technical solution is departed from various embodiments of the present invention technology
The scope of scheme.
Claims (8)
1. a kind of report processing method, it is characterised in that including：
Receive in the report generation request message that user equipment is sent, the report generation request message comprising report generation rule
With form demand information；
The report generation request message is stored in distributed caching；
The report generation request message that timing is inquired about in the distributed caching, and according to the report generation request message inquired
Extract the report data that is matched with the form demand information from the first database, and described in the report data is stored in
In distributed caching, form is generated in the distributed caching according to report generation rule and report data；
The form of generation is write into file server, so that the user equipment downloads the form from the file server；
Wherein, the report processing method, in addition to：
The report query request message that user equipment is sent is received, the report query request message includes query demand information；
The data with the query demand information matches are extracted from first database according to the query demand information；
By the data storage inquired in the distributed caching, so that according to system default rule in the distributed caching
Form is generated with the data inquired；
The form that the distributed caching is generated is pushed to the user equipment.
2. according to the method described in claim 1, it is characterised in that the form by generation is write after file server,
Also include：
Report generation response message is sent to user equipment, to notify the user equipment to download institute from the file server
The form of request；
The response message includes form attribute information.
3. method according to claim 1 or 2, it is characterised in that also include：
The report generation request message is stored in the second database.
4. method according to claim 3, it is characterised in that the form life that the timing is inquired about in the distributed caching
Into after request message, in addition to：
If inquiring about does not have the report generation request message in the distributed caching, inquire about in second database whether
Be stored with report generation request message, if so, then extracted from second database report generation request message to point
In cloth caching.
5. a kind of report processing system, it is characterised in that including：
Wrapped in receiving module, the report generation request message for receiving user equipment transmission, the report generation request message
Containing report generation rule and form demand information；
Memory module, for the report generation request message to be stored in distributed caching；
Generation module, for regularly inquiring about the report generation request message in the distributed caching, and according to the report inquired
Table generation request message extracts the report data matched with the form demand information from the first database, and by the form
Data storage is in the distributed caching, the life in the distributed caching according to report generation rule and report data
Into form；
Writing module, for the form of generation to be write into file server, so that the user equipment is from the file server
Download the form；
Wherein, the receiving module, is additionally operable to receive the report query request message that user equipment is sent, the report query please
Message is asked to include query demand information；
The generation module, is additionally operable to be extracted from first database according to the query demand information and the inquiry need
Seek the data of information matches；The memory module, is additionally operable to the data storage that will be inquired in the distributed caching, according to
System default rule and the data inquired generate form in the distributed caching；
Communication module, the form for the distributed caching to be generated is pushed to the user equipment.
6. system according to claim 5, it is characterised in that also include：
Communication module, for being write by the form of generation after file server, sends report generation response message to user
Equipment, to notify the user equipment to download asked form from the file server；
The response message includes form attribute information.
7. the system according to claim 5 or 6, it is characterised in that the memory module, is additionally operable to the report generation
Request message is stored in the second database.
8. system according to claim 7, it is characterised in that the generation module,
It is additionally operable to after the report generation request message in the distributed caching is inquired about in timing, if inquiry is described distributed slow
There is no the report generation request message in depositing, then inquire about the report generation request that whether is stored with second database and disappear
Breath, if so, then extracting the report generation request message from second database into 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 CN103699557A (en) | 2014-04-02 |
| CN103699557B true 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) |
Families Citing this family (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 |
| 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 |
Citations (4)
| 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 |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| CN102854870A (en) * | 2012-05-09 | 2013-01-02 | 上海西门子工业自动化有限公司 | Distributed control system and data report generating method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090055341A1 (en) * | 2007-08-22 | 2009-02-26 | American Express Travel Related Services Company, Inc. | Regulatory Survey Automation System (RSAS) |
-
2013
- 2013-09-04 CN CN201310397941.9A patent/CN103699557B/en active Active
Patent Citations (4)
| 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 |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| CN102854870A (en) * | 2012-05-09 | 2013-01-02 | 上海西门子工业自动化有限公司 | Distributed control system and data report generating method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103699557A (en) | 2014-04-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103699557B (en) | report processing method and system | |
| TWI701572B (en) | Data access method, system and device | |
| AU2019295818B2 (en) | Block chain-based data processing method and device | |
| CN102638584B (en) | Data distributing and caching method and data distributing and caching system | |
| CN102789619B (en) | Advertisement fixing is to the method thrown in and advertising platform equipment | |
| CN105138571A (en) | Distributed file system and method for storing lots of small files | |
| CN103853714A (en) | Data processing method and device | |
| CN103164525A (en) | Method and device for WEB application release | |
| CN102722405A (en) | Counting method in high concurrent and multithreaded application and system | |
| CN104657435A (en) | Storage management method for application data and network management system | |
| CN107992492A (en) | A kind of storage method of data block, read method, its device and block chain | |
| CN102111452A (en) | System for storing vehicle-mounted information by using distributed data storage program and storage method thereof | |
| CN106250501B (en) | Report processing method and reporting system | |
| CN101826077B (en) | Method and device for obtaining relation contact person record | |
| Eunjeong | How cloud computing is revolutionizing the future | |
| CN103139049B (en) | Information interacting method | |
| CN103942213A (en) | Data paging method and device | |
| CN104391947A (en) | Real-time processing method and system of mass GIS (geographic information system) data | |
| CN109558082B (en) | Distributed file system | |
| CN103778231A (en) | Method and system for managing operation record information, of databank | |
| CN101384050A (en) | Mobile terminal, method and system for resource management | |
| CN103490923A (en) | Log file reading and writing method, device and system | |
| CN103714089A (en) | Method and system of rolling back cloud database | |
| JP5490325B2 (en) | Autonomous intelligent content items | |
| CN105243063B (en) | The method and apparatus of information recommendation |
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 | ||
| 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 |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |