Method for acquiring subordinate financial business data and system for acquiring subordinate financial business data

Abstract

The invention discloses a method for acquiring subordinate financial business data and a system for acquiring the subordinate financial business data, which relate to the field of ETL (extraction-transformation-loading) of a data warehouse, and realize automatic acquisition of the subordinate financial business data based on an SOA (service-oriented architecture) and a message-oriented middleware. The method includes the steps of firstly, extracting financial business data needing to be uploaded according to extracting configuration; and then uploading the extracted data to a superior financial business data center by the aid of the message-oriented middleware and utilizing the uploaded extracted data as a basic data source for integrative query. The method provides two data acquiring modes including overall extracting and data extracting in the extracting configuration, and a user can extract changed data in a data sheet without changing an original business data sheet by the acquiring mode of data extracting, so that data extracting efficiency is improved, only data meeting the requirements can be acquired by setting up access conditions, and acquisition and upload of unnecessary data is avoided.

Description

technical field [0001] The present invention relates to the field of ETL (Extraction-Transformation-Loading, data extraction, transformation and loading) of data warehouse technology, in particular to a method for collecting subordinate financial business data between distributed systems based on SOA and message middleware and system. Background technique [0002] In order to support the needs of financial business management, the Ministry of Finance and local financial departments have carried out some statistical analysis work to varying degrees. With the in-depth promotion of the financial business project (government financial management information system, referred to as GFMIS) application support platform, all localities have gradually unified the basic data of financial business, realized the centralized storage and unified management of financial business data, and laid a solid foundation for the automatic collection of financial business data. established a solid f...

AI Technical Summary

Problems solved by technology

However, the existing data collection mainly adopts the method of reporting reports. Since the financial business systems at all levels cannot be directly connected, business data cannot be automatically uploaded level by level (county, city, province, and central government), and manual work is required in the data collection process. There are many intervention links, the collection period is very long, and the timeliness and accuracy of the collected data are difficult to guarantee

In addition, since the business data table cannot realize real incremental upload at the beginning of design, it often adopts the method of uploading all data regularly, only the result without process, and the data is not comparable

Images