Design And Realization Of Warehouse On GFMIS

Government Fiscal Management Information System (GFMIS) is also called Golden Fiscal Project in China. Before it was put forward, with the government internet project's guidance, some fiscal department developed consciously several finance operation application systems, accordingly strengthened effectively the management of fiscal department to fund, and accumulated a lot of precious finance data. After it was put forward, the existing production can only satisfy the daily operation transact of each finance operation application system, it isn't implement the data integration among every system, fiscal department don't integrate all system's data for analysis, so it is necessary to build the data warehouse architecture, and to make use of the fiscal data accumulated by each system to data mine and analysis, and to forecast the macroscopical and microcosmic economic position.Firstly, the situation of GFMIS in china and the analysis of data warehouse technology being used in GFMIS are introduced. Secondly, an example of designing data warehouse structure, which is based on the budget outside no-tax income straight pay system that one of the applications of GFMIS, to a data warehouse and realizing the OLAP is carried out. It choose no-tax income as subject to implement the design of data warehouse, a whole development process, including designing a data warehouse, Extracting, Transforming and Loading the data from OLTP database to data warehouse, and displaying the analyzed result, is also explained , and data transform is carried out by program by hand and DTS data package. Design the data warehouse query system of budget outside no-tax income straight pay system that supports the struts frame, now this system has got the actual application in finance bureau of harbin city, promoting information-based construction of the finance administration section. I wish this thesis could provide some assistance in building the data warehouse architecture for GFMIS.