| On the basis of studying Data Warehouse theory and OLAP technology, the Adult Education College students'enrollment multidimensional analysis system of North China Electric Power University is designed and developed in this paper. This system takes the affairs data of network recruit students system of the entrance examination for adult college as data source, and constructs the recruitment Data Warehouse according to the analytic subject, which faces analysis and evaluation, after integrating, transferring, clearing and extracting of historic recruitment data. Then multidimensional data models based on the Data Warehouse are constructed in the OLAP server. The Adult Education College students'enrollment multidimensional analysis system based on J2EE is developed by taking Oracle JDeveloper as the development platform. It is achieved that analysis and evaluation of adult college historic recruitment data from different point of view and profile by providing the multidimensional analytic functions of slice, dice, drill down and etc. In the end, the objective is realized, which affords aid decision making for managerial department of recruitment. |
