Design And Implementation Of Data Distribution System Of Data Warehouse Platform For Provincial Rural Credit Cooperatives

With the continuous development of the change of the market and technology, therequirements for enterprise-level data warehouse platform are constantly improved. In thispaper, the effective management and sharing of data in the two levels of province and thecounty are carried out, based on the issues of how to extend and innovate provincial RuralCredit Cooperatives data warehouse system in the changes of the internal and externaldemand, how to meet the requirements of the construction of data platform in the two levelsof province and the county to solve the differences in technology orientation, serviceorientation and management localization of the the rural credit cooperatives in the two levelsof province and the county.In this paper, the construction of data distribution system in the two levels of provinceand the county is built from scratch, on the basis of the provincial rural credit cooperativesexisting data warehouse system. According to the actual demand, the system constructionscheme is presented, the system is designed, and a series of the whole process of systemconstruction are realized.The key points of the data county distribution system in the two levels of province andthe county includes the business level and the technical level. The operational level lies in thesplit rule. The split rule and the county cooperative discussed the demand in detail, thendevelop business models and constraints for the split rule, which can not only meet thedemand of data service of county cooperative, but also ensure the balance of data pressureand data security among the whole province. The technical level mainly lies in the separationimplementation and the file transmission, in which the performance pressure of the systemand the safety and consistency in the process of transmission need to be taken into account.After the design of the key points, the overall system design is started, includingstructure, function, database, interface and so on. And then depending on the existing architecture of the provincial cooperative data warehouse, combining with the API offered byvariety of products, scripting and the C language development are carried out to realizesystem ground in the two levels of province and the county.Finally, in the completion of the system, verification and testing, data sharing in the twolevels of province and the county is realized,based on which, the future data management inthe two levels of province and the county is prospected.