Data archiving processing method and device, computer equipment and storage medium

A data archiving and processing method technology, applied in the field of data processing, can solve problems such as low efficiency, high cost, and reduced operational performance, and achieve the effects of improving processing efficiency, ensuring intelligence and automation, and reducing data volume

Pending Publication Date: 2021-01-05
CHINA PING AN LIFE INSURANCE CO LTD
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Embodiments of the present invention provide a data archiving processing method, device, computer equipment, and storage medium to solve the problems of reduced operational performance, low efficiency, and high cost when a relational database stores data with a large amount of data

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data archiving processing method and device, computer equipment and storage medium
  • Data archiving processing method and device, computer equipment and storage medium
  • Data archiving processing method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0028] The data archiving processing method provided by the embodiment of the present invention, the data archiving processing method can be applied such as figure 1 shown in the application environment. Specifically, the data archiving processing method is applied in a data archiving processing system, and the data archiving processing system includes such as figure 1 The data migration platform shown, the source database and the target database conn...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to the technical field of data processing, and discloses a data archiving processing method and device, computer equipment and a storage medium. The method comprises the steps: scanning an archiving configuration table, and acquiring target archiving information matched with the current time of a system from the archiving configuration table; obtaining and executing a targettable establishing script and a target migration script corresponding to the target archiving information, and migrating the to-be-archived data from a to-be-archived data table of the source databaseto a target data table of the target database; carrying out data verification on the to-be-archived data, and archiving a verification result; and if the archiving verification result shows that archiving succeeds, executing data deletion logic, and performing data deletion processing on the archived data in the to-be-archived data table. The method can guarantee the intelligence and automation of data archiving processing, guarantees the data accuracy, and reduces the storage cost. The invention also relates to the field of block chains, namely, to-be-archived data can be stored in a block chain node, namely, a target database constructed based on a block chain technology.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data archiving processing method, device, computer equipment and storage medium. Background technique [0002] In relational databases such as MySQL, Oracle, and Postgres, if the amount of data recorded in the data table is large (such as reaching tens of millions or more), the performance of its addition, deletion, query, and modification operations will drop sharply, which will reduce the efficiency of addition, deletion, query, and modification operations; Moreover, the storage cost of relational database is relatively high. Contents of the invention [0003] Embodiments of the present invention provide a data archiving processing method, device, computer equipment, and storage medium to solve the problems of reduced operational performance, low efficiency, and high cost when a relational database stores large amounts of data. [0004] A data archiving processing ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/21G06F16/22G06F16/23G06F16/2455G06F16/27
CPCG06F16/214G06F16/2282G06F16/2365G06F16/2455G06F16/27
Inventor 王振兴
Owner CHINA PING AN LIFE INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap