Design And Implementation Of The Optimization Of Query Speed And Intelligent Analysis In Database Audit System

Database audit system is a web application of real-time monitoring and recording of all database operational activities, including fine-grained auditing and alerting, using bypass deployment mode, the system can simultaneously monitor databases of multiple business systems. System produce large amounts of audit data daily, data in database amounted to a total of more than one hundred million. Faced with such a huge amount of data, how to solve the problem of slow query speed to improve system performance has become an important research direction.This paper analyzes the various reasons affecting the query speed in database audit system. For the three-tier structure of applications, this paper investigated the theories of database performance optimization, the principles of Hibernate architecture and optimization, caching technology in WEB front-end as well as analysis theory and related algorithms of users historical query behavior.Based on the theoretical study of a variety of optimization techniques, design and implement a comprehensive query optimization solutions in the database audit system. The solution include reasonable establishment and use of database index according to the data characteristics, optimizing SQL statements based on the index; improving Hibernate performance through adjusting configuration, enable the second level cache to enhance query efficiency; using the front page prefetching technology to hide query latency based on query analysis of user history information. The proposed solution has been applied in the development of database auditing system project, confirmed that the query performance optimization module is feasible and effective.