Government financial data acquisition system and method based on data integration

Abstract

The invention belongs to the technical field of data acquisition, and particularly relates to a government financial data acquisition system and method based on data integration. The system comprisesa data source database, a storage database, a data table generation unit and a data table reading unit; the data table generation unit is used for generating a corresponding data acquisition table according to the selected data field; the data acquisition unit is used for acquiring data from a data source database according to a format corresponding to the generated data acquisition table to obtain source data in a corresponding format; and the data table reading unit is used for reading the source data, verifying the source data and then importing the source data into the storage database. The method has the advantages of high intelligent degree, small data error and high data processing efficiency.

Description

technical field [0001] The invention belongs to the technical field of data processing, and in particular relates to a government financial data collection system and a data collection method based on data integration. Background technique [0002] Data integration is the process of sharing or merging data from two or more applications to create a more functional enterprise application. Traditional business applications are strongly object-oriented—that is, they rely on persistent data structures to model business entities and processes. When this happens, the logical way is to integrate through data sharing or merging, while in other cases, data from one application may be restructured to match the data structure of another application, and then written directly into another application. database. [0003] Data acquisition, also known as data acquisition, is to use a device to collect data from outside the system and input it into an interface inside the system. Data acq...

AI Technical Summary

Problems solved by technology

[0006] The existing government financial system includes multiple subsystems, such as the budget system for budget management, the cashier system for financial expenditure management, and other systems. Each system is built on a different server, and the data is independent. When accounting or other data statistics work is required , it is necessary to export the data tables from the related systems, the data commonality is low, and the difficulty of data statistics is increased. Therefore, the government financial data management system is established, and the government financial data management system can automatically enter multiple subsystems to obtain corresponding data and perform data processing. Integration makes the data common and convenient for data statistics. However, some areas do not have an online system, and the government financial data management system cannot automatically log in to obtain data. According to the existing technology, the corresponding data collection form is usually manually produced and sent to Relevant departments fill in the form, and the relevant part returns the form and imports the data into the data management system. However, due to the irregularity of the data filled in the form, for example, for the amount, data formats such as Arabic numerals and uppercase numbers will be filled in, so errors will occur during the data import process. Manual intervention is required, reducing data collection efficiency

Images