A study of MySQL protocol-based database proxy approval system for fortress machine
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.
Authors
- Taiguo Qu (ORCID: https://orcid.org/0000-0002-2352-7388)
- Xinhui Luo (ORCID: https://orcid.org/0009-0007-4978-1046)
- Hao Li (ORCID: https://orcid.org/0000-0002-9773-8313)
- Xian Zhang (ORCID: https://orcid.org/0000-0002-5841-6899)
- Dong Yin (ORCID: https://orcid.org/0000-0002-3867-5674)
Institutions
- Huaihua University (CN)
Publication Details
- Journal
- International Journal of Data Science
- Published
- 2025-01-01
- DOI
- https://doi.org/10.1504/ijds.2025.144837
- Primary Topic
- Wireless Sensor Networks and IoT
- Type
- article
- Field-Weighted Citation Impact
- 0.00