Dynamic template-based data processing system for database table changes

Rihuan Zuo; Ke Yang; Qiwen Dong; Ye Wang

doi:10.1117/12.3032810

5 July 2024 Dynamic template-based data processing system for database table changes

Rihuan Zuo, Ke Yang, Qiwen Dong, Ye Wang

Proceedings Volume 13184, Third International Conference on Electronic Information Engineering and Data Processing (EIEDP 2024); 1318432 (2024) https://doi.org/10.1117/12.3032810
Event: 3rd International Conference on Electronic Information Engineering and Data Processing (EIEDP 2024), 2024, Kuala Lumpur, Malaysia

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.

(2024) Published by SPIE. Downloading of the abstract is permitted for personal use only.

Citation Download Citation

Rihuan Zuo, Ke Yang, Qiwen Dong, and Ye Wang "Dynamic template-based data processing system for database table changes", Proc. SPIE 13184, Third International Conference on Electronic Information Engineering and Data Processing (EIEDP 2024), 1318432 (5 July 2024); https://doi.org/10.1117/12.3032810

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available

Members: $17.00

Non-members: $21.00 ADD TO CART

PROCEEDINGS
8 PAGES

DOWNLOAD PAPER SAVE TO MY LIBRARY

GET CITATION

RIGHTS & PERMISSIONS

Get copyright permission Get copyright permission on Copyright Marketplace

KEYWORDS

Databases

Data processing

Data modeling

Data acquisition

Computing systems

Industry

Information technology

Show All Keywords

Keywords/Phrases

Search In:

Publication Years