Research And Achievement Of Society Insurance Decision Supporting System

Data warehouse is a sort of technology changing collected great deal of data into significative information. Data warehouse performs through multithreading courses, which include gathering data filtrating data and storing data in order to use these data in analyzing and reporting application to support analysis and disposal of decision. The main target of decision support system is to affirm data structure and current to help related decision-maker make better decisions. The continuous development and perfectness of data warehouse related technology as well as online analysis process (OLAP) tools make the development of decision supporting system based on DW possible.Social security is a project relating to the national economy and the people's livelihood. Along with the constant development of social insurance project of our nation, at present it is the most impending demand for social insurance manage and handle organization to effectively derive analyze the mass of historical data, consequently make the right decision. According to the request of Ministry of Labor and Social Security to the gold protects engineering construction of the three classes work and ensure data center, that is, center(Ministry of Labor Security) province(including Autonomous region > municipality directly under the Central Government) and city(prefecture-level city), Dareway Software Corp. Ltd of Shandong Province founded a subject research group of social insurance decision supporting system.Based on the investigation of Social Insurance Decision Supporting System (note as SEDSS)'s developing process, this paper mainly focuses on data warehouse and data mining, namely the implement of Decision Supporting Subsystem (DSS). According to a Jarge amount of reading experiment and the careful analysis of both the data model in data warehouse and data mining techniques, I propose a compromising star type data model structure suitable for the practical application. This model can greatly reduce the access times which facilitate users to get the inquired results quickly and in time when dealing with the tremendous amount of data. Besides, the idea to set up intermediate table to store intermediate result is proposed. This will be implemented in our second-term development. Meanwhile, various compositional representations of data fit the needs of decision-makers to make retrieval statistic and analysis anytime andanywhere.This research and its experiment results-social insurance decision supportingsystem has run as a pilot project, and practice has proved that data warehouse model design and implement we adopted has upstanding performance index, and can process appointed query statistics in stated response time. In the aspect of data representations, it can combine many kinds of showing methods and give users more abundant and intuitive representing ways, so it is prone to understand and explain. Embody in concretely as follows: Design data warehouse framework fit the social insurance industry, which supports user's flexible grain size of definition data. Design flexible and changeable data model and support user's adjusting data model according to the need of monitoring. Combined the characteristic of social insurance industry, support many ETL tools to load data and support manifold decision analyzing tools data mining tools, and also show analyzing result in many modes.The entire system scheme is characterized by: The construct of data warehouse and assistant decision system is considered as a system project; The flexible designing data warehouse structure and data model combined to the characteristics of social insurance industry is suitable for various decision support demand and provides the ability of sustain future decision-making; Applying the current dominant technology to improve the universal and transplant of software; Making the most use of the current dominant data warehouse tools, and decreasing the amount of work of maintenance; Any change of structure can be interfered by users, so make best use of human's intelligence.According to the research on the development and implement of data warehouse-based Social Insurance Decision Support System (SIDSS), this paper indicates that the modeling of data warehouse and the data mining are of great significance to a further investigation of data warehouse as well as its practical application in various domains.