Versioning management methods, devices, equipment, and media based on relational data
By implementing version control for relational database data, the problem of inaccurate data recovery was solved, enabling versioned storage and fast querying of data, thus improving the accuracy and efficiency of data recovery.
CN117874004BActive Publication Date: 2026-06-30CHINA PING AN PROPERTY INSURANCE CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- CHINA PING AN PROPERTY INSURANCE CO LTD
- Filing Date
- 2024-01-12
- Publication Date
- 2026-06-30
AI Technical Summary
Technical Problem
Existing relational database backups cannot quickly view data, and data recovery can only be performed from the backup point in time, making it impossible to flexibly restore to a specified point in time, resulting in inaccurate data recovery.
Method used
By dividing version data into attributes, selecting primary key attributes to generate data tuples, generating a data version record table, extracting the operation time, and storing it in a relational database, data version management is achieved.
Benefits of technology
It improves the accuracy and efficiency of data recovery, allows switching to any version at any time for data querying, and enables unified data management and version control.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN117874004B_ABST
Abstract
This invention relates to the field of data management technology, and proposes a versioned management method, apparatus, device, and medium based on relational data. The method includes: acquiring version data and its corresponding version number; classifying the version data into attributes to obtain data attributes; selecting a primary key attribute from the data attributes; generating data tuples based on the primary key attribute and the data version number; using these data tuples as target data; generating a data version record table based on the target data and data attributes, and extracting the operation time corresponding to the target data from the data version record table; generating a version timeline based on the operation time; and storing the data version record table and version timeline in a preset relational database. This invention can be applied to the field of financial data, enabling versioned management of financial data in relational databases, thereby improving the accuracy of data recovery.
Need to check novelty before this filing date? Find Prior Art