Research And Application Of Data Warehouse And Data Mining In The System Of Provident Fund

With the establishing and utilizing of the provident fund management system, lots of data and information about the provident fund have been accumulated during the daily operation. But these data cannot be used directly for decision. The provident fund management organization is urged to establish the provident fund decision support system (DSS) on the basis of the Data Warehouse. 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 provident fund 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 shanghai provident fund 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, as a good case in point, some ideas of designing and implementing data warehouse mentioned in this thesis have been applied in Provident fund Analyzing System project successfully, which is useful for constructing the data warehouse and DSS used in the area of Provident fund in the future.