A Study of MySQL Protocol-based Database Proxy Approval System for Fortress Machine
Hao Li, Taiguo Qu, Dong Yin, Xinhui Luo, Xian Zhang · International Journal of Data Science · 2024
With the increase of enterprise informatisation, database security and compliance operation management have become increasingly important. Therefore, it is essential to design an efficient database proxy approval system. In this paper, we develop a database proxy approval system based on the MySQL protocol for fortress machines, which provides a real-time customised configuration scheme for high-risk commands, designs a real-time approval process for six types of high-risk commands, and creates a simple and efficient matching algorithm for high-risk commands. We designed a large number of experiments to test the system's connection success rate, operation stability, response time, CPU resource consumption, matching algorithm performance, and other aspects. The experimental results show that this database proxy approval system has good configuration flexibility, high accuracy, and good time performance. This system has a wide range of applications in electric power, finance, petroleum, and other fields.