Application Research Of Patawarehouse Technology In Forecasting Of Social Insurance Fund Income And Expenses

With the establishing and utilizing of the social security management system,lots of data and information about the social security have been accumulated during the daily operation.But these data cannot be used directly for hospitalization insurance decision.The social security management organization is urged to establish the social security decision support system(DSS)on the basis of the Data Warehouse.This system is used to support the making and modification of the social security policies and the effective management of social security.So,our country made out an engineering of The Social Security Management System,which needs to construct social security decision support system.This thesis makes researches about how to realize it through data warehouse's application and research.Data warehouse has become one hot research field in current Information Technology field.The traditional database is the main information source of data warehouse system.Through the technology of On-Line Analytical Processing,Data Mining and so on,data warehouse can analyse a great deal of data and information and transform data into information.The results of analysis can support the governors' decisions.This thesis has a background of the development of china's social insurance system and current advances in the research of decision support system,data warehouse and data mining.Combined with the structure,function,background and environment of Shaanxi social insurance system,this thesis gives a detailed description on the data design and development process applied in this system.At last it is the expectation of system.Regarding the data warehouse design,it starts from the design of conceptual model.Firstly,the system requirements must be analyzed thus the subjects of the data warehouse can be determined,in which the star schema is used for the modeling work.Next,the logic model design is carried out.In this process,the logic model should be further developed and improved,that is,the structure of dimension tables and fact tables for each subject will be determined.Finally,the physical model design is performed,in which the data storage and index strategy are considered according to the actual hardware conditions.This thesis discusses data warehouse and the relation between data warehouse and DSS.Combined Data warehouse with the social security management system,This thesis analyzes the development of our country's social security and DSS,discusses the architecture and the general developing method of the data warehouse-based DSS.Besides,it introduces the relative technology such as data warehouse technology,OLAP,data mining etc.Finally,as a good case in point,some ideas of designing and implementing data warehouse mentioned in this thesis have been applied in Social Insurance Analyzing System project successfully,which is useful for constructing the data warehouse and DSS used in the area of social security in the future.