Title: A study of MySQL protocol-based database proxy approval system for fortress machine

Authors: Xian Zhang; Xinhui Luo; Dong Yin; Taiguo Qu; Hao Li

Addresses: School of Computer and Artificial Intelligence (School of Software), Huaihua University, Huaihua, 418000, China; Key Laboratory of Intelligent Control Technology for Wuling-Mountain Ecological Agriculture in Hunan Province, Huaihua, 418000, China; Key Laboratory of Wuling-Mountain Health Big Data Intelligent Processing and Application in Hunan Province Universities, Huaihua, 418000, Hunan, China ' Huaihua Tourism School, Huaihua, Hunan, 418099, China ' School of Computer and Artificial Intelligence (School of Software), Huaihua University, Huaihua, 418000, China; Key Laboratory of Intelligent Control Technology for Wuling-Mountain Ecological Agriculture in Hunan Province, Huaihua, 418000, China; Key Laboratory of Wuling-Mountain Health Big Data Intelligent Processing and Application in Hunan Province Universities, Huaihua, 418000, Hunan, China ' School of Computer and Artificial Intelligence (School of Software), Huaihua University, Huaihua, 418000, China ' School of Computer and Artificial Intelligence (School of Software), Huaihua University, Huaihua, 418000, China

Abstract: 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.

Keywords: fortress machine; MySQL protocol; database proxy; approval system; database security.

DOI: 10.1504/IJDS.2025.144837

International Journal of Data Science, 2025 Vol.10 No.1, pp.96 - 117

Received: 07 Mar 2024
Accepted: 31 Jul 2024
Published online: 04 Mar 2025 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article