The Design And Realization Of National Treasury Statistical Analysis Database System

Main proposition an analysis, design based on National Treasury Statistical Analysis Database system of B/S model of three layers, realizing the scheme of the course of this article, explains the difficult point detail of some technology.Analyzed a current national treasury statistics analysis system to statistics the existent shortage of the business aspect in the national treasury first, gave design target and mission of topic. Then, carried on collections and analysis to the system requirements, the concept elaborated a national treasury covariance.Secondly, the design of the system structure introducing a national treasury statistics analyze database system, On the basis of analyzing the features of B/S and C/S software architecture model, The thesis proposes adopts the B/S model to implement teaching management system in the based on .NET technology.In this paper, we have applied the conception of data warehouse and OLAP in the National Treasury Statistical Analysis Database system system, separated the operation data and the analyzed data thoroughly, and made the system more intelligently.In this paper, the invention and development of OLAP and Data Warehouse are explained at length. The constructional solution of Data warehouse is also introduced in this paper, which is different from that the OLTP. A Data Warehouse instance of important business enterprise of taxpayer OLAP cube is designed, in which the multidimensional query and multidimensional analysis are introduced mainly. On the basis of the national treasury income data of Suzhou,We use the usual statistics and me technology,study the correlativity between the national treasury income and economic growth. We built up the national treasury income forecasting model in linear regression algorithm.Finally,Carried on summary to the development of system, and put forward an outlook.