Data batch archiving method, device and equipment and storage medium

A data archiving and data technology, applied in the field of data processing, can solve the problems of large data volume and low data archiving efficiency.

Pending Publication Date: 2020-07-17
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The main purpose of the present invention is to provide a data batch archiving method, device, equipment and computer-readable storage medium, aiming to solve the technical problem of low data archiving efficiency due to the large amount of existing 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 batch archiving method, device and equipment and storage medium
  • Data batch archiving method, device and equipment and storage medium
  • Data batch archiving method, device and equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

[0042] The data batch archiving method involved in the embodiment of the present invention is mainly applied to data batch archiving devices, and the data batch archiving devices may be PCs, portable computers, mobile terminals and other devices with display and processing functions.

[0043] refer to figure 1 , figure 1 It is a schematic diagram of the hardware structure of the data batch archiving device involved in the solution of the embodiment of the present invention. In the embodiment of the present invention, the device for archiving data in batches may include a processor 1001 (such as a CPU), a communication bus 1002 , a user interface 1003 , a network interface 1004 , and a memory 1005 . Wherein, the communication bus 1002 is used to realize the connection and communication between these components;...

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 provides a data batch archiving method, device and equipment and a storage medium, namely determining a to-be-archived source library table, to-be-archived data in the source library table and an archived target table, and obtaining the to-be-archived data in the source library table in batches according to a preset batch time unit to serve as batch to-be-archived data; synchronizingthe batch to-be-archived data to corresponding partitions in a preset temporary table in batches according to a batch time identifier corresponding to the batch to-be-archived data, and generating temporary partition data; and when the data volume of the temporary partition data is the same as that of the corresponding batch to-be-archived data, archiving each piece of temporary partition data inthe temporary table to a corresponding target partition in the target table. According to the method, whether the archived data volume is correct or not can be quickly verified, and when an archivingerror occurs, the data can be quickly synchronized again in a targeted manner, so that the archiving efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a data batch archiving method, device, equipment and computer-readable storage medium. Background technique [0002] The data storage capacity of a relational database is directly related to the performance of the database. Generally, the larger the data storage capacity, the lower the performance of the database, that is, the lower the speed of operations such as query and insertion. In the case of storing massive amounts of data, the performance problem is particularly prominent, and will even become the biggest performance bottleneck on the application side. At present, when data is archived, the data is generally synchronized from the source library to the archive library in batches based on time, and then the query checks whether the number of batches of archived data in the archive library is consistent with the number of records in the source library table ...

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/27G06F16/28
CPCG06F16/21G06F16/2282G06F16/2365G06F16/275G06F16/284
Inventor 唐应泉
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
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