|
College Training graduates to meet the needs of the community, whether we can achieve successful employment, whether it be able to find work for their professional expertise, comprehensive quality and ability to work with in order to adapt to the needs of the job, is China's colleges and universities generally faced an important issue. Many domestic colleges and universities are using information technology to improve the management level, within the campus have employment information management system, student management information system. These systems, after a long run, which has accumulated a large number of the original data, but can only be carried out by the use of the system management there is no concept of data mining, a simple sort, statistics, save, and collecting data, but hidden in the deeper these data The level of information is not further use. The introduction of data warehouse technology in the the Graduate Employment information management, in-depth analysis of student employment information data to provide decision support school leadership is an urgent issue. Comprehensive Utilization of this article the concept of the data warehouse and OLAP technology, Beijing Polytechnic College employment information management system to accumulate large amounts of raw data analysis from employment-related multiple angles, multiple dimensions, and to promote the employment of university students the law from which explores . Graduate Employment information intelligence analysis system through the Microsoft SQL Server2000 create a data warehouse through data extraction, clean-up, conversion and other operations, and then use the the Analysis Servers OLAP analysis capabilities, rotate, slice, drill-through technology analysis of multidimensional data model, from which found that the law, to promote the employment of university students for the College managers to provide reliable data basis. Around above the contents of this article, the main tasks include: in-depth research data warehouse, to grasp the characteristics of the data warehouse, data warehouse architecture, data warehouse implementation strategy, as well as steps to build the data warehouse; variety of OLAP technology and OLAP implementations method. Mastered the required knowledge, according to the decision-making needs to establish a data warehouse multidimensional data model \end. Through the establishment of the model, wherein the data analysis, using Excel analysis of data, to thereby obtain a pie chart of the analytical data, histograms, curves, etc. In order to more analysis of the image data results.
|