| With the rapid development of data system, the scale of data will be more and more tremendous, which imperatively need those managers at all levels capable to pick up the useful information from this complex data system within their range of function. At present, the emphases of data processing has been extended OLAP from the traditional operation, and moreover, the information aiming at management and decision-making are obtained as well, which produce the DSS.By the development of DW, the available techniques of DSS centered on DW was appeared. Due to the function in decision support system, the techniques of data warehouse, OLAP and data mining become hot points in present research.For the data warehouse, the paper makes a specific review on the organization and related techniques of it, explores its theoretical difficulties when applied to decision-making system, and furthermore, investigates the key issues involved the design and application method of it. Through various researches, the author puts forward a feasible plan on the application and design of data warehouse, which effectively solves the difficulties in distilling data, especially if those data are huge, separate and complex. After the transform and cleanout, the expected data model will be attained and the data can be loaded.Finally, according to the demand of decision-making, started from the operation analysis, this dissertation applies SQL Server 2000 and Analysis Services 2000 to set up the data warehouse and implement OLAP. Meanwhile, based on Apriori, from large numbers of teaching data, the dissertation also extracts many valuable management regulations through adding a few self-improvements in operation details.Through above discussions, this dissertation reveals the prominent practical value of a sound data warehouse system in improving the efficiency of information management, enhancing the ability of employing data and intensifying the rationality of college decision-making process. |
PDF Full Text Request