【作者】 孙刚；

【导师】 车喜龙；

【作者基本信息】 吉林大学 ， 软件工程（专业学位）， 2015， 硕士

【摘要】 随着市场的变化与技术的不断发展，对企业级数据仓库平台的要求也在不断提高。论文主要基于省级农村信用社数据仓库系统在当前内外部需求变化中如何扩展与创新的问题，研究为满足省县两级数据平台的建设要求如何进行数据分发的问题，以解决省县两级信用社在科技定位、服务定位、管理定位上的差异，实现省县两级在数据上的有效管理和共享。本文主要研究了在省级农信社已有的数据仓库系统基础之上，从无到有的搭建省县两级数据分发体系，结合实际需求，提出系统建设方案，进行系统设计，并落地实现系统建设的一系列全过程。省县两级数据分发系统的关键点包含业务层面与技术层面。业务层面主要在于业务数据的拆分规则，拆分规则与县级联社详细讨论需求，共同制定数据拆分的业务模式与限制条件，既能满足县级联社的数据业务需求，又能保证在全省范围内的数据压力与数据安全的平衡。技术层面则组要在于拆分实现和文件传输需要考虑系统性能压力，传输过程中的安全性与一致性。在关键点设计之后，则开始整体的系统设计，包括架构、功能、数据库、交互界面等，下一步则依赖省级联社数据仓库已有架构，结合各种产品所提供的API，编写脚本和进行C语言开发，来实现省县两级的系统落地。最终，在完成对系统验证和测试后，实现了省县两级的数据共享，并以此为基础展望未来省县两级的数据管理。更多还原

【Abstract】 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.更多还原