Vertical software controllable system design for grid service operation process

The traditional software control system with partition management is applied to the grid service operation process with more complex data structure, which will lead to slow system response due to high concurrency pressure. In view of the above problems, a vertical software controllable system is designed for the grid service operation process. After designing the hardware part of the two systems, grid server management board and communication module, the system software is designed. In the system software part, the grid service operation functional components are designed to realize the modular management of the service operation. The real-time and relational database of the system is designed, and the keyword query algorithm is used to realize the business item query to realize the system functions. The simulation experiment results show that the response time of the controllable system is all below 2000ms, which meets the demand of grid service operation, and the system has good concurrency resistance.


Introduction
With the increase of users in different industries and the difference in requirements for various services, users are flooded with a huge amount of various information in the process of using software, which provides ample space for the development of specialized and segmented network platforms and network information services. Under the power market, the basic function of power grid enterprises is to provide reliable and high-quality transmission and distribution services for power generation and users without discrimination as an independent third party. Power grid enterprises have always attached great importance to the promotion of management information technology for enterprise development, and actively explore the road of information technology in line with enterprise strategy [1]. A large amount of data will be generated in the process of grid service operation, and because these data contain a large amount of professional information, professional data management software is required, while comprehensive service operation software has been unable to meet the actual demand of grid service operation. Vertical software, which specializes in one or several specialized fields, has gradually replaced the traditional integrated software and won the time for development [2]. In the process of grid service operation, vertical software aids in data, project management, and information recall with good results. In practice, the network environment of power grid enterprises is complicated, the most prominent is the information system management problems, regular inspection type inspection and maintenance has been unable to meet the needs of the entire network information system good operation and maintenance. Therefore, when the vertical software used for data management in the process of power grid operation is managed in a controlled manner, it is one of the ways to ensure the normal operation of power enterprises and provide services. Literature [3] traditional software controllable system uses distributed monitoring approach to realize the control of operation service data management software according to the data source area. This method is better for the management of management software with small data volume and poor data heterogeneity, but for the data integration and heterogeneity of data management software caused by the operation of modern power grid services, the system cannot guarantee real-time control is difficult to meet the needs of power enterprises to provide operational services. The software controllable system mentioned in the literature [4] is based on spring's front-end framework to control the grid service operation management software, which runs on a container server that is easy to deploy and provides rich functionality, but the development process is tedious and repetitive tasks, and a large number of source code files have to be created and maintained, which is less effective for vertical software control and has limitations in actual use. Based on the above analysis content, in order to improve the control efficiency of the data management vertical software in the process of grid service operation, this paper will study and design the vertical software controllable system for the process of grid service operation.

Power grid server management motherboard design
A large amount of data is required to support the operation of the grid service, all data is stored in the database, and for effective management of the grid server, the server management motherboard is designed. Figure 1 below shows a basic motherboard management controller architecture [5]. Figure 1 Server management motherboard architecture The motherboard management controller is a server management processor with an internal integrated RAM processor that uses internal physical variables from physical sensors to monitor the status of the grid server or other external devices, supporting both local in-band access and remote out-of-band access. Temperature and voltage sensors and power monitoring are connected via the I2C bus, and the motherboard management controller monitors system status by measuring internal physical variables. Server administrators can manage the server locally and remotely using the motherboard management controller [6]. The motherboard management controller provides an efficient and convenient server management interface and has a very mature ecosystem, plus its management capabilities are also recognized by a wide range of data center customers, and its general main components are shown in table 1 [7].  7 2 independent watchdog timers, 6 general-purpose timers In the event of a software failure, the microcontroller is reset by resetting the device (if the software does not zero out the device) to protect system operation in a timely manner The main board management control module is connected to the communication module via I2C bus, and the communication module is connected to the grid service operation terminal to realize the communication between the grid service operation server and the vertical software control system.

Communication module design
Due to the need to achieve real-time control of the vertical software when operating the grid service, the advantage of higher I2C bus communication speed can satisfy the communication connection between the control system and the vertical software. The I2C bus connection between the main board management control module and the communication module is made using a shielded twisted pair cable with RJ45 interface [8].
The communication module uses Socket communication protocol for data transfer. Socket is a communication protocol and a socket consists of five main pieces of information: protocol, local address, local port number, remote address, and remote port number. It is a protocol to communicate with any computer that has a socket interface and all messages are sent and received through this socket interface [9][10].The operation of a socket is simple and in application development it is like using a file handle, you can read and write to the socket handle. A client uses a Socket object to send a connection request to a specified port of a server on the network, and if the connection is successful, the session is opened. The client does not need to specify an open port, the operating system usually assigns a temporary, dynamic port of 1024 or more. The server uses the Server Socket object to listen to any specified port and wait for a client connection request. When the client connects successfully, a session is generated; when the client completes the session, the connection is closed.
Based on the above design of the hardware part of the vertical software controllable system, the software part of the vertical software controllable system is designed to meet the requirements of the grid service operation process.
3. Software design of vertical software controllable system for grid service operation process

Design of functional components for grid service operation
During the system design process, in order to realize the vertical management of each service operation project of the power grid, it is necessary to divide each specific application function of the control system into interface control components, business logic components, etc., and all business application functions are decomposed into basic units that conform to the change business needs through the combined component technology [11].
The project management component of the vertical software controllable system is mainly for the management of power grid service operation projects. Since power companies often provide multiple operation services at the same time, it is important to manage the service operation project information through the functional component. The project manager is able to manage the information of each service project through the functional component and enter the latest information of the project into the system through the project data collection. The project data analysis function can display the project data in the form of graphs and charts, which makes it easier to visualize the current status of the project. The project information query function is a channel for the user to query information about a given project [12].
The timing diagram of the functional components of the grid service operation module is shown in figure 2 [13]. Figure 2 Timing diagram of operation function component modules Grid service operation staff enter the main page of the system through their account and password, click on the project management module to enter the project management function interface, click on the grid service project information management function to obtain detailed information of the selected project, and can add, modify and delete the project information and other operations. Once the information is entered, it can be analyzed and processed by the project information analysis function, which can be in the form of tables or graphs. This makes it easier for grid service operations staff to visualize the status of the project [14]. In addition, the power grid service operation staff can query the information and progress of the service project through the project information query function of the functional component module.
The project manager analyzes the results of the comparison and controls the project progress through the project progress control function. The project manager analyzes the comparison results and controls the project schedule through the project schedule control function, which enables the project to proceed smoothly and improves the efficiency of the grid service operation [15]. After designing the grid service operation functional components of the vertical software controllable system, the data storage database of the system is designed.

Database Design
The database of the vertical software controllable system uses a combination of real-time database and relational database, using a real-time library to meet the demand for providing fast real-time data access, while introducing a relational database, which organically combines the real-time database with the relational database. The high reliability, versatility and scalability of the relational database are fully utilized, while the high speed of the real-time database is fully utilized [16].

Real-time database
The real-time database is stored in the physical hard disk in the form of files, including three levels: state, application, and table. The whole real-time database corresponds to a directory on the hard disk, i.e. the real-time library root directory. The real-time database includes several vertical software control states, each corresponding to a subdirectory under the root directory of the real-time database, i.e., the state directory. Each state contains several applications, which correspond to a subdirectory under the vertical software control state directory, i.e., the application directory, and each application corresponds to a binary file under the application directory for storing control data in real time.
The real-time database is specifically designed to provide efficient access to real-time data to monitor, control and analyze the development of each service operation in the course of grid service operation. In the grid service vertical software controllable system, all applications with high requirements for real-time need to be constructed on top of the real-time library, which is also the basis for data interaction between applications and platforms and between applications and applications [17]. Real-time databases support multiple applications and polymorphism and provide various access interfaces, including network interfaces and local interfaces. The main functions of the real-time database include: data down load, data storage, data maintenance, data validation, data browsing, data access, data synchronization, data replication, etc.

Relational Database
The relational database is mainly used to store all data that needs to be stored permanently, such as grid devices, parameters, alarm and event records, system configuration, historical statistics, etc. The relational database data management function includes two parts: model data management and historical data management. The relational database data management function provides a set of database access interfaces, i.e., database middleware, which makes it easy for various applications and public services, etc., to access the data in the relational database [18].
Cluster and parallel processing technologies are used to ensure secure, reliable, and fast database access with openness, real-time, and security. The data storage of the historical database is equipped with a caching mechanism to guarantee that the temporarily lost historical data can be automatically recovered from the SCADA server when the historical database server is out of operation for a short period of time.
After establishing the vertical software controllable system database according to the above, keyword query algorithm is introduced in the system for the convenience of front-end grid service operation staff operation.

Service business data keyword query
An n n  grid is used to partition the data space in the database, and for a given data set R , assuming its dimension to be d , base to be c , and ideally the number of individual interval points to be t , the specific steps to solve for n are given below. The data space is partitioned in the order of the values of n from 2 iterations to d n c   , and for each particular value of n , a local bit string is generated for that scratch task input data slice. After dividing the data by global operations, the specific n value is found. The individual instances in the dataset are distributed in grid intervals, then the keywords contained in each instance also have their subordinate grid intervals. For a given keyword, this paper uses the grid inverted index to quickly locate the grid interval to which it belongs [19].
For a given dataset R , a grid of n n  is used to partition the data space, where the value of n is found by the above procedure. First, the data set R is divided into mutually disjoint data slices 1 2 , , , m R R R  , which are used as inputs for keyword queries. The local inverted index of each data slice is generated according to the data partitioning mechanism and Equation (1).
In the above equation, t is the data space division node. i p is the i -th interval into which the data are divided. w is the keyword; W is the set of keywords. In this paper, the approximate string matching algorithm is used to calculate the degree of matching between the keywords and the elements in the query items. The approximation degree is calculated as follows [20]. x y sim x y s In the above equation, x is the keyword submitted by the system user; y is the query item summarized in the system database. xy s is the standard deviation of the two data elements. A match is given for each keyword based on the approximate string matching algorithm, and if the element and keyword match above a given threshold, it can be identified as a possible match. After the matching algorithm, a series of possible matches are generated for each keyword, forming a match table. By forking each keyword match table, a series of query terms are generated. The work required before submitting the final query results to the user is to rank the relevance of the query templates obtained from the keyword aggregation query. The score of a query template is determined by a combination of node weights and edge weights. The scoring function assigns a score to each query template that measures the relevance of the query results to the query keywords, with the most relevant results being returned first. The sorting function is based on the scoring function. The sorting function ranks the query templates in a certain order based on this score. It is assumed that the nodes in the query template are all corresponding to the query keywords. The number of keywords contained in the query results varies, and the higher the keyword match, the higher the score should be according to the query keyword match. The improved scoring formula is shown in the following equation.
In equation (3), QT is a query template that constitutes a query. sif is the number of nodes contained in the query template. i T is the node in the query template. Q is a keyword query and m is the number of keywords in Q . m is the number of nodes contained in the query template. a is a constant used to ensure that queries containing more keywords have a higher score than those containing fewer keywords.  Through the above design process of system hardware and software, the design of a vertically software controllable system for grid service operation process is completed.

System Experiment
The purpose of software testing is to check whether the system meets the standards, assess the software quality, and test whether the system is functionally complete, available, and reliable, and whether the interfaces are smooth. This section focuses on functional testing, stress testing, and rectification of test results/problems after the completion of the vertical software controllable system for grid service operation process.

Experimental Content
The purpose of performance testing is to check whether the capacity and concurrency of the system meet the performance requirements. The data stress test and concurrency test are used to determine whether the system meets the actual grid service operation requirements and whether the response time of the system meets the requirements under large concurrency conditions. The vertical software controllable system designed in this paper is used as the experimental group, and the control systems mentioned in literature [3] and literature [4] are used as the reference group. In the computer simulation platform, the grid service operation state is simulated, and the three groups of control systems are applied to control respectively, and the experimental conclusions are drawn by processing and analyzing the data in the comparison experiments.

Experimental results and analysis
The experimental data of the control system of the experimental group and the comparison group in the simulation condition environment for the control process of the vertical software are shown in table 2 below. Analysis of the data in Table 2 above shows that the instantaneous capacity and maximum concurrency of the system in this paper are the largest in several experiments, and the response time of the system is much less than 2000 ms . The response times of the software control systems in both papers are greater than 2000 ms, and their system resistance performance test index data are smaller than that of the system in this paper. From the specific numerical point of view, the average response time of the system in this paper is 1761.89ms, the average response time of the system in literature [3] is 2634.2ms, the average response time of the system in literature [4] is 4957.4ms, and the response time of the system in this paper is shortened by at least about 33.3%. In summary, the vertically software controllable system designed in this paper for grid service operation process has high concurrent resilience and effectively reduces the response time by about 33.3% on average, which is superior.

Conclusion
Vertical software does not pursue big and comprehensive, but only focuses on familiar fields and becomes an authority in the corresponding industry field. In the process of grid service operation, applying vertical software helps to manage data. To improve the efficiency of controlling software operations, a vertical software controllable system for grid service operation process is designed. Comparative experiments conducted on the simulation platform proved the reliable performance of the system. In future research, further in-depth studies on enhancing the scope of application of the system are needed.