Report processing method and device

Abstract

The invention discloses a report processing method and device. The method comprises the steps of obtaining a plurality of batches of to-be-processed reports, and querying a plurality of historical processing durations of each batch of to-be-processed reports; respectively inputting the plurality of historical processing durations of each batch of to-be-processed reports into an exponential weighted moving average model, and outputting an exponential weighted moving average value of each batch of to-be-processed reports; according to the exponential weighted moving average values of the multiple batches of to-be-processed reports, dividing the multiple batches of to-be-processed reports into multiple groups, wherein the difference value between the total prediction processing durations of all the groups of to-be-processed reports is less than a preset threshold value; and processing multiple groups of to-be-processed reports in parallel, and processing multiple batches of to-be-processed reports in each group in series. According to the invention, the accuracy of grouping multiple batches of reports can be improved based on the historical processing duration and the exponential weighted moving average model, so that the processing efficiency of the batches of reports is improved.

Description

Technical field [0001] The present invention relates to the technical field of data processing, in particular to a method and device for processing reports. Background technique [0002] The trading system of financial institutions generates a large number of transaction reports and valuation reports in batches at the end of the day, and downloads these reports to the downstream system for analysis and secondary processing. With the fluctuation of financial market prices, the transaction volume of different financial products There will be large fluctuations in different periods. Because the size of transaction volume and report processing time often show a positive correlation, fluctuations in transaction volume will cause fluctuations in report processing time. The currently commonly used report scheduling tool is TivoliWorkload Scheduler (TWS), Calculate the average processing time of multiple historical batches of reports through TWS, and manually group multiple batches of re...

AI Technical Summary

Problems solved by technology

[0002] The trading system of financial institutions generates a large number of transaction reports and valuation reports in batches at the end of each day, and sends these reports to the downstream system for analysis and secondary processing. With the fluctuation of financial market prices, the transaction volume of different financial products There will be large fluctuations in different periods. Since the size of the transaction volume and the report processing time often show a positive correlation, the fluctuation of the transaction volume will cause the fluctuation of the report processing time. Currently, the commonly used report scheduling tool is TivoliWorkload Scheduler (TWS), Calculate the average processing time of multiple historical batches of reports through TWS, and manually group multiple batches of reports according to the average processing time. Since the average processing time of multiple historical batches of reports does not reflect the volatility of the actual report processing time, As a result, there is a large deviation between the predicted situation and the actual situation, and subsequent manual adjustments are required many times, which is inefficient

[0003] For the above problems, no effective solution has been proposed

Images