Data Mining System Based College Preference Chosen Online Consulting System Design And Implementation

The entrance examination is the abbreviation of the college entrance examination, it is one of the country’s major national examinations, it is the bridge for Chinese to enter university, and it is an important focus of the community. The entrance examination contains two process, they are college entrance exam and college preference chosen. The data mining system based college preference chosen online consulting system is acting on the college preference chosen.College preference chosen, it is the student according to their score, ambition, hobbies, and other factors to chose the colleges and professional. It related to whether the student can be admitted and whether admission to the satisfaction of the college and professional, it is a complex process, needs to consider the student’s examination results, the institutional situation, family situation and other factors. Students and parents attached great importance to college preference chosen, and often spend a lot of energy but can’t accurately grasp the pulse. So, a full enrollment data analysis supported college preference chosen online consulting system, can help the students and their parents to make appropriate analysis, and can solve problems for students and parents.Data mining system based college preference chosen online consulting system (hereinafter referred to as the chosen consulting system), it is designed to help student to analysis the objective laws and factors of college preference chosen, it can give students accurate consulting, reduce the variables in the college preference chosen.Chosen consulting system uses Java EE and the SQL Server2008as system, it is base on SSH development framework. The characteristics of the chosen consulting system is based on admission data mining system platform of a province, it can be multi-angle, multi-level reporting mining guidance able to provide more accurate guidance.Throughout the project construction is divided into two stages, the admission data mining system building and the data mining system based college preference chosen online consulting system. This article will be described about the participation by author, as summarized below:(1)Design and Implementation the Chosen Consulting System:The chosen consulting system based on the data mining system, it has used Java EE and SQL Server2008as platform, has used SSH framework、data cache and WEB services to meet the high concurrency and scalability. The system can meet the high-concurrency, stability and scalability; can effectively provide a scientific and practical voluntary reporting guidance for students and parents.(2)The Data Mining System Building:data mining system in accordance with the implementation process points, mainly the following aspects.1.ETL:Data warehouse completed before, we improve it and use SQL Server integration service which based on SQL Server2008to clean data, transformation and load data, we have imported10years of history data, and formed a SSIS project package provides support for the subsequent ETL2, Build Cube:Above the data warehouse, we use SQL Server analysis service; we build cubes for different themes, including one global multi-dimensional data sets (including all dimensions) and considerable sub-multi-dimensional data sets. Provide data to support the establishment of the cube for OLAP and reporting.3, OLAP and Reports:We have completed OLAP analysis and reports which based on SQL Server reporting services and SQL Server analysis services, we use different dimension to analysis different theme, contain volunteering, college taking and so on, finally, we use WEB to show result.4, Data Mining:Data mining based on SQL Server analysis services, it use different algorithms such as association rules, decision trees, neural networks for the different themes applications, it can be used through web and windows form.