Open platform and system for processing reports and report processing method

Abstract

The embodiment of the invention discloses an open platform and a system for processing reports and a report processing method. The open platform for processing the reports is accessed into an in-memory database to serve as a data source of an on-line report, so that the data of the in-memory database can be synchronized, visited and statistically processed, real-time of the data is ensured and meanwhile processing and generating efficiencies of the reports are greatly improved, the use ratio of computer resources is optimized, meanwhile consistency of the in-memory database and mainframe source data is maintained by a data synchronization module, the data of the in-memory database can be visited and processed by a report analysis engine, I / O operation when in data synchronization and processing is reduced, real-time and higher operation parallelism of the data are ensured, and performance of the whole system is improved.

Description

technical field [0001] The invention relates to the field of communication technology, in particular to an open platform for report processing, a system and a report processing method. Background technique [0002] With the rapid development of information technology, informatization has become an important path for the development of banks, and reports are a powerful means for bank data sorting, formatting and data presentation. Business personnel and management personnel can learn about all aspects of the bank's current transaction information and various statuses of the bank in real time through online reports. Online reports can realize online data query statistics and multi-dimensional analysis, which helps banks gain insight into the latest current operating conditions and make decisions quickly. [0003] At the heart of online reporting is real-time data. The quality of real-time data processing determines the quality of online reports and user experience. On the o...

AI Technical Summary

Problems solved by technology

[0005] Because the mainframe platform in the prior art does not have powerful scientific data computing capabilities, it is difficult to efficiently complete data calculation, statistics, judgment, and analysis, so the mainframe platform is not suitable for generating complex online reports, such as real-time trial balance sheets

At the same time, with the expansion of banking business, the increase in data volume, the increase in the number of concurrent users, and the increasing number of statistical analysis operations have had a great impact on the performance of the mainframe platform database that is mainly responsible for production transactions. Bank transactions Data is massive, and online reports involve large-scale data access. For traditional disk databases, frequent access to disks is required for data operations, which greatly reduces system performance and the efficiency of generating online reports.

For example, an ordinary Year To Date (YTD) report involves data operations on the order of GB. What's more, when multiple users generate online reports concurrently, the concurrent database load is very high, often reaching tens of thousands of reads and writes per second. Traditional databases are unbearable, and the bottleneck of the request report generation system is concentrated on the disk database, which will increase the time for online report generation and bring extremely poor user experience

Images