Dynamic template-based data processing system for database table changes

Abstract

With the rapid development of Internet technology, traditional industries such as university have made remarkable achievements in the process of informatization transformation of their own business, and informatization has been widely applied in the teaching and educational affairs, teaching resources, student information and other business fields of university. The management and operation of data plays an important role in university information system. When the database table data changes, the university information system may need to synchronize the cache according to the changed data to ensure the consistency between the database and the cache; There may be a need for real-time acquisition of change data from different systems for processing among various information systems in university. However, the traditional industries such as university usually lags behind the industry in the use of information technology, and there is often no good way for various business processing of data changed in database tables. Aiming at the above problems, this paper designs and implements a database table change data processing system based on configurable templates. The system can capture the change data of the subscribed database table in real time, and perform the automatic setting operation of the change data according to the template, or send the change data to the message queue for the required information system to consume. This template-based change data processing method effectively reduces the coupling of system functions, and the automatic operation and visual configuration also improve the efficiency of university information system developers.