# Research on the Management Information System of College Education and Teaching Based on Web

Authors: Jinhua Liu; Caiping Wang; Yanhua Wu
Journal: Security and Communication Networks
 (2021)

---

## Abstract

The traditional university education and teaching management information system has the problems of low information recall, poor information precision, and long query time. Therefore, this paper designs a university education and teaching management information system based on Web. Through the analysis of the requirements of the higher education and teaching management information system, the design principle of the system is determined, and the structure design of the higher education and teaching management information system is realized; the teaching management information system management process is determined. By calculating the complexity of university education and teaching management information, the priority of query information is determined to effectively improve the processing effect of the system. Finally, the relational database model is designed to realize the design of university education and teaching management information system. In order to verify the effectiveness of this method, comparative experiments are designed. Experimental results show that this method can effectively improve the low information recall and the poor information precision and shorten the query time.


---

## Body

## 1. Introduction

With the popularization of CERNET in all kinds of schools and education management departments at all levels in China, the information construction of education management has entered a new stage of development. The campus network based on Internet technology has gradually broken the original closed and independent management mode of education management and started to transform to an interconnected and open system [1]. However, the current research on teaching management information system has begun to take shape, but the actual application is still in its infancy [2]. In addition to the insufficient investment in education funds and the weak basic environment of school informatization, the main reasons are as follows: ① The lack of standards for teaching management information system results in great data redundancy and waste of resources, which makes it difficult to realize resource sharing and system interoperability; or just standardizing data cannot solve the problem of interoperability between different systems. Many original independent teaching management information systems have made outstanding contributions to the scientization of education management. However, due to the mutual closure and independent operation of teaching, finance, personnel, equipment, scientific research, and other single management systems developed in different periods and departments, it not only causes great data redundancy and resource waste but also makes it difficult to realize information sharing through the network [3]. ② The information quality of educational administrators is relatively backward; in particular, whether the leading cadres at all levels have the awareness of modern information management is the key factor in the development and application of campus network management information system. If school leaders and education administrators do not have the awareness of modern information management and lack of understanding of the role and characteristics of modern information management, they will not pay attention to and care about the development and use of teaching management information system, which will bring about insurmountable obstacles to the development and application of the system [4]. Recently, some schools even have established a relatively perfect teaching management information system, but, due to the defects of some managers in consciousness, ability, and other aspects, as well as the role of conservative factors in the work process, the teaching management information system cannot be fully used and developed.Relevant scholars have made some progress in this field. Shi and others proposed the design of university teaching management information system based on MVP mode [5]. The system adopts the more advanced MVP (Model View Presenter) software design mode and divides the system framework into three layers: model (business logic layer), presenter (moderator layer), and view (view layer). On the basis of the system framework, the hardware used in the system is introduced in detail, including the main control chip and communication network. According to the functional requirements of the system, the system is mainly divided into login module, teacher management module, student management module, public management module, daily management module of educational administration, and system management module, and the throughput performance of the system is compared and analyzed. The results show the following: when 20000 people visit the system at the same time, QPS (queries per second), concurrency number, the number of queries per second, the average response time, and other parameters meet the throughput requirements of the system. Rongjie and Liangnan designed the course of management information system based on the BOPPPS model [6]. In view of the characteristics and problems of the course content of management information system, this paper tries to introduce the BOPPPS learning mode into the management information system classroom and takes the chapter “business information system in career,” which is more comprehensive and difficult to teach, as an example to design the teaching of BOPPPS, so as to achieve interaction and high efficiency. At the same time, it further discusses the specific path and matters needing attention to promote the interactive learning advocated by BOPPPS learning mode and the concept of course modularization to other courses in business school. GanQihong et al. Proposed the design and implementation of university teaching equipment management system based on SSM framework [7]. It is of great significance to use information technology to support teaching equipment management and help the whole process of fine management reform of teaching equipment. The system technology architecture based on SSM framework is built. Finally, the key algorithms and system examples in the development of the system are given. The experimental test shows that the system includes three functional modules of equipment information management, maintenance management, and operation management, which can realize the informatization of teaching equipment, the whole process, and fine management, and lays the foundation for intelligent management.Information security management refers to the establishment of information security policies and objectives in the overall or specific scope. The organization is required to establish an information security management system by determining the scope of the information security management system, formulating the information security policy, clarifying the management responsibilities, and choosing control objectives and control methods based on risk assessment. To get a truly comprehensive cloud computing service, security is a priority. At the same time, how to better establish the enterprise’s own information security management has become the focus of the industry.However, there are some problems in the above methods, such as poor data recall and long query time. Therefore, this paper proposes a Web-based university education and teaching management information system. It is a comprehensive teaching management software system which takes teaching management as the core and integrates educational administration management, student status management, teacher student management, school production management, book management, and system management. Through the network teaching management information system, education administrators, teachers, and students can query, analyze, and process the information in the process of education anytime and anywhere, so as to accurately and timely reflect the current state of the school's work, use the past data to predict the future, and assist the school's functional departments and principals to manage the school from the overall situation. The network teaching management information system also has a clear meaning of the times, which can meet the requirements of the change of work style in the information age and realize the requirements of informatization, scientization, and modernization of school management to meet the needs of assisting school administrators to make correct decisions.Our contribution is threefold:(1)
The traditional university education and teaching management information system has the problems of low information recall, poor information precision, and long query time. Therefore, this paper designs a university education and teaching management information system based on Web.(2)
Through the analysis of the requirements of the higher education and teaching management information system, the design principle of the system is determined, and the structure design of the higher education and teaching management information system is realized.(3)
Experimental results show that this method can effectively improve the low information recall and poor information precision and shorten the query time.The remainder of this paper is organized as follows. Section2 introduces the information system of education and teaching management. Section 3 discusses the software design of university education and teaching management information system. Section 4 discusses database design of management information system. Section 5 discusses experiment and analysis. Section 6 presents the conclusions of the study.


## 2. Information System of Education and Teaching Management Based on Web

### 2.1. System Requirement Analysis

System demand analysis is one of the most important links in the system development. It is the basis of analysis and design to investigate comprehensively from facts. System requirements analysis is an important document in the system analysis stage, it is a milestone, marking the end of the analysis phase, and it is the starting point and basis of the system design stage. It determines whether the next stage of system development can be smoothly carried out, and it is also a contract, which defines the new system that the system developer must deliver to the user [8]. In addition, according to the research of Boehm, the demand of software, its application scope, and its complexity are growing continuously without limitation; 85% of the resources consumed need management, design, testing, planning, project management control, change management, and tool development, which need to be considered with equal importance. Only 15 percent of software development work is dedicated to coding. Thus, how important the demand analysis is can be seen. The purpose of system analysis is to determine the user’s requirements and solutions, including the developer’s understanding of the existing organizational management status. The user needs the function of information system: data business process, management function, and management data index system. The new system is to be modified and the new management model is added.On the basis of extensive demand survey, the research group determines the overall function of the system, divides the system into various functional modules according to the overall function of the system, and determines the methods to realize various functions. The system adopts the combination of B/S mode and C/S mode, which is a new software architecture. Not only is it conducive to the sharing of information resources, easy to operate, and upgradable and maintainable, but also it ensures the data security to a certain extent [9]. The database adopts Microsoft SQL Server 2000, which is easy to use and provides support for massive data; Dreamweaver MX 2004 is used as the design platform, asp.net Web database middleware technology is used to develop Web pages, and ADO (active X data object) technology and OLEDB are used to connect and access the database. Most of the pages of the system add instructions or tips to facilitate users to use the functions provided by the system. Users can operate the system well by simple input or selection.


### 2.2. Design Principle of the System

(1)
System Positioning. When establishing a network information system, we must first make clear who the service object of the system is and what aspects of management the system should mainly complete [10]. For different objects and different user groups, the function of the system has different requirements.(2)
System Scale. The scale of the system has a great influence on the overall scheme of the system and the performance requirements of the software and hardware in the system. The system scale mainly refers to the number of system users, the amount of data processing, the number of functional modules, and so on. It can be said that the scale of the system will affect the overall technical solution of the system to some extent. In addition, the scale of the system also has requirements for the software and hardware of the system [11]. If there are few users in the system, the processing speed of the server, the number of ports of the switch, and the transmission rate of the backbone network can be relatively small. On the contrary, the high-speed server, the switch with more ports, and the backbone network with higher transmission rate must be used.(3)
The Advanced Nature and Rationality of Technology. Generally speaking, the development system is expected to have the best technology and the most powerful function. In the actual system design, we should consider the advanced factors of the technology and the rationality of the practical application according to the comprehensive factors, such as system location and system scale, so as to achieve the optimal performance price ratio [12].(4)
System Security. This is one of the most important and core technologies of the network development system. To realize the information management system in the network environment, it is necessary to manage every login user account and provide a security mechanism [13].(5)
Good Interaction. Good interactivity can realize resource sharing and timely information processing, which requires a user interface that is easy to operate and intuitive.In conclusion, the system function should be determined according to the system positioning and system scale in the system design, and then different specific implementation technologies should be selected according to the specific functional requirements.


### 2.3. Structure Design of the System

The system adopts modular structure, and the division and design of each module strictly follow the principle of high cohesion and low coupling [14]. Each submodule is called by the main module, and each submodule completes a relatively independent function. Each submodule can be developed, tested, and modified independently and finally forms the whole system, so the system has good scalability. The system is divided into eight modules; the system structure is shown in Figure 1, and the system flow chart is shown in Figure 2.Figure 1
System structure diagram.Figure 2
System flow chart.


## 2.1. System Requirement Analysis

System demand analysis is one of the most important links in the system development. It is the basis of analysis and design to investigate comprehensively from facts. System requirements analysis is an important document in the system analysis stage, it is a milestone, marking the end of the analysis phase, and it is the starting point and basis of the system design stage. It determines whether the next stage of system development can be smoothly carried out, and it is also a contract, which defines the new system that the system developer must deliver to the user [8]. In addition, according to the research of Boehm, the demand of software, its application scope, and its complexity are growing continuously without limitation; 85% of the resources consumed need management, design, testing, planning, project management control, change management, and tool development, which need to be considered with equal importance. Only 15 percent of software development work is dedicated to coding. Thus, how important the demand analysis is can be seen. The purpose of system analysis is to determine the user’s requirements and solutions, including the developer’s understanding of the existing organizational management status. The user needs the function of information system: data business process, management function, and management data index system. The new system is to be modified and the new management model is added.On the basis of extensive demand survey, the research group determines the overall function of the system, divides the system into various functional modules according to the overall function of the system, and determines the methods to realize various functions. The system adopts the combination of B/S mode and C/S mode, which is a new software architecture. Not only is it conducive to the sharing of information resources, easy to operate, and upgradable and maintainable, but also it ensures the data security to a certain extent [9]. The database adopts Microsoft SQL Server 2000, which is easy to use and provides support for massive data; Dreamweaver MX 2004 is used as the design platform, asp.net Web database middleware technology is used to develop Web pages, and ADO (active X data object) technology and OLEDB are used to connect and access the database. Most of the pages of the system add instructions or tips to facilitate users to use the functions provided by the system. Users can operate the system well by simple input or selection.


## 2.2. Design Principle of the System

(1)
System Positioning. When establishing a network information system, we must first make clear who the service object of the system is and what aspects of management the system should mainly complete [10]. For different objects and different user groups, the function of the system has different requirements.(2)
System Scale. The scale of the system has a great influence on the overall scheme of the system and the performance requirements of the software and hardware in the system. The system scale mainly refers to the number of system users, the amount of data processing, the number of functional modules, and so on. It can be said that the scale of the system will affect the overall technical solution of the system to some extent. In addition, the scale of the system also has requirements for the software and hardware of the system [11]. If there are few users in the system, the processing speed of the server, the number of ports of the switch, and the transmission rate of the backbone network can be relatively small. On the contrary, the high-speed server, the switch with more ports, and the backbone network with higher transmission rate must be used.(3)
The Advanced Nature and Rationality of Technology. Generally speaking, the development system is expected to have the best technology and the most powerful function. In the actual system design, we should consider the advanced factors of the technology and the rationality of the practical application according to the comprehensive factors, such as system location and system scale, so as to achieve the optimal performance price ratio [12].(4)
System Security. This is one of the most important and core technologies of the network development system. To realize the information management system in the network environment, it is necessary to manage every login user account and provide a security mechanism [13].(5)
Good Interaction. Good interactivity can realize resource sharing and timely information processing, which requires a user interface that is easy to operate and intuitive.In conclusion, the system function should be determined according to the system positioning and system scale in the system design, and then different specific implementation technologies should be selected according to the specific functional requirements.


## 2.3. Structure Design of the System

The system adopts modular structure, and the division and design of each module strictly follow the principle of high cohesion and low coupling [14]. Each submodule is called by the main module, and each submodule completes a relatively independent function. Each submodule can be developed, tested, and modified independently and finally forms the whole system, so the system has good scalability. The system is divided into eight modules; the system structure is shown in Figure 1, and the system flow chart is shown in Figure 2.Figure 1
System structure diagram.Figure 2
System flow chart.


## 3. Software Design of University Education and Teaching Management Information System

### 3.1. Information Complexity Calculation

SettingPw represents the activity of the educational and teaching managers in colleges and universities, which is used to describe the total amount of information in period T of the information of the education and teaching of colleges and universities S, and the expression is as follows:(1)Pw=e−∑i=1Sweightti−1,where weightti represents the time weight function; ti is the interval time.SetVw as the cumulative amount of information transmission; through the importance of university education and teaching management personnel to the system released in period T, the calculation formula is as follows:(2)Vw=e−∑i=1Smi×weightti−1,where M represents the amount of information in the i packet.Wpro represents the weight of the teaching management personnel in colleges and universities. It is calculated by the activity of the teaching managers Pw and the cumulative transmission of information:(3)Wpro=ωPw+1−ωVw,where ω represents the corresponding weight factor of the teaching and education managers in colleges and universities, which is taken in the interval [0, 1]. Through the test, it is found that the weight factor ω is 0.4, and the best effect is that w is equal to 0.5.SettingCmod represents the module complexity. Based on the data flow diagram and system architecture diagram, the complexity of each submodule in the monitoring system is calculated:(4)Cmod=∑i=1nevGi,where n represents the number of modules in the system and evGi is the corresponding complexity of the i-th submodule in the system.SetCdes as the design complexity, which is calculated based on the calling relationship between the module and the system:(5)Cdes=∑i=1n∑j=1nCi,j,where Ci,j describes whether module j is called by module i. When the value of Ci,j is 1, it indicates that module j is called by module i. A value of 0 for Ci,j indicates that module j is not called by module I.Assume thatCstr represents the complexity of teaching management data in colleges and universities, which is measured by the length and total number of paths in the data flow diagram. Its calculation formula is as follows:(6)Cstr=∑k=1mLk,where m represents the total number of paths in the data flow graph and Lk is the length of the k path.The information complexityCstr is obtained through the above process, and its calculation formula is as follows:(7)Cstr=αCmod+βCdes+γCtas,where parameters α, β, and γ meet the following equation:(8)α+β+γ=1.LetB represent information benefit, which can be calculated by the following formula:(9)B=e−Ctas/Q.Here,Q represents the total price of information.


### 3.2. Information Priority Extraction

LetU be the corresponding emergency degree of education and teaching information in colleges and universities:(10)U=e−AT/Ctas,where AT represents the information period.The design method of Web-based university education and teaching information management system calculates the information weightWtas by logarithmic logistic model.(11)Wtas=11+e−λB−μU,where λ represents the weight factor corresponding to the information benefit; parameters λ and μ satisfy the following equation:(12)λ+μ=1.Letδ represent the priority of information, which can be calculated by information weight Wtas:(13)δ=φWpro+1−φWtas.Here,φ represents the priority factor of higher education and teaching information, which is in the interval [0, 1]. According to the investigation, when the value of priority factor φ is 0.6, the higher education and teaching information priority is obtained [15].


## 3.1. Information Complexity Calculation

SettingPw represents the activity of the educational and teaching managers in colleges and universities, which is used to describe the total amount of information in period T of the information of the education and teaching of colleges and universities S, and the expression is as follows:(1)Pw=e−∑i=1Sweightti−1,where weightti represents the time weight function; ti is the interval time.SetVw as the cumulative amount of information transmission; through the importance of university education and teaching management personnel to the system released in period T, the calculation formula is as follows:(2)Vw=e−∑i=1Smi×weightti−1,where M represents the amount of information in the i packet.Wpro represents the weight of the teaching management personnel in colleges and universities. It is calculated by the activity of the teaching managers Pw and the cumulative transmission of information:(3)Wpro=ωPw+1−ωVw,where ω represents the corresponding weight factor of the teaching and education managers in colleges and universities, which is taken in the interval [0, 1]. Through the test, it is found that the weight factor ω is 0.4, and the best effect is that w is equal to 0.5.SettingCmod represents the module complexity. Based on the data flow diagram and system architecture diagram, the complexity of each submodule in the monitoring system is calculated:(4)Cmod=∑i=1nevGi,where n represents the number of modules in the system and evGi is the corresponding complexity of the i-th submodule in the system.SetCdes as the design complexity, which is calculated based on the calling relationship between the module and the system:(5)Cdes=∑i=1n∑j=1nCi,j,where Ci,j describes whether module j is called by module i. When the value of Ci,j is 1, it indicates that module j is called by module i. A value of 0 for Ci,j indicates that module j is not called by module I.Assume thatCstr represents the complexity of teaching management data in colleges and universities, which is measured by the length and total number of paths in the data flow diagram. Its calculation formula is as follows:(6)Cstr=∑k=1mLk,where m represents the total number of paths in the data flow graph and Lk is the length of the k path.The information complexityCstr is obtained through the above process, and its calculation formula is as follows:(7)Cstr=αCmod+βCdes+γCtas,where parameters α, β, and γ meet the following equation:(8)α+β+γ=1.LetB represent information benefit, which can be calculated by the following formula:(9)B=e−Ctas/Q.Here,Q represents the total price of information.


## 3.2. Information Priority Extraction

LetU be the corresponding emergency degree of education and teaching information in colleges and universities:(10)U=e−AT/Ctas,where AT represents the information period.The design method of Web-based university education and teaching information management system calculates the information weightWtas by logarithmic logistic model.(11)Wtas=11+e−λB−μU,where λ represents the weight factor corresponding to the information benefit; parameters λ and μ satisfy the following equation:(12)λ+μ=1.Letδ represent the priority of information, which can be calculated by information weight Wtas:(13)δ=φWpro+1−φWtas.Here,φ represents the priority factor of higher education and teaching information, which is in the interval [0, 1]. According to the investigation, when the value of priority factor φ is 0.6, the higher education and teaching information priority is obtained [15].


## 4. Database Design of the Management Information System for College Education and Teaching

### 4.1. System Database Core Design

The database of university education and teaching management information system is divided into two parts: the general control center database and the subcontrol center database.The database of the main control center is the core part of the remote network teaching system. It is particularly important to support the operation of the whole system. In order to efficiently integrate all the information and resource data of the whole system, the capacity, stability, and operation efficiency of the database must be fully considered in the construction of the database of the general control center. In order to make the main control center database able to effectively meet the daily information reading, backup, and other needs, one way is to select the appropriate hardware platform to provide the necessary hardware support for the system, and another is to select an efficient and stable database management system to realize the complete management of data. Database construction is the core part of the network distance education system, which plays a vital role. From the functional point of view, it mainly covers system use case analysis, data management, financial management, identity authentication, security management, and so on. As the data storage point of the whole system, the central host system of the system construction manages and processes the data storage and transmission of the whole system. The system design adopts a typical three-tier system architecture. In its architecture design, it covers two functional servers: central database server and teaching management platform. Among them, teaching management platform includes data management server, security server, identity authentication server, and other related equipment servers.


### 4.2. Relational Database Model

The logic structure of the system is divided into two types: conceptual mode and external mode. According to these two modes, the database design of the system can be carried out, and the object patterns can be transformed into fictitious database tables to get the table pattern (conceptual model). External tables (external models) can be associated with table models through database views or interface programs. Finally, the concept table is converted to an internal pattern, as shown in Figure3.Figure 3
Transformation of object model and database model.


## 4.1. System Database Core Design

The database of university education and teaching management information system is divided into two parts: the general control center database and the subcontrol center database.The database of the main control center is the core part of the remote network teaching system. It is particularly important to support the operation of the whole system. In order to efficiently integrate all the information and resource data of the whole system, the capacity, stability, and operation efficiency of the database must be fully considered in the construction of the database of the general control center. In order to make the main control center database able to effectively meet the daily information reading, backup, and other needs, one way is to select the appropriate hardware platform to provide the necessary hardware support for the system, and another is to select an efficient and stable database management system to realize the complete management of data. Database construction is the core part of the network distance education system, which plays a vital role. From the functional point of view, it mainly covers system use case analysis, data management, financial management, identity authentication, security management, and so on. As the data storage point of the whole system, the central host system of the system construction manages and processes the data storage and transmission of the whole system. The system design adopts a typical three-tier system architecture. In its architecture design, it covers two functional servers: central database server and teaching management platform. Among them, teaching management platform includes data management server, security server, identity authentication server, and other related equipment servers.


## 4.2. Relational Database Model

The logic structure of the system is divided into two types: conceptual mode and external mode. According to these two modes, the database design of the system can be carried out, and the object patterns can be transformed into fictitious database tables to get the table pattern (conceptual model). External tables (external models) can be associated with table models through database views or interface programs. Finally, the concept table is converted to an internal pattern, as shown in Figure3.Figure 3
Transformation of object model and database model.


## 5. Experiment

### 5.1. Experimental Scheme

Hardware configuration was as follows: server was Pentium 4 processor, memory 512M, hard disk capacity 60 g, and UPS power supply.Client was as follows: Pentium 3 or more CPU, memory 128M or more, and hard disk space 650 m or more.Network configuration was as follows: LAN.


### 5.2. Software Environment

Server operating system was as follows: Windows 2000 (Advanced) Server.Client operating system was as follows: Windows 98/2000/ME/XP.DBMS was as follows: SQL Server 2000.Web server was as follows: Internet Information Server.


### 5.3. System Performance Verification

#### 5.3.1. Accuracy Rate of the Management Information of the Education and Teaching in Colleges and Universities

In order to verify the accuracy of this method on the management information of higher education and teaching, the methods of literature [5], literature [6], literature [7], and this paper are used to test the accuracy rate of the management information of higher education and teaching. The specific results are shown in Table 1.Table 1
Precision rate of education and teaching management information in colleges and universities.
Data quantity of teaching information (GB)Accuracy rate of teaching management information in colleges and universities (%)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper50788069838783981007682777985899415079797581908798200836474728488962507667727879828730073787976828889Mean value77.57574.3378.284.585.893.67According to Table1, when the data of teaching information is 100 GB, the accuracy rate of the information of the teaching management in colleges and universities in the method of literature [5] is 76%, that of the method of literature [6] is 82%, the accuracy rate of the information of the management of the university education in the method of literature [7] is 77%, and the accuracy rate of the information of the teaching management in colleges and universities in this paper is 94%. The accuracy of the method is always at a high level, which indicates that the method is more accurate for the information inquiry of the management information of the higher education and teaching.


#### 5.3.2. Recall Rate of Teaching Management Information in Colleges and Universities

In order to verify the whole situation of the method of this paper, the paper uses the methods of literature [5], literature [6], document [7], and our method to detect the recall rate of the management information of higher education and teaching. The specific results are shown in Table 2.Table 2
Recall rate of university education and teaching management information.
Data quantity of teaching information (GB)Recall rate of teaching management information in colleges and universities (%)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper50848184848191981008568868783929415083747982758999200767273797989962507175697582879330078797383858392Mean value79.7574.8377.3381.780.888.595.33According to the analysis of Table2, the recall rates of higher education and teaching management information are different under different methods. When the amount of teaching information data is 200 GB, the recall rate of the method of literature [5] is 76%, that of the method of literature [6] is 72%, that of the method of literature [7] is 73%, and that of our method is 96%. According to the overall analysis of the above table, the average recall rates of literature [6], literature [7], literature [7], and this method are 79.75%, 74.83%, 77.33%, and 95.33%, respectively. This shows that this method has a good effect of university education and teaching management information search.


#### 5.3.3. Research on Information Query of University Education and Teaching Management

In order to verify the time-consuming method of this paper, the methods of literature [5], literature [6], literature [7], and this paper are used to test the time-consuming method of university education and teaching management information query. The specific results are shown in Table 3.Table 3
Query time of university education and teaching management information.
Data quantity of teaching information (GB)Research on information query of university education and teaching management (s)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper502122261524120.51003637321729160.91504549421832181.32004953482638241.62505463543040291.93006269663746292.3Mean value44.548.8344.6723.834.821.31.42According to the analysis of Table3, there are differences in the query time of university education and teaching management information under different methods. When the amount of teaching information data is 100 GB, the query time of the method of literature [5] is 36 s, that of the method of literature [6] is 37 s, that of the method of literature [7] is 32 s, and that of the method in this paper is only 0.9 s. When the amount of teaching information data is 300 GB, the query time of the method of literature [5] is 62 s, that of the method of literature [6] is 69 s, that of the method of literature [7] is 66 s, and the method of this paper is only 2.3 s. This method always has a lower query time of university education and teaching management information, which shows that the query efficiency of this method is better.


## 5.1. Experimental Scheme

Hardware configuration was as follows: server was Pentium 4 processor, memory 512M, hard disk capacity 60 g, and UPS power supply.Client was as follows: Pentium 3 or more CPU, memory 128M or more, and hard disk space 650 m or more.Network configuration was as follows: LAN.


## 5.2. Software Environment

Server operating system was as follows: Windows 2000 (Advanced) Server.Client operating system was as follows: Windows 98/2000/ME/XP.DBMS was as follows: SQL Server 2000.Web server was as follows: Internet Information Server.


## 5.3. System Performance Verification

### 5.3.1. Accuracy Rate of the Management Information of the Education and Teaching in Colleges and Universities

In order to verify the accuracy of this method on the management information of higher education and teaching, the methods of literature [5], literature [6], literature [7], and this paper are used to test the accuracy rate of the management information of higher education and teaching. The specific results are shown in Table 1.Table 1
Precision rate of education and teaching management information in colleges and universities.
Data quantity of teaching information (GB)Accuracy rate of teaching management information in colleges and universities (%)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper50788069838783981007682777985899415079797581908798200836474728488962507667727879828730073787976828889Mean value77.57574.3378.284.585.893.67According to Table1, when the data of teaching information is 100 GB, the accuracy rate of the information of the teaching management in colleges and universities in the method of literature [5] is 76%, that of the method of literature [6] is 82%, the accuracy rate of the information of the management of the university education in the method of literature [7] is 77%, and the accuracy rate of the information of the teaching management in colleges and universities in this paper is 94%. The accuracy of the method is always at a high level, which indicates that the method is more accurate for the information inquiry of the management information of the higher education and teaching.


### 5.3.2. Recall Rate of Teaching Management Information in Colleges and Universities

In order to verify the whole situation of the method of this paper, the paper uses the methods of literature [5], literature [6], document [7], and our method to detect the recall rate of the management information of higher education and teaching. The specific results are shown in Table 2.Table 2
Recall rate of university education and teaching management information.
Data quantity of teaching information (GB)Recall rate of teaching management information in colleges and universities (%)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper50848184848191981008568868783929415083747982758999200767273797989962507175697582879330078797383858392Mean value79.7574.8377.3381.780.888.595.33According to the analysis of Table2, the recall rates of higher education and teaching management information are different under different methods. When the amount of teaching information data is 200 GB, the recall rate of the method of literature [5] is 76%, that of the method of literature [6] is 72%, that of the method of literature [7] is 73%, and that of our method is 96%. According to the overall analysis of the above table, the average recall rates of literature [6], literature [7], literature [7], and this method are 79.75%, 74.83%, 77.33%, and 95.33%, respectively. This shows that this method has a good effect of university education and teaching management information search.


### 5.3.3. Research on Information Query of University Education and Teaching Management

In order to verify the time-consuming method of this paper, the methods of literature [5], literature [6], literature [7], and this paper are used to test the time-consuming method of university education and teaching management information query. The specific results are shown in Table 3.Table 3
Query time of university education and teaching management information.
Data quantity of teaching information (GB)Research on information query of university education and teaching management (s)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper502122261524120.51003637321729160.91504549421832181.32004953482638241.62505463543040291.93006269663746292.3Mean value44.548.8344.6723.834.821.31.42According to the analysis of Table3, there are differences in the query time of university education and teaching management information under different methods. When the amount of teaching information data is 100 GB, the query time of the method of literature [5] is 36 s, that of the method of literature [6] is 37 s, that of the method of literature [7] is 32 s, and that of the method in this paper is only 0.9 s. When the amount of teaching information data is 300 GB, the query time of the method of literature [5] is 62 s, that of the method of literature [6] is 69 s, that of the method of literature [7] is 66 s, and the method of this paper is only 2.3 s. This method always has a lower query time of university education and teaching management information, which shows that the query efficiency of this method is better.


## 5.3.1. Accuracy Rate of the Management Information of the Education and Teaching in Colleges and Universities

In order to verify the accuracy of this method on the management information of higher education and teaching, the methods of literature [5], literature [6], literature [7], and this paper are used to test the accuracy rate of the management information of higher education and teaching. The specific results are shown in Table 1.Table 1
Precision rate of education and teaching management information in colleges and universities.
Data quantity of teaching information (GB)Accuracy rate of teaching management information in colleges and universities (%)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper50788069838783981007682777985899415079797581908798200836474728488962507667727879828730073787976828889Mean value77.57574.3378.284.585.893.67According to Table1, when the data of teaching information is 100 GB, the accuracy rate of the information of the teaching management in colleges and universities in the method of literature [5] is 76%, that of the method of literature [6] is 82%, the accuracy rate of the information of the management of the university education in the method of literature [7] is 77%, and the accuracy rate of the information of the teaching management in colleges and universities in this paper is 94%. The accuracy of the method is always at a high level, which indicates that the method is more accurate for the information inquiry of the management information of the higher education and teaching.


## 5.3.2. Recall Rate of Teaching Management Information in Colleges and Universities

In order to verify the whole situation of the method of this paper, the paper uses the methods of literature [5], literature [6], document [7], and our method to detect the recall rate of the management information of higher education and teaching. The specific results are shown in Table 2.Table 2
Recall rate of university education and teaching management information.
Data quantity of teaching information (GB)Recall rate of teaching management information in colleges and universities (%)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper50848184848191981008568868783929415083747982758999200767273797989962507175697582879330078797383858392Mean value79.7574.8377.3381.780.888.595.33According to the analysis of Table2, the recall rates of higher education and teaching management information are different under different methods. When the amount of teaching information data is 200 GB, the recall rate of the method of literature [5] is 76%, that of the method of literature [6] is 72%, that of the method of literature [7] is 73%, and that of our method is 96%. According to the overall analysis of the above table, the average recall rates of literature [6], literature [7], literature [7], and this method are 79.75%, 74.83%, 77.33%, and 95.33%, respectively. This shows that this method has a good effect of university education and teaching management information search.


## 5.3.3. Research on Information Query of University Education and Teaching Management

In order to verify the time-consuming method of this paper, the methods of literature [5], literature [6], literature [7], and this paper are used to test the time-consuming method of university education and teaching management information query. The specific results are shown in Table 3.Table 3
Query time of university education and teaching management information.
Data quantity of teaching information (GB)Research on information query of university education and teaching management (s)Literature [5]Literature [6]Literature [7]Literature [16]Literature [17]Literature [18]Method of this paper502122261524120.51003637321729160.91504549421832181.32004953482638241.62505463543040291.93006269663746292.3Mean value44.548.8344.6723.834.821.31.42According to the analysis of Table3, there are differences in the query time of university education and teaching management information under different methods. When the amount of teaching information data is 100 GB, the query time of the method of literature [5] is 36 s, that of the method of literature [6] is 37 s, that of the method of literature [7] is 32 s, and that of the method in this paper is only 0.9 s. When the amount of teaching information data is 300 GB, the query time of the method of literature [5] is 62 s, that of the method of literature [6] is 69 s, that of the method of literature [7] is 66 s, and the method of this paper is only 2.3 s. This method always has a lower query time of university education and teaching management information, which shows that the query efficiency of this method is better.


## 6. Conclusion

This paper designs a Web-based university education and teaching management information system. By analyzing the requirements of university education and teaching management information system, the design principle of the system is determined, the structure design of university education and teaching management information system is realized, and the management process of the system is determined. On the basis of the above, by calculating the complexity of university education and teaching management information, the priority of query information is determined to effectively improve the processing effect of the system. Finally, the relational database model is designed to realize the design of university education and teaching management information system. The results are as follows:(1)
When the amount of teaching information data is 100 GB, the precision rate of this method is 94%, which shows that this method has better query accuracy for university education and teaching management information.(2)
When the data of teaching information is 200 GB, the recall rate of the information of the teaching management in colleges and universities is 96%, which shows that the method has a good effect on the information retrieval of the teaching management in colleges and universities.(3)
When the amount of teaching information data is 300 GB, the query time of this method is only 2.3 s. It shows that the query efficiency of this method is better.In the future work, we can further optimize the information storage mode, query mode, and resource management, in order to conduct accurate query in the case of complex data.



---

*Source: 5090813-2021-08-04.xml*