# The Dissemination and Evaluation of Campus Ideological and Political Public Opinion Based on Internet of Things Monitoring

Authors: Xiao Xu; Bei Sun
Journal: Computational Intelligence and Neuroscience
 (2022)

---

## Abstract

With the advent of the information age, the rapid development of Internet of Things technology makes monitoring methods more flexible and changeable. As an intelligent application, the development of the Internet of Things brings convenience to public opinion monitoring. However, at present, due to the high price of transmission equipment, inconvenient maintenance, information delay, and other unfavorable conditions, real-time and controllable public opinion monitoring cannot be carried out on a large scale, and there are still many deficiencies in campus ideological and political public opinion monitoring. We found an effective transmission method, explored the network energy saving, dig deep into the transmission function of the signal system, and reduced the interference and mutual influence of various transmission accessories. In the application of the Internet of Things, the network public opinion is remotely monitored, the campus public opinion information is mastered, and its dissemination and development orientation are controlled. The exploration and research of online public opinion monitoring are in line with the goal of smart campus, and its theoretical development is constantly enriched.


---

## Body

## 1. Introduction

The Internet of Things is an emerging information technology revolution [1–5]. As an intelligent application, it has become an extremely important application field. It is an extremely effective tool for monitoring systems [6–9]. Its popularity is increasing year by year, so it is more familiar to the public. The concept of smart campus has gradually gained popularity in recent years [10–12]. It is of great practical significance for ideological and political education to grasp this trend and use the Internet of Things to carry out ideological education work. With the continuous upgrading and expansion of Internet of Things technology, we can realize real-time network remote monitoring. To better meet the needs of campus ideological and political public opinion monitoring [13], public opinion supervision is crucial to campus stability [14, 15]. We use corresponding research methods to improve the supervision of public opinion, conduct real-time mastery and supervision of campus public opinion, and manage and guide it accordingly. The development and application of ideological and political education functions through the development of corresponding modules on the network and the continuous improvement of the functional application of the Internet of Things platform are the embodiment of the comprehensive implementation of the smart campus. The exponential development of Internet platforms has greatly increased the number of online public opinions. In today’s information age, the masses have considerable freedom of speech on the Internet, which makes the overall controllability of public opinion information poor. It is necessary to increase the development of public opinion monitoring tools.


## 2. Overall Design of Campus Public Opinion Dissemination

In the dissemination of campus public opinion information, the dissemination of ideological and political public opinion is one of the important aspects. We need to complete these tasks: the construction of the campus Internet of Things site, the construction of the energy cycle development system, and the construction of the public opinion monitoring website. Finally, the application of monitoring model to perfect the network environment is established.When the Internet of Things technology is applied to the construction of smart campuses, it is necessary to fully exploit and utilize the characteristics of the Internet of Things. It makes the task of campus information management in the data age more convenient and effective and can better control the development of public opinion and make it truly effective. The optimization and upgrading of the monitoring function of the Internet of Things conform to the trend of the times and meet the goal of building a smart campus, so that the management and control of campus public opinion can be truly improved.There are three parts in the campus public opinion dissemination system. One is the monitoring system, including wireless transmission, core control. and sensing operation, which is the core application of the entire system. The second is the appropriate addition of the energy supply system, including the reasonable conversion of natural energy, which can effectively improve the efficiency of energy utilization. The last is the web page display system, which can record and call monitoring data, including time data and location data. The overall design block diagram of campus public opinion dissemination is shown in Figure1.Figure 1
Overall block diagram of campus public opinion communication design.


### 2.1. Text Analysis and Calculation of Public Opinion

The following is the application of the TF-IDF method. We can calculate and add vocabulary weights on the basis of the original documents and assign different weights to different words, so as to achieve the division of importance. When a word appears more than average, it can be considered representative, and we perform TF-IDF assignment operation on it. This can make the entire corpus weighted, making it easier to judge the orientation of campus public opinion. This formula can be converted into document feature values for operation when the number of occurrences of words in the article is too large. Specifically, it is a weight addition and subtraction operation for dividing the importance level. The formula for calculating the TF value is as follows:(1)TFi,j=ni,jΣknk,j.Among them,TFi,j represents the TF value of the ith word of the jth article, ni,j represents the frequency of the ith word of the jth article, Σknk,j represents the frequency of occurrence of all words in the jth article, and k refers to the vocabulary size contained in the jth article. The introduction of the IDF calculation formula allows us to facilitate its calculation process, as shown below:(2)IDFi,j=logD1+Dti.IDFi,j can be specific to the IDF value of the ith word in the jth article, D represents the total number of text data, and Dti represents the text number of ti.The overall calculation formula of the TF-IDF value is as follows:(3)TF−IDFi,j=TFi,j×IDFi,j.After a large number of TF weight operations [16], extract basic emotional information from text information, so that we can understand the general orientation of public opinion and better study its control methods. Public opinion information is the expression and expression of people’s emotions, reflecting the needs of the social masses. The orientation of public opinion information in today’s society will cause huge social repercussions, so it is very important to carry out its monitoring work. Public discourse text information is an important aspect, and more attention should be paid to text sentiment analysis.Naive Bayes is a hypothetical concept [17]. First, assume that the conditions are established, so that the joint behavior turns to differentiation, then gradually solve the probability, and finally apply the conditional probability to calculate.After multiplying the probabilities, add the maximum likelihood value to solve(4)PX=x，Y=Ck=PY=CkPX=x|Y=Ck,PY=Ck=countY=CkN.The prior probability is represented byPY=Ck. The maximum likelihood value proposed above also speaks of it. Usually the value of x is not easy to determine, which brings great difficulty to our calculation, so we have to carry out what-if analysis and use conditional independence and likelihood value to perform calculation operations:(5)PX=x|Y=Ck=PX1=x1,…,Xn=xn|Y=Ck=∏i=1nPXi=xi|Y=Ck,PXi=xi|Y=Ck=countXi=xi,yi=ckcountyi=ck.The posterior probability is then obtained, and they value is output:(6)y=argmaxCkPX=x|Y=CkPY=CkPX=x.We can finally get the calculation formula of the classification prediction function by simple conversion:(7)y=argmaxCkPY=Ck∏i=0nPXi=xi|Y=Ck.After the above calculation is carried out, the text sentiment analysis value can be obtained. Then, take corresponding measures to guide public opinion information to avoid unnecessary losses.


### 2.2. Storage and Operation of Information

Sentiment analysis work is very important [15, 18–21]. In the following, a series of refinement operations are performed on the public opinion text information, and the lexical sentiment weights are arranged for the text data. Through keyword search, public opinion overview and early warning operations can be performed, and crawler and training parameters can be appropriately added to store and maintain public opinion data. Its design can be drawn from Figure 2:Figure 2
Analysis of public opinion text data.Because people’s words and deeds on the Internet are relatively free [22–24], the speed of dissemination of public opinion information has reached an unimaginable level, and the huge vocabulary increases the difficulty of its storage. For the main body of teachers and students, network tools are used more frequently, so the task of storing public opinions on campus is more difficult. We recommend using MySQL database technology. It has the characteristics of low overhead, high efficiency, and fast speed. It can run in many environments and has good performance in different scenarios. The data hierarchy is interconnected. The differentiated operation of the monitoring system is realized through Mange management, and it also has comprehensive operation monitoring of sessions, threads, and memory. Then, connect to the database protocol communication layer data and implement SQL parsing and optimization operations through the JDBC driver. The classification structure of MySQL database is shown in Figure 3.Figure 3
MySQL database implementation flow chart.Among them, the MySQL statement has the following advantages: MySQL statement has a good shareability, can share and exchange campus public opinion, and adapt to such a huge network public opinion system on campus. MySQL occupies less memory resources, which can facilitate our later cleaning and maintenance work, and we can run operations with less investment. The MySQL language is easy to use, is open source, and has a wealth of applicable platforms, which is convenient for campus personnel to use.For the data set stored in the database, its reserves are quite huge. We require most of the data to be empty and only extract a small number of clearly representative data as representatives to represent the overall attributes, so as to achieve high efficiency. To identify and analyze public opinion information, we add the model evaluation analysis system to it and propose the precision rateP, recall rate r, F1, and so on. The following calculated values can be obtained through matrix operations:(8)P=TPTP+FP,r=TPTP+FN,F1=2TP2TP+FP+FN,acc=TP+TNTP+FP+TN+FN.P is the overall analysis result of the predictive model, and r is the positive scale of the data. The F1 value represents the average value of the reciprocal, and acc is the accuracy of the data, which is the proportion of all data. After the abovementioned data storage analysis, the orientation of campus public opinion can be clearly drawn, so that we can conduct more accurate and precise guidance and facilitate the direction of public opinion.


## 2.1. Text Analysis and Calculation of Public Opinion

The following is the application of the TF-IDF method. We can calculate and add vocabulary weights on the basis of the original documents and assign different weights to different words, so as to achieve the division of importance. When a word appears more than average, it can be considered representative, and we perform TF-IDF assignment operation on it. This can make the entire corpus weighted, making it easier to judge the orientation of campus public opinion. This formula can be converted into document feature values for operation when the number of occurrences of words in the article is too large. Specifically, it is a weight addition and subtraction operation for dividing the importance level. The formula for calculating the TF value is as follows:(1)TFi,j=ni,jΣknk,j.Among them,TFi,j represents the TF value of the ith word of the jth article, ni,j represents the frequency of the ith word of the jth article, Σknk,j represents the frequency of occurrence of all words in the jth article, and k refers to the vocabulary size contained in the jth article. The introduction of the IDF calculation formula allows us to facilitate its calculation process, as shown below:(2)IDFi,j=logD1+Dti.IDFi,j can be specific to the IDF value of the ith word in the jth article, D represents the total number of text data, and Dti represents the text number of ti.The overall calculation formula of the TF-IDF value is as follows:(3)TF−IDFi,j=TFi,j×IDFi,j.After a large number of TF weight operations [16], extract basic emotional information from text information, so that we can understand the general orientation of public opinion and better study its control methods. Public opinion information is the expression and expression of people’s emotions, reflecting the needs of the social masses. The orientation of public opinion information in today’s society will cause huge social repercussions, so it is very important to carry out its monitoring work. Public discourse text information is an important aspect, and more attention should be paid to text sentiment analysis.Naive Bayes is a hypothetical concept [17]. First, assume that the conditions are established, so that the joint behavior turns to differentiation, then gradually solve the probability, and finally apply the conditional probability to calculate.After multiplying the probabilities, add the maximum likelihood value to solve(4)PX=x，Y=Ck=PY=CkPX=x|Y=Ck,PY=Ck=countY=CkN.The prior probability is represented byPY=Ck. The maximum likelihood value proposed above also speaks of it. Usually the value of x is not easy to determine, which brings great difficulty to our calculation, so we have to carry out what-if analysis and use conditional independence and likelihood value to perform calculation operations:(5)PX=x|Y=Ck=PX1=x1,…,Xn=xn|Y=Ck=∏i=1nPXi=xi|Y=Ck,PXi=xi|Y=Ck=countXi=xi,yi=ckcountyi=ck.The posterior probability is then obtained, and they value is output:(6)y=argmaxCkPX=x|Y=CkPY=CkPX=x.We can finally get the calculation formula of the classification prediction function by simple conversion:(7)y=argmaxCkPY=Ck∏i=0nPXi=xi|Y=Ck.After the above calculation is carried out, the text sentiment analysis value can be obtained. Then, take corresponding measures to guide public opinion information to avoid unnecessary losses.


## 2.2. Storage and Operation of Information

Sentiment analysis work is very important [15, 18–21]. In the following, a series of refinement operations are performed on the public opinion text information, and the lexical sentiment weights are arranged for the text data. Through keyword search, public opinion overview and early warning operations can be performed, and crawler and training parameters can be appropriately added to store and maintain public opinion data. Its design can be drawn from Figure 2:Figure 2
Analysis of public opinion text data.Because people’s words and deeds on the Internet are relatively free [22–24], the speed of dissemination of public opinion information has reached an unimaginable level, and the huge vocabulary increases the difficulty of its storage. For the main body of teachers and students, network tools are used more frequently, so the task of storing public opinions on campus is more difficult. We recommend using MySQL database technology. It has the characteristics of low overhead, high efficiency, and fast speed. It can run in many environments and has good performance in different scenarios. The data hierarchy is interconnected. The differentiated operation of the monitoring system is realized through Mange management, and it also has comprehensive operation monitoring of sessions, threads, and memory. Then, connect to the database protocol communication layer data and implement SQL parsing and optimization operations through the JDBC driver. The classification structure of MySQL database is shown in Figure 3.Figure 3
MySQL database implementation flow chart.Among them, the MySQL statement has the following advantages: MySQL statement has a good shareability, can share and exchange campus public opinion, and adapt to such a huge network public opinion system on campus. MySQL occupies less memory resources, which can facilitate our later cleaning and maintenance work, and we can run operations with less investment. The MySQL language is easy to use, is open source, and has a wealth of applicable platforms, which is convenient for campus personnel to use.For the data set stored in the database, its reserves are quite huge. We require most of the data to be empty and only extract a small number of clearly representative data as representatives to represent the overall attributes, so as to achieve high efficiency. To identify and analyze public opinion information, we add the model evaluation analysis system to it and propose the precision rateP, recall rate r, F1, and so on. The following calculated values can be obtained through matrix operations:(8)P=TPTP+FP,r=TPTP+FN,F1=2TP2TP+FP+FN,acc=TP+TNTP+FP+TN+FN.P is the overall analysis result of the predictive model, and r is the positive scale of the data. The F1 value represents the average value of the reciprocal, and acc is the accuracy of the data, which is the proportion of all data. After the abovementioned data storage analysis, the orientation of campus public opinion can be clearly drawn, so that we can conduct more accurate and precise guidance and facilitate the direction of public opinion.


## 3. Model Structure Optimization

### 3.1. Improvements in Energy Delivery

The power generation efficiency of traditional energy is extremely low, so we have carried out related transformations. The inverter, controller, converter, and battery have been properly adjusted, and the effect has improved. The energy initially flows to the controller and then splits into two to the inverter and battery. The inverter mainly supplies power to the equipment, and the battery stores the backup power. The specific implementation is shown in Figure4.Figure 4
Hardware allocation process of energy supply structure.


### 3.2. Upgrade of Information Extraction

Generally speaking, the system of public opinion monitoring can be divided into front and rear ends. In the front-end operation, we mainly perform login options, which can roughly preview the public opinion content, watch the ranking of popular topics, search for keywords, etc., which is the main tool for understanding public opinion information. In terms of the back-end, we sequentially carry out the process of data collection, storage, extraction, and analysis and collect statistics on the collected information, so as to achieve effective monitoring of public opinion information. Its system structure diagram is roughly as shown in Figure5.Figure 5
Structure diagram of public opinion monitoring system.Sentiment analysis of text is extremely important. It is worth emphasizing that we individually revamp and optimize the text sentiment analysis work. We introduce the CNN-BILSTM-ATT sentiment classification model. The CNN neural network has great advantages in capturing information in local areas and can perform analysis operations on high-latitude data. Since the object of our processing is the extremely large campus public opinion information group, it is easy to cause data missing when the CNN pooling layer performs data extraction and analysis on it. RNN has the ability of time processing and can effectively complete some difficult problems in time processing. But, at the same time, when RNN encounters such huge data information, its processing ability is also poor. LSTM has a certain ability to forget data, which is extremely important for text work with a huge amount of information. The forgetting ability of LSTM allows us to exclude those neutral words, or words that are not very helpful for analysis. Finally, combining the respective advantages of these models, we concluded that the CNN-BILSTM model can effectively solve this problem and greatly improve the accuracy of data sentiment analysis. Its comprehensive structure is shown in Figure6.Figure 6
CNN-BILSTM model structure diagram.Introduce the model, adding three gates. The calculations are as follows, each responsible for forgetting filtering, transmitting information, and outputting data. The calculation is as follows:(9)ft=σwf⋅ht−1,xt+bf,it=σwi⋅ht−1,xt+bi,∼ct=tanhwc⋅ht−1,xt+bc,ct=ft∗ct−1+it∗∼ct,ot=σwo⋅ht−1,xt+bo,ht=ot∗tanhct.Sequence detection of convolutional kernels is performed in the convolutional layers of the model. We set this value tom and calculate as follows:(10)ki=tanhui∗w′+b.Among them,ui represents the convolution kernel, and w′=wi,wi+1⋯wi+m−1 is a continuous m vocabulary vector.The output of feature vector calculation at timet is Otf, Otb. Then, Vt is calculated as follows:(11)Vt=Otf+Otb.Assign weights to the BILSTM layer to obtain the target weights, which are calculated as follows:(12)Ut=tanhvtThe final SOFTMAX function can obtain the vectorPt after probabilistic operation and then calculate the weighted average to complete the calculation of each part. The relevant calculations are as follows:(13)Pt=expUt∑t=1mexpUt,at=∑t=1mPt⋅Vt.


### 3.3. Optimization of Data Storage

In the overall framework structure of data storage applications, we are mainly dividing it into the following layers, which are user layer, application management layer, application platform support layer, application service layer, and application device layer.The user layer mainly manages the user’s data information. In the application management layer, the system settings, database, and website modules of public opinion can be applied for hierarchical data management. Subsequently, the development of multiplatform systems provides better system support capabilities. The series of platforms mainly include data acquisition and analysis and communication interfaces. Finally, it comes to the service layer, which is the application for the public, including SMS service, pop-up information service, and report download service. Its overall frame structure is shown in Figure7.Figure 7
Overall framework of data storage applications.This figure depicts the comprehensive framework of the data storage application and its overall architecture. It can be seen from the figure that the application device serves as the underlying device and has the main objects of the service on it, including short messages, information, and other content. The support layer is its core processing layer, which provides the processing work of information technology. The mutual cooperation of each application layer can finally realize the effective operation of data storage.When it comes to data storage work, the first thing that comes to our mind is the extremely large number of chaotic information elements. In the face of these massive data information, it is very difficult for us to extract and analyze valuable factors, but we still have some. The approach makes it less complicated to sift through the data for analysis. The RBF neural structure diagram allows us to understand the principle of its data extraction. Its organizational structure is roughly as shown in Figure8.Figure 8
RBF neural network diagram.(14)GX,cj=e1/2σj2x−cj2,y=∑j=1mGx,cj×wj.In this formula,m is the unit number of hidden neuron G, the output is Y, and the input is X. cj and σj are the length and width data in the hidden layer.(15)Loss=12y^−y2,cj=cj−a∂Loss∂cj=cj+awjσj2y^−yGx,cjx−cj,σj=σj−a∂Loss∂σj=σj+awjσj3y^−yGx,cjx−cj2,wj=wj−a∂Loss∂wj=wj+ay^−yGx,cj,where y^ represents the real result, y is the final result, and a is the learning rate. The RBF neural network data is continuously learned and trained to improve the learning accuracy of data analysis and speed up the learning efficiency on the basis of the machine memory ability. In continuous learning and training, find the best oscillation range. In this way, the maximum learning accuracy is obtained and the most accurate data analysis results are obtained.


## 3.1. Improvements in Energy Delivery

The power generation efficiency of traditional energy is extremely low, so we have carried out related transformations. The inverter, controller, converter, and battery have been properly adjusted, and the effect has improved. The energy initially flows to the controller and then splits into two to the inverter and battery. The inverter mainly supplies power to the equipment, and the battery stores the backup power. The specific implementation is shown in Figure4.Figure 4
Hardware allocation process of energy supply structure.


## 3.2. Upgrade of Information Extraction

Generally speaking, the system of public opinion monitoring can be divided into front and rear ends. In the front-end operation, we mainly perform login options, which can roughly preview the public opinion content, watch the ranking of popular topics, search for keywords, etc., which is the main tool for understanding public opinion information. In terms of the back-end, we sequentially carry out the process of data collection, storage, extraction, and analysis and collect statistics on the collected information, so as to achieve effective monitoring of public opinion information. Its system structure diagram is roughly as shown in Figure5.Figure 5
Structure diagram of public opinion monitoring system.Sentiment analysis of text is extremely important. It is worth emphasizing that we individually revamp and optimize the text sentiment analysis work. We introduce the CNN-BILSTM-ATT sentiment classification model. The CNN neural network has great advantages in capturing information in local areas and can perform analysis operations on high-latitude data. Since the object of our processing is the extremely large campus public opinion information group, it is easy to cause data missing when the CNN pooling layer performs data extraction and analysis on it. RNN has the ability of time processing and can effectively complete some difficult problems in time processing. But, at the same time, when RNN encounters such huge data information, its processing ability is also poor. LSTM has a certain ability to forget data, which is extremely important for text work with a huge amount of information. The forgetting ability of LSTM allows us to exclude those neutral words, or words that are not very helpful for analysis. Finally, combining the respective advantages of these models, we concluded that the CNN-BILSTM model can effectively solve this problem and greatly improve the accuracy of data sentiment analysis. Its comprehensive structure is shown in Figure6.Figure 6
CNN-BILSTM model structure diagram.Introduce the model, adding three gates. The calculations are as follows, each responsible for forgetting filtering, transmitting information, and outputting data. The calculation is as follows:(9)ft=σwf⋅ht−1,xt+bf,it=σwi⋅ht−1,xt+bi,∼ct=tanhwc⋅ht−1,xt+bc,ct=ft∗ct−1+it∗∼ct,ot=σwo⋅ht−1,xt+bo,ht=ot∗tanhct.Sequence detection of convolutional kernels is performed in the convolutional layers of the model. We set this value tom and calculate as follows:(10)ki=tanhui∗w′+b.Among them,ui represents the convolution kernel, and w′=wi,wi+1⋯wi+m−1 is a continuous m vocabulary vector.The output of feature vector calculation at timet is Otf, Otb. Then, Vt is calculated as follows:(11)Vt=Otf+Otb.Assign weights to the BILSTM layer to obtain the target weights, which are calculated as follows:(12)Ut=tanhvtThe final SOFTMAX function can obtain the vectorPt after probabilistic operation and then calculate the weighted average to complete the calculation of each part. The relevant calculations are as follows:(13)Pt=expUt∑t=1mexpUt,at=∑t=1mPt⋅Vt.


## 3.3. Optimization of Data Storage

In the overall framework structure of data storage applications, we are mainly dividing it into the following layers, which are user layer, application management layer, application platform support layer, application service layer, and application device layer.The user layer mainly manages the user’s data information. In the application management layer, the system settings, database, and website modules of public opinion can be applied for hierarchical data management. Subsequently, the development of multiplatform systems provides better system support capabilities. The series of platforms mainly include data acquisition and analysis and communication interfaces. Finally, it comes to the service layer, which is the application for the public, including SMS service, pop-up information service, and report download service. Its overall frame structure is shown in Figure7.Figure 7
Overall framework of data storage applications.This figure depicts the comprehensive framework of the data storage application and its overall architecture. It can be seen from the figure that the application device serves as the underlying device and has the main objects of the service on it, including short messages, information, and other content. The support layer is its core processing layer, which provides the processing work of information technology. The mutual cooperation of each application layer can finally realize the effective operation of data storage.When it comes to data storage work, the first thing that comes to our mind is the extremely large number of chaotic information elements. In the face of these massive data information, it is very difficult for us to extract and analyze valuable factors, but we still have some. The approach makes it less complicated to sift through the data for analysis. The RBF neural structure diagram allows us to understand the principle of its data extraction. Its organizational structure is roughly as shown in Figure8.Figure 8
RBF neural network diagram.(14)GX,cj=e1/2σj2x−cj2,y=∑j=1mGx,cj×wj.In this formula,m is the unit number of hidden neuron G, the output is Y, and the input is X. cj and σj are the length and width data in the hidden layer.(15)Loss=12y^−y2,cj=cj−a∂Loss∂cj=cj+awjσj2y^−yGx,cjx−cj,σj=σj−a∂Loss∂σj=σj+awjσj3y^−yGx,cjx−cj2,wj=wj−a∂Loss∂wj=wj+ay^−yGx,cj,where y^ represents the real result, y is the final result, and a is the learning rate. The RBF neural network data is continuously learned and trained to improve the learning accuracy of data analysis and speed up the learning efficiency on the basis of the machine memory ability. In continuous learning and training, find the best oscillation range. In this way, the maximum learning accuracy is obtained and the most accurate data analysis results are obtained.


## 4. Experimental Simulation

### 4.1. Experimental Scheme

At the end of the experiment, we conduct a comparative analysis of the algorithm to verify its practical effect. Research campus public opinion information is the analysis object of the monitoring model. We compare multiple sets of data and obtain corresponding results by statistics on the efficiency of text sentiment analysis, the amount of text information analysis, and the delay in time transmission. The specific plans are as follows:Option 1: TF-IDF method and MySQL database screening for public opinion data analysisOption 2: TF-IDF method combined with MySQL database to provide energy-optimized public opinion data analysisOption 3: TF-IDF method, public opinion data analysis after introducing CNN-BILSTM-ATT sentiment classification model into MySQL databaseScheme 1: TF-IDF method, MySQL database combined with CNN-BILSTM-ATT sentiment classification model and RBF neural network to analyze the final public opinion information


### 4.2. Public Opinion Analysis and Comparison

Through the design of the above four schemes, we respectively set up a public opinion sentiment analysis experiment with the number of public opinion data information as 200, 500, 1000, and 3000 as the basic amount of data 3000. The results can clearly see the strength of each scheme for sentiment analysis. The specific comparison is shown in Figure9.Figure 9
Comparison of public opinion sentiment analysis.In the following, we will study the time analysis efficiency of various schemes. In the specified unit time, the algorithm analysis amount of schemes 1–4 will be counted, respectively. After comparison, it can be clearly seen that the optimization of scheme 1 has improved significantly. Especially after 4 minutes, the pros and cons of the algorithm are more obvious. The amount of data analysis of scheme 1 is significantly higher than that of other categories. It can be seen more clearly the data analysis ability of our optimized model. The quantitative analysis comparison is shown in Figure10.Figure 10
Unit time analysis and comparison chart.Time efficiency is an important performance metric in any algorithm. The amount of data transmission per unit time of the algorithm is one of the important manifestations. It can be clearly seen from the time delay comparison analysis chart of the four algorithms that the time loss of scheme 1 is significantly lower than that of other algorithms. From left to right, the amount of data selected by the time delay is 100, 300, 500, and 1000, and the specific time loss comparison is shown in Figure11.Figure 11
Unit data time delay diagram.Next, we use the fixed length of public opinion texts as a statistic to explore the efficiency ratio of each scheme to show the distribution of the highest efficiency. Not surprisingly, scheme 1 is the least efficient, while scheme 1 accounts for more than half of the total analysis efficiency, which is equivalent to the sum of the other three algorithms. The specific efficiency distribution is shown in Figure12.Figure 12
Efficiency ratio of text length analysis.In the division of market satisfaction based on a fixed number of people, Schemes 1–4 have achieved different results. In the comparative analysis chart, the superiority of option 4 can be clearly seen, and its satisfaction level even reaches about 95%, which clearly shows the public’s recognition of it, specifically as shown in Figure13.Figure 13
Market satisfaction.


### 4.3. Analysis and Evaluation of Public Opinion

Among the numerous information data, we finally obtained two forms through the algorithm collection and analysis, one is the relevant information introduction of the search, and the other is the user’s information description. In the search information, we can clearly know the user ID, the completion time of the search, the number of likes and retweets, etc., and even the text content of the search relevance. In the user specific information, we can learn some content, such as name and age. The acquisition of the following information data enables us to quickly understand the direction of public opinion dissemination, which brings great convenience to the detection work and more effectively controls the development of public opinion. The details are shown in Tables1 and 2.Table 1
Search information table.
IdPrimary keyUser-idUser IDLike-numLikesRetweet-numNumber of retweetsKeywordSearch keywordCreate-timeFirst acquisition timeUpdate-timeLast acquisition timeTargetSearch titleHrefSearch linkClickHave hitsRankHeatTagIs it relevantTable 2
User information table.
Field nameExplainIdPrimary keyNicknameUsernameGenderUser genderLocationUser locationDescriptionUser profileKeywordUser search contentTalentUser creditWorkUser work informationIn order to further verify the practical application ability of the public opinion data improvement model, we conducted a comprehensive data collection and analysis experiment, using the optimal algorithm for experimental operation, and running the algorithm under the condition that the optimal parameters are set as the benchmark to obtain the data in Table3. It can be seen that the accuracy of the analysis of public opinion information in this experiment is very high, with an average of more than 95%. The specific situation is as follows:Table 3
Comprehensive data analysis table.
Data setCorrect rate (%)Recall (%)Cluster191.0289.56Cluster294.5792.65Cluster392.0996.77Cluster493.2583.59Cluster598.5796.64Cluster695.6591.56


## 4.1. Experimental Scheme

At the end of the experiment, we conduct a comparative analysis of the algorithm to verify its practical effect. Research campus public opinion information is the analysis object of the monitoring model. We compare multiple sets of data and obtain corresponding results by statistics on the efficiency of text sentiment analysis, the amount of text information analysis, and the delay in time transmission. The specific plans are as follows:Option 1: TF-IDF method and MySQL database screening for public opinion data analysisOption 2: TF-IDF method combined with MySQL database to provide energy-optimized public opinion data analysisOption 3: TF-IDF method, public opinion data analysis after introducing CNN-BILSTM-ATT sentiment classification model into MySQL databaseScheme 1: TF-IDF method, MySQL database combined with CNN-BILSTM-ATT sentiment classification model and RBF neural network to analyze the final public opinion information


## 4.2. Public Opinion Analysis and Comparison

Through the design of the above four schemes, we respectively set up a public opinion sentiment analysis experiment with the number of public opinion data information as 200, 500, 1000, and 3000 as the basic amount of data 3000. The results can clearly see the strength of each scheme for sentiment analysis. The specific comparison is shown in Figure9.Figure 9
Comparison of public opinion sentiment analysis.In the following, we will study the time analysis efficiency of various schemes. In the specified unit time, the algorithm analysis amount of schemes 1–4 will be counted, respectively. After comparison, it can be clearly seen that the optimization of scheme 1 has improved significantly. Especially after 4 minutes, the pros and cons of the algorithm are more obvious. The amount of data analysis of scheme 1 is significantly higher than that of other categories. It can be seen more clearly the data analysis ability of our optimized model. The quantitative analysis comparison is shown in Figure10.Figure 10
Unit time analysis and comparison chart.Time efficiency is an important performance metric in any algorithm. The amount of data transmission per unit time of the algorithm is one of the important manifestations. It can be clearly seen from the time delay comparison analysis chart of the four algorithms that the time loss of scheme 1 is significantly lower than that of other algorithms. From left to right, the amount of data selected by the time delay is 100, 300, 500, and 1000, and the specific time loss comparison is shown in Figure11.Figure 11
Unit data time delay diagram.Next, we use the fixed length of public opinion texts as a statistic to explore the efficiency ratio of each scheme to show the distribution of the highest efficiency. Not surprisingly, scheme 1 is the least efficient, while scheme 1 accounts for more than half of the total analysis efficiency, which is equivalent to the sum of the other three algorithms. The specific efficiency distribution is shown in Figure12.Figure 12
Efficiency ratio of text length analysis.In the division of market satisfaction based on a fixed number of people, Schemes 1–4 have achieved different results. In the comparative analysis chart, the superiority of option 4 can be clearly seen, and its satisfaction level even reaches about 95%, which clearly shows the public’s recognition of it, specifically as shown in Figure13.Figure 13
Market satisfaction.


## 4.3. Analysis and Evaluation of Public Opinion

Among the numerous information data, we finally obtained two forms through the algorithm collection and analysis, one is the relevant information introduction of the search, and the other is the user’s information description. In the search information, we can clearly know the user ID, the completion time of the search, the number of likes and retweets, etc., and even the text content of the search relevance. In the user specific information, we can learn some content, such as name and age. The acquisition of the following information data enables us to quickly understand the direction of public opinion dissemination, which brings great convenience to the detection work and more effectively controls the development of public opinion. The details are shown in Tables1 and 2.Table 1
Search information table.
IdPrimary keyUser-idUser IDLike-numLikesRetweet-numNumber of retweetsKeywordSearch keywordCreate-timeFirst acquisition timeUpdate-timeLast acquisition timeTargetSearch titleHrefSearch linkClickHave hitsRankHeatTagIs it relevantTable 2
User information table.
Field nameExplainIdPrimary keyNicknameUsernameGenderUser genderLocationUser locationDescriptionUser profileKeywordUser search contentTalentUser creditWorkUser work informationIn order to further verify the practical application ability of the public opinion data improvement model, we conducted a comprehensive data collection and analysis experiment, using the optimal algorithm for experimental operation, and running the algorithm under the condition that the optimal parameters are set as the benchmark to obtain the data in Table3. It can be seen that the accuracy of the analysis of public opinion information in this experiment is very high, with an average of more than 95%. The specific situation is as follows:Table 3
Comprehensive data analysis table.
Data setCorrect rate (%)Recall (%)Cluster191.0289.56Cluster294.5792.65Cluster392.0996.77Cluster493.2583.59Cluster598.5796.64Cluster695.6591.56


## 5. Conclusion

In today’s network information age, with the continuous popularization of network use, the amount of public opinion information is huge, and its management and monitoring are increasingly important. It is necessary to supervise and control the sensitive information and guide the trend of public opinion reasonably. These are all we need to do. In campus public opinion, topics with political tendencies are particularly important. If some negative emotions are added to them, it may affect the public’s value orientation and bring about serious social problems. We must take measures to control them. This paper uses TF-IDF method to add and subtract weights and MySQL database and CNN-BILSTM-ATT sentiment classification model, combined with RBF neural network, to extract and analyze public opinion texts. Then, add a text sentiment analysis model for algorithm analysis. Implement the search and supervision of user information, and achieve a comprehensive upgrade of the accuracy of public opinion monitoring. It effectively avoids the serious problems caused by bad public opinion information. After a series of optimizations, it is more in line with the needs of campus public opinion monitoring. The monitoring of campus public opinion is of great practical significance. This paper mainly conducts exploration and research on public opinion text information and does not involve media such as pictures, voice, and video. Since these are also important aspects that reflect the trend of public opinion of the masses, comprehensive consideration of these will also be added in future research to expand public opinion monitoring, depth and width. Through the development of network modules, we improve its functions and continuously promote the construction of smart campuses.



---

*Source: 8294613-2022-06-14.xml*