Data Mining Applying And Studying In Student Information Administration System

Data warehouse and data mining are two of the most active branches of database studying,developing and application, and also the key factors of DSS. Data warehouse is a decision supporting, subject-oriented, integrated, stable and time-dependent collection of data; Data mining is to analyze data and acquire knowledge from database and data warehouse using the method of artificial intelligence. The binding of them will provide a strong basis of decision analyzing for enterprises and related departments.Most of the previous teaching management systems are the On-Line Transaction Processing (OLTP) systems that have no ability of synthetic analysis, decision support, and the utilization of hidden knowledge from vast history information. Analysis of teaching management is an important way to teaching evaluation. It is necessary to guarantee the quality of teaching and improve the stuiT of students analyzing the data made in processes of tests and teaching and then supporting the teaching with the results of analysis.In this paper, I introduce the fundamental theory and technologies of data mining based on data warehouse, and research method of classify and cluster in data mining. Combined with the practice in educational administration system, I has improved decision tree algorithm in the classify algorithm, and applied it to CET-4 grade analysis, and besides, I has realized the k-means and k-methods algorithm in the cluster algorithm, and applied it to circs analysis of a graduate of a college. I put emphasis on the design and implementation of data mining system for educational administration data.In the system, I mainly realize the following functions: to construct suitable data warehouse based on decision and analysis requirement about educational administration system, to pretreat data and improve method of conception level, to analyze pretreated data at chart and table, to mine data by improving algorithm, to conclude on effectual results and put its into practice.By applying the method to educational administration system we obtain much valuable knowledge which is helpful for college education.