Lightweight dynamic data statistical system based on MyBatis

Abstract

The invention relates to a lightweight dynamic data statistical system based on MyBatis. A user dynamically increases and decreases data in a corresponding database based on a dynamic service SQL template; a statistical actuator inputs one or more dynamic service SQL templates with dynamic data at the same time; if a cache result corresponding to one or more statistical SQL statements exists in acache library, directly obtaining the cache result; and otherwise, analyzing to form a final executable statistical SQL statement, executing the analyzed SQL statement in parallel in a thread pool manner to obtain a statistical result, and caching the statistical result to different regions of the cache library based on the identifier of the database. The method is simple in principle, flexible inconfiguration, small in invasiveness and coupling to an original system, convenient to maintain, upgrade and expand in the later period, low in overall implementation cost and particularly suitable for small and medium-sized enterprises needing to control research and development cost, a multi-thread and cache mechanism is adopted, and the processing performance of the system is greatly improved.

Description

technical field [0001] The invention relates to the technical field of electrical digital data processing, in particular to a lightweight dynamic data statistics system based on MyBatis. Background technique [0002] With the continuous upgrading of enterprise informatization, all kinds of enterprises have gradually equipped themselves with one or more sets of information management systems to improve their own production and management efficiency. In most enterprise information management systems, workbench to-do is an indispensable functional module, which can very intuitively display the work items that users need to deal with every day. How to conveniently and flexibly count the number of to-do items has become a problem that system developers must think about. [0003] In the prior art, the more commonly used solution is to separately design the to-do list, write data into the to-do list when the business is triggered, and then display the statistical data from the tab...

AI Technical Summary

Problems solved by technology

[0004] (1) The business code is very intrusive. Basically, each to-do business module needs to modify the code to realize the statistics of the to-do items, and when the business status changes, the to-do list needs to be processed synchronously. Statistical data, complex and costly to implement;

[0005] (2) The scalability is not high. When a pending business changes, the code must be modified and reissued;

[0006] (3) It does not support the existing systems in the enterprise. If these existing systems want to introduce the function of the work to-do module, it is necessary to analyze each business module of the existing system and make code modifications. The overall implementability is not high

Images