The invention discloses an analytical
database dynamic
cache management system based on a single plug-in integrated architecture, which is characterized by comprising a dynamic cache plug-in, a
bloom filter module, a pre-judgment type
memory control module, a CTE /
SQL cache module, a dynamic updating module and a
database base table, and the dynamic
cache management system is constructed through a five-level
collaboration module.
Cache optimization and memory security control of
SQL query are achieved, the pre-judgment type
memory control module actively loads high-
frequency data to a memory, disk access is reduced, an intermediate result is reused through CTE or
SQL cache, and repeated calculation and hard disk reading are avoided. Compared with the prior art, the method has the advantages of zero memory overload,
high memory security, high calculation efficiency and the like, the execution efficiency of repeated query and sub-query in the analytical
database is remarkably improved, the calculation overhead and time consumption are reduced, and the problems of resource overload and low calculation efficiency are effectively solved. The method is suitable for high-
concurrency analysis scenes such as financial
risk control and real-time large screens.