The Research On The Data Warehouse Of The Macro-decision System Of The Social Security

With the continuous development of database technology and database management system for a wide range of applications, databases and the amount of data is the sharp increase in the size, it is no longer satisfied with the business of loading and simple data query, reporting, but also hope for the growing accumulation of Massive changes in the business data and information to analyze the environment, so that information can not only reflect the current changes in the business, it better reflects the development trend of data warehouse technology came into being and developed rapidly in the telecommunications, mobile and a variety of business fields Widely used.This text mainly introduced in the field of social security for the data warehouse decision support system analysis, design and realization of the process. Business for Social Security data characteristics, with emphasis on data extraction, storage and management and front-end Data Presentation three areas were studied.The current system is more popular B / S / S structure, the background to ORACLE data warehouse technology and metadata management technology to determine the theme of the domain model, the establishment of the dimension table and a fact sheet, ETL development for the realization of business data collected , Conversion and loading. The use of data mining techniques to identify potential social security business association rules, the more popular of the current use of risk prediction models and models of social security make situation and development trend of substantial forecast. DTS to carry out from time to time with automatic scheduling and data conversion, data storage components used SQL2000 the establishment of multi-dimensional data sets and OLAP analysis. Front-end data to show J2EE technology framework for multi-level design and design competence, at the same time embedded in Microsoft DOT NET technology for data and statements showing the development, the realization of any of the data slice, spin, drill, and other on-line analytical processing functions.In this paper, the results of research have been applied to the -NO.1 project of construction of social security information system in Chongqing city--apply exploitation and put project into practice of labor security general management business system and macroscopic decision making system, From the user's actual results, reflect the general good, high utilization rate system, indicating the results of this study is feasible and practical to meet the actual needs of business.