The Research On The Application Of Data Mining To The Department Budget

Enterprise annuity as a supplementary for pension system, its influence for the social security system is growing. The World Bank predicted by the end of2030, China’s enterprise annuity overall scale will increase to1.8trillion dollars, and then China will become the world’s third largest enterprise annuity market. As China’s enterprise annuity system of continuous improvement, the amount of business data increase, the government supervision department’s various business data query bring a great pressure for enterprise annuity database, People would prefer to have a multi-level, multi-angle, fast data query to be performed in order to support decision analysis of integrated and unified data environment. However, the traditional online transaction processing (OLTP) system is an OLTP technology, which can support the deletion or omission of some data and a simple query, based on the limitations, for the scientific decision to create a good data warehouse technology solutions ideas, technologies and products arises at the historic moment.This article first introduces the development history and application status of data warehouse, and reviewed the related theory of the enterprise annuity and data warehouse, and then based on the analysis of enterprise annuity demand and feasibility on the basis of data warehouse, completes the enterprise annuity of data warehouse design and modeling, obtained the management business customers and personnel statistics, the management business pay cost statistics, the management business statistics analysis sheet. Based on the OLAP analysis operation of three table, we can get enterprise annuity plan type, industry under the condition of the customer number, the number of participating in the project and customer pay cost, time, region combination query; we can also classification inquires the management of assets from personnel scale, enterprise asset scale, the scale of plan assets classification etc. Application of data warehouse technology could make full use of the existing historical data, improve the science and efficiency of the decision, making information analysis and decision support system based on time function is increased greatly, which has important practical significance for enterprise annuity supervision department.