Data processing system

Abstract

The invention provides a data processing system used for realizing the data reuse between an analysis report and an acquisition report. The data processing system comprises a dataset unit used for storing data from a data providing unit, the data providing unit connected to a service system which corresponds to the analysis report and a report system which corresponds to the acquisition report and used for acquiring data of the service system and the report system and transmitting the acquired data to the dataset unit, an analysis sheet display unit connected to the dataset unit and used for displaying service data from the dataset unit, a dataset function unit connected to the dataset unit and used for acquiring data from the dataset unit according to the dataset function unit, and an acquisition sheet display unit connected to the dataset function unit and used for displaying data from the dataset function unit. Therefore, the data processing system realizes the data reuse between the analysis report and the acquisition report, and generates significant business management values.

Description

technical field [0001] The invention relates to report application, in particular to a data processing system for realizing data reuse between analysis report and collection report. Background technique [0002] Report applications are usually divided into two categories: analysis reports and collection reports. [0003] Analysis report is a report designed for the purpose of statistical analysis of business system data. The data is extracted from the business system (may come from a single data source, multiple data sources or file system) and becomes one or more metadata descriptions. Two-dimensional data collection (also known as data set), after data processing and transformation, these data sets are placed in a flexible design report format for display, users can analyze and process the data when browsing the report, or The report is output, published or rematerialized into the table structure of the database. Analytical report data usually does not support editing, b...

AI Technical Summary

Problems solved by technology

[0008] (1) There is inconsistency in the access mode between the analysis report and the collection report. The former is usually a database query, and the latter is usually a unit access formula. The two are not compatible enough in terms of data structure and data container;

[0009] (2) There is inconsistency in the data storage model between the analysis report and the collection report. The former is usually not stored, even if it is stored, it is statically created materialized tables (snapshots) based on the data result set. Fully dynamic, and usually stored in reporting system data sources independent of business systems;

[0010] (3) There is inconsistency in the data source of the analysis report and the collection report to achieve data reuse. The former usually comes from the business system or data warehouse, and the latter usually comes from the report system;

[0011] (4) It is difficult to display the analysis data of the dynamic row and column structure in the relatively fixed format area of ​​the collection report;

Images