# Intervention Algorithm of Horse Racing for Students’ Psychological Disorders Based on Big Data

Authors: Meng Qin; Quanan Gui
Journal: Mobile Information Systems
 (2022)

---

## Abstract

Horse racing is a competitive activity in which humans control horses. It is a worldwide traditional sports activity. In the history of human-horse racing, horse racing activities in various eras have been followed but also constantly innovated. According to the K-means clustering algorithm, a cluster analysis model is constructed for the model, and the algorithm model is applied to the students’ mental health counseling work. After six iterations to get the classification and six iterations of the cluster center algorithm, it was found that the mixed psychological population accounted for 50%. Horse racing can not only effectively relieve students’ psychological problems and exercise students’ willpower and thinking ability, but also promote traditional sports. Through K-means clustering algorithm research, frame design, and program design, a complete psychological disorder intervention system is established, which provides scientific, objective, and reliable data guarantee for the correct implementation of decision-making strategies. Integrating cluster analysis into the process of students’ mental health analysis makes it easier for decision-makers to understand and master all aspects of students’ information, to analyze and customize solutions for different types of students. It provides a good foundation for providing different psychotherapeutic methods for different groups of students.


---

## Body

## 1. Introduction

In today’s society, increasingly serious psychological problems have become one of the important research directions of psychology and pedagogy. Students are at the most important stage of their lives and can have high cultural knowledge and wonderful life experiences. In the face of social pressure and difficulties in life and employment, there are often psychological problems such as inferiority complex, autism, extreme, withdrawal, and depression. The establishment of horse racing courses in school sports can not only promote the physical and mental development of primary school students but also exercise and cultivate their willpower and thinking independence. Therefore, it is an inevitable trend to use data mining techniques to analyze the mental health data of college students and obtain corresponding solutions to problems.How to improve students’ mental health levels, solve students’ mental health problems, and ensure that students can move toward a modern and healthy future is a problem that colleges and mental health workers are constantly exploring. In recent years, students’ mental health problems have been a concern by society, and scholars at home and abroad have also continued to do in-depth research on students’ mental health problems. At present, the psychological intervention model of college students has become the focus of many researches. Speeding up the development of sports horse racing can not only promote the development of traditional sports but also have a positive effect on the cultivation of students’ good psychological quality.These data have different mental health problems generated by different students, collect these stubborn mental health problems with the same background and common background among these students, and conduct a comprehensive analysis of these problems with “characteristics,” which can effectively prevent the occurrence of similar students’ mental health problems. In order to improve and optimize decision-making and improve the efficiency of college students’ psychological counseling, it is necessary to analyze the information timely and accurately. The purpose of cluster analysis is to maximize the homogeneity of each inter-class element and the heterogeneity of the inter-class elements in big data. As a non-intervention mode technology, cluster analysis has a good application market in the field of data mining, transforming complex and hidden data into actual decision-making activities, and providing a more scientific reference. Through the test of experimental data, data mining technology can be used to analyze the mental health of students.


## 2. Related Work

With the development of society and economy, people’s life pressure is increasing, and mental health problems have also received special attention. Klein captures the audience’s attention with the trendy adage that the term “big data” is applied to situations where analysts, managers, and continuous improvement teams need large amounts of data to support decision-making. In terms of quality, it is a format for decision makers to provide high-quality data [1]. Knipe et al. investigates the prevalence of mental disorders among health science students and investigates help-seeking behavior. This results that 1/4 of the students reported moderate/severe depressive symptoms and 27% reported moderate/severe anxiety symptoms. Only 21% of students with severe depressive symptoms sought professional help. The main reason for not seeking help is fear of documentation about academic records. The study highlights the magnitude of mental health problems faced by health science students [2]. Reyes et al. aimed to improve upon a previously developed non-stigmatizing smartphone app intervention for college veterans with post-traumatic stress disorder (PTSD) based on principles of acceptance and commitment therapy. The acceptability of developing prototypes was tested for this using a mixed methods research design. The results showed that this intervention was highly acceptable. Based on the results, the intervention was revised for prospective feasibility and efficacy testing [3]. Galván-Molina and Me Jiménez-Capdeville used an electronic self-report survey to screen medical students for psychopathology and related factors. He collected 323 student surveys of first-, third-, and sixth-year medical students. The three more prevalent disorders were depression (24%), attention deficit disorder with hyperactivity disorder (28%), and anxiety disorders (13%), with a prevalence of high-level burnout syndrome at 13%. In addition, Part V students use harmful tobacco and alcohol. He concluded that 60% of medical students may suffer from one or more diseases or burnout [4]. Evidence-based risk screening procedures should accurately include students who are candidates for group therapy and exclude students who do not require therapy or other forms of intervention and support for better services. Grassetti et al. described and evaluated the sequence of steps used to screen 7th and 8th-grade students (N = 89) who were referred by school staff for youth group trauma and grief component therapy. Results showed that group screening helped identify mental health needs, and individual interviews further identified students with PTS and emotional problems. Behavioral problems and trauma exposure predicted attrition among students eligible for treatment. MG progressively predicted students moving from group screening to individual interviews, while trauma exposure progressively predicted attrition from treatment. The findings have implications for improving research and practice, including strengthening procedures for school-based referral, screening, assessment, and selection procedures [5]. Kuang et al. proposed a unified tensor model to represent unstructured, semi-structured, and structured data. He uses the tensor expansion operator to represent various types of data as sub-tensors, which are then combined into a unified tensor. He analyzed the time complexity, memory usage, and approximation accuracy of the proposed method [6]. Zhang et al. proposed a cyber-physical system for patient-centric healthcare applications and services based on cloud and big data analytics technology, called Health-CPS. The system consists of a unified standard data acquisition layer, a data management layer for distributed storage and parallel computing, and a data-oriented service layer [7]. In today’s era of real-time remote sensing, big data is much more than it first appears, efficiently extracting useful information presents systems with significant computational challenges, such as analysis, aggregation, and storage, where data is collected remotely. Considering the factors, it is necessary to design a system architecture that supports both real-time and offline data processing. Therefore, Rathore et al. proposed a real-time big data analysis architecture for remote sensing satellite applications [8]. Xing et al. discussed the group work mode of smart grid operation from the perspective of management mode. This model breaks through the geographical restrictions of energy flow and data flow, enabling advanced big data analysis. For certain large zoning systems with multiple connected utilities, each site operates in group work mode and can only use its own measured/simulated data to calculate the zonal MSR [9]. These studies are instructive to a certain extent, but there are cases where the demonstration is insufficient or not accurate enough, which can be further improved.


## 3. Methods of Data Mining

Most schools have their own student management system, educational administration system, etc. When the system collects student data, it only achieves the data storage function, and these data are not used effectively. With the increase of time, a large amount of “garbage” data has accumulated, and there is a lot of utilization value in this data. Similarly, the mental health data of college students also need to be analyzed by data mining. Before mining and analysis, it is necessary to preprocess the data to unify the data format, so that the system can analyze the data effectively. There are many methods of data mining, such as association analysis, cluster analysis, classification, prediction and deviation analysis, and other algorithms. Association analysis, predicting other things through one thing that is related to each other, to point out the relationship hidden in the data. The relationship between cluster analysis data is described by the distance of eigenvectors between individuals. Cluster analysis is an important part of unsupervised learning methods. Classification and predictive classification is to find a conceptual description of a category, analyze a set of objects in the database, and find common attributes from the objects. Most problems are generally difficult to model, and historical data can be used for data modeling. Deviation analysis is used to review data and find data that deviates from the norm. Cluster analysis can be applied in many fields. Cluster analysis can either be used as a data mining model to analyze data, or it can be an integral part of other algorithms [10]. In the analysis of students’ mental health, it is often necessary to analyze the unique psychological factors of college students, and it is necessary to have higher requirements for clustering algorithms.According to the established data model, the machine learning method is combined with common prediction methods such as the nearest neighbor method, naive Bayes, etc., and mathematical methods are used in large-scale databases to find an effective data mining method. Generally speaking, a large number of problems that rely on people to analyze and calculate data through experience can now be handed over to computers to generate conclusions quickly and efficiently by methods such as data mining. Driven by strong commercial interests, merchants began to use data mining technology to analyze historical promotion data and predict the customers with the largest return on investment [11]. In addition, the use of data mining technology can obtain useful information and knowledge methods, so as to find potential great benefits.


### 3.1. Cluster Analysis Algorithm

The clustering algorithm is an important branch in Machine Learning, generally using unsupervised learning [12]. Using a cluster analysis algorithm, the data in the database can be divided into several categories. The distance between individuals in the same category is small, so the similarity of objects in the cluster is high; while the distance between individuals in different categories is large and has great differences.The clustering model can be described as follows: divide then data objects in the m-dimensional space Rm, and assign the vector with the smallest distance from the cluster center to the corresponding K-means cluster. In cluster analysis, b is the number of attributes of the clustered samples, n is the number of samples, and Rm is the number of classifications preset by the user. The mathematical model is as follows: Definition—for vectors Ia, Ib in m-dimensional space Rm. There are Ia=Ia1,Ia2,Ia3,⋯Iam, Ib=Ia1,Ia2,Ia3,⋯Iam, if the distance between the vectors is dIa,We: For the cluster center, if it satisfies dIa,We=mindIa,Wb,b=1,2,…,k, then Ia=Wc. The basic idea of combining statistical methods and data mining algorithms is to combine some existing effective statistical methods with data mining algorithms to generate some efficient statistical methods and increase the efficiency of cluster analysis. The cluster analysis algorithm divides the data set into k classes, and the value of k can be specified by the user. In order to achieve the best results, the clustering performance index is minimized and assigned to adjacent classes according to the minimum distance. It is quantified by the following distance methods: (1) Similarity coefficient: It is represented by a number between 0 and 1. If the samples are similar, the value is close to 1, otherwise, it is close to 0. (2) Distance function: Let Ω be the set of sample points, the distance function will satisfy the following formulas: positive definiteness D(a, b), symmetry D (a, b) = D (b, a), triangular inequality Da,b+Db,a≥Da,corDa,b≤maxDa,c,Dc,b. In the clustering method, the frequently used quantification methods are as follows:Absolute distance:(1)DI,J=∑a=1bIa−Ja.Euclidean distance:(2)DI,J=∑a=1bIa−Ja21/2.Chebyshev distance:(3)DI,J=∑a=1bIa−Ja81/8.


### 3.2. Criterion Function

The criterion function [13] is obtained by summing the squared error values of each cluster in the dataset. Calculate the squared error value for each cluster in the dataset and add them up, but it is difficult to handle datasets with uneven density. Therefore, the clustering function refers to the criterion for evaluating the strategy adopted by the system with a specific function [14]. When the final result of the clustering algorithm satisfies the criterion function, the algorithm ends. The clustering algorithm is the decision criterion of the specific function evaluation system. In order to improve the accuracy of the clustering algorithm, it is necessary to select an appropriate criterion function. Commonly used criterion functions are as follows:(1)
Error sum of squares criterion functionAssuming a mixed sample setA=a1,a2,a3,⋯an, based on a certain association, the sample set is clustered into C separate subsets a1,a2,a3,⋯,an, each of which is a type and contains n1,n2,n3,⋯,nc, samples respectively. The samples are separated into subsets by some association with the mixed sample sets. In order to measure the instructions of the clustering algorithm, the error sum of squares criterion function is used. The definition Formula is as follows:(4)Jk=∑b=1k∑c=1nicb−mb2,mb=1nj∑b=1nibb=1,2,…,c.In the Formula,mb represents the mean of the samples in the bth class, and nb represents the number of samples in the bth class. According to the definition of the criterion function, it is not difficult to find its value k cluster centers and the samples in each cluster. The larger the value of jk, the larger the error of the clustering, and the lower the quality of the clustering algorithm. On the contrary, if the value of jk is smaller, the algorithm has a good clustering effect. The limitation of the error sum of squares criterion function is that it must use relatively dense samples with small differences in the number of samples [15]. When there is a large difference in the number of samples, the error sum of squares criterion function is used to discriminate the samples, which effectively separates each clustering type.(2)
Weighted average squared distance and criterion(5)YX=∑b=1KPbSb∗,S∗=2nbnb−1∑i=ia∑i=ibx−x′2,whereAA is the average squared distance between samples between classes. In order to deal with the large gap in sample data, the weighted average squared distance and the criterion function can be used to get the correct clustering results.(3)
Inter-class distance and criteria(6)Yj=∑b=1Kmb−mmb−m.In the Formula,mb is the sample mean vector of type wb, and m is the mean vector of all samples. The larger the value of the inter-class distance and the criterion function, the higher the separation and clustering quality of the clustering results.


### 3.3. K-Means Clustering Algorithm

The k-means algorithm, also known ask- or k-means, is a classic aggregation technique used for many tasks [16]. It is the distance of the data point to the prototype as the objective function of optimization. The algorithm performs a rotation function by finding the limit of a function, dividing the dataset into different parts such that the evaluation point J is the smallest and the resulting classes are about the same distance. Indicates the dataset grouping method as follows:(1)
Select a certain distance as the metric between samples: The search process of k-means clustering algorithm is limited to a part of all possible partition spaces [17]. If the sample similarity between each class is very low, the k-means algorithm can often achieve better results. However, if the sample similarity between classes is high, then further division of clusters may occur. Therefore, it is possible to obtain a local rather than a global minimum solution of the scoring function due to the convergence of the algorithm.(2)
Selection criterion functionThe k-means clustering algorithm is affected by the selected similarity measurement method, and the commonly used similarity measurement method uses the error sum of squares criterion function to improve the clustering performance. Assuming that I contains C cluster subsetsI1, I2,…, Ic; the number of samples in each cluster subset is n1, n2, …, nc; the mean points of each cluster subset are m1, m2, …, mc respectively, then the Formula of the error sum of squares criterion function is:(7)E∗=∑a=1c∑p∈ap−ma2.①The calculation of similarity is carried out according to the average value of objects in a cluster [15]. ② Randomly assign K cluster centers ③ For each sample Ia, assign it to the nearest neighbor class according to the principle of minimum distance. ④ Move the sample mean in the cluster to the cluster center. ⑤ Repeat the second step and the third step until the center of the cluster does not change. The data object set S is shown in Table 1. As a two-dimensional sample for cluster analysis, the required number of clusters k = 2.ChooseO10,2, O20,0 as the initial cluster center, namely M1=O10,2=,=M2=O20,0 According to the distance between the remaining objects and each central cluster, they are classified as the nearest cluster, for O3:(8)dM1,O1=0−1.52+2−02=2.5,dM2,O3=0−1.52+0−02=1.5.ObviouslydM2,O2≤dM1,O3, so give O3 to C2. For O5:(9)dM2,O3=0−1.52+0−0=1.5.ObviouslydM2,O2≤M1,O3, so give O5 to C1 to update, get new clusters C1=O1,O5 and C2=O2,O3,O4, calculate the squared error criterion, the single variance is:(10)E1=0−02+2−22+0−52+2−22=25,M1=O1=0,2E2=27.25M2=O2=0,0.The population mean variance is:E=E1+E2=25+27.25=52.25(3)
Calculate the center of the new cluster.(11)M1=0+52,2+22=2.5,2,M2=0+1.5+53,0+0+03=2.17,0.Repeat the steps of selecting functions and calculating new clusters to getO1 to C1; O2 to C2, O3 to C2, O4 to C2, and O5 to C1. Update, get new clusters C1=O1,O5 and C2=O2,O4, the center is M1=2.5,2, M2=2.17,0. The individual variances are,(12)E1=0−2.52+2−22+2.5−52+2−22=12.5E2=13.15.The overall mean error is:E=E1+E2=12.5+13.15=25.65Table 1
Student-related system table.
Field nameNotesTypeLengthIs it allowed to be emptyIdStudent IDString20NoStudent-nameStudent nameString20NoClass-idClass numberString20NoBirthdayDate of birthDateNoSexGenderString3NoDormitory-idDormitory numberString20NoContactContact informationString35NoParents-contactParent contact detailsString35NoHome-addressHome addressString100NoStudent-idStudent numberString20NoEvaluator-idAssessor numberEnum20NoMental-health degreeMental healthStringNoEvaluator-detailAssessment detailsStringAutoNoClass-adciser-idNumberingString20NoNameNameenum20NoSexGenderString3NoContactContact informationString20NoSdeptDepartmentString30NoAfter the first correlation, the mean error has improved significantly. Since the cluster centers of the two exchanges have not changed, the negotiation process ends and the algorithm stops. The K-means algorithm is used to measure a certain point in the sample. When facing the clustering problem, the algorithm is more efficient to complete the task. Even in the face of large datasets, the algorithm has high scalability and high efficiency. Since its complexity isOnkt. where n is the number of all objects, the value of k is user-specified, and t is the number of iterations, usually k〈n and t〈n.The clustering results show that when the k-means clustering algorithm is used, the difference between clusters is obvious, and the clustering effect is better [18]. The main disadvantage is that the K-Means algorithm often leads to completely different results by setting different k values. Algorithms can be used to analyze the distribution of the data, such as centers, hierarchical clustering, and density, and then choose an appropriate value of k until the cluster center tends to be stable.According to the performance analysis of the above algorithm, it can be seen that the core problem of using the K-means algorithm for clustering lies in the selection ofk value. But in the process of evaluating students’ mental health, there are a lot of information management systems, such as mental health evaluation system, psychological quality evaluation system, and so on. At the same time, every college has full-time counselors working on the front line of student management for a long time, which provides a valuable theoretical basis for the selection of K-worth.


## 3.1. Cluster Analysis Algorithm

The clustering algorithm is an important branch in Machine Learning, generally using unsupervised learning [12]. Using a cluster analysis algorithm, the data in the database can be divided into several categories. The distance between individuals in the same category is small, so the similarity of objects in the cluster is high; while the distance between individuals in different categories is large and has great differences.The clustering model can be described as follows: divide then data objects in the m-dimensional space Rm, and assign the vector with the smallest distance from the cluster center to the corresponding K-means cluster. In cluster analysis, b is the number of attributes of the clustered samples, n is the number of samples, and Rm is the number of classifications preset by the user. The mathematical model is as follows: Definition—for vectors Ia, Ib in m-dimensional space Rm. There are Ia=Ia1,Ia2,Ia3,⋯Iam, Ib=Ia1,Ia2,Ia3,⋯Iam, if the distance between the vectors is dIa,We: For the cluster center, if it satisfies dIa,We=mindIa,Wb,b=1,2,…,k, then Ia=Wc. The basic idea of combining statistical methods and data mining algorithms is to combine some existing effective statistical methods with data mining algorithms to generate some efficient statistical methods and increase the efficiency of cluster analysis. The cluster analysis algorithm divides the data set into k classes, and the value of k can be specified by the user. In order to achieve the best results, the clustering performance index is minimized and assigned to adjacent classes according to the minimum distance. It is quantified by the following distance methods: (1) Similarity coefficient: It is represented by a number between 0 and 1. If the samples are similar, the value is close to 1, otherwise, it is close to 0. (2) Distance function: Let Ω be the set of sample points, the distance function will satisfy the following formulas: positive definiteness D(a, b), symmetry D (a, b) = D (b, a), triangular inequality Da,b+Db,a≥Da,corDa,b≤maxDa,c,Dc,b. In the clustering method, the frequently used quantification methods are as follows:Absolute distance:(1)DI,J=∑a=1bIa−Ja.Euclidean distance:(2)DI,J=∑a=1bIa−Ja21/2.Chebyshev distance:(3)DI,J=∑a=1bIa−Ja81/8.


## 3.2. Criterion Function

The criterion function [13] is obtained by summing the squared error values of each cluster in the dataset. Calculate the squared error value for each cluster in the dataset and add them up, but it is difficult to handle datasets with uneven density. Therefore, the clustering function refers to the criterion for evaluating the strategy adopted by the system with a specific function [14]. When the final result of the clustering algorithm satisfies the criterion function, the algorithm ends. The clustering algorithm is the decision criterion of the specific function evaluation system. In order to improve the accuracy of the clustering algorithm, it is necessary to select an appropriate criterion function. Commonly used criterion functions are as follows:(1)
Error sum of squares criterion functionAssuming a mixed sample setA=a1,a2,a3,⋯an, based on a certain association, the sample set is clustered into C separate subsets a1,a2,a3,⋯,an, each of which is a type and contains n1,n2,n3,⋯,nc, samples respectively. The samples are separated into subsets by some association with the mixed sample sets. In order to measure the instructions of the clustering algorithm, the error sum of squares criterion function is used. The definition Formula is as follows:(4)Jk=∑b=1k∑c=1nicb−mb2,mb=1nj∑b=1nibb=1,2,…,c.In the Formula,mb represents the mean of the samples in the bth class, and nb represents the number of samples in the bth class. According to the definition of the criterion function, it is not difficult to find its value k cluster centers and the samples in each cluster. The larger the value of jk, the larger the error of the clustering, and the lower the quality of the clustering algorithm. On the contrary, if the value of jk is smaller, the algorithm has a good clustering effect. The limitation of the error sum of squares criterion function is that it must use relatively dense samples with small differences in the number of samples [15]. When there is a large difference in the number of samples, the error sum of squares criterion function is used to discriminate the samples, which effectively separates each clustering type.(2)
Weighted average squared distance and criterion(5)YX=∑b=1KPbSb∗,S∗=2nbnb−1∑i=ia∑i=ibx−x′2,whereAA is the average squared distance between samples between classes. In order to deal with the large gap in sample data, the weighted average squared distance and the criterion function can be used to get the correct clustering results.(3)
Inter-class distance and criteria(6)Yj=∑b=1Kmb−mmb−m.In the Formula,mb is the sample mean vector of type wb, and m is the mean vector of all samples. The larger the value of the inter-class distance and the criterion function, the higher the separation and clustering quality of the clustering results.


## 3.3. K-Means Clustering Algorithm

The k-means algorithm, also known ask- or k-means, is a classic aggregation technique used for many tasks [16]. It is the distance of the data point to the prototype as the objective function of optimization. The algorithm performs a rotation function by finding the limit of a function, dividing the dataset into different parts such that the evaluation point J is the smallest and the resulting classes are about the same distance. Indicates the dataset grouping method as follows:(1)
Select a certain distance as the metric between samples: The search process of k-means clustering algorithm is limited to a part of all possible partition spaces [17]. If the sample similarity between each class is very low, the k-means algorithm can often achieve better results. However, if the sample similarity between classes is high, then further division of clusters may occur. Therefore, it is possible to obtain a local rather than a global minimum solution of the scoring function due to the convergence of the algorithm.(2)
Selection criterion functionThe k-means clustering algorithm is affected by the selected similarity measurement method, and the commonly used similarity measurement method uses the error sum of squares criterion function to improve the clustering performance. Assuming that I contains C cluster subsetsI1, I2,…, Ic; the number of samples in each cluster subset is n1, n2, …, nc; the mean points of each cluster subset are m1, m2, …, mc respectively, then the Formula of the error sum of squares criterion function is:(7)E∗=∑a=1c∑p∈ap−ma2.①The calculation of similarity is carried out according to the average value of objects in a cluster [15]. ② Randomly assign K cluster centers ③ For each sample Ia, assign it to the nearest neighbor class according to the principle of minimum distance. ④ Move the sample mean in the cluster to the cluster center. ⑤ Repeat the second step and the third step until the center of the cluster does not change. The data object set S is shown in Table 1. As a two-dimensional sample for cluster analysis, the required number of clusters k = 2.ChooseO10,2, O20,0 as the initial cluster center, namely M1=O10,2=,=M2=O20,0 According to the distance between the remaining objects and each central cluster, they are classified as the nearest cluster, for O3:(8)dM1,O1=0−1.52+2−02=2.5,dM2,O3=0−1.52+0−02=1.5.ObviouslydM2,O2≤dM1,O3, so give O3 to C2. For O5:(9)dM2,O3=0−1.52+0−0=1.5.ObviouslydM2,O2≤M1,O3, so give O5 to C1 to update, get new clusters C1=O1,O5 and C2=O2,O3,O4, calculate the squared error criterion, the single variance is:(10)E1=0−02+2−22+0−52+2−22=25,M1=O1=0,2E2=27.25M2=O2=0,0.The population mean variance is:E=E1+E2=25+27.25=52.25(3)
Calculate the center of the new cluster.(11)M1=0+52,2+22=2.5,2,M2=0+1.5+53,0+0+03=2.17,0.Repeat the steps of selecting functions and calculating new clusters to getO1 to C1; O2 to C2, O3 to C2, O4 to C2, and O5 to C1. Update, get new clusters C1=O1,O5 and C2=O2,O4, the center is M1=2.5,2, M2=2.17,0. The individual variances are,(12)E1=0−2.52+2−22+2.5−52+2−22=12.5E2=13.15.The overall mean error is:E=E1+E2=12.5+13.15=25.65Table 1
Student-related system table.
Field nameNotesTypeLengthIs it allowed to be emptyIdStudent IDString20NoStudent-nameStudent nameString20NoClass-idClass numberString20NoBirthdayDate of birthDateNoSexGenderString3NoDormitory-idDormitory numberString20NoContactContact informationString35NoParents-contactParent contact detailsString35NoHome-addressHome addressString100NoStudent-idStudent numberString20NoEvaluator-idAssessor numberEnum20NoMental-health degreeMental healthStringNoEvaluator-detailAssessment detailsStringAutoNoClass-adciser-idNumberingString20NoNameNameenum20NoSexGenderString3NoContactContact informationString20NoSdeptDepartmentString30NoAfter the first correlation, the mean error has improved significantly. Since the cluster centers of the two exchanges have not changed, the negotiation process ends and the algorithm stops. The K-means algorithm is used to measure a certain point in the sample. When facing the clustering problem, the algorithm is more efficient to complete the task. Even in the face of large datasets, the algorithm has high scalability and high efficiency. Since its complexity isOnkt. where n is the number of all objects, the value of k is user-specified, and t is the number of iterations, usually k〈n and t〈n.The clustering results show that when the k-means clustering algorithm is used, the difference between clusters is obvious, and the clustering effect is better [18]. The main disadvantage is that the K-Means algorithm often leads to completely different results by setting different k values. Algorithms can be used to analyze the distribution of the data, such as centers, hierarchical clustering, and density, and then choose an appropriate value of k until the cluster center tends to be stable.According to the performance analysis of the above algorithm, it can be seen that the core problem of using the K-means algorithm for clustering lies in the selection ofk value. But in the process of evaluating students’ mental health, there are a lot of information management systems, such as mental health evaluation system, psychological quality evaluation system, and so on. At the same time, every college has full-time counselors working on the front line of student management for a long time, which provides a valuable theoretical basis for the selection of K-worth.


## 4. Intervention Algorithm for Students’ Psychological Disorders

Psychological disorder is the ability of an individual to actively adapt and recover from adversity and stress [19]. In the past, it was often used in psychological development research and psychiatry research of children or adolescents to explore the relationship between resilience and early childhood life events, and the potential relationship with psychopathology.


### 4.1. Factors Affecting Students’ Mental Health

Another important concept related to psychological disorders is protective factors, which can protect individuals from or reduce the adverse effects of risk factors. These protective factors can be divided into personal factors and external environmental factors, and individual-level protective factors such as personality, temperament, and self-efficacy. The protective factors outside the individual are mainly family and social support, such as age, parental support, etc., as shown in Figure1.Figure 1
Psychological disorders framework.Among them, the main factors of internal psychological barriers are mental, cognitive, behavioral, emotional, and physical [20]. Spiritual factors mainly include dreams and personal goals, meaning in life, independence, internal control, hope and optimism, determination, and perseverance. Cognitive abilities include intelligence and ability to learn and work, insight, self-esteem, planning, and creativity. People with a higher psychological barrier framework have higher levels of self-control, are able to foresee the outcome of different choices in the future, and make clear and positive plans for the future. Behavioral factors include problem-solving, empathy, and interpersonal skills. Emotional factors include well-being, emotion management skills, and a sense of humor. Physical factors include physical fitness, good performance, and strong physical fitness.The macro definition of mental health refers to a continuous, efficient, and self-satisfied psychological state. On the other hand, at the micro level, the definition of mental health is further strengthened. It also refers to the ability of people to effectively coordinate cognition, emotion, thought, behavioral habits, and personality during a complete psychological activity process, so as to achieve the purpose of adapting to and keeping pace with society.To determine whether students have basic mental health qualities: social adaptability, personality quality, self-control, ability to distinguish right from wrong, calmness, and so on. These are the basic criteria for judging students’ mental health [21].


#### 4.1.1. Educational Methods for Mental Health

The mental state of students can often reflect the mental state of students [22]. These factors are often very important for college students. Students acquire knowledge and grow by themselves, which is essentially a continuous psychological activity and psychological development process. In the process of receiving education, students constantly choose and absorb the knowledge provided, so that their psychology gradually moves from naive to mature, and their psychological quality is also continuously improved in this process. Colleges and universities vigorously promote mental health education to improve students’ psychological quality, which is one of the effective ways to improve students’ comprehensive quality.


#### 4.1.2. The Impact of Campus Mental Health Problems

The level of students’ psychological quality is related to the psychological health education environment in which they live. From the perspective of students, in the process of education, they are constantly influenced by factors such as moral norms, social environment, and family expectations and improve their own personalities. From an objective point of view, students are constantly measuring, evaluating, and regulating their own personality development in contact with different values. When certain conditions are met, a personality with personal characteristics will emerge. However, mental health education not only has this kind of passive personality transformation but also actively guides students in the transformation process. There is no big deviation in the overall direction so that students can understand themselves and further cognition of their own behavior, so as to achieve the purpose of psychological sublimation and perfect personality.


#### 4.1.3. Stimulate Students’ Potential through Mental Health

Exploiting students’ potential is one of the goals of education, and students’ psychological quality is strongly dependent on the development of their potential [23]. Therefore, improving mental health education has become the primary task of the coordinated development of the two. In the process of mental health education, students are guided to change their mental activities by stimulating their self-confidence and self-awareness at a higher level. Gradually strengthen the ability to adapt to complex environments, so that students’ potential can be efficiently explored and brought into play. The mental health problems of contemporary college students are as follows: 1. Students are in the phenomenon of fear, depression, anxiety, and other psychological problems about the unknown. 2. The high tuition fees required to study make students bear huge financial pressure, especially those from families with poor financial ability. When learning is tied to cost, a slight deviation in grades can create extreme psychology. 3. The subjective judgment of students who are interacting with the opposite sex will be affected by emotional factors. When they are emotionally frustrated, they are prone to depression and even extremes.


### 4.2. Intervention Process Design of Horse Racing for Students’ Psychological Disorders

The process of mining the psychological data of students can be divided into five parts. As shown in Figure2, the following sections will be divided into five sections.(1)
Demand analysis: In the commercial field, data mining is used to analyze user data and customer purchase behavior, so that marketing can gain more profits, and mine operating information from data to reduce operating costs. Data mining personnel must clarify the goals of the project, provide the basis for formulating targeted strategies, and further confirm the available data mining algorithms.(2)
Data preparation: Select some data from the student psychological database for data mining [24]. If the existing student mental health data in the school meets the requirements of data mining, the data warehouse can be used as a data mining library.(3)
Data sorting: Data may be structured or unstructured data and some of them have complex data structures. To analyze data, it is necessary to preprocess the data. Comprehension is the source of data and data sets, through relevant knowledge and technology, checking and removing erroneous irrelevant data.(4)
Modeling: According to the data mining algorithm and the characteristics of the data, a prediction model is established.(5)
Interpretation and evaluation of results: Through the processing of the steps, a series of results and patterns can be obtained. The generated model results need to be verified to generate the final optimized model. If it is found that the model is not optimized enough in the steps, it is necessary to go back to the previous steps to adjust [25].Figure 2
Data mining process.Through a detailed analysis of the existing student work process, and asking the front-line staff of the student work such as the counselor and class teacher of the Department of Information Engineering to determine the basic needs, as shown in Figure3:Figure 3
Functional structure diagram of student mental health management system.The analysis of the test results of the Student Mental Health Scale before the experiment is shown in Figure4. P < 0.05 shows a significant difference, andP < 0.01 shows a very significant difference.Figure 4
Test results before and after the psychological impact of the horse racing training experimental group and the general physical education control group.
(a)(b)As shown in Figure5, the functions that the student mental health management system needs to implement are as follows:(1)
It has a simple and elegant interface, supports the skinning function, and users can use the system anytime and anywhere by using the browser.(2)
Multiple user management, head teacher, psychological assessor, department-level leader, and administrator each perform their own duties and jointly manage, as shown in Figure4.(3)
Perfect authority management, each user manages their own area without crossing the border.(4)
Management of student basic information, management of students’ names, student IDs, classes, home addresses, contact information, etc., providing batch import from Excel sheets, and batch export of information to Excel sheets.(5)
Students’ mental health status management, record the results of students’ psychological assessment, and push the information of students with poor mental health status to their head teachers.(6)
Students’ weekend comment management, record the attendance and comment content of weekend comments.(7)
Class information management, to manage class information so that students can conduct centralized management by class as a unit.(8)
Information management of the head teacher, management of the contact information of the head teacher, if there are students with poor mental state, in addition to the system push information, they can also make telephone notifications.(9)
During information management, the data is displayed in pages, 50 pieces of data per page, and the current page number and the total number of records are displayed.Figure 5
Multi-authority user management structure diagram.Use the database in the user management structure diagram to design the E-R diagram of the student mental health management system, as shown in Figure6.Figure 6
Entity-relationship (E-R) model.The E-R model designed according to Figure6 can be converted into a data dictionary, and the specific design is shown in Table 1.The physical data model is a direct representation of the database implementation. After the physical data model of the database is prepared, it can be converted into the physical realization of the database through specific DBMS products or tools such as Power Designer, and it can be thought of it as the final step in database design.The module design of cluster analysis of students’ mental health after collecting the data through the method, processing the valid data, and establishing the relevant database, the clustering algorithm data is used to analyze the data to produce the clustering result prediction analysis. The evaluation given by the analysis results is shown in Figure7.Figure 7
Flow chart of student mental health analysis.The students’ mental health cluster analysis module test first subdivides the attributes of the relevant data in the database table in the student mental health management system. Then make an objective and rational judgment on the mental health of students through the data analysis function of the system, and thus establish a management mechanism with a practical reference value. The data preparation is divided into three steps: data selection, data pre-processing, and data transformation.The selection phase needs to integrate the task object properties. However, attributes that are not related to the mining task and are easy to increase the complexity are eliminated, such as student number, name, etc., to reduce the load brought by the algorithm and achieve the purpose of improving the robustness of the system. Finally, the remaining attribute elements are integrated. This study summarizes various factors that affect students’ psychology, extracts several factors and summarizes them, and obtains the required Table2.Table 2
UPI table.
NameNumberingGenderFemaleAge20Classification number52220111021Test date2019-10-11Evaluation score5Test score93Physical fitnessGood76Introvert/ExtrovertExtrovert93interpersonal relationshipExcellent interpersonal relationship98Image demeanorExcellent89The 16PF table used in data mining is shown in Table3.Table 3
16PF table.
NameNumberGenderFemaleAge20Classification number52220111021Test date2010-10-11Factor nameCodeOriginal scoreStandard scoreGregariousnessA2019IntelligenceB208StabilityC208AnxietyD209ExperimentalE202IndependenceF208Self-disciplineG2012TensionH204The element calculation results and brief introduction are shown in Table4:Table 4
Elemental calculation results.
AttributesNumberingInitial scoreScoreNotesAdaptability and anxiety levelsX13.50Strong adaptability to the environmentIntroversion and extroversionX26.50MiddleMental healthX36.80MiddleProfessional and successfulY1320GenerallyCreativityY2685GenerallyGrowth abilityY3210GenerallyBy pre-processing the student data such as noise reduction, filling in missing values, and deduplication, the stability of the system in the next mining and analysis is further strengthened. At the same time, it also allows the system to reduce the secondary processing time of the data in the later stage, which not only enhances the accuracy of the results but also enhances the robustness of the system.In the database management of the mental health system, through the noise reduction processing of the effective data, the attributes of the data established in the database are merged to obtain the relevant data tables, as shown in Table5:Table 5
Mental health data sheet.
Field nameType of datais emptyDescribeStudent IDVarchar (15)Not nullStudent IDSexVarchar (21)Not nullTester’s genderTimeVarchar (22)Not nullAdaptation and anxietyIntroverted and outgoingVarchar (23)Not nullIntroversion and extroversionCalm and impetuousVarchar (24)Not nullCalm and impetuousBravery cowardiceVarchar (20)Not nullBrave and cowardlyMental healthVarchar (26)Not nullMental healthCareer achievementVarchar (27)Not nullCareer achievementCreative abilityVarchar (28)Not nullCreativityPotentialVarchar (29)Not nullPotentialAfter denoising the data, establish the relevant mental health table data, as shown in Figure8:Figure 8
Selected mental health data.
(a)(b)


### 4.3. Feasibility Analysis of K-Means Algorithm

In order to further analyze the feasibility of the clustering algorithm in the specific application process, we use the K-means algorithm to cluster the mental health data of 1000 students in a university. The results of the analysis were compared with the school’s psychological evaluation system, and then the teachers of the school’s mental health center evaluated the analysis results. To analyze the specific feasibility of the algorithm, we mainly use data cleaning, data transformation, data reduction, and other methods in the pre-processing process. The data attribute code conversion table is shown in Table6.Table 6
Data attribute code conversion table.
Data attributeValueCodeGenderMale21Female22Character traitsIntroverted, intellectual31Introverted, emotional32Introverted, willful33Extraverted, intellectual34Extraverted, emotional35Extraverted, willful36Household incomeHigh41Middle42Low43One-parent familyYes51No62Is it an only childYes61No62Comprehensive academic GPAExcellent71Good72Qualified73Failed74Daily attendanceGood81Qualified82Failed83Table7 is the basic information table of a certain student. Before the system analysis, this basic information is converted into data fields that can be used by the system.Table 7
Basic information of a student.
GenderMale21Character traitsIntroverted intellectual31Household incomeMiddle42One-parent familyYes51Is it an only childYes61Grade pointGood72Daily attendanceQualified82Note, according to the attribute code conversion table in the third line, the data set of the sample is {21, 31, 42, 51, 61, 72, 82}, which provides convenience for the subsequent processing of the system.Here, a sample of 1,000 students from a university is selected. Since student management is generally managed separately by a department that is generally managed by a full-time counselor. Since the majors are similar, they have the same courses and the same management mode. Moreover, the analysis of the characteristics of student-related activities in the same department can also help counselors and colleges have a reference value in the process of managing students. Therefore, it is not only correct but also representative to select students from a department for cluster analysis.After the pre-processing data is formed, K-means clustering is performed using SPSS software. The K-means clustering results are shown in Figure9.Figure 9
K-means clustering effect of spss software.When using the K-means algorithm for cluster analysis, the number of clusters was determined by psychological consultants based on the classification of the Student SCL-90 symptom self-rating scale and the UPI college student personality test scale to determineK = 3. Its initial cluster center is randomly generated by the system. Among them, the seven attributes of “gender,” “character characteristics,” “family income,” “single-parent family,” “only child,” “grade points” and “attendance” are used as input variables. Select 10 for the maximum number of iterations and display clustering information for each case.


### 4.4. Cluster Results

After six iterations, the classification results are as follows: The system performs cluster analysis, and the initial cluster center and iteration history are shown in Figure10.Figure 10
Initial cluster centers.After the initial cluster center is determined, the distance between each data and the initial center is calculated and added to a new cluster. Then a new cluster center is generated. After six iterations, the cluster center remains unchanged and the algorithm ends, and the classification result is obtained. The iteration history is shown in Figure11.Figure 11
Iteration history.The distance table between the final cluster center map and the final cluster center is shown in Figure12.Figure 12
Final cluster centers.After six iterations, the classification is obtained, and the algorithm ends when the cluster center remains unchanged for six iterations, and the classification result is obtained. According to the previous algorithm, the distance of the final cluster center is obtained, as shown in Table8.Table 8
Distances between final cluster centers.
Clustering12312.8352.07022.8353.45332.0703.453According to the results of the clustering algorithm, the comprehensive characteristics of each type of student in the student data set can be extracted.There are 26 students in the first student category or 23% of the overall student population. The comprehensive attributes of these students show that these students are introverted and stubborn in their views on issues and will not listen to others’ opinions and ideas; the vast majority of families have low incomes; the majority of only children are single-parent families. The reasons lead to the fact that in all aspects, the situation of students from normal families is worse, and it is easy to cause them to have an inferiority complex. Their psychological problems are often troubled, and they are reluctant to communicate with teachers and students, making it difficult for them to detect these psychological problems early. Although students in this category study in the same environment as other students, their learning methods are not perfect due to their own reasons, and their learning efficiency is also very low. And the inefficient study makes the grades unsatisfactory, making the students have negative emotions about the grades. In the long run, the accumulation of a large number of negative emotions cannot be resolved, and this type of student is very easy to go to extremes. Even a small problem will cause this type of student to make very extreme behaviors. Therefore, this type of student is the focus of school education administrators, teachers, and psychological counselors. At the same time, according to the data in the table, it is shown that there are more male subjects in the sample, and what girls need most is a person to talk to. Therefore, among such students, more attention should be paid to girls.There are 30 students in the second student category or 27% of the overall student population. The students in this group are mainly characterized by extroverted personalities, rich feelings, a superior family environment, and excellent academic performance. The vast majority of students hold key class positions, club positions, and college positions in the class. Therefore, this type of student needs to play an exemplary role in bringing a healthy and upward mental attitude to other students, and they are the main helpers of teachers, counselors, and psychological counselors.There are 53 students in the third student category or 50% of the overall student population. This group of students is defined as a mixed psychological group. According to the data, this type of student has its own advantages and disadvantages, regardless of whether they are introverted or not or their ability to communicate with others. But there is a common feature that is strong self-regulation ability. Although it will be affected by the outside world, it will not change significantly, and it will slowly adjust itself over time. Although this group is relatively stable, there must be an effective management mechanism to properly intervene in their psychological state. The K-means algorithm is used in the research method of cluster analysis in the feasibility analysis of students’ mental health problems. Actively analyzing the students’ psychological state by extracting the data features in the students’ basic information database and obtaining an accurate and stable classification. Then, through the subjective analysis of school counselors and student administrators, it is proved that the classification realized by this algorithm has a certain reference value. It can provide more and better services for the mental health management of students for the relevant staff, and also provides a new working idea and working mode for the mental health educators in colleges and universities. A set of student mental health management system is realized by using the clustering method. Through this system, more basic data of students can be obtained, and the extraction of data features can be more stable, reliable, efficient, and scalable. Finally, this data mining technology is embedded into the student management system to improve the work efficiency of relevant personnel. It makes up for the limitations of traditional analysis methods, and reflects the psychological state of students scientifically and reasonably, thereby giving more information to relevant instructors.


## 4.1. Factors Affecting Students’ Mental Health

Another important concept related to psychological disorders is protective factors, which can protect individuals from or reduce the adverse effects of risk factors. These protective factors can be divided into personal factors and external environmental factors, and individual-level protective factors such as personality, temperament, and self-efficacy. The protective factors outside the individual are mainly family and social support, such as age, parental support, etc., as shown in Figure1.Figure 1
Psychological disorders framework.Among them, the main factors of internal psychological barriers are mental, cognitive, behavioral, emotional, and physical [20]. Spiritual factors mainly include dreams and personal goals, meaning in life, independence, internal control, hope and optimism, determination, and perseverance. Cognitive abilities include intelligence and ability to learn and work, insight, self-esteem, planning, and creativity. People with a higher psychological barrier framework have higher levels of self-control, are able to foresee the outcome of different choices in the future, and make clear and positive plans for the future. Behavioral factors include problem-solving, empathy, and interpersonal skills. Emotional factors include well-being, emotion management skills, and a sense of humor. Physical factors include physical fitness, good performance, and strong physical fitness.The macro definition of mental health refers to a continuous, efficient, and self-satisfied psychological state. On the other hand, at the micro level, the definition of mental health is further strengthened. It also refers to the ability of people to effectively coordinate cognition, emotion, thought, behavioral habits, and personality during a complete psychological activity process, so as to achieve the purpose of adapting to and keeping pace with society.To determine whether students have basic mental health qualities: social adaptability, personality quality, self-control, ability to distinguish right from wrong, calmness, and so on. These are the basic criteria for judging students’ mental health [21].


### 4.1.1. Educational Methods for Mental Health

The mental state of students can often reflect the mental state of students [22]. These factors are often very important for college students. Students acquire knowledge and grow by themselves, which is essentially a continuous psychological activity and psychological development process. In the process of receiving education, students constantly choose and absorb the knowledge provided, so that their psychology gradually moves from naive to mature, and their psychological quality is also continuously improved in this process. Colleges and universities vigorously promote mental health education to improve students’ psychological quality, which is one of the effective ways to improve students’ comprehensive quality.


### 4.1.2. The Impact of Campus Mental Health Problems

The level of students’ psychological quality is related to the psychological health education environment in which they live. From the perspective of students, in the process of education, they are constantly influenced by factors such as moral norms, social environment, and family expectations and improve their own personalities. From an objective point of view, students are constantly measuring, evaluating, and regulating their own personality development in contact with different values. When certain conditions are met, a personality with personal characteristics will emerge. However, mental health education not only has this kind of passive personality transformation but also actively guides students in the transformation process. There is no big deviation in the overall direction so that students can understand themselves and further cognition of their own behavior, so as to achieve the purpose of psychological sublimation and perfect personality.


### 4.1.3. Stimulate Students’ Potential through Mental Health

Exploiting students’ potential is one of the goals of education, and students’ psychological quality is strongly dependent on the development of their potential [23]. Therefore, improving mental health education has become the primary task of the coordinated development of the two. In the process of mental health education, students are guided to change their mental activities by stimulating their self-confidence and self-awareness at a higher level. Gradually strengthen the ability to adapt to complex environments, so that students’ potential can be efficiently explored and brought into play. The mental health problems of contemporary college students are as follows: 1. Students are in the phenomenon of fear, depression, anxiety, and other psychological problems about the unknown. 2. The high tuition fees required to study make students bear huge financial pressure, especially those from families with poor financial ability. When learning is tied to cost, a slight deviation in grades can create extreme psychology. 3. The subjective judgment of students who are interacting with the opposite sex will be affected by emotional factors. When they are emotionally frustrated, they are prone to depression and even extremes.


## 4.1.1. Educational Methods for Mental Health

The mental state of students can often reflect the mental state of students [22]. These factors are often very important for college students. Students acquire knowledge and grow by themselves, which is essentially a continuous psychological activity and psychological development process. In the process of receiving education, students constantly choose and absorb the knowledge provided, so that their psychology gradually moves from naive to mature, and their psychological quality is also continuously improved in this process. Colleges and universities vigorously promote mental health education to improve students’ psychological quality, which is one of the effective ways to improve students’ comprehensive quality.


## 4.1.2. The Impact of Campus Mental Health Problems

The level of students’ psychological quality is related to the psychological health education environment in which they live. From the perspective of students, in the process of education, they are constantly influenced by factors such as moral norms, social environment, and family expectations and improve their own personalities. From an objective point of view, students are constantly measuring, evaluating, and regulating their own personality development in contact with different values. When certain conditions are met, a personality with personal characteristics will emerge. However, mental health education not only has this kind of passive personality transformation but also actively guides students in the transformation process. There is no big deviation in the overall direction so that students can understand themselves and further cognition of their own behavior, so as to achieve the purpose of psychological sublimation and perfect personality.


## 4.1.3. Stimulate Students’ Potential through Mental Health

Exploiting students’ potential is one of the goals of education, and students’ psychological quality is strongly dependent on the development of their potential [23]. Therefore, improving mental health education has become the primary task of the coordinated development of the two. In the process of mental health education, students are guided to change their mental activities by stimulating their self-confidence and self-awareness at a higher level. Gradually strengthen the ability to adapt to complex environments, so that students’ potential can be efficiently explored and brought into play. The mental health problems of contemporary college students are as follows: 1. Students are in the phenomenon of fear, depression, anxiety, and other psychological problems about the unknown. 2. The high tuition fees required to study make students bear huge financial pressure, especially those from families with poor financial ability. When learning is tied to cost, a slight deviation in grades can create extreme psychology. 3. The subjective judgment of students who are interacting with the opposite sex will be affected by emotional factors. When they are emotionally frustrated, they are prone to depression and even extremes.


## 4.2. Intervention Process Design of Horse Racing for Students’ Psychological Disorders

The process of mining the psychological data of students can be divided into five parts. As shown in Figure2, the following sections will be divided into five sections.(1)
Demand analysis: In the commercial field, data mining is used to analyze user data and customer purchase behavior, so that marketing can gain more profits, and mine operating information from data to reduce operating costs. Data mining personnel must clarify the goals of the project, provide the basis for formulating targeted strategies, and further confirm the available data mining algorithms.(2)
Data preparation: Select some data from the student psychological database for data mining [24]. If the existing student mental health data in the school meets the requirements of data mining, the data warehouse can be used as a data mining library.(3)
Data sorting: Data may be structured or unstructured data and some of them have complex data structures. To analyze data, it is necessary to preprocess the data. Comprehension is the source of data and data sets, through relevant knowledge and technology, checking and removing erroneous irrelevant data.(4)
Modeling: According to the data mining algorithm and the characteristics of the data, a prediction model is established.(5)
Interpretation and evaluation of results: Through the processing of the steps, a series of results and patterns can be obtained. The generated model results need to be verified to generate the final optimized model. If it is found that the model is not optimized enough in the steps, it is necessary to go back to the previous steps to adjust [25].Figure 2
Data mining process.Through a detailed analysis of the existing student work process, and asking the front-line staff of the student work such as the counselor and class teacher of the Department of Information Engineering to determine the basic needs, as shown in Figure3:Figure 3
Functional structure diagram of student mental health management system.The analysis of the test results of the Student Mental Health Scale before the experiment is shown in Figure4. P < 0.05 shows a significant difference, andP < 0.01 shows a very significant difference.Figure 4
Test results before and after the psychological impact of the horse racing training experimental group and the general physical education control group.
(a)(b)As shown in Figure5, the functions that the student mental health management system needs to implement are as follows:(1)
It has a simple and elegant interface, supports the skinning function, and users can use the system anytime and anywhere by using the browser.(2)
Multiple user management, head teacher, psychological assessor, department-level leader, and administrator each perform their own duties and jointly manage, as shown in Figure4.(3)
Perfect authority management, each user manages their own area without crossing the border.(4)
Management of student basic information, management of students’ names, student IDs, classes, home addresses, contact information, etc., providing batch import from Excel sheets, and batch export of information to Excel sheets.(5)
Students’ mental health status management, record the results of students’ psychological assessment, and push the information of students with poor mental health status to their head teachers.(6)
Students’ weekend comment management, record the attendance and comment content of weekend comments.(7)
Class information management, to manage class information so that students can conduct centralized management by class as a unit.(8)
Information management of the head teacher, management of the contact information of the head teacher, if there are students with poor mental state, in addition to the system push information, they can also make telephone notifications.(9)
During information management, the data is displayed in pages, 50 pieces of data per page, and the current page number and the total number of records are displayed.Figure 5
Multi-authority user management structure diagram.Use the database in the user management structure diagram to design the E-R diagram of the student mental health management system, as shown in Figure6.Figure 6
Entity-relationship (E-R) model.The E-R model designed according to Figure6 can be converted into a data dictionary, and the specific design is shown in Table 1.The physical data model is a direct representation of the database implementation. After the physical data model of the database is prepared, it can be converted into the physical realization of the database through specific DBMS products or tools such as Power Designer, and it can be thought of it as the final step in database design.The module design of cluster analysis of students’ mental health after collecting the data through the method, processing the valid data, and establishing the relevant database, the clustering algorithm data is used to analyze the data to produce the clustering result prediction analysis. The evaluation given by the analysis results is shown in Figure7.Figure 7
Flow chart of student mental health analysis.The students’ mental health cluster analysis module test first subdivides the attributes of the relevant data in the database table in the student mental health management system. Then make an objective and rational judgment on the mental health of students through the data analysis function of the system, and thus establish a management mechanism with a practical reference value. The data preparation is divided into three steps: data selection, data pre-processing, and data transformation.The selection phase needs to integrate the task object properties. However, attributes that are not related to the mining task and are easy to increase the complexity are eliminated, such as student number, name, etc., to reduce the load brought by the algorithm and achieve the purpose of improving the robustness of the system. Finally, the remaining attribute elements are integrated. This study summarizes various factors that affect students’ psychology, extracts several factors and summarizes them, and obtains the required Table2.Table 2
UPI table.
NameNumberingGenderFemaleAge20Classification number52220111021Test date2019-10-11Evaluation score5Test score93Physical fitnessGood76Introvert/ExtrovertExtrovert93interpersonal relationshipExcellent interpersonal relationship98Image demeanorExcellent89The 16PF table used in data mining is shown in Table3.Table 3
16PF table.
NameNumberGenderFemaleAge20Classification number52220111021Test date2010-10-11Factor nameCodeOriginal scoreStandard scoreGregariousnessA2019IntelligenceB208StabilityC208AnxietyD209ExperimentalE202IndependenceF208Self-disciplineG2012TensionH204The element calculation results and brief introduction are shown in Table4:Table 4
Elemental calculation results.
AttributesNumberingInitial scoreScoreNotesAdaptability and anxiety levelsX13.50Strong adaptability to the environmentIntroversion and extroversionX26.50MiddleMental healthX36.80MiddleProfessional and successfulY1320GenerallyCreativityY2685GenerallyGrowth abilityY3210GenerallyBy pre-processing the student data such as noise reduction, filling in missing values, and deduplication, the stability of the system in the next mining and analysis is further strengthened. At the same time, it also allows the system to reduce the secondary processing time of the data in the later stage, which not only enhances the accuracy of the results but also enhances the robustness of the system.In the database management of the mental health system, through the noise reduction processing of the effective data, the attributes of the data established in the database are merged to obtain the relevant data tables, as shown in Table5:Table 5
Mental health data sheet.
Field nameType of datais emptyDescribeStudent IDVarchar (15)Not nullStudent IDSexVarchar (21)Not nullTester’s genderTimeVarchar (22)Not nullAdaptation and anxietyIntroverted and outgoingVarchar (23)Not nullIntroversion and extroversionCalm and impetuousVarchar (24)Not nullCalm and impetuousBravery cowardiceVarchar (20)Not nullBrave and cowardlyMental healthVarchar (26)Not nullMental healthCareer achievementVarchar (27)Not nullCareer achievementCreative abilityVarchar (28)Not nullCreativityPotentialVarchar (29)Not nullPotentialAfter denoising the data, establish the relevant mental health table data, as shown in Figure8:Figure 8
Selected mental health data.
(a)(b)


## 4.3. Feasibility Analysis of K-Means Algorithm

In order to further analyze the feasibility of the clustering algorithm in the specific application process, we use the K-means algorithm to cluster the mental health data of 1000 students in a university. The results of the analysis were compared with the school’s psychological evaluation system, and then the teachers of the school’s mental health center evaluated the analysis results. To analyze the specific feasibility of the algorithm, we mainly use data cleaning, data transformation, data reduction, and other methods in the pre-processing process. The data attribute code conversion table is shown in Table6.Table 6
Data attribute code conversion table.
Data attributeValueCodeGenderMale21Female22Character traitsIntroverted, intellectual31Introverted, emotional32Introverted, willful33Extraverted, intellectual34Extraverted, emotional35Extraverted, willful36Household incomeHigh41Middle42Low43One-parent familyYes51No62Is it an only childYes61No62Comprehensive academic GPAExcellent71Good72Qualified73Failed74Daily attendanceGood81Qualified82Failed83Table7 is the basic information table of a certain student. Before the system analysis, this basic information is converted into data fields that can be used by the system.Table 7
Basic information of a student.
GenderMale21Character traitsIntroverted intellectual31Household incomeMiddle42One-parent familyYes51Is it an only childYes61Grade pointGood72Daily attendanceQualified82Note, according to the attribute code conversion table in the third line, the data set of the sample is {21, 31, 42, 51, 61, 72, 82}, which provides convenience for the subsequent processing of the system.Here, a sample of 1,000 students from a university is selected. Since student management is generally managed separately by a department that is generally managed by a full-time counselor. Since the majors are similar, they have the same courses and the same management mode. Moreover, the analysis of the characteristics of student-related activities in the same department can also help counselors and colleges have a reference value in the process of managing students. Therefore, it is not only correct but also representative to select students from a department for cluster analysis.After the pre-processing data is formed, K-means clustering is performed using SPSS software. The K-means clustering results are shown in Figure9.Figure 9
K-means clustering effect of spss software.When using the K-means algorithm for cluster analysis, the number of clusters was determined by psychological consultants based on the classification of the Student SCL-90 symptom self-rating scale and the UPI college student personality test scale to determineK = 3. Its initial cluster center is randomly generated by the system. Among them, the seven attributes of “gender,” “character characteristics,” “family income,” “single-parent family,” “only child,” “grade points” and “attendance” are used as input variables. Select 10 for the maximum number of iterations and display clustering information for each case.


## 4.4. Cluster Results

After six iterations, the classification results are as follows: The system performs cluster analysis, and the initial cluster center and iteration history are shown in Figure10.Figure 10
Initial cluster centers.After the initial cluster center is determined, the distance between each data and the initial center is calculated and added to a new cluster. Then a new cluster center is generated. After six iterations, the cluster center remains unchanged and the algorithm ends, and the classification result is obtained. The iteration history is shown in Figure11.Figure 11
Iteration history.The distance table between the final cluster center map and the final cluster center is shown in Figure12.Figure 12
Final cluster centers.After six iterations, the classification is obtained, and the algorithm ends when the cluster center remains unchanged for six iterations, and the classification result is obtained. According to the previous algorithm, the distance of the final cluster center is obtained, as shown in Table8.Table 8
Distances between final cluster centers.
Clustering12312.8352.07022.8353.45332.0703.453According to the results of the clustering algorithm, the comprehensive characteristics of each type of student in the student data set can be extracted.There are 26 students in the first student category or 23% of the overall student population. The comprehensive attributes of these students show that these students are introverted and stubborn in their views on issues and will not listen to others’ opinions and ideas; the vast majority of families have low incomes; the majority of only children are single-parent families. The reasons lead to the fact that in all aspects, the situation of students from normal families is worse, and it is easy to cause them to have an inferiority complex. Their psychological problems are often troubled, and they are reluctant to communicate with teachers and students, making it difficult for them to detect these psychological problems early. Although students in this category study in the same environment as other students, their learning methods are not perfect due to their own reasons, and their learning efficiency is also very low. And the inefficient study makes the grades unsatisfactory, making the students have negative emotions about the grades. In the long run, the accumulation of a large number of negative emotions cannot be resolved, and this type of student is very easy to go to extremes. Even a small problem will cause this type of student to make very extreme behaviors. Therefore, this type of student is the focus of school education administrators, teachers, and psychological counselors. At the same time, according to the data in the table, it is shown that there are more male subjects in the sample, and what girls need most is a person to talk to. Therefore, among such students, more attention should be paid to girls.There are 30 students in the second student category or 27% of the overall student population. The students in this group are mainly characterized by extroverted personalities, rich feelings, a superior family environment, and excellent academic performance. The vast majority of students hold key class positions, club positions, and college positions in the class. Therefore, this type of student needs to play an exemplary role in bringing a healthy and upward mental attitude to other students, and they are the main helpers of teachers, counselors, and psychological counselors.There are 53 students in the third student category or 50% of the overall student population. This group of students is defined as a mixed psychological group. According to the data, this type of student has its own advantages and disadvantages, regardless of whether they are introverted or not or their ability to communicate with others. But there is a common feature that is strong self-regulation ability. Although it will be affected by the outside world, it will not change significantly, and it will slowly adjust itself over time. Although this group is relatively stable, there must be an effective management mechanism to properly intervene in their psychological state. The K-means algorithm is used in the research method of cluster analysis in the feasibility analysis of students’ mental health problems. Actively analyzing the students’ psychological state by extracting the data features in the students’ basic information database and obtaining an accurate and stable classification. Then, through the subjective analysis of school counselors and student administrators, it is proved that the classification realized by this algorithm has a certain reference value. It can provide more and better services for the mental health management of students for the relevant staff, and also provides a new working idea and working mode for the mental health educators in colleges and universities. A set of student mental health management system is realized by using the clustering method. Through this system, more basic data of students can be obtained, and the extraction of data features can be more stable, reliable, efficient, and scalable. Finally, this data mining technology is embedded into the student management system to improve the work efficiency of relevant personnel. It makes up for the limitations of traditional analysis methods, and reflects the psychological state of students scientifically and reasonably, thereby giving more information to relevant instructors.


## 5. Discussion

The development of horse racing activities in various countries and regions is not balanced and presents different styles and genres, but there is no lack of connection, exchange, and reference between each other so the various horse racing activities seek common ground while reserving differences. Using cluster analysis, the potential value information of students’ psychology and the correlation between various information factors are analyzed from the massive psychological measurement data of students in the school database. It provides more scientific student mental health solutions for the majority of psychological teaching workers.Provide theoretical and technical support for how to mine psychological data from the psychological management system. Data mining technology promotes the digitization of psychological information and effectively improves the management level and the quality of psychological services. On the one hand, the existing mental health data of students is classified and cleaned, combined with algorithms such as cluster analysis, to make data collection more purposeful and improve analysis efficiency. On the other hand, the analysis of the psychological data in the database can further mine the relevant information on the students’ psychology. In this way, corresponding solutions can be put forward for different types of psychological problems of students, and it is convenient for schools and related personnel to quickly and conveniently understand the crux of students’ psychological problems.


## 6. Conclusion

The government gives great support at the macro level and trains horse racing-related teachers at the meso level. Follow the example of colleges and universities to establish primary and secondary school horse racing teams, improve the mechanism of horse racing competitions and performances in primary and secondary schools, and promote the coordinated development of horse racing in universities and primary and secondary schools. It not only has an impact on the physical and mental health of primary school students but also has a profound impact on the inheritance of traditional Chinese culture. If primary school students want to have good mental health, physical exercise is the shortcut among shortcuts. The normal development of heart health and physical training are inseparable, and there is a complementary relationship between them. Horse racing not only regulate the psychological balance of students, and enhance the will quality of students, but also has a decompression function. In the psychological management system, the cluster analysis technology is used to mine psychological information, and according to the corresponding characteristics of the psychological diseases existing in the system, the associations and value information rules between different psychological assessment data are mined from the massive psychological data of students. A classification model of mental illness was constructed. And it uses mining technology to verify the application data of students’ psychological management systems in practice, solves the problem of finding information from massive data, and puts forward methods and improvement suggestions for the construction of original students’ psychological files. The probability of solving mental illness is greatly improved, and according to the specific spatial distribution of the data, this study adopts a two-step clustering analysis algorithm and constructs a clustering analysis model at the same time. It has provided technical support for major colleges and universities across the country to carry out student mental health-related work and has significantly improved student mental health education. [19].



---

*Source: 3513240-2022-07-31.xml*