# Research on Enterprise Employee Performance Appraisal Management System Based on CS Architecture

Authors: Pei Lin
Journal: Security and Communication Networks
 (2021)

---

## Abstract

Aiming at the problems of poor system throughput and poor performance appraisal indicators in traditional enterprise employee performance appraisal management systems, a corporate employee performance appraisal management system based on the CS architecture was designed. Firstly, the system architecture of performance appraisal system is built, the system logical architecture design is determined, and the functional modules of the appraisal management system are analyzed. Then, the influencing factors of employee performance appraisal management system are analyzed through the evaluation constraint parameters, and the quantitative regression analysis model of enterprise employee performance appraisal management is constructed to realize the design of enterprise employee performance management software. Finally, the evaluation management system database was built to realize the enterprise employee performance evaluation system’s design based on CS architecture. The experimental results show that this system can improve the throughput of the employee performance appraisal management system and the rationality of enterprise employee appraisal standards. It plays an important role in enterprise employee performance appraisal management.


---

## Body

## 1. Introduction

Enterprise employee performance appraisal system is mainly used to manage enterprise employees’ work efficiency and service quality. As a constraint means, it can stimulate the work potential and enthusiasm of enterprise employees. The implementation of performance appraisal management in enterprises reflects the development planning and business philosophy of enterprises. It is of far-reaching significance to put the development of performance appraisal on the important work agenda of enterprises and take it as an important part of management [1]. Although performance appraisal is a means of standardizing and restricting work, it can also stimulate the work enthusiasm of enterprise employees, improve the work efficiency of enterprise employees, let enterprise employees demand their work with performance appraisal indicators, and achieve the purpose of optimizing human resources. In the process of enterprise development, through reasonable performance appraisal, it can cultivate and reserve talents for the enterprise, improve the overall business level of the enterprise, and improve the work efficiency of the whole team. Reasonable performance appraisal can promote the development of enterprises and enhance the market competitiveness of enterprises. At present, with the rapid development of information technology, it is far from enough to rely solely on the traditional performance appraisal management of enterprise employees [2]. The traditional performance appraisal management cannot adapt to the development of the times and meet the needs of reality. With the help of information technology, enterprises should design and develop a performance appraisal system suitable for enterprises and standardize enterprise performance appraisal management mechanism. Enterprises should constantly innovate performance appraisal management, establish a scientific and reasonable performance appraisal mechanism, abandon the disadvantages of traditional performance management, develop a perfect performance appraisal management system with the help of information technology, and combine performance appraisal with human resource management to stimulate the enthusiasm of enterprise employees and improve work efficiency [3].With the continuous development of a socialist market economy, the competition between various industries is becoming more and more fierce. It is not easy to win in fierce competition. In recent years, enterprises have paid more and more attention to the scientific development of performance appraisal to improve employees’ work efficiency and create greater enterprise profits. The performance appraisal of enterprise employees and the introduction of more advanced appraisal management experience and methods have become essential for enterprises to improve their competitiveness. Nevertheless, there are still some problems. Through the investigation of some domestic enterprises, it is known that enterprises have the following issues when implementing performance appraisal management on employees:(1)
The content of the performance appraisal system implemented by some enterprises cannot keep pace with the times, so it is difficult to carry out effective appraisal, which will affect the normal operation of enterprises and make the departments unable to cooperate effectively. In the daily management process of enterprises, some enterprises pay attention to the business performance, but there are problems in management, which make the performance not outstanding. During performance appraisal, the appraisal method is not scientific enough. Some are only assessed and punished at the end of the year, and some are assessed too many times, which makes the appraisal work lose its practical significance.(2)
Through the investigation, it is learned that the setting of performance appraisal indicators of some enterprises is not reasonable. The performance appraisal indicators adopt the way of mandatory indicators. All work is mainly based on the completed performance. In many cases, the management quality and efficiency are ignored, resulting in the lack of long-term development of enterprises. Moreover, some performance appraisal methods are too single, do not pay attention to the appraisal results, and do not diagnose the performance appraisal problems.Therefore, this paper designs an enterprise employee performance appraisal management system based on CS architecture to improve the rationality and performance of the appraisal management system.Our contribution includes the following three points:(1)
In order to solve the problems existing in the traditional enterprise employee performance appraisal management system, such as poor system throughput and poor rationality of performance appraisal indicators, this paper designs the enterprise employee performance appraisal management system based on CS architecture.(2)
This paper analyzes the influencing factors of the employee performance appraisal management system through the evaluation constraint parameters, constructs the quantitative regression analysis model of the employee performance appraisal management, and realizes the design of the employee performance management software.(3)
The experimental results show that this system can improve the throughput of employee performance appraisal management system and the rationality of enterprise employee appraisal standards. It plays an important role in enterprise employee performance appraisal management.


## 2. Overall System Design

The system design should follow the process of software development. It is necessary to carry out the system’s overall design, including architecture design and logical architecture design and then divide and design the functional modules in detail. The performance appraisal management system can be divided into three functional modules. The specific design process is as follows. CS structure is a software development structure for data interaction between browser and server. Users operate the system through browser. The characteristic of this structure is that all data can be processed and stored on the server, and users can access the server anytime and anywhere through the browser. The CS structure diagram is shown in Figure1.Figure 1
Performance appraisal system architecture.


### 2.1. Presentation Layer

According to the actual research, the system designed in this paper faces the company’s internal operators. This layer is mainly used for the interaction between the enterprise employee performance appraisal system and external data.


### 2.2. Application Layer

Based on CS structure, according to the processing requirements of enterprise employee performance appraisal system, the original application server layer is expanded into four fine layers: application organization layer, business processing layer, data analysis layer, and data access layer.Application organization layer: this layer is set between the presentation layer and the application layer. It is mainly responsible for judging the system user’s request and judging the correctness of the request. The user request is packaged into a data form conforming to the system specification and transmitted down if it is correct. If the request is incorrect, the layer will not issue the request, but directly feedback a message to the presentation layer.Business processing layer: this layer mainly analyzes the user’s request, generates the data format recognized by the system, extracts the business type data, enables the system to perform corresponding business operations, and distributes the data after salary settlement. This layer is also responsible for forwarding the data of the lower layer.Data analysis layer: this layer mainly completes the functions of data analysis, processing, or calculation. The common methods are report, OLAP, etc. The data analysis and processing layer is the most critical part of the whole system. Basically, if the system wants to process business, it needs to use the functions of this layer. Data access layer: this layer is mainly used to interpret and analyze the data requests sent from the upper layer, translate the data requests into formats that can be recognized by the data layer according to the data storage format in the database, and provide data layer access services for the upper layer.


### 2.3. Data Layer

The data layer is the most important part of the system, and its main task is to maintain the data warehouse. It provides multiple interfaces to the outside to access the underlying metadata. The data layer implements all data management services.


## 2.1. Presentation Layer

According to the actual research, the system designed in this paper faces the company’s internal operators. This layer is mainly used for the interaction between the enterprise employee performance appraisal system and external data.


## 2.2. Application Layer

Based on CS structure, according to the processing requirements of enterprise employee performance appraisal system, the original application server layer is expanded into four fine layers: application organization layer, business processing layer, data analysis layer, and data access layer.Application organization layer: this layer is set between the presentation layer and the application layer. It is mainly responsible for judging the system user’s request and judging the correctness of the request. The user request is packaged into a data form conforming to the system specification and transmitted down if it is correct. If the request is incorrect, the layer will not issue the request, but directly feedback a message to the presentation layer.Business processing layer: this layer mainly analyzes the user’s request, generates the data format recognized by the system, extracts the business type data, enables the system to perform corresponding business operations, and distributes the data after salary settlement. This layer is also responsible for forwarding the data of the lower layer.Data analysis layer: this layer mainly completes the functions of data analysis, processing, or calculation. The common methods are report, OLAP, etc. The data analysis and processing layer is the most critical part of the whole system. Basically, if the system wants to process business, it needs to use the functions of this layer. Data access layer: this layer is mainly used to interpret and analyze the data requests sent from the upper layer, translate the data requests into formats that can be recognized by the data layer according to the data storage format in the database, and provide data layer access services for the upper layer.


## 2.3. Data Layer

The data layer is the most important part of the system, and its main task is to maintain the data warehouse. It provides multiple interfaces to the outside to access the underlying metadata. The data layer implements all data management services.


## 3. System Logic Architecture Design

The enterprise employee performance appraisal system adopts a standard system in the logical architecture design. The whole system is composed of performance layer, application layer, data layer, and physical layer. The presentation layer is a web client. The application layer is divided into core business layer and business support layer. The data layer is divided into basic data and business data. The physical layer is mainly network, hardware system, and operating system. The system logic structure diagram is shown in Figure2.Figure 2
System logic structure diagram.Figure2 is reproduced from Wang et al. [4] (under the Creative Commons Attribution License/public domain) and also received the permission from the abovementioned article’s author to reuse their image in the current submission.As can be seen from Figure2, in the core business, it is a business implemented by modules that refine the whole functional requirements of the system. In the business support, it is mainly the setting and implementation of some components and controls to ensure the smooth implementation of the core business. In the data service layer, there are some basic business processes, assessment standards, and other data in the basic database. It provides the most basic business support for the business, and the business database mainly realizes the storage of user account information and assessment results. The independence of the database helps us to protect the integrity and correctness of the system and can effectively and pertinently recover the system when the system runs in danger.


### 3.1. System Function Module Design

After understanding the system’s demand analysis and function description, we divided the enterprise employee performance appraisal management system into the following 13 submodules and incorporated these submodules into the three function menus of system management, department leadership management, and ordinary enterprise employee appraisal. The specific functional module diagram is as follows.The following describes the function modules, respectively. The system is divided into three subsystems: system management, department leadership, and ordinary enterprise employee assessment. The specific functions are described as follows.


#### 3.1.1. System Management Module

The participants of system management are system administrators. The main functions completed are user registration review, enterprise employee performance statistics, departmentn performance statistics, entering dynamic news, data optimization, performance index design, freezing leaders, etc. The system administrator has the highest operation authority. User registration is divided into the registration of ordinary enterprise employees and the registration of department leaders. The account permissions after registration are different. The leader account has the permission to modify and approve, while the registration of enterprise employees only has the permission to submit. Performance statistics are divided into employee and department statistics. Each statistic is divided into basic self-evaluation table statistics, floating self-evaluation table statistics, mutual evaluation table, attendance statistics, and total performance statistics.


#### 3.1.2. Department Leadership Management Module

The main function of the department leadership management module is to carry out macrocontrol and management on the performance of the department. The main functions include registering department leaders, reviewing employee performance, department assessment management, and freezing employees. The authority of department leaders is higher than that of employees but lower than that of system administrators. For account registration, you can register a new account or modify the password of the account. The employee performance review includes basic self-evaluation table statistics, floating self-evaluation table statistics, mutual evaluation table, attendance statistics, and total performance statistics.


#### 3.1.3. General Employee Assessment Module

The assessment of ordinary employees is mainly to register users and fill in self-inspection forms. Ordinary employees have the lowest permissions and can only fill in and submit their own attendance. You can view the results of performance appraisal approval.


### 3.2. Enterprise Employee Activity Charts

System users (including ordinary employees, department leaders, and system administrators) should first login. Normal users fill in, submit, or modify the self-inspection form. Department leaders review the self-recommendation form. Then, users can query data according to their own permissions. Finally, they need to exit the whole system. Therefore, the activity diagram of the system is shown in Figure3.Figure 3
System activity diagram.In the activity diagram of the system, the start and end of all account permissions are realized by login and exit. Each account has the permission to view. The permissions to view here are different. The system administrator has the permission to view all information, while the department manager has the permission to view the performance appraisal information of his own department, while ordinary employees only have the permission to view their own performance appraisal information. In addition, after logging in, you can perform different operations through modification, approval, submission, etc., according to different accounts.


## 3.1. System Function Module Design

After understanding the system’s demand analysis and function description, we divided the enterprise employee performance appraisal management system into the following 13 submodules and incorporated these submodules into the three function menus of system management, department leadership management, and ordinary enterprise employee appraisal. The specific functional module diagram is as follows.The following describes the function modules, respectively. The system is divided into three subsystems: system management, department leadership, and ordinary enterprise employee assessment. The specific functions are described as follows.


### 3.1.1. System Management Module

The participants of system management are system administrators. The main functions completed are user registration review, enterprise employee performance statistics, departmentn performance statistics, entering dynamic news, data optimization, performance index design, freezing leaders, etc. The system administrator has the highest operation authority. User registration is divided into the registration of ordinary enterprise employees and the registration of department leaders. The account permissions after registration are different. The leader account has the permission to modify and approve, while the registration of enterprise employees only has the permission to submit. Performance statistics are divided into employee and department statistics. Each statistic is divided into basic self-evaluation table statistics, floating self-evaluation table statistics, mutual evaluation table, attendance statistics, and total performance statistics.


### 3.1.2. Department Leadership Management Module

The main function of the department leadership management module is to carry out macrocontrol and management on the performance of the department. The main functions include registering department leaders, reviewing employee performance, department assessment management, and freezing employees. The authority of department leaders is higher than that of employees but lower than that of system administrators. For account registration, you can register a new account or modify the password of the account. The employee performance review includes basic self-evaluation table statistics, floating self-evaluation table statistics, mutual evaluation table, attendance statistics, and total performance statistics.


### 3.1.3. General Employee Assessment Module

The assessment of ordinary employees is mainly to register users and fill in self-inspection forms. Ordinary employees have the lowest permissions and can only fill in and submit their own attendance. You can view the results of performance appraisal approval.


## 3.1.1. System Management Module

The participants of system management are system administrators. The main functions completed are user registration review, enterprise employee performance statistics, departmentn performance statistics, entering dynamic news, data optimization, performance index design, freezing leaders, etc. The system administrator has the highest operation authority. User registration is divided into the registration of ordinary enterprise employees and the registration of department leaders. The account permissions after registration are different. The leader account has the permission to modify and approve, while the registration of enterprise employees only has the permission to submit. Performance statistics are divided into employee and department statistics. Each statistic is divided into basic self-evaluation table statistics, floating self-evaluation table statistics, mutual evaluation table, attendance statistics, and total performance statistics.


## 3.1.2. Department Leadership Management Module

The main function of the department leadership management module is to carry out macrocontrol and management on the performance of the department. The main functions include registering department leaders, reviewing employee performance, department assessment management, and freezing employees. The authority of department leaders is higher than that of employees but lower than that of system administrators. For account registration, you can register a new account or modify the password of the account. The employee performance review includes basic self-evaluation table statistics, floating self-evaluation table statistics, mutual evaluation table, attendance statistics, and total performance statistics.


## 3.1.3. General Employee Assessment Module

The assessment of ordinary employees is mainly to register users and fill in self-inspection forms. Ordinary employees have the lowest permissions and can only fill in and submit their own attendance. You can view the results of performance appraisal approval.


## 3.2. Enterprise Employee Activity Charts

System users (including ordinary employees, department leaders, and system administrators) should first login. Normal users fill in, submit, or modify the self-inspection form. Department leaders review the self-recommendation form. Then, users can query data according to their own permissions. Finally, they need to exit the whole system. Therefore, the activity diagram of the system is shown in Figure3.Figure 3
System activity diagram.In the activity diagram of the system, the start and end of all account permissions are realized by login and exit. Each account has the permission to view. The permissions to view here are different. The system administrator has the permission to view all information, while the department manager has the permission to view the performance appraisal information of his own department, while ordinary employees only have the permission to view their own performance appraisal information. In addition, after logging in, you can perform different operations through modification, approval, submission, etc., according to different accounts.


## 4. Design of Enterprise Employee Performance Management Software

Combined with the systematic feature modeling and hierarchical analysis of performance appraisal standards, the quantitative feature analysis of performance appraisal standards is carried out. The constraint parameters of performance appraisal standards are analyzed by using the fuzzy constraint index analysis method. The hierarchical analysis results of performance appraisal standards are as follows:(1)MSDa⟶b=1−∑i=1Ia,bda,i2+da,i2Ia,b×∑i=1Ia,bda,i−d¯a2+db,i−d¯b2,where MSDa⟶b is the consistency function of distributed evaluation of performance appraisal under the multilayer evaluation pattern, and da,i is the examination score; d¯a indicates the type and quantity of appraisal methods; db,i indicates the rationality of performance appraisal (values from reasonable to unreasonable are divided into 1, 2, and 3); d¯b represents the amount of capital invested by the enterprise; Ia,b indicates the allocation degree of the enterprise. The factor distribution level X0 of performance appraisal indicators is divided into 8 grades, which is X1,X2,…,XN, i.e., x0=∪i=1Nxi. Using the linear programming model, the correlation mapping relationship of performance appraisal indicators is as follows:(2)pRN=ri=pXN=xi|xi=ri,anglexiangleri=φg,mod2π.The empirical mode decomposition method is used to decompose the characteristics of the performance appraisal system, and the fuzzy set function is constructed asR2TR2=V2∑2V2T. It is obtained that the constraint parameter index analysis characteristic quantity meets IRN;φg|ZN=V2, which is substituted into the above formula:(3)R2T=IRN;φg|ZN∑2V2TR2.Set the status parameter set of performance appraisal influencing factors as(4)F=f1,f2,…,fn.In the quantitative evaluation of assessment system factors, it is obtained that the assessment factor distribution fuzzy set scheduling set under the linear programming mode is(5)ft=1R2TdFargzt.The characteristic quantity of construction decision is(6)Sx=Eft+sbust−τ0,Kx=Eft−3E2ftb,where Ex3t is the expected value, b is the decision coefficient, and the fuzzy scheduling set of assessment factor index scheduling is(7)H0:x′t=wt,H1:Es′t+wt,0≤t≤T.In the above formula,x′ (t) and s′ (t) are, respectively,(8)x′t=xt∗hwt,s′t=st∗hwt.To sum up, the characteristics of association rules are extracted, and the constraint parameter index architecture is constructed.The multiorder eigenmode function analysis model of performance appraisal factors is constructed [5]. The quantitative regression analysis of performance appraisal factors and the distribution of correlation dimension index information are as follows:(9)SC/Af=TBNTC2Xf2+∑l=−∞∞sinc2πTBf−lNTC,among(10)Xf2=TC2Nsinc2πfTCXcodef2,Xcodef=1N∑n=0N−1xnexp−j2πfnTc.In the above formula,TC is the nonlinear characteristic distribution threshold, f is the sampling frequency of enterprise employee performance test management information, and Xcodef is the information weighted feature vector [6]. A multiorder eigenmode function analysis model for enterprise employee performance evaluation is constructed to represent the correlation between performance evaluation factors and the rationality of evaluation indicators [7]. The description is as follows:(11)Tj=σw^jk1−b2×E∑b=1b+1E,b=H0,MSDa⟶b,b=H1,where N represents the length of index distribution and J is the order of analytic hierarchy process for the rationality of assessment indicators. According to the analysis formula (9), when the variable parameter is b=H0, it means that the assessment content of the assessment system and enterprise allocation are irrelevant, while when it is b=H1, it means that it is related to the factors analyzed in Section 1. To sum up, the design of performance appraisal management system is realized [8].


## 5. Database Design

At present, there are many database products. The products of each database are aimed at different user groups. They can be divided into hierarchical database, network database, and relational database. Different types of databases adopt different storage methods, and the internal data structure is also different. The data of various types of databases adopt different organization methods. With the development of technology and the change of user needs, the first two types of databases cannot adapt to the development of the times and have been eliminated [9]. Now, most databases on the market are relational databases and nonrelational databases. The data products on the market include Oracle, DB2, MySQL, SQL Server, and other database products. These databases have their advantages. When selecting a database, it is not good to select a large and high-performance database. It is most important to select a more appropriate database according to the specific application environment when selecting a database [10].


### 5.1. Management and Development Tools

SQL Server database is a relational database developed by Microsoft. It has very excellent performance. Due to the market of Windows operating system, its database has also been favored by the majority of users. Microsoft SQL Server constantly updates versions, including Microsoft SQL Server 2000, Microsoft SQL Server 2005, and Microsoft SQL Server 2008 [11]. Databases occupy a large market. At present, the latest version is SQL Server 2012 launched in March 2012. This paper selects SQL Server database as the data of the system, which can provide effective database support for enterprise employee performance appraisal management system [12].It mainly includes the following common management and development tools.


#### 5.1.1. Profiler

This graphical tool captures a continuous record of server activity in real time. The profiler monitors multiple different server events and event categories, filters these events using user-defined criteria, and outputs trace records to screens, files, or other SQL servers. SQL Server Profiler can be used to monitor the performance of SQL Server; debug transact SQL statements and stored procedures; identify slow queries; and solve the problems in SQL Server; by capturing all events that cause a specific problem and then reproducing these events on the test system, the problem can be repeated and separated to achieve the purpose of solving the problem. In the project development stage, test SQL statements and stored procedures by executing statements one line at a time to confirm whether the code is executed according to the expected results.The SQL Server Profiler provides a graphical user interface for a set of extended stored procedures. You can also use these extended stored procedures directly. Therefore, you can create your own application that uses SQL Server Profiler extended stored procedures to monitor SQL Server.


#### 5.1.2. Query Analyzer

Query analyzer is an application used to write and execute transact SQL sentences for SQL Server database. It is developed from ISOL and ISOL/W. Before enterprise manager appeared in SQL Server Version 6.0, administrators relied on ISOL to manage servers and databases and execute query statements. Query analyzer is a multidocument interface application, so it can keep one or more query windows. Users can use the query window to enter and execute multiple one statements.


### 5.2. Database Audit and Log Management Strategy

Audit function is an important part of DBMS security. Because the security protection measures of any system are not impeccable, people who deliberately steal and destroy data always try to break the control. Through the audit, all users’ operations on the database can be automatically recorded and put into the audit log. In this way, the database system can use the audit tracking information to reproduce a series of events leading to the existing situation of the database and find out the person, time, and content of illegally accessing data. To facilitate the tracing of relevant responsibilities, at the same time, audit also helps to find weaknesses and loopholes in system security. According to the security policy requirements in TDI/TCSEC standard, the audit function is also an essential index for DBMS to reach the security level above C2 [13]. The audit log is very effective for postinspection. It effectively enhances the physical integrity of data. However, the audit with too fine granularity, such as the change of each record value, is very time-consuming and space-consuming, especially in the application system of large-scale distribution and data replication environment with large batch and short transaction processing. This determines that the audit function is generally used in departments with high security requirements. Therefore, DBMS often takes it as an optional feature to allow the database system to flexibly turn on or off the audit function according to the application’s security requirements.Accordingly, the enterprise employee performance appraisal management system diagram is given, as shown in Figure4.Figure 4
Enterprise employee performance appraisal management system.


## 5.1. Management and Development Tools

SQL Server database is a relational database developed by Microsoft. It has very excellent performance. Due to the market of Windows operating system, its database has also been favored by the majority of users. Microsoft SQL Server constantly updates versions, including Microsoft SQL Server 2000, Microsoft SQL Server 2005, and Microsoft SQL Server 2008 [11]. Databases occupy a large market. At present, the latest version is SQL Server 2012 launched in March 2012. This paper selects SQL Server database as the data of the system, which can provide effective database support for enterprise employee performance appraisal management system [12].It mainly includes the following common management and development tools.


### 5.1.1. Profiler

This graphical tool captures a continuous record of server activity in real time. The profiler monitors multiple different server events and event categories, filters these events using user-defined criteria, and outputs trace records to screens, files, or other SQL servers. SQL Server Profiler can be used to monitor the performance of SQL Server; debug transact SQL statements and stored procedures; identify slow queries; and solve the problems in SQL Server; by capturing all events that cause a specific problem and then reproducing these events on the test system, the problem can be repeated and separated to achieve the purpose of solving the problem. In the project development stage, test SQL statements and stored procedures by executing statements one line at a time to confirm whether the code is executed according to the expected results.The SQL Server Profiler provides a graphical user interface for a set of extended stored procedures. You can also use these extended stored procedures directly. Therefore, you can create your own application that uses SQL Server Profiler extended stored procedures to monitor SQL Server.


### 5.1.2. Query Analyzer

Query analyzer is an application used to write and execute transact SQL sentences for SQL Server database. It is developed from ISOL and ISOL/W. Before enterprise manager appeared in SQL Server Version 6.0, administrators relied on ISOL to manage servers and databases and execute query statements. Query analyzer is a multidocument interface application, so it can keep one or more query windows. Users can use the query window to enter and execute multiple one statements.


## 5.1.1. Profiler

This graphical tool captures a continuous record of server activity in real time. The profiler monitors multiple different server events and event categories, filters these events using user-defined criteria, and outputs trace records to screens, files, or other SQL servers. SQL Server Profiler can be used to monitor the performance of SQL Server; debug transact SQL statements and stored procedures; identify slow queries; and solve the problems in SQL Server; by capturing all events that cause a specific problem and then reproducing these events on the test system, the problem can be repeated and separated to achieve the purpose of solving the problem. In the project development stage, test SQL statements and stored procedures by executing statements one line at a time to confirm whether the code is executed according to the expected results.The SQL Server Profiler provides a graphical user interface for a set of extended stored procedures. You can also use these extended stored procedures directly. Therefore, you can create your own application that uses SQL Server Profiler extended stored procedures to monitor SQL Server.


## 5.1.2. Query Analyzer

Query analyzer is an application used to write and execute transact SQL sentences for SQL Server database. It is developed from ISOL and ISOL/W. Before enterprise manager appeared in SQL Server Version 6.0, administrators relied on ISOL to manage servers and databases and execute query statements. Query analyzer is a multidocument interface application, so it can keep one or more query windows. Users can use the query window to enter and execute multiple one statements.


## 5.2. Database Audit and Log Management Strategy

Audit function is an important part of DBMS security. Because the security protection measures of any system are not impeccable, people who deliberately steal and destroy data always try to break the control. Through the audit, all users’ operations on the database can be automatically recorded and put into the audit log. In this way, the database system can use the audit tracking information to reproduce a series of events leading to the existing situation of the database and find out the person, time, and content of illegally accessing data. To facilitate the tracing of relevant responsibilities, at the same time, audit also helps to find weaknesses and loopholes in system security. According to the security policy requirements in TDI/TCSEC standard, the audit function is also an essential index for DBMS to reach the security level above C2 [13]. The audit log is very effective for postinspection. It effectively enhances the physical integrity of data. However, the audit with too fine granularity, such as the change of each record value, is very time-consuming and space-consuming, especially in the application system of large-scale distribution and data replication environment with large batch and short transaction processing. This determines that the audit function is generally used in departments with high security requirements. Therefore, DBMS often takes it as an optional feature to allow the database system to flexibly turn on or off the audit function according to the application’s security requirements.Accordingly, the enterprise employee performance appraisal management system diagram is given, as shown in Figure4.Figure 4
Enterprise employee performance appraisal management system.


## 6. Experiment

### 6.1. System Parameter Design

Before the system testing, the system testing environment is built in this paper. Considering the influence of the configuration of hardware and software in the test environment on the system test results, the system’s test environment adopts some equipment with good performance as the test machine. The hardware environment is shown in Table1.Table 1
Hardware environment.
Equipment nameDetailed description of equipmentComputer (A)CPUIntel Core i7 6700 3.4 GHzMemory16 GBHard disk capacity2 TBNumber of cores/threadsFour cores/eight threadsComputer (B, C, and D)CPUIntel Core i5 6400 2.7 GHzMemory4 GBHard disk capacity1 TBNumber of cores/threadsQuad core/quad threadLANGigabit LANComputer A is used as the server of the test environment; computers B, C, and D are used as browser machines and personal computers used by test users. Four machines are connected to gigabit switches to form the test environment.The software environment tested is shown in Table2.Table 2
Software environment.
Equipment nameSoftware platformDetailed description of the softwareComputer (A)Database serverMySQL 5.6.20 databaseOperating systemWindows Server 2008Java runtime environmentJDK 1.7.08 editionWeb application serverTomcat 8.0.3 editionComputer (B, C, and D)Operating systemWindows 10, Windows 7, Windows XPBrowserIE, Firefox, Chrome, Opera, 360


### 6.2. Rationality Verification of Enterprise Employee Performance Appraisal Indicators

In order to verify the rationality of the enterprise employee performance appraisal index of this method, the methods of literature [14], literature [15], literature [16], and this method are used to evaluate the rationality of the enterprise employee performance appraisal index. 500 people were selected to evaluate the rationality of the enterprise employee appraisal. The enterprise employees classify the results as reasonable, fair, and unreasonable and locate 1 point, 0 point, and 1 point, respectively. Obtain the rationality of performance appraisal results through employee scoring. The results are shown in Table 3. Rationality evaluation of enterprise employee assessment is shown in Figure 5.Table 3
Rationality evaluation of enterprise employee assessment.
Iterations (time)Evaluation rationality score of enterprise employees under different methodsLiterature [15] systemLiterature [16] systemLiterature [17] systemPaper system103524194004892037538836549830386325386492403753673974875038937538648660421412353487Figure 5
Rationality evaluation of enterprise employee assessment.It can be seen from Table3 that the evaluation results of employee assessment rationality are different under different methods. When the number of iterations is 10, the enterprise employee assessment rationality score of literature [15] system is 352, the enterprise employee assessment rationality score of literature [16] system is 419, the enterprise employee assessment rationality score of literature [17] system is 400, and the enterprise employee assessment rationality score of this system is 489. When the number of iterations is 50, the enterprise employee assessment rationality score of literature [15] system is 389, the enterprise employee assessment rationality score of literature [16] system is 375, the enterprise employee assessment rationality score of literature [17] system is 386, and the enterprise employee assessment rationality score of this system is 486. The rationality score of enterprise employee assessment in this system is significantly higher than that of other methods, which shows that this method can improve the rationality of enterprise employee assessment. In order to analyze the results more intuitively, corresponding bar charts are presented, and the results are shown in Figure 5.


### 6.3. CPU Occupancy Rate of Enterprise Employee Performance Appraisal Management System

To verify the CPU occupancy rate of the performance appraisal management system in this paper, the literature [15] system, the literature [16] system, the literature [17] system, and the system CPU occupancy rate of this system are adopted, and the results are shown in Figure 6.Figure 6
CPU occupancy of enterprise employee performance appraisal management system.By analyzing Figure6, it can be seen that there are differences in CPU utilization of enterprise employee performance appraisal management system under different systems. When the number of enterprise employees is 100, the CPU occupancy rate of enterprise employee performance appraisal management system in document [15] system is 35%, the CPU occupancy rate of enterprise employee performance appraisal management system in document [16] system is 26%, the CPU occupancy rate of enterprise employee performance appraisal management system in document [17] system is 35%, and the CPU occupancy rate of enterprise employee performance appraisal management system in the design system is 2%. When the number of enterprise employees is 500, the CPU occupancy rate of enterprise employee performance appraisal management system in document [15] system is 49%, that of enterprise employee performance appraisal management system in document [16] system is 41%, that of enterprise employee performance appraisal management system in document [17] system is 49%, and that of enterprise employee performance appraisal management system designed in the system is 8%. The CPU occupancy rate of the design system evaluation management system is far lower than that of other systems, which shows that the CPU occupancy rate of this system is low, which can better manage the performance evaluation of enterprise employees.


### 6.4. Enterprise Employee Performance Appraisal Management System

In order to verify the throughput of the design system to the enterprise employee performance appraisal management system, the experimental verification is carried out by using the methods of literature [15], literature [16], literature [17], and this paper. The results are shown in Table 4. Throughput of assessment management system is shown in Figure 7.Table 4
Throughput of assessment management system.
Number of users/personsAssessment management system throughput (kbps)Literature [15] systemLiterature [16] systemLiterature [17] systemPaper system100234127653262459520023652753321355433002264287432366543400243329753078684650024533164297674536002568325127547754Figure 7
Throughput of assessment management system.It can be seen from Table4 that the throughput of the assessment management system is different under different methods. When the number of users is 200, the throughput of the assessment management system of document [15] system is 2365 kbps, the throughput of the assessment management system of document [16] system is 2753 kbps, the throughput of the assessment management system of document [17] system is 3213 kbps, and the throughput of the assessment management system of this paper is 5543 kbps. When the number of users is 600, the throughput of the assessment management system of document [15] system is 2568 kbps, the throughput of the assessment management system of document [16] system is 3251 kbps, the throughput of the assessment management system of document [17] system is 2754 kbps, and the throughput of the assessment management system of this system is 7754 kbps. The throughput of the assessment management system of this system is significantly higher than that of other methods, and the throughput of this system increases with the increase of the number of users, which can better adapt to the evaluation management of enterprise employees in multiuser system, which shows that the enterprise employee evaluation management of this system is better. In order to analyze the results more intuitively, corresponding bar charts are presented, and the results are shown in Figure 7.


## 6.1. System Parameter Design

Before the system testing, the system testing environment is built in this paper. Considering the influence of the configuration of hardware and software in the test environment on the system test results, the system’s test environment adopts some equipment with good performance as the test machine. The hardware environment is shown in Table1.Table 1
Hardware environment.
Equipment nameDetailed description of equipmentComputer (A)CPUIntel Core i7 6700 3.4 GHzMemory16 GBHard disk capacity2 TBNumber of cores/threadsFour cores/eight threadsComputer (B, C, and D)CPUIntel Core i5 6400 2.7 GHzMemory4 GBHard disk capacity1 TBNumber of cores/threadsQuad core/quad threadLANGigabit LANComputer A is used as the server of the test environment; computers B, C, and D are used as browser machines and personal computers used by test users. Four machines are connected to gigabit switches to form the test environment.The software environment tested is shown in Table2.Table 2
Software environment.
Equipment nameSoftware platformDetailed description of the softwareComputer (A)Database serverMySQL 5.6.20 databaseOperating systemWindows Server 2008Java runtime environmentJDK 1.7.08 editionWeb application serverTomcat 8.0.3 editionComputer (B, C, and D)Operating systemWindows 10, Windows 7, Windows XPBrowserIE, Firefox, Chrome, Opera, 360


## 6.2. Rationality Verification of Enterprise Employee Performance Appraisal Indicators

In order to verify the rationality of the enterprise employee performance appraisal index of this method, the methods of literature [14], literature [15], literature [16], and this method are used to evaluate the rationality of the enterprise employee performance appraisal index. 500 people were selected to evaluate the rationality of the enterprise employee appraisal. The enterprise employees classify the results as reasonable, fair, and unreasonable and locate 1 point, 0 point, and 1 point, respectively. Obtain the rationality of performance appraisal results through employee scoring. The results are shown in Table 3. Rationality evaluation of enterprise employee assessment is shown in Figure 5.Table 3
Rationality evaluation of enterprise employee assessment.
Iterations (time)Evaluation rationality score of enterprise employees under different methodsLiterature [15] systemLiterature [16] systemLiterature [17] systemPaper system103524194004892037538836549830386325386492403753673974875038937538648660421412353487Figure 5
Rationality evaluation of enterprise employee assessment.It can be seen from Table3 that the evaluation results of employee assessment rationality are different under different methods. When the number of iterations is 10, the enterprise employee assessment rationality score of literature [15] system is 352, the enterprise employee assessment rationality score of literature [16] system is 419, the enterprise employee assessment rationality score of literature [17] system is 400, and the enterprise employee assessment rationality score of this system is 489. When the number of iterations is 50, the enterprise employee assessment rationality score of literature [15] system is 389, the enterprise employee assessment rationality score of literature [16] system is 375, the enterprise employee assessment rationality score of literature [17] system is 386, and the enterprise employee assessment rationality score of this system is 486. The rationality score of enterprise employee assessment in this system is significantly higher than that of other methods, which shows that this method can improve the rationality of enterprise employee assessment. In order to analyze the results more intuitively, corresponding bar charts are presented, and the results are shown in Figure 5.


## 6.3. CPU Occupancy Rate of Enterprise Employee Performance Appraisal Management System

To verify the CPU occupancy rate of the performance appraisal management system in this paper, the literature [15] system, the literature [16] system, the literature [17] system, and the system CPU occupancy rate of this system are adopted, and the results are shown in Figure 6.Figure 6
CPU occupancy of enterprise employee performance appraisal management system.By analyzing Figure6, it can be seen that there are differences in CPU utilization of enterprise employee performance appraisal management system under different systems. When the number of enterprise employees is 100, the CPU occupancy rate of enterprise employee performance appraisal management system in document [15] system is 35%, the CPU occupancy rate of enterprise employee performance appraisal management system in document [16] system is 26%, the CPU occupancy rate of enterprise employee performance appraisal management system in document [17] system is 35%, and the CPU occupancy rate of enterprise employee performance appraisal management system in the design system is 2%. When the number of enterprise employees is 500, the CPU occupancy rate of enterprise employee performance appraisal management system in document [15] system is 49%, that of enterprise employee performance appraisal management system in document [16] system is 41%, that of enterprise employee performance appraisal management system in document [17] system is 49%, and that of enterprise employee performance appraisal management system designed in the system is 8%. The CPU occupancy rate of the design system evaluation management system is far lower than that of other systems, which shows that the CPU occupancy rate of this system is low, which can better manage the performance evaluation of enterprise employees.


## 6.4. Enterprise Employee Performance Appraisal Management System

In order to verify the throughput of the design system to the enterprise employee performance appraisal management system, the experimental verification is carried out by using the methods of literature [15], literature [16], literature [17], and this paper. The results are shown in Table 4. Throughput of assessment management system is shown in Figure 7.Table 4
Throughput of assessment management system.
Number of users/personsAssessment management system throughput (kbps)Literature [15] systemLiterature [16] systemLiterature [17] systemPaper system100234127653262459520023652753321355433002264287432366543400243329753078684650024533164297674536002568325127547754Figure 7
Throughput of assessment management system.It can be seen from Table4 that the throughput of the assessment management system is different under different methods. When the number of users is 200, the throughput of the assessment management system of document [15] system is 2365 kbps, the throughput of the assessment management system of document [16] system is 2753 kbps, the throughput of the assessment management system of document [17] system is 3213 kbps, and the throughput of the assessment management system of this paper is 5543 kbps. When the number of users is 600, the throughput of the assessment management system of document [15] system is 2568 kbps, the throughput of the assessment management system of document [16] system is 3251 kbps, the throughput of the assessment management system of document [17] system is 2754 kbps, and the throughput of the assessment management system of this system is 7754 kbps. The throughput of the assessment management system of this system is significantly higher than that of other methods, and the throughput of this system increases with the increase of the number of users, which can better adapt to the evaluation management of enterprise employees in multiuser system, which shows that the enterprise employee evaluation management of this system is better. In order to analyze the results more intuitively, corresponding bar charts are presented, and the results are shown in Figure 7.


## 7. Conclusion

This paper proposes an enterprise employee performance appraisal management system based on CS architecture. The architecture of performance appraisal system was built and the functional modules of the appraisal management system were analyzed. Through the evaluation constraint parameters, this paper analyzes the influencing factors of employee performance appraisal management system, constructs the quantitative regression analysis model of enterprise employee performance appraisal management, constructs the appraisal management system database, and realizes the design of enterprise employee performance appraisal management system based on CS architecture. The following conclusions are drawn through experiments:(1)
When the number of iterations is 50, the rationality score of enterprise employee assessment in this system is 486, which shows that this method can improve the rationality of enterprise employee assessment.(2)
When the number of employees is 500, the CPU occupancy rate of the enterprise employee performance appraisal management system designed is 8%, which shows that the CPU occupancy rate of this system is low, which can better manage the performance appraisal of enterprise employees.(3)
When the number of users is 600, the throughput of the assessment management system of this system is 7754 kbps, which shows that the enterprise employee assessment management of this system is better.



---

*Source: 9087094-2021-10-26.xml*