A system and method for synchronizing redundant fields in a database table, and a computer storage medium.

By defining annotation tags and aspect processing classes, redundant fields in the database table can be synchronized asynchronously, which solves the data inconsistency problem, improves data query efficiency and system performance, and simplifies data synchronization operations.

CN116166744BActive Publication Date: 2026-06-30CLP JIUTIAN INTELLIGENT TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
CLP JIUTIAN INTELLIGENT TECH CO LTD
Filing Date
2022-12-28
Publication Date
2026-06-30

AI Technical Summary

Technical Problem

During the data query process, if a field in table A is changed, table B will not be updated synchronously, resulting in data inconsistency. Existing technologies have problems such as complex foreign key management, high resource consumption, high risk of deadlock, and I/O bottlenecks. Furthermore, without foreign keys, data synchronization errors and performance consumption are severe.

Method used

By defining annotation tags and aspect processing classes, redundant fields in asynchronous and synchronous database tables are implemented. Data structures are automatically recorded using caching middleware, interceptors control the smallest granularity, and plugins are provided as a ready-to-use solution.

Benefits of technology

It achieves data consistency and accuracy, improves production efficiency, reduces the complexity and resource consumption of data synchronization operations, and avoids deadlock and error overwriting.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116166744B_ABST
    Figure CN116166744B_ABST
Patent Text Reader

Abstract

This invention discloses a database table redundant field synchronization system and method, and a computer storage medium, belonging to the field of communication technology. It achieves asynchronous synchronization of data field to ensure data consistency and accuracy, thereby improving production efficiency. The method includes the following steps: defining annotation tags and configuring data; defining a runtime startup class to obtain the data structure in the runtime environment for configuring the annotation dataset; defining an aspect processing class for the data synchronization domain; and updating the historical dataset based on the defined annotation tags, startup class, and aspect processing class for the data synchronization domain. The database table redundant field synchronization method provided by this invention uses a caching middleware to automatically record the data storage structure, omitting cumbersome data structure configuration; the database table redundant field synchronization method provided by this invention achieves minimum granular control over redundant fields in the DB table through interceptors.
Need to check novelty before this filing date? Find Prior Art